alpr / db /database.py
notashwinii's picture
deploy hugging face space
dbcce87
Raw History Blame Contribute Delete
865 Bytes
import os
from urllib.parse import quote_plus
from dotenv import load_dotenv
from sqlalchemy import create_engine
from sqlalchemy.orm import declarative_base, sessionmaker
load_dotenv()
def build_database_url():
database_url = os.getenv("DATABASE_URL")
if database_url:
return database_url
user = os.getenv("DB_USER", "root")
password = quote_plus(os.getenv("DB_PASSWORD", ""))
host = os.getenv("DB_HOST", "localhost")
port = os.getenv("DB_PORT", "3306")
name = os.getenv("DB_NAME", "speedotector")
return f"mysql+pymysql://{user}:{password}@{host}:{port}/{name}"
DATABASE_URL = build_database_url()
engine = create_engine(DATABASE_URL, echo=False)
SessionLocal = sessionmaker(bind=engine, autoflush=False, autocommit=False)
Base = declarative_base()
def create_tables():
Base.metadata.create_all(bind=engine)