summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_db_maintenance.py
AgeCommit message (Collapse)AuthorFilesLines
2015-05-08reproducible: db: fix syntaxMattia Rizzolo1-3/+3
2015-05-08fixup languageHolger Levsen1-1/+1
2015-05-08reproducible: new table (and new column on the schedule table) on the db ↵Mattia Rizzolo1-0/+8
where to take note of who schedule what
2015-05-01fix typoHolger Levsen1-1/+1
2015-04-25reproducible: add a sane mean to notify the IRC channel when builds finish.Mattia Rizzolo1-0/+4
* new column in the database, schedule table * turn $SAVE_ARTIFACTS a true boolean, 0→no artifacts, 1→yes artifacts * $NOTIFY in the build script is text containg a keyword: + if empty no notification will be sent + if "debbindiff" a "$DBDVERSION had trouble with these" will be sent + if "failure" a "no artifacts could have been saved"-like will be sent + any other value trigs a normal message * adapt the maintenance script and the manual scheduler to cope with the new column
2015-04-16reproducible: new db table: removed_packages, to track removed package and ↵Mattia Rizzolo1-0/+7
subsequently clean up files the db now stores tuple of (pkgname, suite, architecture) of every removed packages, then reproducible_maintenance.sh pick up entries from it and find+remove files. For now the reproducible_maintenance only output what he would have remove.
2015-03-29reproducible: store notes in the database. This is a initial work. It does ↵Mattia Rizzolo1-0/+15
nothing other than picking the yaml files and store it's content on the db
2015-03-29reproducible: db_maintenance: print out execution time infosMattia Rizzolo1-4/+18
2015-03-29reproducible: db_maintenance: update comments, removing references to a dev ↵Mattia Rizzolo1-3/+2
version of the script
2015-03-14reproducible: rename 'sid' to 'unstable'Holger Levsen1-0/+8
2015-03-14reproducible: add myself to copyrightHolger Levsen1-0/+1
2015-03-10fix typoHolger Levsen1-1/+1
2015-03-10reproducible: db schema 8: add default value to stats_bugs to get a full ↵Holger Levsen1-0/+36
'done vs open bugs' graph
2015-03-07reproducible: db: results.build_duration should be type integer, so ORDER BY ↵Mattia Rizzolo1-0/+27
works as it should
2015-03-03fixup last commitHolger Levsen1-1/+1
2015-03-03reproducible: stats_builds_age needs (datum, suite) as primary keyHolger Levsen1-0/+15
2015-03-03reproducible: stats_builds_per_day needs (datum, suite) as primary keyHolger Levsen1-0/+16
2015-03-02reproducible: update db schema: stats_pkg_state needs (datum, suite) as ↵Holger Levsen1-0/+17
primary key
2015-02-27fix syntax errorHolger Levsen1-1/+1
2015-02-27reproducible: track new usertag, umaskHolger Levsen1-0/+4
2015-02-27reproducible: db_maintenance: add open_signatures, done_signatures, ↵Mattia Rizzolo1-0/+4
open_environment, done_environment columns to the bugs_stats. they are already there, just document them
2015-02-26fix some more typos and languageHolger Levsen1-6/+6
2015-02-26fix typoHolger Levsen1-1/+1
2015-02-26reproducible: and finally commit the updated schema. + a new simple script ↵Mattia Rizzolo1-0/+268
to manage the db schema and handle+track updates (so remove the schema from _common.sh and call this instead)