[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reprodcible: db_maintenance: convert stats_build.build_duration from text to integer

[Mattia Rizzolo]

Mattia Rizzolo pushed to branch master at Debian QA / jenkins.debian.net


Commits:
673fd148 by Mattia Rizzolo at 2018-12-12T17:08:10Z
reprodcible: db_maintenance: convert stats_build.build_duration from text to integer

Thanks to Bernhard for noticing!

Signed-off-by: Mattia Rizzolo <mattia at debian.org>

- - - - -


1 changed file:

- bin/reproducible_db_maintenance.py


Changes:

=====================================
bin/reproducible_db_maintenance.py
=====================================
@@ -668,6 +668,10 @@ schema_updates = {
             ADD COLUMN distribution INTEGER DEFAULT 1
             REFERENCES distributions(id)""",
     ],
+    39: [  # fix build_duration datatype
+        "ALTER TABLE stats_build ALTER COLUMN build_duration SET DATA TYPE integer"
+        " USING build_duration::integer"
+    ],
 }
 
 



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/673fd148299a943de9af0daf1d13678a9617e1b1

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/673fd148299a943de9af0daf1d13678a9617e1b1
You're receiving this email because of your account on salsa.debian.org.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20181212/15295eb9/attachment.html>