Nobody2503
be89cc3acd
- Removed the old npc_memory.db file. - Updated time.txt with a new timestamp. - Refactored transaction recording in bank_functions.py to use parameterized queries. - Enhanced DatabaseManager in sql_commands.py to support singleton pattern and improved table creation logic. - Added methods for sanitizing SQL identifiers and parsing insert columns for upsert operations. - Improved error handling and connection management in execute_query, fetch_one, fetch_all, and fetch_as_dataframe methods. - Introduced a new bootstrap_database.py script for initializing the database schema. - Updated app.py to use the new initialize_database function for database management.
7 lines
153 B
Python
7 lines
153 B
Python
from utils.sql_commands import initialize_database
|
|
|
|
|
|
if __name__ == "__main__":
|
|
initialize_database()
|
|
print("Database initialization complete.")
|