sthen
8944205b73
record USE_NOEXECONLY in sqlports
2023-01-09 17:09:55 +00:00
espie
96e9672cb6
remove shortcut that was resulting in bizarre warning when trying to
...
integrate empty files
2022-11-14 12:54:47 +00:00
naddy
7a958849ed
drop RCS Ids
2022-03-11 18:31:17 +00:00
ajacoutot
32baf14873
Unbreak COMMENT-main and bump.
2021-11-23 07:10:49 +00:00
espie
737fb8bb76
zap a few PKGNAME-sub which are now default
...
(and also duplicated EPOCH-sub which make little sense in db/{v3,v4}
2021-11-22 13:55:54 +00:00
espie
de8d34ed61
add FIX_CRLF_FILES to secondary tables
2021-02-25 23:26:30 +00:00
espie
4d7cd6c96a
document DEBUG_* tables and views
2021-02-21 09:14:05 +00:00
espie
ec88bfaedb
finally add DEBUG_PACKAGES and DEBUG_CONFIGURE_ARGS to sqlports
...
not sure what I missed the last time as this is fundamentally trivial
2021-02-20 18:05:04 +00:00
espie
c10c81e8a7
simplify my debug process by allowing to restart build from a given point
2021-01-29 10:28:30 +00:00
espie
c0b8252709
add the date at which the db was generated into sqlports.
...
document Meta table, which I somehow forgot
2021-01-29 08:30:37 +00:00
espie
b95f372d1d
flesh out some more stuff in the manpage.
...
do a REV bump for once, since we don't actually change any real details
2020-07-07 10:53:27 +00:00
espie
f652d789b5
move description of the schema to a manpage
2020-07-06 09:06:45 +00:00
espie
d994b4272d
flesh out a bit more stuff from DESCR
2020-07-05 12:28:13 +00:00
espie
2ae760cc0d
seems that people don't expect this information to be in DESC, so start
...
converting it to mandoc, to be completed.
2020-07-05 12:23:24 +00:00
espie
2159135658
extend request a bit more so that verbose mode also shows type of dependency
2020-06-11 19:55:15 +00:00
espie
a0cef780a2
verbose mode, now that I've figured it out again
2020-06-11 16:05:52 +00:00
espie
f03a34da8b
add a few options and a manpage to show-reverse-deps
2020-06-11 15:40:41 +00:00
espie
00fb740c85
handling of DEBUG_PACKAGES/DEBUG_CONFIGURE_ARGS is bogus
...
just ignore them for now
2020-05-19 08:50:55 +00:00
espie
2f0dce97ea
likewise, don't try to use incomplete hash
2020-05-19 08:44:44 +00:00
espie
ca77b7dcb1
parse errors in dump-vars will lead to $h being invalid, push past that
...
so that it properly errors out without a huge dump
2020-05-19 08:38:03 +00:00
espie
1d9534e98b
allow SUBDIRLIST to leak through, in case robert@ wants to build
...
a partial db.
okay robert@
2019-11-26 11:32:17 +00:00
espie
2941d54083
add DEBUG_PACKAGES and DEBUG_CONFIGURE_ARGS
...
make sqlports strict by default (ignore PORTSDIR_PATH and look only in
PORTSDIR)
2019-11-11 20:44:39 +00:00
kn
870bcebea8
Say pkgpath not path in show-reverse-deps usage
...
Drop useless use of cat(1) and quote user input while here.
OK espie
2019-10-03 12:41:22 +00:00
espie
8a1ff3888e
get things to work even if DESCR is not an absolute path.
2019-08-24 23:16:25 +00:00
espie
935e9f2b7c
cleaner way to deal with paths, no functional change
2019-07-21 11:10:23 +00:00
espie
70d0d70b25
fix sqlports, bump to make sure
2019-07-20 23:12:47 +00:00
sthen
98e1189996
Add a belt-and-braces check for the number of lines output in the produced
...
ports-INDEX, error out if it's too small.
2019-07-18 06:35:43 +00:00
espie
d45c8394c9
bye bye old PERMIT_*
2019-07-14 11:27:19 +00:00
sthen
9fe1e38b23
replace simple PERMIT_PACKAGE_CDROM=Yes with PERMIT_PACKAGE=Yes
2019-07-12 20:43:27 +00:00
espie
3ec73388de
make sure to stop if scripts fail
...
as noticed by sthen@
2019-06-04 16:05:52 +00:00
espie
7271781869
phase out old PERMIT_* variables.
...
We won't be distributing CDROM anymore, so simplify to
just PERMIT_PACKAGE / PERMIT_DISTFILES
In particular, the new variables are shorter, so this makes
for better cosmetic sense in ports.
The "current" version allows for the old variables to die out
peacefully, at our leasure, and then I'll remove the old stubs.
As discussed with sthen@, various people agree, and deraadt@
is okay with the strategic change.
This does survive a bulk.
PLEASE NOTE: built packages require current pkg* tools.
In particular, the current version deals with
@comment pkgpath=* ftp=*
just fine, but the old one WILL COMPLAIN about missing cdrom info.
register-plist also doesn't care, adding/removing cdrom info
is a no-op for it. There is NO BUMP needed for the conversion.
For now, sqlports STILL carries the old variables. I'll deal
with their removal later.
2019-05-31 21:27:03 +00:00
espie
71a2ef4f62
Add a denormalized table that instantiates the main ports view.
...
So, Portsq is a snapshot of Ports... dirty but fast.
I had mixed feelings about this.
There's also a script to resync the table.
Grows the db by about 50% (+25MB)
Discussed with sthen@
2019-05-18 21:35:21 +00:00
espie
78fb9be676
create indices for all fullpkgpaths in secondary tables, this ought
...
to speed up some requests at least a little bit.
2019-05-17 20:41:54 +00:00
espie
9f70fcb4b8
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 11:29:53 +00:00
espie
86c6128347
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 13:29:21 +00:00
espie
4c1a6388c5
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 16:55:22 +00:00
espie
f70efd5390
rename a few methods and finish implementing chaining joins
2019-01-21 08:51:56 +00:00
espie
3e31d033e5
somewhat more extensive diagnostics
2019-01-17 17:39:00 +00:00
espie
037e1af327
better error reporting
2019-01-14 18:38:04 +00:00
espie
1f4ec730cf
allow us to ask for indexed/non indexed variables
2019-01-14 18:37:15 +00:00
espie
b44acbd441
use (SELECT ) inside INSERT for keyword tables, so that less actual perl
...
code is needed.
no actual schema change
2019-01-12 13:57:41 +00:00
espie
8a522c95ec
incorporate shared_libs into main view
2019-01-12 11:10:00 +00:00
espie
98537e4d7f
put distfiles in its own table along with indexers
2019-01-11 21:52:25 +00:00
espie
0af4f8081b
fix comma location with columns with an expr
2019-01-11 21:22:26 +00:00
espie
d906df9046
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 19:52:14 +00:00
espie
3196ba8cf0
stop inheriting from Select, but forward appropriate methods instead
2019-01-11 19:51:39 +00:00
espie
e14a11decb
fix the _wantlib table (it should separate >=10 as extra)
...
AND amend the wantlib view so that it has the "complete" wantlib
2019-01-11 17:17:13 +00:00
espie
a60e3c3634
make the View::Column display smarter: intuit join/base table names
...
(default to join for obvious reasons)
2019-01-11 15:44:59 +00:00
espie
388141c83e
rewrite ::Expr to be more sensible wrt complicated expressions
...
ditch the "origin/origin_name" nonsense
2019-01-11 10:26:51 +00:00
espie
00cb60d1c9
todo
2019-01-10 13:44:22 +00:00