print "Fixing bin_assoc_by_arch view"
try:
c = self.db.cursor()
- c.execute("DROP VIEW bin_assoc_by_arch")
c.execute("""CREATE OR REPLACE VIEW bin_assoc_by_arch AS
SELECT ba.suite, ba.bin, a.id AS arch
FROM bin_associations ba
JOIN binaries b ON ba.bin = b.id, architecture a
- WHERE a.id > 2 AND (b.architecture = 2 OR b.architecture = a.id)
- """
+ WHERE a.id > 2 AND (b.architecture = 2 OR b.architecture = a.id) """)
c.execute("UPDATE config SET value = '5' WHERE name = 'db_revision'")
self.db.commit()