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
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 )
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 )