#!/usr/bin/env python
"""
-Database Update Script - Fix bin_assoc_by_arch view
+Fix bin_assoc_by_arch view
@contact: Debian FTP Master <ftpmaster@debian.org>
@copyright: 2009 Joerg Jaspert <joerg@debian.org>
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()