X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/b9fff8cfb529517f0e1dfcb4c3684ab523278654..2b97466ad6b5939356ebfd06268e5a07b2869ee5:/forum_modules/pgfulltext/startup.py diff --git a/forum_modules/pgfulltext/startup.py b/forum_modules/pgfulltext/startup.py index 6a6f85d..59990b5 100644 --- a/forum_modules/pgfulltext/startup.py +++ b/forum_modules/pgfulltext/startup.py @@ -1,40 +1,27 @@ -import os -from forum.models import KeyValue -from django.db import connection, transaction - -KEY = 'PG_FTSTRIGGERS_VERSION' -VERSION = 3 -install = False - -try: - version = KeyValue.objects.get(key=KEY).value - if version < VERSION: - install = True -except: - install = True - - -if install: - f = open(os.path.join(os.path.dirname(__file__), 'pg_fts_install.sql'), 'r') - - try: - cursor = connection.cursor() - cursor.execute(f.read()) - transaction.commit_unless_managed() - - try: - kv = KeyValue.objects.get(key=KEY) - except: - kv = KeyValue(key=KEY) - - kv.value = VERSION - kv.save() - - except Exception, e: - #import sys, traceback - #traceback.print_exc(file=sys.stdout) - pass - finally: - cursor.close() - - f.close() +import os +from forum.models import KeyValue +from django.db import connection, transaction +import settings + +VERSION = 11 + +if int(settings.PG_FTSTRIGGERS_VERSION) < VERSION: + f = open(os.path.join(os.path.dirname(__file__), 'pg_fts_install.sql'), 'r') + + try: + cursor = connection.cursor() + cursor.execute(f.read()) + transaction.commit_unless_managed() + + settings.PG_FTSTRIGGERS_VERSION.set_value(VERSION) + + except Exception, e: + #import sys, traceback + #traceback.print_exc(file=sys.stdout) + pass + finally: + cursor.close() + + f.close() + +import handlers