-import os\r
-from forum.models import KeyValue\r
-from django.db import connection, transaction\r
-\r
-KEY = 'PG_FTSTRIGGERS_VERSION'\r
-VERSION = 2\r
-install = False\r
-\r
-try:\r
- version = KeyValue.objects.get(key=KEY).value\r
- if version < VERSION:\r
- install = True\r
-except:\r
- install = True\r
-\r
-\r
-if install:\r
- f = open(os.path.join(os.path.dirname(__file__), 'pg_fts_install.sql'), 'r')\r
-\r
- try:\r
- cursor = connection.cursor()\r
- cursor.execute(f.read())\r
- transaction.commit_unless_managed()\r
- except:\r
- pass\r
- finally:\r
- cursor.close()\r
-\r
- f.close()\r
-\r
- try:\r
- kv = KeyValue.objects.get(key=KEY)\r
- except:\r
- kv = KeyValue(key=KEY)\r
-\r
- kv.value = VERSION\r
- kv.save()\r
-
\ No newline at end of file
+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