diff options
| author | Étienne Loks <etienne.loks@peacefrogs.net> | 2011-06-07 11:40:37 +0200 |
|---|---|---|
| committer | Étienne Loks <etienne.loks@peacefrogs.net> | 2011-06-07 11:40:37 +0200 |
| commit | 494b96ec210a9eefa00fbabc499d4ed240580ab3 (patch) | |
| tree | 8f31426c37a8798bcf55671e935168d59d45782f /chimere/scripts/upgrade.py | |
| parent | 3818d66f0354f54e73f36bd3e1524905241c2be1 (diff) | |
| download | Chimère-494b96ec210a9eefa00fbabc499d4ed240580ab3.tar.bz2 Chimère-494b96ec210a9eefa00fbabc499d4ed240580ab3.zip | |
Add optional reference route to marker model (refs #300)
Diffstat (limited to 'chimere/scripts/upgrade.py')
| -rwxr-xr-x | chimere/scripts/upgrade.py | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/chimere/scripts/upgrade.py b/chimere/scripts/upgrade.py index a5e316f..286842a 100755 --- a/chimere/scripts/upgrade.py +++ b/chimere/scripts/upgrade.py @@ -278,3 +278,16 @@ for route in routes: if changed: print " * projections of routes corrected" +# -> version 1.3: associate point to route (for the future) +query = QUERY_CHECK_FIELD % ('main_marker', 'route_id') +cursor.execute(query) +transaction.commit_unless_managed() + +row = cursor.fetchone() +if not row: + query_update = 'ALTER TABLE "main_marker" ADD COLUMN \ +"route_id" integer REFERENCES "main_route" ("id") DEFERRABLE INITIALLY DEFERRED' + cursor.execute(query_update) + transaction.commit_unless_managed() + print " * route_id added to table main_marker." + |