Coverage for dak/dakdb/update116.py: 100%

1""" 

2Add support for by-hash with a new table and per-suite boolean 

3 

4@contact: Debian FTP Master <ftpmaster@debian.org> 

5@copyright: 2016, Julien Cristau <jcristau@debian.org> 

6@license: GNU General Public License version 2 or later 

7""" 

8 

9statements = [ 

10 "ALTER TABLE suite ADD COLUMN byhash BOOLEAN DEFAULT false", 

11 """ 

12 CREATE TABLE hashfile ( 

13 suite_id INTEGER NOT NULL REFERENCES suite(id) ON DELETE CASCADE, 

14 path TEXT NOT NULL, 

15 unreferenced TIMESTAMP, 

16 PRIMARY KEY (suite_id, path) 

17 ) 

18 """, 

19]