summaryrefslogtreecommitdiff
path: root/patchtracker/DB.py
AgeCommit message (Collapse)AuthorFilesLines
2008-07-06bugfix: don't automatically prune in destructorSean Finney1-5/+10
otherwise its gets pruned every page visit, whoops.
2008-07-05use a "marked" field to catch stale/removed pkgsSean Finney1-2/+7
2008-06-28fix a long overdue XXX wrt diffgz's in pagehandlerSean Finney1-0/+10
2008-06-28have a "slightly" more efficient frontpage querySean Finney1-2/+15
2008-06-28db "optimizations" fsvo "optimization"Sean Finney1-8/+6
stop the voodoo with home-rolled "auto increment" type stuff. also, use sqlite "extensions" for conflict resolution (in schema for all but the source package table, which has it in saveSourcePackage), so that we don't need to check for pre-existing records. the "OR REPLACE" was doing this previously, but had wierd effects with modifying the primary key, which would cause db inconsistency and *really* wierd effects when combined with the triggers).
2008-06-28remove need for initial empty rows, fix syntax errSean Finney1-4/+4
2008-06-26package search / versionless implementationSean Finney1-39/+13
going to /packages/pkg now gives a table of contents with the available versions for the package, or the results of a widers search in the case of no exact matches also removed a bunch of dead code from DB mostly
2008-06-26add new collection row factory, query cleanupSean Finney1-26/+36
2008-06-24modify relateSourcePackage to take package/versionSean Finney1-4/+3
...instead of a source package, which should remove an extra query and also allow changing the behaviour for findSourcePackage later on as well
2008-06-24remove debug printing cruft for db bootstrappingSean Finney1-1/+0
2008-06-24slightly optimize query logic w/ INSERT OR REPLACESean Finney1-26/+11
2008-06-22big commit with db and cgi handling updatesSean Finney1-34/+137
i know it's bad form to lump this all together. oh well :p gen-patch-info now does very little besides processing packages and updating the relevant database entries. pretty much everything else is dynamically generated from pagehandler.py now.
2008-06-11saving some work on sqlite related stuffSean Finney1-0/+68