summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_common.py
AgeCommit message (Collapse)AuthorFilesLines
2016-10-17reproducible debian: make python sql more sqlite/postgres agnosticValerie R Young1-23/+23
This commit fixes all the python script sql queries that required minimal editing to be syntactically correct for both sqlite and postgres. Almost all fixes consist of the removal of double quotes from query strings. NOTE: the following scripts expect the schedule table's primary key to autoincrement. Running reproducible_db_maintence.py on a postgres database will not add the necessary autoincrementing functionality at this time. The following script WILL run on the sqlite database but will fail on postgres database constructed from reproducible_db_maintence.py until this is fixed: reproducible_remote_scheduler.py reproducible_schedule.py Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-10-02reproducible Debian: Move regular "Scheduled in..." messages to #-changesChris Lamb1-2/+2
2016-08-20reproducible debian: raise the timeout to 60sHolger Levsen1-1/+1
2016-08-20reproducible debian: raise the connetion timeout to the db to 30 secondsMattia Rizzolo1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-08-19reproducible debian: common: add missing 'sys.' on the exit(1) callMattia Rizzolo1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-08-19reproducible debian: make sqlite3 locking errors less noisyValerie R Young1-4/+12
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-08-19reproducible debian: switch python database backend to SQLAlchemyValerie R Young1-8/+40
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-08-03reproducible debian: remove suite or arch nav when not relevent for pageValerie R Young1-30/+29
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-08-03reproducible debian: add cross suite/arch nav for scheduled and maintainersValerie R Young1-11/+23
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-28reproducible debian: move mustache template directory out of binValerie R Young1-1/+1
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-28reproducible debian: show the "show all" button when summary tag supportedValerie R Young1-1/+2
The "summary" tag is presentally not supported in firefox... but will be with the release of firefox version 48 in August 2016! In the meantime, this commit hides the "see all package sets in suite/arch" button on the package set pages used to expand all the summary tags for firefox. Once Firefox 48 is released, this commit should be reverted. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-26reproducible debian: add versioning to css style sheetsValerie R Young1-1/+10
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: add collapsible sections to pkgset navigationValerie R Young1-1/+2
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: add categories to meta_pkgset definitionsValerie R Young1-2/+2
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: decouple navigation and page writing logicValerie R Young1-37/+15
Decoupling the navigation and page writing logic made it easier to do the following: - fix a bug introduced by adding headers at the top of the mainbody div (fixed in this commit) - make package pages to use the same structure as all other pages that contain a left navigation (to do in future) Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: add cross arch/suite navigation for many pagesValerie R Young1-7/+33
From the left navigation "suite/arch" section, you can now navigation between suite and architecture specific results for the following pages: packages sets, packages with notes, packages without notes, packages tested in 24/48hs, all packages state pages and all packages page. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: first pass at main navigation improvementsValerie R Young1-2/+14
Reshuffled links, added headers, added hover text, small changes in highlighting of links. Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: move page titles to mainbody, add dashboard header in navValerie R Young1-2/+2
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-24reproducible debian: move html from code into basic_page templateValerie R Young1-16/+14
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-17reproducible debian: rewrite reproducible_html_pkg_sets in pythonValerie R Young1-9/+16
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-17reproducible debian: add main navigation highlighting to python pagesValerie R Young1-3/+15
Added the correct navigation highlighting to the following pages: notes, no notes, tested in the last 24 hours, tested in the last 48 hours, all packages, notifications enabled, breakages, issue pages, scheduled, and maintainers page. Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: replace bash write_page_footer with mustache templateValerie R Young1-5/+2
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: add common function for creating temporary filesValerie R Young1-0/+10
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: add mustache script for main page navigationValerie R Young1-114/+18
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: add package list symbol legend templateValerie R Young1-14/+3
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: add template for default footerValerie R Young1-18/+11
[ Mattia Rizzolo ] wrap and indent lines in default_page_footer.mustache Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: add a percent() function to reproducible_common.pyValerie R Young1-0/+4
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: move python 'gen_status_link_icon' function to commonValerie R Young1-0/+25
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-07-05reproducible debian: move META_PKGSET definition to csv fileValerie R Young1-0/+9
Signed-off-by: Mattia Rizzolo <mattia@debian.org> Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-18reproducible debian: common: collect bug titles too while collecting data ↵Mattia Rizzolo1-5/+5
about bugs Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-17reproducible debian: improve package page navigationValerie R Young1-0/+1
Changes made: - suite and arch specific details moved from the top of side bar to the suite and arch section - "notes" and "test history" (suite and arch agnostic) move to the top of side bar - hover text added to most links, starting with either "Go to:" (if the link takes you away from package page) or "Show:" (if the link opens a file in the iframe) - enabled notifications flag still on top left, by "Test Details" header reproducible debian: address mattia's code review comments Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-17reproducible debian: dont hide broken piecesHolger Levsen1-0/+1
2016-06-14reproducible debian: also decorate popular packages in per-issue pagesXimin Luo1-8/+12
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-10reproducible debian: fix more links on test.r-b.orgValerie R Young1-19/+19
Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-08reproducible debian: bug fix: only debian html belongs in tests.r-b.org/debianValerie R Young1-35/+36
2016-06-08reproducible debian: update urls to include tests.r-b.org/debian directoryValerie R Young1-3/+5
2016-06-08reproducible debian: create subdirectory tests.r-b.org/debianValerie R Young1-1/+1
2016-06-07reproducible debian: the issue ftbfs_build-indep_not_build_on_armhf has been ↵Holger Levsen1-1/+1
renamed to ftbfs_build-indep_not_build_on_some_archs in notes.git
2016-06-07Fix get_bugs - don't join on the same table twice, also remove redundant ↵Ximin Luo1-3/+1
join against "sources" Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-04reproducible debian: stop filtering out the ↵Mattia Rizzolo1-1/+0
'bad_handling_of_extra_warnings', it's long gone Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-06-03reproducible debian: ignore ftbfs_build-indep_not_build_on_armhf for ↵Holger Levsen1-0/+1
tracker.json and on FTBFS pages
2016-05-21reproducible debian: add more spacing between archs/suites to make it ↵Reiner Herrmann1-2/+2
clearer they are separate links Signed-off-by: Holger Levsen <holger@layer-acht.org>
2016-05-20reproducible debian: new page, 'variations tested', split off from dashboardHolger Levsen1-0/+1
2016-05-18reproducible debian: new page, performance stats, split off from dashboardHolger Levsen1-0/+1
2016-05-18reproducible debian: add link to S_D_E spec on every pageHolger Levsen1-0/+1
2016-05-14reproducible debian: fix typoHolger Levsen1-1/+1
2016-05-14reproducible debian: restructure navigationHolger Levsen1-24/+53
2016-05-14reproducible debian navigation: start reorganizing new navigation (WIP, ↵Holger Levsen1-47/+58
misses the .sh part)
2016-05-14reproducible debian navigation: s#⚑#⚑ packages with enabled notifications#Holger Levsen1-1/+1
2016-05-14reproducible debian navigation: merge package states icons into one fieldHolger Levsen1-14/+2