diff options
| author | root <root@debian.provectio.local> | 2010-11-18 19:12:48 +0100 |
|---|---|---|
| committer | root <root@debian.provectio.local> | 2010-11-18 19:12:48 +0100 |
| commit | b7683aacb0921058db64489c7c6ac3592038a5d8 (patch) | |
| tree | f382ae011af0fa65493983ac059ad7e980cd3a73 /chimere/scripts/upgrade.py | |
| parent | fbfa1eaa2613b03d41a834ab6235bcbb38a12367 (diff) | |
| parent | 047416ad2a7d39aa41459df91a6a0b49daba92a4 (diff) | |
| download | Chimère-b7683aacb0921058db64489c7c6ac3592038a5d8.tar.bz2 Chimère-b7683aacb0921058db64489c7c6ac3592038a5d8.zip | |
Merge branch 'origin/v1.0' into carte-ouverte
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() |