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 | |
| parent | 3818d66f0354f54e73f36bd3e1524905241c2be1 (diff) | |
| download | Chimère-494b96ec210a9eefa00fbabc499d4ed240580ab3.tar.bz2 Chimère-494b96ec210a9eefa00fbabc499d4ed240580ab3.zip | |
Add optional reference route to marker model (refs #300)
| -rw-r--r-- | chimere/main/models.py | 1 | ||||
| -rwxr-xr-x | chimere/scripts/upgrade.py | 13 |
2 files changed, 14 insertions, 0 deletions
diff --git a/chimere/main/models.py b/chimere/main/models.py index daf7b3b..198b837 100644 --- a/chimere/main/models.py +++ b/chimere/main/models.py @@ -209,6 +209,7 @@ Format YYYY-MM-DD")) if 'chimere.rss' in settings.INSTALLED_APPS: available_date = models.DateTimeField(_("Available Date"), blank=True, null=True) + route = models.ForeignKey("Route", blank=True, null=True) objects = models.GeoManager() def __unicode__(self): 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." + |