summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_db_maintenance.py
AgeCommit message (Collapse)AuthorFilesLines
2017-06-16reproducible debian: db: s/testing/stretch/gMattia Rizzolo1-2/+8
Signed-off-by: Mattia Rizzolo <mattia@debian.org>
2017-01-12fixup 93a522cb: reproducible Debian: add a graph with diffoscope crashes and ↵Holger Levsen1-4/+4
timeouts Signed-off-by: Holger Levsen <holger@layer-acht.org>
2017-01-12reproducible Debian: add a graph with diffoscope crashes and timeoutsHolger Levsen1-0/+9
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-12-19reproducible Debian: add auto incrementing to postgres id columnsValerie R Young1-0/+18
This commit makes reproducible_db_maintence.py no longer compatible with a sqlite database. Sqlite primary key id fields automatically autoincrement. To copy this functionality to the new postgresql database, the table id columns must be altered using postgres specific commands. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-11-08reproducible debian: generalize _db_maintenance script to work with postgres dbValerie R Young1-67/+76
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2015-12-20reproducible armhf: enable package setsHolger Levsen1-0/+21
2015-12-09reproducible: db: correct grammar in code commentMattia Rizzolo1-1/+1
2015-12-09reproducible: save the schedule message in the db and show it in the "test ↵Mattia Rizzolo1-0/+4
history" table
2015-12-09reproducible db: s,builder,job, also in the schedule table.Mattia Rizzolo1-0/+21
2015-12-09reproducible db: rename column in the results table: s#builder#job, and add ↵Mattia Rizzolo1-0/+20
build nodes information
2015-12-09reproducible: store in the db also the actual build host in stats_build, and ↵Mattia Rizzolo1-0/+22
rename the current "builder" field to "job", since it contains the jenkins job name and nummber
2015-08-19reproducible: fix table updatesHolger Levsen1-16/+16
2015-08-19reproducible: keep arch specific stats and introduce suite_$arch_statsHolger Levsen1-0/+56
2015-07-05reproducible: track new usertag 'locale'Holger Levsen1-0/+4
2015-07-05reproducible: improve commentHolger Levsen1-1/+1
2015-07-05reproducible: db 17: add a 'builder' column to schedule, results, ↵Mattia Rizzolo1-0/+5
stats_build to save who builded what
2015-06-17reproducible: provide default '0' value for all columns in stats_bugs (fixup ↵Holger Levsen1-0/+38
for f9147e8b)
2015-06-17reproducible: also track 'ftbfs' usertagHolger Levsen1-0/+4
2015-06-12reproducible: *.py: from datetime import datetime, timedelta instead of all ↵Mattia Rizzolo1-5/+5
datetime
2015-05-29reproducible: add another flag to the db, "notify_maintainer" to indicate ↵Mattia Rizzolo1-0/+3
that any status change on this package should be mailed to the maintainers. Also teach the build script how to handle that, emailing $pkgname@packages.debian.org
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)