diff options
author | Marius Peter <marius.peter@tutanota.com> | 2022-06-05 14:20:40 +0200 |
---|---|---|
committer | Marius Peter <marius.peter@tutanota.com> | 2022-06-05 14:20:40 +0200 |
commit | 51c9fed15381421c4b7e8ba95af60b5204483d50 (patch) | |
tree | 9d4b9b9d55f44c9be23ab7f33c4a0b19ab9beaec /initialize_database.py |
First commit :baby:
Diffstat (limited to 'initialize_database.py')
-rw-r--r-- | initialize_database.py | 24 |
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.") |