File size: 720 Bytes
fd06b5a |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
import os
from sqlmodel import SQLModel, create_engine, Session
# Persistent SQLite database in the project directory
# Using absolute path to ensure data persists across runs
project_dir = os.path.dirname(os.path.abspath(__file__))
db_file_path = os.path.join(project_dir, "meeting_database.db")
database_url = f"sqlite:///{db_file_path}"
# Connect with persistent storage
engine = create_engine(
database_url,
connect_args={"check_same_thread": False},
echo=False # Set to True for SQL debugging
)
print(f"✓ Database configured at: {db_file_path}")
def create_db_and_tables():
SQLModel.metadata.create_all(engine)
def get_session():
with Session(engine) as session:
yield session
|