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

1"""add `authorized_by_fingerprint` 

2 

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

4@copyright: 2025 Ansgar <ansgar@debian.org> 

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

6""" 

7 

8# This program is free software; you can redistribute it and/or modify 

9# it under the terms of the GNU General Public License as published by 

10# the Free Software Foundation; either version 2 of the License, or 

11# (at your option) any later version. 

12 

13# This program is distributed in the hope that it will be useful, 

14# but WITHOUT ANY WARRANTY; without even the implied warranty of 

15# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 

16# GNU General Public License for more details. 

17 

18# You should have received a copy of the GNU General Public License 

19# along with this program; if not, write to the Free Software 

20# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 

21 

22################################################################################ 

23 

24statements = [ 

25 """ 

26 ALTER TABLE binaries 

27 ADD COLUMN authorized_by_fingerprint_id INTEGER 

28 REFERENCES fingerprint(id) 

29 """, 

30 """ 

31 COMMENT ON COLUMN binaries.authorized_by_fingerprint_id 

32 IS 'fingerprint of signature used to authorized the upload' 

33 """, 

34 """ 

35 ALTER TABLE source 

36 ADD COLUMN authorized_by_fingerprint_id INTEGER 

37 REFERENCES fingerprint(id) 

38 """, 

39 """ 

40 COMMENT ON COLUMN source.authorized_by_fingerprint_id 

41 IS 'fingerprint of signature used to authorized the upload' 

42 """, 

43 """ 

44 ALTER TABLE changes ADD COLUMN authorized_by_fingerprint TEXT 

45 """, 

46 """ 

47 COMMENT ON COLUMN changes.authorized_by_fingerprint 

48 IS 'fingerprint of signature used to authorized the upload' 

49 """, 

50]