summaryrefslogtreecommitdiffstats
path: root/db_downgrade.py
diff options
context:
space:
mode:
Diffstat (limited to 'db_downgrade.py')
-rwxr-xr-xdb_downgrade.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/db_downgrade.py b/db_downgrade.py
new file mode 100755
index 0000000..59200a9
--- /dev/null
+++ b/db_downgrade.py
@@ -0,0 +1,8 @@
+#!flask/bin/python
+from migrate.versioning import api
+from config import SQLALCHEMY_DATABASE_URI
+from config import SQLALCHEMY_MIGRATE_REPO
+v = api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)
+api.downgrade(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, v - 1)
+v = api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)
+print('Current database version: ' + str(v))