__all__ = ["engine", "Base", "Session"]


import appdirs
import pathlib
import sqlalchemy
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker



path = pathlib.Path(appdirs.user_data_dir(appname="shopdb")) / "sqlite3.db"
path.parent.mkdir(parents=True, exist_ok=True)
engine = sqlalchemy.create_engine(f"sqlite:///{path}", echo=False)

Base = declarative_base()

Session = sessionmaker(bind=engine)