diff options
| author | Étienne Loks <etienne.loks@peacefrogs.net> | 2010-11-18 19:10:58 +0100 |
|---|---|---|
| committer | Étienne Loks <etienne.loks@peacefrogs.net> | 2010-11-18 19:10:58 +0100 |
| commit | 047416ad2a7d39aa41459df91a6a0b49daba92a4 (patch) | |
| tree | 93810fd4af0fcf6141bd2f7340ea8b660737aec2 /chimere/scripts/upgrade.py | |
| parent | d676446e6f2f5b9b210df3b74a8881f47f210a4f (diff) | |
| download | Chimère-047416ad2a7d39aa41459df91a6a0b49daba92a4.tar.bz2 Chimère-047416ad2a7d39aa41459df91a6a0b49daba92a4.zip | |
Correct the upgrade script
Diffstat (limited to 'chimere/scripts/upgrade.py')
| -rwxr-xr-x | chimere/scripts/upgrade.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/chimere/scripts/upgrade.py b/chimere/scripts/upgrade.py index 5b6b04a..f260a07 100755 --- a/chimere/scripts/upgrade.py +++ b/chimere/scripts/upgrade.py @@ -32,6 +32,9 @@ def slugfy(text, separator): ret = re.sub(" +", separator, ret) return ret.strip() +QUERY_CHECK_TABLE = """SELECT c.relname FROM pg_class c +WHERE c.relname = '%s';""" + query = """SELECT a.attname AS field FROM pg_class c, pg_attribute a WHERE c.relname = 'main_area' AND a.attnum > 0 AND a.attrelid = c.oid AND a.attname='urn';""" @@ -110,8 +113,7 @@ CREATE TABLE "main_subcategory_areas" ( # early versions before 0.1: main_tinyurl table doesn't exist -query = """SELECT c.relname FROM pg_class c -WHERE c.relname = 'main_tinyurl';""" +query = QUERY_CHECK_TABLE % 'main_tinyurl' cursor.execute(query) transaction.commit_unless_managed() |