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

1""" 

2Add support for Description-md5 

3 

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

5@copyright: 2011 Ansgar Burchardt <ansgar@debian.org> 

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

7""" 

8 

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

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

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

12# (at your option) any later version. 

13 

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

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

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

17# GNU General Public License for more details. 

18 

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

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

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

22 

23################################################################################ 

24 

25statements = [ 

26 """CREATE OR REPLACE FUNCTION public.add_missing_description_md5() 

27 RETURNS VOID 

28 VOLATILE 

29 LANGUAGE plpgsql 

30AS $function$ 

31DECLARE 

32 description_key_id metadata_keys.key_id%TYPE; 

33 description_md5_key_id metadata_keys.key_id%TYPE; 

34 BEGIN 

35 SELECT key_id INTO STRICT description_key_id FROM metadata_keys WHERE key='Description'; 

36 SELECT key_id INTO description_md5_key_id FROM metadata_keys WHERE key='Description-md5'; 

37 IF NOT FOUND THEN 

38 INSERT INTO metadata_keys (key) VALUES ('Description-md5') RETURNING key_id INTO description_md5_key_id; 

39 END IF; 

40 

41 INSERT INTO binaries_metadata 

42 (bin_id, key_id, value) 

43 SELECT 

44 bm.bin_id AS bin_id, 

45 description_md5_key_id AS key_id, 

46 MD5(bm.value || E'\n') AS value 

47 FROM binaries_metadata AS bm 

48 WHERE 

49 bm.key_id = description_key_id 

50 AND 

51 NOT EXISTS (SELECT 1 FROM binaries_metadata AS bm2 WHERE bm.bin_id = bm2.bin_id AND bm2.key_id = description_md5_key_id); 

52END; 

53$function$""", 

54 "ALTER TABLE suite ADD COLUMN include_long_description BOOLEAN NOT NULL DEFAULT 't'", 

55]