aswi2021jmsd-gitlab/src/db/setup_database.py @ 2510f01a
| 1 | fa03de5c | Captain_Trojan | import sqlite3 |
|---|---|---|---|
| 2 | |||
| 3 | from src.constants import DATABASE_FILE_LOCATION |
||
| 4 | from src.db.init_queries import SCHEMA_SQL, DEFAULT_VALUES_SQL |
||
| 5 | |||
| 6 | |||
| 7 | def setup_database(): |
||
| 8 | co = sqlite3.connect(DATABASE_FILE_LOCATION.shortest_relative_path()) |
||
| 9 | cu = co.cursor() |
||
| 10 | cu.executescript(SCHEMA_SQL) |
||
| 11 | cu.executescript(DEFAULT_VALUES_SQL) |
||
| 12 | |||
| 13 | |||
| 14 | if __name__ == '__main__': |
||
| 15 | setup_database() |