database.py

import os

from enum import Enum
from sqlmodel import create_engine

from geomagio.api.db.models.metadata import MetadataTable
from geomagio.api.db.models.metadata_history import MetadataHistoryTable
from geomagio.api.db.models.session import session


class Tables(str, Enum):
    METADATA = MetadataTable
    METADATAHISTORYTABLE = MetadataHistoryTable


database_url = os.getenv("DATABASE_URL", "sqlite:///./api_database.db")

try:
    engine = create_engine(database_url)
except Exception as e:
    print("error creating engine:", e)
    pass