Source Code for Module dak.dakdb.update102

 1  """ 
 2  src_associations_full view, now also including sources for all binaries 
 3   
 4  @contact: Debian FTP Master <ftpmaster@debian.org> 
 5  @copyright: 2013-2014, 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   
25  import psycopg2 
26   
27  from daklib.dak_exceptions import DBUpdateError 
28   
29  statements = [ 
30      """ 
31  CREATE OR REPLACE VIEW src_associations_full AS 
32  SELECT 
33    suite, 
34    source, 
35    BOOL_AND(extra_source) AS extra_source 
36  FROM 
37    (SELECT sa.suite AS suite, sa.source AS source, FALSE AS extra_source 
38       FROM src_associations sa 
39     UNION 
40     SELECT ba.suite AS suite, esr.src_id AS source_id, TRUE AS extra_source 
41       FROM extra_src_references esr 
42       JOIN bin_associations ba ON esr.bin_id = ba.bin 
43     UNION 
44     SELECT ba.suite AS suite, b.source AS source, TRUE AS extra_source 
45       FROM bin_associations ba 
46       JOIN binaries b ON ba.bin = b.id) 
47    AS tmp 
48  GROUP BY suite, source 
49  """, 
50      """ 
51  COMMENT ON VIEW src_associations_full IS 
52    'all source packages for a suite, including sources for all binaries and those referenced by Built-Using' 
53  """, 
54  ] 
55   
56  ################################################################################ 
57   
58   
59 -def do_update(self): 
60      print(__doc__) 
61      try: 
62          c = self.db.cursor() 
63   
64          for stmt in statements: 
65              c.execute(stmt) 
66   
67          c.execute("UPDATE config SET value = '102' WHERE name = 'db_revision'") 
68          self.db.commit() 
69   
70      except psycopg2.ProgrammingError as msg: 
71          self.db.rollback() 
72          raise DBUpdateError( 
73              "Unable to apply sick update 102, rollback issued. Error message: {0}".format( 
74                  msg 
75              ) 
76          ) 
77