./databases/sqlports [sqlite database of ports]
[+] Add this package to your ports tracker

[ CVSweb ] [ Homepage ] [ RSS feed ]

Version: 6.3, Package name: sqlports-6.3
Maintained by: Marc Espie
Master sites:
Description-compact
SQLite database of every port in the system. This can be queried through
e.g., sqlitebrowser, or any kind of programming interface.

This schema is mostly optimized for tools, and cumbersome to query by
hand.

Database Schema:
- Paths (ID, FULLPKGPATH, PKGPATH, CANONICAL)
PKGPATH points to a PATHS entry corresponding to the stripped down version of
FULLPKGPATH, without flavors or subpackage markers, or is null if FULLPKGPATH
is already stripped. Every other FULLPKGPATH, PKGPATH, DEPENDSPATH entry
in the database points to this table.
The FULLPKGPATH is complete, including flavors and pseudo flavors markers.
For every port with MULTI_PACKAGES settings, one entry is written
for each SUBPACKAGE.
CANONICAL points to the actual ID to use as an entry in other tables, for
FULLPKGPATH which don't have their own entry.

- Ports(FULLPKGPATH, ...)
holds all the information retrieved through various variables that is not
stored in specialized tables, e.g.,:
AUTOCONF_VERSION
AUTOMAKE_VERSION
BROKEN
COMMENT
DESCR
DISTFILES
DISTNAME
DIST_SUBDIR
EPOCH
FLAVORS
FULLPKGNAME
GH_*
HOMEPAGE
IS_INTERACTIVE
MAINTAINER
MULTI_PACKAGES
NO_*
PERMIT_*
PKGNAME
PKGSPEC
PKG_ARCH
PREFIX
PSEUDO_FLAVOR
PSEUDO_FLAVORS
TEST_IS_INTERACTIVE
REVISION
SEPARATE_BUILD
STATIC_PLIST
SUBPACKAGE
SUPDISTFILES
USE_*
README
WANT_CXX

This information is mostly unchanged, except for replacing Yes/No variables
with 1/0. Variables not present in a given port are left undefined.

README corresponds to README files (full text value) and only exists when
such files are present.

Note that USE_LIBTOOL is 3-valued: 2 is gnu, 1 is yes, undef is no.

MULTI_PACKAGES ports hold several entries with corresponding FULLPKGPATH

- Flavors(FULLPKGPATH, VALUE)
- PseudoFlavors(FULLPKGPATH, VALUE)
- Categories(FULLPKGPATH, VALUE)
- Multi(FULLPKGPATH, VALUE, SUBPKGPATH) ('-' values are not stored)
- Modules(FULLPKGPATH, VALUE)
- Configure(FULLPKGPATH, VALUE) (corresponds to CONFIGURE_STYLE)
- ConfigureArgs(FULLPKGPATH, VALUE)
- MasterSites(FULLPKGPATH, N, VALUE)
- Makefiles(FULLPKGPATH, VALUE)
- NotForArch(FULLPKGPATH, VALUE)
- OnlyForArch(FULLPKGPATH, VALUE)
All of these variable values are actually lists. These lists are taken apart
and result in many entries in these secondary tables (or none if the list
is completely empty)

The Makefiles table contains only Makefiles from MAKEFILE_LIST that are not
"default values" (always included makefiles).

Each keyword table follows the same scheme
TABLENAME(KEYREF, VALUE)


- Depends(FULLPKGPATH, FULLDEPENDS, PKGSPEC, REST, DEPENDSPATH, TYPE)
All depends are stored in a single table, including the type:
0 -> library
1 -> run
2 -> build
3 -> test
with FULLDEPENDS the full text of the dependency, DEPENDSPATH the PKGPATH
we depend upon, PKGSPEC the spec we depend upon (if explicit), and REST
the rest.
- Wantlib(FULLPKGPATH, VALUE, EXTRA)
All the libraries the FULLPKGPATH depends upon, with optional version
number specification stored in EXTRA
coming from either the WANTLIB variable or various LIB_DEPENDS.

- Multi(FULLPKGPATH, VALUE, SUBPKGPATH)
also contains the normalized pkgpath for the corresponding subpackage.
- Broken(FULLPKGPATH, ARCH, TEXT)
This is stored both in the main table (for now) and in a separate table, with
keywords since it may be arch-dependent

- Shared_Libs(FULLPKGPATH, LIBNAME, VERSION)

- TARGETS(FULLPKGPATH, VALUE)

Some information, both in the main table and in secondary tables
is stored as keyword references to other tables:
AUTOCONF_VERSION, AUTOMAKE_VERSION -> AUTOVERSION
MAINTAINER -> EMAIL
CATEGORIES -> CATEGORYKEYS
CONFIGURE -> CONFIGURE_KEYS
MAKEFILES -> FILENAMES
MODULES -> MODULEKEYS
PREFIX -> PREFIX
WANTLIB.VALUE, SHARED_LIBS.LIBNAME -> LIBRARY
PERMIT_*, SEPARATE_BUILD -> KEYWORDS2
FLAVORS, PSEUDO_FLAVORS -> KEYWORDS
NOT_FOR_ARCHS, ONLY_FOR_ARCHS, PKG_ARCH -> ARCH
TARGETS -> TARGETKEYS

Description-list
Reduced list of every fullpkgpath reachable in the ports tree, with
duplicate pkgnames removed, and with ports without static plists taken
out.

Description-main
SQLite database of every port in the system. This can be queried through
e.g., sqlitebrowser, or any kind of programming interface.

This is more suitable for human consumption, use sqlite-compact for
more structured information.

Database Schema:
- Ports(FULLPKGPATH, ...)
holds all the information retrieved through various variables, e.g.,:
AUTOCONF_VERSION
AUTOMAKE_VERSION
BROKEN
*DEPENDS
CATEGORIES
COMMENT
CONFIGURE_STYLE
DESCR
DISTFILES
DISTNAME
DIST_SUBDIR
EPOCH
FLAVORS
FULLPKGNAME
GH_*
HOMEPAGE
IS_INTERACTIVE
MAINTAINER
MAKEFILE_LIST
MASTER_SITES*
MODULES
MULTI_PACKAGES
NO_*
NOT_FOR_ARCHS
ONLY_FOR_ARCHS
PERMIT_*
PKGNAME
PKGSPEC
PKG_ARCH
PREFIX
PSEUDO_FLAVOR
PSEUDO_FLAVORS
TEST_IS_INTERACTIVE
REVISION
SEPARATE_BUILD
SHARED_LIBS
SUBPACKAGE
SUPDISTFILES
TARGETS
USE_*
WANTLIB
README
WANT_CXX

This information is mostly unchanged, except for replacing Yes/No variables
with 1/0. Variables not present in a given port are left undefined.

README corresponds to README files (full text value) and only exists when
such files are present.

Note that USE_LIBTOOL is 3-valued: 2 is gnu, 1 is yes, undef is no.

The FULLPKGPATH is complete, including flavor and pseudo-flavors markers.
For every port with MULTI_PACKAGES settings, one entry is written for
each SUBPACKAGE.

- Paths (FULLPKGPATH, PKGPATH, CANONICAL)
PKGPATH is the stripped down version or FULLPKGPATH, without flavors
or subpackage markers.
CANONICAL points to the reduced version.

- Flavors(FULLPKGPATH, VALUE)
- Categories(FULLPKGPATH, VALUE)
- Multi(FULLPKGPATH, VALUE, SUBPKGPATH)
- Makefiles(FULLPKGPATH, VALUE)
- Modules(FULLPKGPATH, VALUE)
- Configure(FULLPKGPATH, VALUE)
- ConfigureArgs(FULLPKGPATH, VALUE)
- NotForArch(FULLPKGPATH, VALUE)
- OnlyForArch(FULLPKGPATH, VALUE)
- Targets(FULLPKGPATH, VALUE)
All of these variable values are actually lists. These lists are taken apart
and result in many entries in these secondary tables (or none if the list
is completely empty)

Makefiles holds the stuff from MAKEFILE_LIST that's specific to a given port
with all default entries stripped away.

- Depends(FULLPKGPATH, FULLDEPENDS, PKGSPEC, REST, DEPENDSPATH, TYPE)
All depends are stored in a single table, including the type:
R -> run
L -> lib
B -> build
T -> test
with FULLDEPENDS the full text of the dependency, DEPENDSPATH the PKGPATH
we depend upon, PKGSPEC the spec we depend upon (if explicit), and REST
the rest.
- Wantlib(FULLPKGPATH, VALUE)
All the libraries the FULLPKGPATH depends upon, with and without version number,
coming from either the WANTLIB variable or various LIB_DEPENDS.

- Multi(FULLPKGPATH, VALUE, SUBPKGPATH)
with SUBPKGPATH the normalized pkgpath for that subpackage.

- BROKEN(FULLPKGPATH, ARCH, VALUE)
All the broken entries, which might be arch-dependent.

- Shared_Libs(FULLPKGPATH, LIBNAME, VERSION)


Version History (View Complete History)
  • (2017-05-13) Updated to version: sqlports-6.3
  • (2017-04-11) Updated to version: sqlports-6.2
  • (2017-01-30) Updated to version: sqlports-6.1
  • (2016-08-18) Updated to version: sqlports-6.0
  • (2016-03-21) Updated to version: sqlports-5.0
  • (2015-05-15) Updated to version: sqlports-4.4
  • (2014-11-04) Updated to version: sqlports-4.3
  • (2014-09-03) Updated to version: sqlports-4.2
  • (2014-07-12) Updated to version: sqlports-4.1
  • (2013-11-25) Updated to version: sqlports-4.0
[show/hide] View available PLISTS (Can be a lot of data)

CVS Commit History:

   2019-03-15 05:29:53 by Marc Espie | Files touched by this commit (4)
Log message:
Fix bug in argument order, strenghten argument parsing to avoid that.
Add a "meta" table that just contains a schema version and a hash.
So that some clients (e.g., portroach) can automatically figure out
whether a rebuild is required.
   2019-03-15 05:29:53 by Marc Espie | Files touched by this commit (4)
Log message:
Fix bug in argument order, strenghten argument parsing to avoid that.
Add a "meta" table that just contains a schema version and a hash.
So that some clients (e.g., portroach) can automatically figure out
whether a rebuild is required.
   2019-03-15 05:29:53 by Marc Espie | Files touched by this commit (4)
Log message:
Fix bug in argument order, strenghten argument parsing to avoid that.
Add a "meta" table that just contains a schema version and a hash.
So that some clients (e.g., portroach) can automatically figure out
whether a rebuild is required.
   2019-03-15 05:29:53 by Marc Espie | Files touched by this commit (4)
Log message:
Fix bug in argument order, strenghten argument parsing to avoid that.
Add a "meta" table that just contains a schema version and a hash.
So that some clients (e.g., portroach) can automatically figure out
whether a rebuild is required.
   2019-03-11 07:29:21 by Marc Espie | Files touched by this commit (2)
Log message:
slightly more correct subrequest (fullpkgpath is ordered "by accident")
I suspected this, confirmed after a discussion with Reda Dehak, from my
lab at work.
   2019-03-11 07:29:21 by Marc Espie | Files touched by this commit (2)
Log message:
slightly more correct subrequest (fullpkgpath is ordered "by accident")
I suspected this, confirmed after a discussion with Reda Dehak, from my
lab at work.
   2019-01-22 09:55:22 by Marc Espie | Files touched by this commit (2)
Log message:
use "chained joins" to create canonical_depends with the Sql.pm framework
kill a bit of code.
adjust is now the only request "not in the mold", so just create it when
needed (so, late enough)
Add index creation (directly in create_schema), for now used for
canonical.
   2019-01-22 09:55:22 by Marc Espie | Files touched by this commit (2)
Log message:
use "chained joins" to create canonical_depends with the Sql.pm framework
kill a bit of code.
adjust is now the only request "not in the mold", so just create it when
needed (so, late enough)
Add index creation (directly in create_schema), for now used for
canonical.
   2019-01-21 01:51:56 by Marc Espie | Files touched by this commit (1)
Log message:
rename a few methods and finish implementing chaining joins
   2019-01-17 10:39:00 by Marc Espie | Files touched by this commit (1)
Log message:
somewhat more extensive diagnostics
   2019-01-14 11:38:04 by Marc Espie | Files touched by this commit (1)
Log message:
better error reporting
   2019-01-14 11:37:15 by Marc Espie | Files touched by this commit (1)
Log message:
allow us to ask for indexed/non indexed variables
   2019-01-12 06:57:41 by Marc Espie | Files touched by this commit (3)
Log message:
use (SELECT ) inside INSERT for keyword tables, so that less actual perl
code is needed.
no actual schema change
   2019-01-12 06:57:41 by Marc Espie | Files touched by this commit (3)
Log message:
use (SELECT ) inside INSERT for keyword tables, so that less actual perl
code is needed.
no actual schema change
   2019-01-12 06:57:41 by Marc Espie | Files touched by this commit (3)
Log message:
use (SELECT ) inside INSERT for keyword tables, so that less actual perl
code is needed.
no actual schema change
   2019-01-12 04:10:00 by Marc Espie | Files touched by this commit (2)
Log message:
incorporate shared_libs into main view
   2019-01-12 04:10:00 by Marc Espie | Files touched by this commit (2)
Log message:
incorporate shared_libs into main view
   2019-01-11 14:52:25 by Marc Espie | Files touched by this commit (5)
Log message:
put distfiles in its own table along with indexers
   2019-01-11 14:52:25 by Marc Espie | Files touched by this commit (5)
Log message:
put distfiles in its own table along with indexers
   2019-01-11 14:52:25 by Marc Espie | Files touched by this commit (5)
Log message:
put distfiles in its own table along with indexers
   2019-01-11 14:52:25 by Marc Espie | Files touched by this commit (5)
Log message:
put distfiles in its own table along with indexers
   2019-01-11 14:52:25 by Marc Espie | Files touched by this commit (5)
Log message:
put distfiles in its own table along with indexers
   2019-01-11 14:22:26 by Marc Espie | Files touched by this commit (1)
Log message:
fix comma location with columns with an expr
   2019-01-11 12:52:14 by Marc Espie | Files touched by this commit (2)
Log message:
fix wantlib view to not create bogus entries
create a wantlib_ordered view with full lists of wantlib
re-incorporate wantlib into main ports view
   2019-01-11 12:52:14 by Marc Espie | Files touched by this commit (2)
Log message:
fix wantlib view to not create bogus entries
create a wantlib_ordered view with full lists of wantlib
re-incorporate wantlib into main ports view
   2019-01-11 12:51:39 by Marc Espie | Files touched by this commit (1)
Log message:
stop inheriting from Select, but forward appropriate methods instead
   2019-01-11 08:44:59 by Marc Espie | Files touched by this commit (1)
Log message:
make the View::Column display smarter: intuit join/base table names
(default to join for obvious reasons)
   2019-01-11 03:26:51 by Marc Espie | Files touched by this commit (2)
Log message:
rewrite ::Expr to be more sensible wrt complicated expressions
ditch the "origin/origin_name" nonsense
   2019-01-11 03:26:51 by Marc Espie | Files touched by this commit (2)
Log message:
rewrite ::Expr to be more sensible wrt complicated expressions
ditch the "origin/origin_name" nonsense
   2019-01-10 06:44:22 by Marc Espie | Files touched by this commit (1)
Log message:
todo
   2019-01-09 08:46:20 by Marc Espie | Files touched by this commit (2)
Log message:
add descr/readme to ports view, simplify print-ports-index
don't left join on categories, it's always here.
make 'alter-tables' full
wantlib_ordered does not work yet... more stuff to look at.
   2019-01-09 08:46:20 by Marc Espie | Files touched by this commit (2)
Log message:
add descr/readme to ports view, simplify print-ports-index
don't left join on categories, it's always here.
make 'alter-tables' full
wantlib_ordered does not work yet... more stuff to look at.
   2019-01-09 05:59:44 by Marc Espie | Files touched by this commit (4)
Log message:
fix table name in canonical_depends, somehow my tests missed it :(
Re-add EqualConstant, so that I can actually error out if names are NOT
there.
   2019-01-09 05:59:44 by Marc Espie | Files touched by this commit (4)
Log message:
fix table name in canonical_depends, somehow my tests missed it :(
Re-add EqualConstant, so that I can actually error out if names are NOT
there.
   2019-01-09 05:59:44 by Marc Espie | Files touched by this commit (4)
Log message:
fix table name in canonical_depends, somehow my tests missed it :(
Re-add EqualConstant, so that I can actually error out if names are NOT
there.
   2019-01-09 05:59:44 by Marc Espie | Files touched by this commit (4)
Log message:
fix table name in canonical_depends, somehow my tests missed it :(
Re-add EqualConstant, so that I can actually error out if names are NOT
there.
   2019-01-08 16:28:15 by Marc Espie | Files touched by this commit (2)
Log message:
simplify table name handling
   2019-01-08 16:28:15 by Marc Espie | Files touched by this commit (2)
Log message:
simplify table name handling
   2019-01-08 12:43:14 by Marc Espie | Files touched by this commit (1)
Log message:
no longer needed
   2019-01-08 12:42:45 by Marc Espie | Files touched by this commit (6)
Log message:
move to using Sql for most tables and Views, no functional change.
The main benefit is that it's easier to construct the schema from several
places, with proper indentation.
Also, sql knows a bit about sql, so it's able to
- know which column is a foreign key, just reference the table
- remove table aliases when they're not needed
- leave table names out in table.column when there's no ambiguity.
For instance, view Ports now looks like:
CREATE VIEW Ports AS
SELECT
Id AS PathId,
_Paths.FullPkgPath AS FullPkgPath,
_AutoVersion.Value AS AUTOCONF_VERSION,
T0001.Value AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths
ON Canonical=_Ports.FullPkgPath
LEFT JOIN _AutoVersion
ON _AutoVersion.KeyRef=AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0001
ON T0001.KeyRef=AUTOMAKE_VERSION
instead of:
CREATE VIEW Ports AS
SELECT
T0057.Id AS PathId,
T0057.FULLPKGPATH AS FULLPKGPATH,
T0058.VALUE AS AUTOCONF_VERSION,
T0059.VALUE AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths T0057
ON  T0057.Canonical=_Ports.FULLPKGPATH
LEFT JOIN _AutoVersion T0058
ON  T0058.KEYREF=_Ports.AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0059
ON  T0059.KEYREF=_Ports.AUTOMAKE_VERSION
   2019-01-08 12:42:45 by Marc Espie | Files touched by this commit (6)
Log message:
move to using Sql for most tables and Views, no functional change.
The main benefit is that it's easier to construct the schema from several
places, with proper indentation.
Also, sql knows a bit about sql, so it's able to
- know which column is a foreign key, just reference the table
- remove table aliases when they're not needed
- leave table names out in table.column when there's no ambiguity.
For instance, view Ports now looks like:
CREATE VIEW Ports AS
SELECT
Id AS PathId,
_Paths.FullPkgPath AS FullPkgPath,
_AutoVersion.Value AS AUTOCONF_VERSION,
T0001.Value AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths
ON Canonical=_Ports.FullPkgPath
LEFT JOIN _AutoVersion
ON _AutoVersion.KeyRef=AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0001
ON T0001.KeyRef=AUTOMAKE_VERSION
instead of:
CREATE VIEW Ports AS
SELECT
T0057.Id AS PathId,
T0057.FULLPKGPATH AS FULLPKGPATH,
T0058.VALUE AS AUTOCONF_VERSION,
T0059.VALUE AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths T0057
ON  T0057.Canonical=_Ports.FULLPKGPATH
LEFT JOIN _AutoVersion T0058
ON  T0058.KEYREF=_Ports.AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0059
ON  T0059.KEYREF=_Ports.AUTOMAKE_VERSION
   2019-01-08 12:42:45 by Marc Espie | Files touched by this commit (6)
Log message:
move to using Sql for most tables and Views, no functional change.
The main benefit is that it's easier to construct the schema from several
places, with proper indentation.
Also, sql knows a bit about sql, so it's able to
- know which column is a foreign key, just reference the table
- remove table aliases when they're not needed
- leave table names out in table.column when there's no ambiguity.
For instance, view Ports now looks like:
CREATE VIEW Ports AS
SELECT
Id AS PathId,
_Paths.FullPkgPath AS FullPkgPath,
_AutoVersion.Value AS AUTOCONF_VERSION,
T0001.Value AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths
ON Canonical=_Ports.FullPkgPath
LEFT JOIN _AutoVersion
ON _AutoVersion.KeyRef=AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0001
ON T0001.KeyRef=AUTOMAKE_VERSION
instead of:
CREATE VIEW Ports AS
SELECT
T0057.Id AS PathId,
T0057.FULLPKGPATH AS FULLPKGPATH,
T0058.VALUE AS AUTOCONF_VERSION,
T0059.VALUE AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths T0057
ON  T0057.Canonical=_Ports.FULLPKGPATH
LEFT JOIN _AutoVersion T0058
ON  T0058.KEYREF=_Ports.AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0059
ON  T0059.KEYREF=_Ports.AUTOMAKE_VERSION
   2019-01-08 12:42:45 by Marc Espie | Files touched by this commit (6)
Log message:
move to using Sql for most tables and Views, no functional change.
The main benefit is that it's easier to construct the schema from several
places, with proper indentation.
Also, sql knows a bit about sql, so it's able to
- know which column is a foreign key, just reference the table
- remove table aliases when they're not needed
- leave table names out in table.column when there's no ambiguity.
For instance, view Ports now looks like:
CREATE VIEW Ports AS
SELECT
Id AS PathId,
_Paths.FullPkgPath AS FullPkgPath,
_AutoVersion.Value AS AUTOCONF_VERSION,
T0001.Value AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths
ON Canonical=_Ports.FullPkgPath
LEFT JOIN _AutoVersion
ON _AutoVersion.KeyRef=AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0001
ON T0001.KeyRef=AUTOMAKE_VERSION
instead of:
CREATE VIEW Ports AS
SELECT
T0057.Id AS PathId,
T0057.FULLPKGPATH AS FULLPKGPATH,
T0058.VALUE AS AUTOCONF_VERSION,
T0059.VALUE AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths T0057
ON  T0057.Canonical=_Ports.FULLPKGPATH
LEFT JOIN _AutoVersion T0058
ON  T0058.KEYREF=_Ports.AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0059
ON  T0059.KEYREF=_Ports.AUTOMAKE_VERSION
   2019-01-08 12:42:45 by Marc Espie | Files touched by this commit (6)
Log message:
move to using Sql for most tables and Views, no functional change.
The main benefit is that it's easier to construct the schema from several
places, with proper indentation.
Also, sql knows a bit about sql, so it's able to
- know which column is a foreign key, just reference the table
- remove table aliases when they're not needed
- leave table names out in table.column when there's no ambiguity.
For instance, view Ports now looks like:
CREATE VIEW Ports AS
SELECT
Id AS PathId,
_Paths.FullPkgPath AS FullPkgPath,
_AutoVersion.Value AS AUTOCONF_VERSION,
T0001.Value AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths
ON Canonical=_Ports.FullPkgPath
LEFT JOIN _AutoVersion
ON _AutoVersion.KeyRef=AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0001
ON T0001.KeyRef=AUTOMAKE_VERSION
instead of:
CREATE VIEW Ports AS
SELECT
T0057.Id AS PathId,
T0057.FULLPKGPATH AS FULLPKGPATH,
T0058.VALUE AS AUTOCONF_VERSION,
T0059.VALUE AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths T0057
ON  T0057.Canonical=_Ports.FULLPKGPATH
LEFT JOIN _AutoVersion T0058
ON  T0058.KEYREF=_Ports.AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0059
ON  T0059.KEYREF=_Ports.AUTOMAKE_VERSION
   2019-01-08 12:42:45 by Marc Espie | Files touched by this commit (6)
Log message:
move to using Sql for most tables and Views, no functional change.
The main benefit is that it's easier to construct the schema from several
places, with proper indentation.
Also, sql knows a bit about sql, so it's able to
- know which column is a foreign key, just reference the table
- remove table aliases when they're not needed
- leave table names out in table.column when there's no ambiguity.
For instance, view Ports now looks like:
CREATE VIEW Ports AS
SELECT
Id AS PathId,
_Paths.FullPkgPath AS FullPkgPath,
_AutoVersion.Value AS AUTOCONF_VERSION,
T0001.Value AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths
ON Canonical=_Ports.FullPkgPath
LEFT JOIN _AutoVersion
ON _AutoVersion.KeyRef=AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0001
ON T0001.KeyRef=AUTOMAKE_VERSION
instead of:
CREATE VIEW Ports AS
SELECT
T0057.Id AS PathId,
T0057.FULLPKGPATH AS FULLPKGPATH,
T0058.VALUE AS AUTOCONF_VERSION,
T0059.VALUE AS AUTOMAKE_VERSION,
[...]
FROM _Ports
JOIN _Paths T0057
ON  T0057.Canonical=_Ports.FULLPKGPATH
LEFT JOIN _AutoVersion T0058
ON  T0058.KEYREF=_Ports.AUTOCONF_VERSION
LEFT JOIN _AutoVersion T0059
ON  T0059.KEYREF=_Ports.AUTOMAKE_VERSION
   2019-01-06 23:09:40 by Marc Espie | Files touched by this commit (1)
Log message:
trim table names in on part as well if we can
sort table/views for easier comparison
have table aliases per-select
   2019-01-02 15:49:42 by Marc Espie | Files touched by this commit (1)
Log message:
have prepend respect the order of added columns
add Sql::IsNull join constraint
   2019-01-02 08:37:51 by Marc Espie | Files touched by this commit (1)
Log message:
fix prepend for views (need to go to the select, like add)
and add a "constant" join, because ordered_depends.2  does not mean much...
   2019-01-01 09:23:10 by Marc Espie | Files touched by this commit (1)
Log message:
column_names + better diagnostics for incomplete reference.
   2018-12-30 12:08:25 by Marc Espie | Files touched by this commit (1)
Log message:
typo
   2018-12-30 03:40:32 by Marc Espie | Files touched by this commit (1)
Log message:
have the inserter order match the table order, much less confusing for later
   2018-12-28 03:48:57 by Marc Espie | Files touched by this commit (1)
Log message:
allow multi-line stringize (for expr) and indent each accordingly
allow view columns to double as group-by entries, because it's often
the case
   2018-12-27 05:37:33 by Marc Espie | Files touched by this commit (1)
Log message:
references can know which field it's referring to (table key) in many cases
   2018-12-27 03:38:21 by Marc Espie | Files touched by this commit (1)
Log message:
refine syntax a bit, constraints don't need to exist as separate objects
(group-by, order-by to revisit ?)
start using parent
   2018-12-26 07:01:29 by Marc Espie | Files touched by this commit (1)
Log message:
turns out moving "AS" around like this breaks WITH.
give a "parent" handle to list elements because they often need to look
at it.
various syntax additions
   2018-12-26 06:20:15 by Marc Espie | Files touched by this commit (2)
Log message:
fix stupid double pathid
   2018-12-26 06:20:15 by Marc Espie | Files touched by this commit (2)
Log message:
fix stupid double pathid
   2018-12-24 03:49:47 by Marc Espie | Files touched by this commit (1)
Log message:
choose inserter mode.
pull the AS into the contents so that we can get another mode of creating
views.
   2018-12-21 10:06:21 by Marc Espie | Files touched by this commit (1)
Log message:
join will become ambiguous
   2018-12-21 10:06:07 by Marc Espie | Files touched by this commit (1)
Log message:
skip actual autoincrement keys.
   2018-12-21 04:49:05 by Marc Espie | Files touched by this commit (1)
Log message:
take column names into account
   2018-12-21 04:11:06 by Marc Espie | Files touched by this commit (3)
Log message:
register views and tables centrally (so we know the names)
inserter sql statement
   2018-12-21 04:11:06 by Marc Espie | Files touched by this commit (3)
Log message:
register views and tables centrally (so we know the names)
inserter sql statement
   2018-12-21 04:11:06 by Marc Espie | Files touched by this commit (3)
Log message:
register views and tables centrally (so we know the names)
inserter sql statement
   2018-12-20 14:02:09 by Marc Espie | Files touched by this commit (1)
Log message:
add group_concat idiom
add missing commas
remove extra table name from select if there's just one table involved
   2018-12-20 13:39:24 by Marc Espie | Files touched by this commit (1)
Log message:
simplify origin sytnax
   2018-12-20 08:57:16 by Marc Espie | Files touched by this commit (1)
Log message:
a bit more fluff
   2018-12-20 08:10:13 by Marc Espie | Files touched by this commit (2)
Log message:
Tweak table/view creation so that it will be able to use the new nicer way
once it's ready
   2018-12-20 08:10:13 by Marc Espie | Files touched by this commit (2)
Log message:
Tweak table/view creation so that it will be able to use the new nicer way
once it's ready
   2018-12-20 05:13:01 by Marc Espie | Files touched by this commit (1)
Log message:
make table aliases global, but trigger them later
add "prepend" so that we can more easily tweak tables/views from both
sides
   2018-12-19 09:05:14 by Marc Espie | Files touched by this commit (1)
Log message:
add glue for with contents
allow view columns without join (for now)
fix group by/order by display
   2018-12-19 08:34:14 by Marc Espie | Files touched by this commit (1)
Log message:
tweak join handling so it preserves column order
   2018-12-19 08:29:47 by Marc Espie | Files touched by this commit (1)
Log message:
have show-reverse-deps be more extensive.
Specifically, get it to take a pkgpath, and extend it to all variations
on that path
(e.g., try
show-reverse-deps devel/py-jedi after the change,
yields all the stuff depending on python2 AND python3 flavors)
   2018-12-18 12:09:26 by Marc Espie | Files touched by this commit (1)
Log message:
(unused yet) tools to building "readable" sql requests with nice indent
for sqlports
   2018-12-04 03:35:09 by Marc Espie | Files touched by this commit (4)
Log message:
faster turn-around: add a small script (and inserter logic) that can
just recreate the view info on top of an existing db.
   2018-12-04 03:35:09 by Marc Espie | Files touched by this commit (4)
Log message:
faster turn-around: add a small script (and inserter logic) that can
just recreate the view info on top of an existing db.
   2018-12-04 03:35:09 by Marc Espie | Files touched by this commit (4)
Log message:
faster turn-around: add a small script (and inserter logic) that can
just recreate the view info on top of an existing db.
   2018-12-04 03:35:09 by Marc Espie | Files touched by this commit (4)
Log message:
faster turn-around: add a small script (and inserter logic) that can
just recreate the view info on top of an existing db.
   2018-12-03 13:11:15 by Marc Espie | Files touched by this commit (3)
Log message:
do a bit  of pretty printing on the other generated views as well
   2018-12-03 13:11:15 by Marc Espie | Files touched by this commit (3)
Log message:
do a bit  of pretty printing on the other generated views as well
   2018-12-03 13:11:15 by Marc Espie | Files touched by this commit (3)
Log message:
do a bit  of pretty printing on the other generated views as well
   2018-12-03 08:28:40 by Marc Espie | Files touched by this commit (3)
Log message:
replace the Column stuff with semantically identical definitions but
correctly indented
This makes most views marginally more readable
   2018-12-03 08:28:40 by Marc Espie | Files touched by this commit (3)
Log message:
replace the Column stuff with semantically identical definitions but
correctly indented
This makes most views marginally more readable
   2018-12-03 08:28:40 by Marc Espie | Files touched by this commit (3)
Log message:
replace the Column stuff with semantically identical definitions but
correctly indented
This makes most views marginally more readable
   2018-12-03 07:01:03 by Marc Espie | Files touched by this commit (1)
Log message:
heh. adding all pkgpaths leading to a canonical version mean I have to
dedup for the ports index (e.g., group by...)
This should yield a fully stable index now
   2018-12-01 13:37:57 by Marc Espie | Files touched by this commit (3)
Log message:
iick, I still need to cd ${PORTSDIR} for DESCR, unfuck ports-INDEX
also add MASTER_SITES* and *DEPENDS to main ports view
also strip network.conf from "unneeded" makefile names
   2018-12-01 13:37:57 by Marc Espie | Files touched by this commit (3)
Log message:
iick, I still need to cd ${PORTSDIR} for DESCR, unfuck ports-INDEX
also add MASTER_SITES* and *DEPENDS to main ports view
also strip network.conf from "unneeded" makefile names
   2018-12-01 13:37:57 by Marc Espie | Files touched by this commit (3)
Log message:
iick, I still need to cd ${PORTSDIR} for DESCR, unfuck ports-INDEX
also add MASTER_SITES* and *DEPENDS to main ports view
also strip network.conf from "unneeded" makefile names
   2018-12-01 13:36:19 by Marc Espie | Files touched by this commit (1)
Log message:
also write the inserter in verbose mode
   2018-12-01 08:48:15 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks:
- do the cd ${PORTSDIR} directly in the script, no need to change directory
to run mksqlitedb
- uniformize build vs fake to do every build part during build
   2018-12-01 08:48:15 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks:
- do the cd ${PORTSDIR} directly in the script, no need to change directory
to run mksqlitedb
- uniformize build vs fake to do every build part during build
   2018-12-01 01:28:55 by Marc Espie | Files touched by this commit (2)
Log message:
add even more data to the main view, mainly most of the keyword lists
fixes a bug in the previous incarnation which would incorrectly record
one single key for lists (like CONFIGURE_STYLE)
simplify print-ports-INDEX accordingly
   2018-12-01 01:28:55 by Marc Espie | Files touched by this commit (2)
Log message:
add even more data to the main view, mainly most of the keyword lists
fixes a bug in the previous incarnation which would incorrectly record
one single key for lists (like CONFIGURE_STYLE)
simplify print-ports-INDEX accordingly
   2018-11-30 15:26:04 by Marc Espie | Files touched by this commit (3)
Log message:
integrate a few of the list variables into the main view
   2018-11-30 15:26:04 by Marc Espie | Files touched by this commit (3)
Log message:
integrate a few of the list variables into the main view
   2018-11-30 15:26:04 by Marc Espie | Files touched by this commit (3)
Log message:
integrate a few of the list variables into the main view
   2018-11-30 02:08:24 by Marc Espie | Files touched by this commit (2)
Log message:
separate inserter roles so I'll be able to add secondary vars to the
ports view
   2018-11-30 02:08:24 by Marc Espie | Files touched by this commit (2)
Log message:
separate inserter roles so I'll be able to add secondary vars to the
ports view
   2018-11-29 10:26:18 by Marc Espie | Files touched by this commit (2)
Log message:
rework _canonical_depends to be more similar to ports (e.g., canonicalize
the result, not the fullpkgpath).
create canonical_depends with the same info in a human readable form, so
yeah, a new join !
   2018-11-29 10:26:18 by Marc Espie | Files touched by this commit (2)
Log message:
rework _canonical_depends to be more similar to ports (e.g., canonicalize
the result, not the fullpkgpath).
create canonical_depends with the same info in a human readable form, so
yeah, a new join !
   2018-11-29 04:44:58 by Marc Espie | Files touched by this commit (3)
Log message:
deal better with canonical paths: actually create a view row for
each fullpkgpath that results in a given canonical path.
note that there are "orphans" in _paths: the few bare pkgpaths entries that do
NOT correspond to a full-fledged fullpkgpath.
Add a paths view that shows the actual text associated with pkgpath and
canonical.
   2018-11-29 04:44:58 by Marc Espie | Files touched by this commit (3)
Log message:
deal better with canonical paths: actually create a view row for
each fullpkgpath that results in a given canonical path.
note that there are "orphans" in _paths: the few bare pkgpaths entries that do
NOT correspond to a full-fledged fullpkgpath.
Add a paths view that shows the actual text associated with pkgpath and
canonical.
   2018-11-29 04:44:58 by Marc Espie | Files touched by this commit (3)
Log message:
deal better with canonical paths: actually create a view row for
each fullpkgpath that results in a given canonical path.
note that there are "orphans" in _paths: the few bare pkgpaths entries that do
NOT correspond to a full-fledged fullpkgpath.
Add a paths view that shows the actual text associated with pkgpath and
canonical.
   2018-11-28 10:34:28 by Marc Espie | Files touched by this commit (3)
Log message:
with the "dual database" gone, I can get rid of a lot of scaffolding.
   2018-11-28 10:34:28 by Marc Espie | Files touched by this commit (3)
Log message:
with the "dual database" gone, I can get rid of a lot of scaffolding.
   2018-11-28 10:34:28 by Marc Espie | Files touched by this commit (3)
Log message:
with the "dual database" gone, I can get rid of a lot of scaffolding.
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-28 07:57:45 by Marc Espie | Files touched by this commit (13)
Log message:
switch to one single schema for sqlports. Kill sqlports-compact (it is the
new default, change tables to be _table, views to be view (for now)) and
adjust consumers to work with the new tool, to the best of my knowledge
   2018-11-27 09:31:25 by Marc Espie | Files touched by this commit (2)
Log message:
very minor code clean-up
   2018-11-27 09:31:25 by Marc Espie | Files touched by this commit (2)
Log message:
very minor code clean-up
   2018-11-27 03:36:17 by Marc Espie | Files touched by this commit (4)
Log message:
pass inserter thru so it's much easier to change table schemes
   2018-11-27 03:36:17 by Marc Espie | Files touched by this commit (4)
Log message:
pass inserter thru so it's much easier to change table schemes
   2018-11-27 03:36:17 by Marc Espie | Files touched by this commit (4)
Log message:
pass inserter thru so it's much easier to change table schemes
   2018-11-27 03:36:17 by Marc Espie | Files touched by this commit (4)
Log message:
pass inserter thru so it's much easier to change table schemes
   2018-11-27 01:28:34 by Marc Espie | Files touched by this commit (3)
Log message:
minor cleanups. Prepare for the column mapper to accept as many parameters
as needed
   2018-11-27 01:28:34 by Marc Espie | Files touched by this commit (3)
Log message:
minor cleanups. Prepare for the column mapper to accept as many parameters
as needed
   2018-11-27 01:28:34 by Marc Espie | Files touched by this commit (3)
Log message:
minor cleanups. Prepare for the column mapper to accept as many parameters
as needed
   2018-11-26 15:53:41 by Marc Espie | Files touched by this commit (4)
Log message:
add more correct equivalence handling in order to get predictable results.
(as asked by robert@)
side-effect: paths is now much larger...
   2018-11-26 15:53:41 by Marc Espie | Files touched by this commit (4)
Log message:
add more correct equivalence handling in order to get predictable results.
(as asked by robert@)
side-effect: paths is now much larger...
   2018-11-26 15:53:41 by Marc Espie | Files touched by this commit (4)
Log message:
add more correct equivalence handling in order to get predictable results.
(as asked by robert@)
side-effect: paths is now much larger...
   2018-11-26 15:53:41 by Marc Espie | Files touched by this commit (4)
Log message:
add more correct equivalence handling in order to get predictable results.
(as asked by robert@)
side-effect: paths is now much larger...
   2018-11-25 10:45:57 by Marc Espie | Files touched by this commit (2)
Log message:
now we're getting serious :)
   2018-11-25 10:45:57 by Marc Espie | Files touched by this commit (2)
Log message:
now we're getting serious :)
   2018-11-25 10:08:48 by Marc Espie | Files touched by this commit (3)
Log message:
add a "canonical_depends" schema with normalized pkgpaths on both sides
   2018-11-25 10:08:48 by Marc Espie | Files touched by this commit (3)
Log message:
add a "canonical_depends" schema with normalized pkgpaths on both sides
   2018-11-25 10:08:48 by Marc Espie | Files touched by this commit (3)
Log message:
add a "canonical_depends" schema with normalized pkgpaths on both sides
   2018-11-25 09:28:32 by Marc Espie | Files touched by this commit (4)
Log message:
fix README/DESCR tables to actually contain the filename along with the
contents.
move print-ports-index to sqlports-compact, now that enough pieces of the
puzzle are there.
(still missing joins for all the *_ordered stuff in default _ports view)
   2018-11-25 09:28:32 by Marc Espie | Files touched by this commit (4)
Log message:
fix README/DESCR tables to actually contain the filename along with the
contents.
move print-ports-index to sqlports-compact, now that enough pieces of the
puzzle are there.
(still missing joins for all the *_ordered stuff in default _ports view)
   2018-11-25 09:28:32 by Marc Espie | Files touched by this commit (4)
Log message:
fix README/DESCR tables to actually contain the filename along with the
contents.
move print-ports-index to sqlports-compact, now that enough pieces of the
puzzle are there.
(still missing joins for all the *_ordered stuff in default _ports view)
   2018-11-25 09:28:32 by Marc Espie | Files touched by this commit (4)
Log message:
fix README/DESCR tables to actually contain the filename along with the
contents.
move print-ports-index to sqlports-compact, now that enough pieces of the
puzzle are there.
(still missing joins for all the *_ordered stuff in default _ports view)
   2018-11-25 08:04:10 by Marc Espie | Files touched by this commit (4)
Log message:
minor tweaks and addition:
- prepare to handle all columns in the main ports view.
- add a PathId column to a few views where it makes sense.
- reorg inserter to simplify all creation of tables and views thru a single
common method instead of rolling my own several times.
   2018-11-25 08:04:10 by Marc Espie | Files touched by this commit (4)
Log message:
minor tweaks and addition:
- prepare to handle all columns in the main ports view.
- add a PathId column to a few views where it makes sense.
- reorg inserter to simplify all creation of tables and views thru a single
common method instead of rolling my own several times.
   2018-11-25 08:04:10 by Marc Espie | Files touched by this commit (4)
Log message:
minor tweaks and addition:
- prepare to handle all columns in the main ports view.
- add a PathId column to a few views where it makes sense.
- reorg inserter to simplify all creation of tables and views thru a single
common method instead of rolling my own several times.
   2018-11-25 08:04:10 by Marc Espie | Files touched by this commit (4)
Log message:
minor tweaks and addition:
- prepare to handle all columns in the main ports view.
- add a PathId column to a few views where it makes sense.
- reorg inserter to simplify all creation of tables and views thru a single
common method instead of rolling my own several times.
   2018-11-21 09:00:49 by Marc Espie | Files touched by this commit (1)
Log message:
document my code a bit ;)
   2018-11-19 12:58:28 by Marc Espie | Files touched by this commit (3)
Log message:
refactor again so that we can actually handle depends
   2018-11-19 12:58:28 by Marc Espie | Files touched by this commit (3)
Log message:
refactor again so that we can actually handle depends
   2018-11-19 12:58:28 by Marc Espie | Files touched by this commit (3)
Log message:
refactor again so that we can actually handle depends
   2018-11-19 09:43:39 by Marc Espie | Files touched by this commit (3)
Log message:
start adding ordered lists for multiple value vars, to be completed.
   2018-11-19 09:43:39 by Marc Espie | Files touched by this commit (3)
Log message:
start adding ordered lists for multiple value vars, to be completed.
   2018-11-19 09:43:39 by Marc Espie | Files touched by this commit (3)
Log message:
start adding ordered lists for multiple value vars, to be completed.
   2018-11-19 08:13:06 by Marc Espie | Files touched by this commit (1)
Log message:
factor common code
   2018-11-17 05:19:08 by Marc Espie | Files touched by this commit (2)
Log message:
fix trace mechanism, almost the same as dpb.
   2018-11-17 05:19:08 by Marc Espie | Files touched by this commit (2)
Log message:
fix trace mechanism, almost the same as dpb.
   2018-11-17 03:39:40 by Marc Espie | Files touched by this commit (3)
Log message:
zap autocarp code that doesn't work (to be replaced)
add N, QUOTETYPE columns to be able to reconstitue lists in views.
   2018-11-17 03:39:40 by Marc Espie | Files touched by this commit (3)
Log message:
zap autocarp code that doesn't work (to be replaced)
add N, QUOTETYPE columns to be able to reconstitue lists in views.
   2018-11-17 03:39:40 by Marc Espie | Files touched by this commit (3)
Log message:
zap autocarp code that doesn't work (to be replaced)
add N, QUOTETYPE columns to be able to reconstitue lists in views.
   2018-11-16 11:15:18 by Marc Espie | Files touched by this commit (1)
Log message:
make sure DPB does not interfere with what's collected
   2018-11-16 11:14:08 by Marc Espie | Files touched by this commit (3)
Log message:
also dump PKGPATHS, which gives us all build-packages for a port
   2018-11-16 11:14:08 by Marc Espie | Files touched by this commit (3)
Log message:
also dump PKGPATHS, which gives us all build-packages for a port
   2018-11-16 11:14:08 by Marc Espie | Files touched by this commit (3)
Log message:
also dump PKGPATHS, which gives us all build-packages for a port
   2018-11-16 07:45:57 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks:
- make the table names/view names convention configurable so that it's
easy to swap
- sort table creation for easy diffing
- more accurate constraints on the Paths table
   2018-11-16 07:45:57 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks:
- make the table names/view names convention configurable so that it's
easy to swap
- sort table creation for easy diffing
- more accurate constraints on the Paths table
   2018-11-15 12:41:55 by Marc Espie | Files touched by this commit (1)
Log message:
portslist does NOT run-depends on sqlite, that's the point
   2018-11-13 10:06:11 by Marc Espie | Files touched by this commit (1)
Log message:
register USE_LLD
   2018-11-12 08:27:35 by Marc Espie | Files touched by this commit (3)
Log message:
add print-ports-index and ports-INDEX
   2018-11-12 08:27:35 by Marc Espie | Files touched by this commit (3)
Log message:
add print-ports-index and ports-INDEX
   2018-11-12 08:27:35 by Marc Espie | Files touched by this commit (3)
Log message:
add print-ports-index and ports-INDEX
   2018-11-10 10:12:24 by Marc Espie | Files touched by this commit (1)
Log message:
what do you know ? I can just reuse the lexical from the other package
   2018-11-10 09:41:03 by Marc Espie | Files touched by this commit (2)
Log message:
strip PORTSDIR from DESCR/README
   2018-11-10 09:41:03 by Marc Espie | Files touched by this commit (2)
Log message:
strip PORTSDIR from DESCR/README
   2018-10-21 08:57:55 by Marc Espie | Files touched by this commit (1)
Log message:
make sure we don't catch SUBDIRLIST on later calls
   2018-09-04 06:41:51 by Marc Espie | Files touched by this commit (2)
Log message:
introduce PKGSTEM
intended to fix a problem reported by tb@: pkg-readmes docs used to have
the FULLPKGNAME encoded, which makes for gratuitous differences from version
to version.
- use PKGSTEM inside the README for less variation
- ditch the FULLPKGNAME as the install location, PKGSTEM is enough.
PKGSTEM ?=  is overrideable, because stuff like php branches need to install
several readmes.
Next commit will fix all affected ports: all readmes change location, so lots
of plist tweaks and bumps
   2018-09-04 06:41:51 by Marc Espie | Files touched by this commit (2)
Log message:
introduce PKGSTEM
intended to fix a problem reported by tb@: pkg-readmes docs used to have
the FULLPKGNAME encoded, which makes for gratuitous differences from version
to version.
- use PKGSTEM inside the README for less variation
- ditch the FULLPKGNAME as the install location, PKGSTEM is enough.
PKGSTEM ?=  is overrideable, because stuff like php branches need to install
several readmes.
Next commit will fix all affected ports: all readmes change location, so lots
of plist tweaks and bumps
   2018-08-10 04:19:18 by Marc Espie | Files touched by this commit (17)
Log message:
use AUTOCONF_ENV and add correct env variables, so that those ports work
even if /usr/local is not part of the builder's path.
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2018-05-26 08:20:43 by Marc Espie | Files touched by this commit (4)
Log message:
add support for SUBST_VARS and UPDATE_PLIST_ARGS
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-06-05 08:48:09 by Marc Espie | Files touched by this commit (5)
Log message:
add COMPILER_LINKS. Tweak USE_WXNEEDED to support a 3rd option (special)
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-31 02:39:21 by Marc Espie | Files touched by this commit (4)
Log message:
pass COMPILER/COMPILER_LANGS thru
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-05-12 12:18:09 by Marc Espie | Files touched by this commit (5)
Log message:
support WANT_CXX and LIBECXX in sqlports
   2017-04-10 13:11:11 by Marc Espie | Files touched by this commit (2)
Log message:
hack things so that LIBCXX doesn't get expanded for sqlports.
This will probably be revisited and cleansed later.
okay sthen@
   2017-04-10 13:11:11 by Marc Espie | Files touched by this commit (2)
Log message:
hack things so that LIBCXX doesn't get expanded for sqlports.
This will probably be revisited and cleansed later.
okay sthen@
   2017-01-30 09:39:22 by Stuart Henderson | Files touched by this commit (1)
Log message:
add RDEP on sqlite3, ok espie@
   2016-09-23 03:16:58 by Stuart Henderson | Files touched by this commit (124)
Log message:
Cope with moving sqlite3 back to ports.
   2016-08-18 06:28:53 by Stuart Henderson | Files touched by this commit (2)
Log message:
Add an USE_WXNEEDED flag for ports, to write an ld wrapper script in
${WRKDIR}/bin that adds -z wxneeded to linker command lines. It won't work
everywhere but provides an easy (and easily identifiable) way to add this
flag without fiddling with build systems.
Feedback/ok jca@ jasper@
   2016-08-18 06:28:53 by Stuart Henderson | Files touched by this commit (2)
Log message:
Add an USE_WXNEEDED flag for ports, to write an ld wrapper script in
${WRKDIR}/bin that adds -z wxneeded to linker command lines. It won't work
everywhere but provides an easy (and easily identifiable) way to add this
flag without fiddling with build systems.
Feedback/ok jca@ jasper@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-20 14:03:07 by Christian Weisgerber | Files touched by this commit (4)
Log message:
drop SHARED_ONLY from the variables available in the database; ok jca@
   2016-03-16 09:49:37 by Christian Weisgerber | Files touched by this commit (2)
Log message:
remove NO_SHARED_ARCHS and the resulting unreachable code
   2016-03-16 09:49:37 by Christian Weisgerber | Files touched by this commit (2)
Log message:
remove NO_SHARED_ARCHS and the resulting unreachable code
   2015-05-14 12:01:08 by Jasper Lievisse Adriaanse | Files touched by this commit (2)
Log message:
store PORTROACH_COMMENT
ok sthen@ (previous bsd.port.mk commit was ok with stuart too)
   2015-05-14 12:01:08 by Jasper Lievisse Adriaanse | Files touched by this commit (2)
Log message:
store PORTROACH_COMMENT
ok sthen@ (previous bsd.port.mk commit was ok with stuart too)
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2015-04-19 06:08:02 by Marc Espie | Files touched by this commit (4)
Log message:
track first dependency parent so that we can display it, instead
of the user having to figure out where the broken dependency comes from
by inspecting the partial database.
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2014-11-04 03:44:33 by Marc Espie | Files touched by this commit (5)
Log message:
add support for MAKEFILE_LIST
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-04-10 12:01:13 by Jasper Lievisse Adriaanse | Files touched by this commit (15)
Log message:
adjust after recent lesstif removal
ok aja@ sthen@
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-03-02 09:19:54 by Marc Espie | Files touched by this commit (4)
Log message:
tweak the way mksqlitedb work: keep looking at dependencies after we do
the main tree.
initial work by florent tribouilloy
a bit of clean-up from me.
   2011-01-04 14:55:19 by Marc Espie | Files touched by this commit (2)
Log message:
handle PATCHFILES, ignore CHECKSUM_FILE
   2011-01-04 14:55:19 by Marc Espie | Files touched by this commit (2)
Log message:
handle PATCHFILES, ignore CHECKSUM_FILE
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:32:38 by Marc Espie | Files touched by this commit (5)
Log message:
handle USE_MOTIF, add PKGSPEC
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-26 13:11:12 by Marc Espie | Files touched by this commit (4)
Log message:
report Yes/No variables with wrong values.
common work with Florent Tribouilloy
also rework Yes/No variables as valued variables.
   2010-11-14 17:22:54 by Marc Espie | Files touched by this commit (427)
Log message:
convert to new style depends
zap default spec that are not needed
convert libspecs as well
convert p* to REVISION.
No package changes
   2010-11-14 01:42:00 by Marc Espie | Files touched by this commit (2)
Log message:
prepare for new specs
   2010-11-14 01:42:00 by Marc Espie | Files touched by this commit (2)
Log message:
prepare for new specs
   2010-10-30 17:00:28 by Marc Espie | Files touched by this commit (1)
Log message:
fix. stupid. me.
   2010-10-28 05:11:17 by Marc Espie | Files touched by this commit (1)
Log message:
make sure sqlports will stop in case of an error.
problem noticed by steven@, sneaky solution by me ;)
   2010-10-24 14:44:50 by Antoine Jacoutot | Files touched by this commit (1)
Log message:
Remove obsolete USE_X11 from $vars.
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-10-02 04:26:17 by Marc Espie | Files touched by this commit (6)
Log message:
USE_LIBTOOL is 3-valued.
register TARGETS
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-09-21 09:18:03 by Stuart Henderson | Files touched by this commit (4)
Log message:
output EPOCH and REVISION in dump-vars, and use it in sqlports.
ok espie@ (with a reminder to add EPOCH, my first diff just had REVISION).
   2010-04-26 04:20:51 by Marc Espie | Files touched by this commit (3)
Log message:
whitespace
   2010-04-26 04:20:51 by Marc Espie | Files touched by this commit (3)
Log message:
whitespace
   2010-04-26 04:20:51 by Marc Espie | Files touched by this commit (3)
Log message:
whitespace
   2010-04-26 04:19:02 by Marc Espie | Files touched by this commit (1)
Log message:
get ready to coalesce columns
   2010-04-26 02:52:09 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks + whitespace
   2010-04-26 02:52:09 by Marc Espie | Files touched by this commit (2)
Log message:
minor tweaks + whitespace
   2010-04-25 06:35:26 by Marc Espie | Files touched by this commit (1)
Log message:
view_schema always follows the same format, so just do that...
   2010-04-19 03:21:31 by Marc Espie | Files touched by this commit (1)
Log message:
fix, should build correctly even if SUBDIR is defined
   2010-04-17 08:48:15 by Marc Espie | Files touched by this commit (2)
Log message:
simplify mapping slightly for now...
   2010-04-17 08:48:15 by Marc Espie | Files touched by this commit (2)
Log message:
simplify mapping slightly for now...
   2010-04-17 08:37:02 by Marc Espie | Files touched by this commit (3)
Log message:
turn on foreign key constraints, as they seem to work ;-)
   2010-04-17 08:37:02 by Marc Espie | Files touched by this commit (3)
Log message:
turn on foreign key constraints, as they seem to work ;-)
   2010-04-17 08:37:02 by Marc Espie | Files touched by this commit (3)
Log message:
turn on foreign key constraints, as they seem to work ;-)
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 07:06:49 by Marc Espie | Files touched by this commit (7)
Log message:
a few minor tidying.
commit to db only at end of port (referential integrity for later)
handle BROKEN-arch and create new table/view based on that.
   2010-04-17 03:33:18 by Marc Espie | Files touched by this commit (3)
Log message:
sanitize code, no functional changes
   2010-04-17 03:33:18 by Marc Espie | Files touched by this commit (3)
Log message:
sanitize code, no functional changes
   2010-04-17 03:33:18 by Marc Espie | Files touched by this commit (3)
Log message:
sanitize code, no functional changes
   2010-04-13 04:56:42 by Marc Espie | Files touched by this commit (3)
Log message:
rename stuff to try to make it clearer.
   2010-04-13 04:56:42 by Marc Espie | Files touched by this commit (3)
Log message:
rename stuff to try to make it clearer.
   2010-04-13 04:56:42 by Marc Espie | Files touched by this commit (3)
Log message:
rename stuff to try to make it clearer.
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-04-13 04:23:53 by Marc Espie | Files touched by this commit (4)
Log message:
cut script into smaller pieces, since it becomes hard to manage
   2010-02-12 04:53:09 by Marc Espie | Files touched by this commit (2)
Log message:
get mksqlitedb to handle IGNORE and COMES_WITH if they show up.
Also don't spazz out if we meet variables we don't know. This makes us
safe from changes in dump-vars.
   2010-02-12 04:53:09 by Marc Espie | Files touched by this commit (2)
Log message:
get mksqlitedb to handle IGNORE and COMES_WITH if they show up.
Also don't spazz out if we meet variables we don't know. This makes us
safe from changes in dump-vars.
   2009-12-01 11:27:46 by Marc Espie | Files touched by this commit (3)
Log message:
tag sqlports as "always-update".
If you don't have current pkgtools, *this will break*.
(@option always-update was introduced over a month ago).
   2009-12-01 11:27:46 by Marc Espie | Files touched by this commit (3)
Log message:
tag sqlports as "always-update".
If you don't have current pkgtools, *this will break*.
(@option always-update was introduced over a month ago).
   2009-12-01 11:27:46 by Marc Espie | Files touched by this commit (3)
Log message:
tag sqlports as "always-update".
If you don't have current pkgtools, *this will break*.
(@option always-update was introduced over a month ago).
   2009-08-25 03:23:03 by Marc Espie | Files touched by this commit (1)
Log message:
oops
   2009-08-25 03:15:43 by Marc Espie | Files touched by this commit (2)
Log message:
use left join on optional values, otherwise we lose a lot of _ports entries.
   2009-08-25 03:15:43 by Marc Espie | Files touched by this commit (2)
Log message:
use left join on optional values, otherwise we lose a lot of _ports entries.
   2009-08-15 21:24:28 by Marc Espie | Files touched by this commit (1)
Log message:
make internals more consistent
   2009-08-15 06:43:58 by Marc Espie | Files touched by this commit (2)
Log message:
start building the _Ports view.
   2009-08-15 06:43:58 by Marc Espie | Files touched by this commit (2)
Log message:
start building the _Ports view.
   2009-08-14 08:02:12 by Marc Espie | Files touched by this commit (1)
Log message:
consistent capitalization
   2009-08-14 06:41:56 by Marc Espie | Files touched by this commit (2)
Log message:
create views for most of the subsidiary tables
   2009-08-14 06:41:56 by Marc Espie | Files touched by this commit (2)
Log message:
create views for most of the subsidiary tables
   2009-08-14 05:31:37 by Marc Espie | Files touched by this commit (2)
Log message:
create the ports table in the same way
   2009-08-14 05:31:37 by Marc Espie | Files touched by this commit (2)
Log message:
create the ports table in the same way
   2009-08-14 04:45:52 by Marc Espie | Files touched by this commit (2)
Log message:
higher level table creation for individual tables except Ports:
create column objects, and ask the inserter to "render" them.
   2009-08-14 04:45:52 by Marc Espie | Files touched by this commit (2)
Log message:
higher level table creation for individual tables except Ports:
create column objects, and ask the inserter to "render" them.
   2009-08-14 03:23:10 by Marc Espie | Files touched by this commit (2)
Log message:
even though sqlite doesn't really care, this fixes the column types and adds
foreign key constraints to all the sql compact stuff.
   2009-08-14 03:23:10 by Marc Espie | Files touched by this commit (2)
Log message:
even though sqlite doesn't really care, this fixes the column types and adds
foreign key constraints to all the sql compact stuff.
   2008-11-25 11:01:15 by Marc Espie | Files touched by this commit (2)
Log message:
kill oldish wantlib syntax that no longer exists, results in saner wantlib
tables.
   2008-11-25 11:01:15 by Marc Espie | Files touched by this commit (2)
Log message:
kill oldish wantlib syntax that no longer exists, results in saner wantlib
tables.
   2008-10-26 17:42:24 by Marc Espie | Files touched by this commit (1)
Log message:
fixes some inheritance issues. Problem noticed by bernd@
   2008-10-26 09:12:30 by Marc Espie | Files touched by this commit (1)
Log message:
recognize more wrong depends errors
   2008-08-20 15:02:47 by Marc Espie | Files touched by this commit (1)
Log message:
style nitpick, no functional changes
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2008-08-19 17:50:54 by Marc Espie | Files touched by this commit (8)
Log message:
new version, lots of code refactoring, and a new compact database.
   2007-09-15 16:27:39 by Simon Bertrang | Files touched by this commit (29)
Log message:
remove surrounding quotes from COMMENT/BROKEN/PERMIT_*
   2007-02-15 01:04:49 by Steven Mestdagh | Files touched by this commit (2)
Log message:
NO_CHECKSUM and remove empty distinfo
from mikolaj.kucharski at gmail.com
go for it espie@


   2007-02-15 01:04:49 by Steven Mestdagh | Files touched by this commit (2)
Log message:
NO_CHECKSUM and remove empty distinfo
from mikolaj.kucharski at gmail.com
go for it espie@


   2006-12-27 04:16:10 by Steven Mestdagh | Files touched by this commit (2)
Log message:
put USE_X11 in the table.
sure espie@
   2006-12-27 04:16:10 by Steven Mestdagh | Files touched by this commit (2)
Log message:
put USE_X11 in the table.
sure espie@
   2006-11-03 16:26:41 by Marc Espie | Files touched by this commit (2)
Log message:
optimize table structure, idea from Martynas Venckus
   2006-11-03 16:26:41 by Marc Espie | Files touched by this commit (2)
Log message:
optimize table structure, idea from Martynas Venckus
   2006-11-03 16:03:09 by Marc Espie | Files touched by this commit (2)
Log message:
use DROP IF EXISTS (from Martynas Venckus)
fix WANTLIB, regexp to strip version was totally wrong...
(more to come)
   2006-11-03 16:03:09 by Marc Espie | Files touched by this commit (2)
Log message:
use DROP IF EXISTS (from Martynas Venckus)
fix WANTLIB, regexp to strip version was totally wrong...
(more to come)
   2006-10-15 03:41:44 by Marc Espie | Files touched by this commit (2)
Log message:
move mksqlitedb in the port that uses it.
   2006-10-15 03:41:44 by Marc Espie | Files touched by this commit (2)
Log message:
move mksqlitedb in the port that uses it.
   2006-08-01 10:22:22 by Marc Espie | Files touched by this commit (2)
Log message:
tweak for PKGPATH, name it correctly as FULLPKGPATH, and add a subsidiary
table to map FULLPKGPATH to PKGPATH, e.g.,
SELECT DISTINCT PKGPATH, VALUE FROM Wantlib,Paths WHERE Wantlib.FULLPKGPATH=Paths.FULLPKGPATH ORDER BY PKGPATH


   2006-08-01 10:22:22 by Marc Espie | Files touched by this commit (2)
Log message:
tweak for PKGPATH, name it correctly as FULLPKGPATH, and add a subsidiary
table to map FULLPKGPATH to PKGPATH, e.g.,
SELECT DISTINCT PKGPATH, VALUE FROM Wantlib,Paths WHERE Wantlib.FULLPKGPATH=Paths.FULLPKGPATH ORDER BY PKGPATH


   2006-07-10 08:34:01 by Marc Espie | Files touched by this commit (2)
Log message:
Handle CONFIGURE_ARGS as a list, e.g.,
SELECT DISTINCT VALUE FROM ConfigureArgs
makes sense.


   2006-07-10 08:34:01 by Marc Espie | Files touched by this commit (2)
Log message:
Handle CONFIGURE_ARGS as a list, e.g.,
SELECT DISTINCT VALUE FROM ConfigureArgs
makes sense.


   2006-07-10 05:44:30 by Marc Espie | Files touched by this commit (2)
Log message:
Really process SHARED_LIBS


   2006-07-10 05:44:30 by Marc Espie | Files touched by this commit (2)
Log message:
Really process SHARED_LIBS