X-Git-Url: http://git.datanom.net/wpp.git/blobdiff_plain/06d96c2aaa206c47d6040716f25c8c65f6cf29c4..047d4d29754ed04bb696cc6dad3c43084290820b:/db_downgrade.py

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))