Thursday, August 01, 2019

Re: sqlports info available as a json in the CDN/mirrors, yay or nay?

On Mon, Jul 15, 2019 at 09:00:46PM -0400, Daniel Jakots wrote:
> On Tue, 2 Jul 2019 17:42:07 +0200, Juan Francisco Cantero Hurtado
> <iam@juanfra.info> wrote:
>
> > I've the python script but I've not started yet with the port. The
> > question for the porters (and in special people running the bulks,
> > signing/uploading packages) is, are you against this idea?
>
> It looks like to me no one has any objection :)
>

The script:
https://github.com/juanfra684/ports-json

The JSON:
https://juanfra.keybase.pub/tmp-ports/take3/packages.json

The size of the file is 14MB without compression and 2.7MB with gzip -1.
Some of our mirrors support gzip compression for some file types.

The file is mostly the same as in previous versions but I added a new
object at the start of the file to add some basic info about the build,
like the date, which I would like to use in the future. Also, the file
now includes the BROKEN info.

The columns used by the script are:

+-------------------------+-----------+
| PathId | DISCARDED |
+-------------------------+-----------+
| FullPkgPath | SELECTED |
+-------------------------+-----------+
| AUTOCONF_VERSION | DISCARDED |
+-------------------------+-----------+
| AUTOMAKE_VERSION | DISCARDED |
+-------------------------+-----------+
| BUILD_DEPENDS | SELECTED |
+-------------------------+-----------+
| CATEGORIES | SELECTED |
+-------------------------+-----------+
| COMES_WITH | DISCARDED |
+-------------------------+-----------+
| COMMENT | SELECTED |
+-------------------------+-----------+
| COMPILER | DISCARDED |
+-------------------------+-----------+
| COMPILER_LANGS | DISCARDED |
+-------------------------+-----------+
| COMPILER_LINKS | DISCARDED |
+-------------------------+-----------+
| CONFIGURE_ARGS | DISCARDED |
+-------------------------+-----------+
| CONFIGURE_STYLE | DISCARDED |
+-------------------------+-----------+
| DESCR | DISCARDED |
+-------------------------+-----------+
| DESCR_CONTENTS | SELECTED |
+-------------------------+-----------+
| DISTFILES | DISCARDED |
+-------------------------+-----------+
| DISTNAME | SELECTED |
+-------------------------+-----------+
| DIST_SUBDIR | DISCARDED |
+-------------------------+-----------+
| DPB_PROPERTIES | DISCARDED |
+-------------------------+-----------+
| EPOCH | DISCARDED |
+-------------------------+-----------+
| FIX_EXTRACT_PERMISSIONS | DISCARDED |
+-------------------------+-----------+
| FLAVORS | DISCARDED |
+-------------------------+-----------+
| FULLPKGNAME | SELECTED |
+-------------------------+-----------+
| GH_ACCOUNT | DISCARDED |
+-------------------------+-----------+
| GH_COMMIT | DISCARDED |
+-------------------------+-----------+
| GH_PROJECT | DISCARDED |
+-------------------------+-----------+
| GH_TAGNAME | DISCARDED |
+-------------------------+-----------+
| HOMEPAGE | SELECTED |
+-------------------------+-----------+
| IGNORE | DISCARDED |
+-------------------------+-----------+
| IS_INTERACTIVE | DISCARDED |
+-------------------------+-----------+
| LIB_DEPENDS | SELECTED |
+-------------------------+-----------+
| MAINTAINER | SELECTED |
+-------------------------+-----------+
| MAKEFILE_LIST | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES0 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES1 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES2 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES3 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES4 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES5 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES6 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES7 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES8 | DISCARDED |
+-------------------------+-----------+
| MASTER_SITES9 | DISCARDED |
+-------------------------+-----------+
| MODULES | SELECTED |
+-------------------------+-----------+
| NOT_FOR_ARCHS | SELECTED |
+-------------------------+-----------+
| NO_BUILD | SELECTED |
+-------------------------+-----------+
| NO_TEST | SELECTED |
+-------------------------+-----------+
| ONLY_FOR_ARCHS | SELECTED |
+-------------------------+-----------+
| PATCHFILES | DISCARDED |
+-------------------------+-----------+
| PERMIT_DISTFILES | DISCARDED |
+-------------------------+-----------+
| PERMIT_DISTFILES_FTP | DISCARDED |
+-------------------------+-----------+
| PERMIT_PACKAGE | SELECTED |
+-------------------------+-----------+
| PERMIT_PACKAGE_CDROM | DISCARDED |
+-------------------------+-----------+
| PERMIT_PACKAGE_FTP | DISCARDED |
+-------------------------+-----------+
| PKGNAME | SELECTED |
+-------------------------+-----------+
| PKGPATHS | DISCARDED |
+-------------------------+-----------+
| PKGSPEC | DISCARDED |
+-------------------------+-----------+
| PKGSTEM | DISCARDED |
+-------------------------+-----------+
| PKG_ARCH | DISCARDED |
+-------------------------+-----------+
| PORTROACH | DISCARDED |
+-------------------------+-----------+
| PORTROACH_COMMENT | DISCARDED |
+-------------------------+-----------+
| PREFIX | DISCARDED |
+-------------------------+-----------+
| PSEUDO_FLAVOR | DISCARDED |
+-------------------------+-----------+
| PSEUDO_FLAVORS | DISCARDED |
+-------------------------+-----------+
| README | DISCARDED |
+-------------------------+-----------+
| README_CONTENTS | DISCARDED |
+-------------------------+-----------+
| REVISION | DISCARDED |
+-------------------------+-----------+
| RUN_DEPENDS | SELECTED |
+-------------------------+-----------+
| SEPARATE_BUILD | DISCARDED |
+-------------------------+-----------+
| SHARED_LIBS | SELECTED |
+-------------------------+-----------+
| STATIC_PLIST | DISCARDED |
+-------------------------+-----------+
| SUBPACKAGE | DISCARDED |
+-------------------------+-----------+
| SUBST_VARS | DISCARDED |
+-------------------------+-----------+
| SUPDISTFILES | DISCARDED |
+-------------------------+-----------+
| TARGETS | DISCARDED |
+-------------------------+-----------+
| TEST_DEPENDS | SELECTED |
+-------------------------+-----------+
| TEST_IS_INTERACTIVE | DISCARDED |
+-------------------------+-----------+
| UPDATE_PLIST_ARGS | DISCARDED |
+-------------------------+-----------+
| USE_GMAKE | DISCARDED |
+-------------------------+-----------+
| USE_GROFF | DISCARDED |
+-------------------------+-----------+
| USE_LIBTOOL | DISCARDED |
+-------------------------+-----------+
| USE_LLD | DISCARDED |
+-------------------------+-----------+
| USE_WXNEEDED | SELECTED |
+-------------------------+-----------+
| WANTLIB | SELECTED |
+-------------------------+-----------+


I will try to send a port in the next weeks.


--
Juan Francisco Cantero Hurtado http://juanfra.info

No comments:

Post a Comment