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

1""" 

2Add component ordering 

3 

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

5@copyright: 2012 Varnish Software AS 

6@author: Tollef Fog Heen <tfheen@varnish-software.com> 

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

8""" 

9 

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

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

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

13# (at your option) any later version. 

14 

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

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

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

18# GNU General Public License for more details. 

19 

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

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

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

23 

24################################################################################ 

25 

26statements = [ 

27 """ 

28ALTER TABLE component 

29ADD COLUMN ordering INTEGER UNIQUE 

30""", 

31 """ 

32CREATE SEQUENCE component_ordering_seq 

33INCREMENT BY 10 

34START WITH 100 

35OWNED BY component.ordering 

36""", 

37] 

38 

39statements += [ 

40 f"UPDATE component SET ordering = nextval('component_ordering_seq') WHERE name = '{component}'" 

41 for component in ("main", "contrib", "non-free-firmware", "non-free") 

42] 

43 

44statements += [ 

45 "UPDATE component SET ordering = nextval('component_ordering_seq') WHERE ordering IS NULL", 

46 "ALTER TABLE component ALTER COLUMN ordering SET NOT NULL", 

47 "ALTER TABLE component ALTER COLUMN ordering SET DEFAULT nextval('component_ordering_seq')", 

48]