X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;ds=inline;f=daklib%2Fdbconn.py;h=21c9cc626a82956b8e75fb207073cf0abb692e09;hb=e0ef48cd237d4af31499adbb16606ce3d8b7ee4f;hp=5bd1d76595717043fb744d1715d33612e8d9c442;hpb=fdf3c42445b4f11f4cd71634dd2b57cb7d7a4f36;p=dak.git diff --git a/daklib/dbconn.py b/daklib/dbconn.py index 5bd1d765..21c9cc62 100755 --- a/daklib/dbconn.py +++ b/daklib/dbconn.py @@ -452,6 +452,32 @@ class DBConn(Singleton): return id + def get_suite_architectures(self, suite): + """ + Returns list of architectures for C{suite}. + + @type suite: string, int + @param suite: the suite name or the suite_id + + @rtype: list + @return: the list of architectures for I{suite} + """ + + suite_id = None + if type(suite) == str: + suite_id = self.get_suite_id(suite) + elif type(suite) == int: + suite_id = suite + else: + return None + + c = self.db_con.cursor() + c.execute( """SELECT a.arch_string FROM suite_architectures sa + JOIN architecture a ON (a.id = sa.architecture) + WHERE suite='%s'""" % suite_id ) + + return map(lambda x: x[0], c.fetchall()) + def insert_content_paths(self, package, fullpaths): """ Make sure given path is associated with given binary id @@ -470,7 +496,7 @@ class DBConn(Singleton): try: # Remove any already existing recorded files for this package - c.execute("""DELETE FROM temp_content_associations + c.execute("""DELETE FROM pending_content_associations WHERE package=%(Package)s AND version=%(Version)s""", package ) @@ -481,7 +507,7 @@ class DBConn(Singleton): file_id = self.get_or_set_contents_file_id(file) path_id = self.get_or_set_contents_path_id(path) - c.execute("""INSERT INTO temp_content_associations + c.execute("""INSERT INTO pending_content_associations (package, version, filepath, filename) VALUES (%%(Package)s, %%(Version)s, '%d', '%d')""" % (path_id, file_id), package )