CREATE TABLE src_format (
id SERIAL PRIMARY KEY,
format_name TEXT NOT NULL,
- unique (format_name)
+ UNIQUE (format_name)
)
""")
c.execute("INSERT INTO src_format (format_name) VALUES('1.0')")
c.execute("""
CREATE TABLE suite_src_formats (
- suite INT4 NOT NULL,
- src_format INT4 NOT NULL,
- unique (suite, src_format)
+ suite INT4 NOT NULL REFERENCES suite(id),
+ src_format INT4 NOT NULL REFERENCES src_format(id),
+ PRIMARY KEY (suite, src_format)
)
""")
print "Authorize format 1.0 on all suites by default"
c.execute("SELECT id FROM suite")
suites = c.fetchall()
- c.execute("SELECT id FROM src_format WHERE format_name == '1.0'")
+ c.execute("SELECT id FROM src_format WHERE format_name = '1.0'")
formats = c.fetchall()
for s in suites:
- c.execute("INSERT INTO suite_src_formats (suite, src_format) VALUES(%s, %s)", (s[0], f[0]))
+ for f in formats:
+ c.execute("INSERT INTO suite_src_formats (suite, src_format) VALUES(%s, %s)", (s[0], f[0]))
print "Authorize all other formats on tpu, unstable & experimental by default"
c.execute("SELECT id FROM suite WHERE suite_name IN ('testing-proposed-updates', 'unstable', 'experimental')")