Download src/db/database.py from AIterAI/Finova: direct link, hf CLI and curl.
- Browser
- Download file 1.44 kB
-
https://huggingface.co/spaces/AIterAI/Finova/resolve/main/src/db/database.py
- Command line
-
hf download hf://spaces/AIterAI/Finova/src/db/database.py
-
curl -L -o database.py https://huggingface.co/spaces/AIterAI/Finova/resolve/main/src/db/database.py
1.44 kB
| import os | |
| import logging | |
| from datetime import datetime | |
| from sqlalchemy.engine import Engine, create_engine | |
| from typing_extensions import Optional | |
| from sqlalchemy.orm import declarative_base, Mapped, mapped_column, sessionmaker | |
| from sqlalchemy.types import DECIMAL, TIMESTAMP, String | |
| logger = logging.getLogger(__name__) | |
| script_dir = os.path.dirname(os.path.abspath(__file__)) | |
| DB_PATH = f"{script_dir}/finova.db" | |
| DB_URL = f"sqlite:///{DB_PATH}" | |
| logger.info(f"Database URL configured: {DB_URL}") | |
| engine = create_engine(DB_URL, connect_args={"check_same_thread": False}) | |
| Session = sessionmaker(autocommit=False, autoflush=False, bind=engine) | |
| Base = declarative_base() | |
| class Transaction(Base): | |
| __tablename__ = "transactions" | |
| id: Mapped[int] = mapped_column(primary_key=True, index=True) | |
| timestamp: Mapped[datetime] = mapped_column(TIMESTAMP(), nullable=False) | |
| amount: Mapped[DECIMAL] = mapped_column(DECIMAL(10, 2), nullable=False) | |
| type: Mapped[str] = mapped_column(String(8), nullable=False) | |
| description: Mapped[str] = mapped_column(String(500), nullable=False) | |
| category: Mapped[str] = mapped_column(String(50), nullable=False) | |
| subcategory: Mapped[Optional[str]] = mapped_column(String(50), nullable=True) | |
| notes: Mapped[Optional[str]] = mapped_column(String(500), nullable=True) | |
| def initialize_db(engine: Engine) -> None: | |
| """Crete all the database tables""" | |
| Base.metadata.create_all(engine) | |