1 files changed, 24 insertions, 0 deletions
diff --git a/initialize_database.py b/initialize_database.py
new file mode 100644
index 0000000..7b7226b
--- /dev/null
+++ b/initialize_database.py
@@ -0,0 +1,24 @@
+# -*- mode: python; -*-
+
+import os
+from app import create_app, db
+
+
+app = create_app()
+DB_NAME = "mdl.db"
+app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///" + DB_NAME
+db_path = f"app/{DB_NAME}"
+
+
+if os.path.exists(db_path):
+    os.remove(db_path)
+    print(f"Existing database {db_path} has been deleted successfully.")
+else:
+    print(f"Database {db_path} does not exist yet, creating now.")
+
+with app.app_context():
+    print(f"Creating database {db_path}...")
+    db.create_all()
+
+
+print(f"Database {db_path} created successfully.")