File size: 810 Bytes
61207aa fec8feb 7803d4e fb1fe87 fec8feb 09f1e96 61207aa | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | from sqlalchemy import Column, DateTime, Boolean, BigInteger, Integer, String, Float
from sqlalchemy.orm import declarative_base
from datetime import datetime, timezone
Base = declarative_base()
class User(Base):
__tablename__ = "users"
chat_id = Column(BigInteger, primary_key=True, index=True)
is_subscribed = Column(Boolean, default=True)
created_at = Column(DateTime, default=lambda: datetime.now(timezone.utc).replace(tzinfo=None))
class ExchangeRateHistory(Base):
__tablename__ = "exchange_rate_history"
id = Column(Integer, primary_key=True, index=True)
currency = Column(String(3), nullable=False, index=True)
rate_to_lkr = Column(Float, nullable=False)
timestamp = Column(DateTime, default=lambda: datetime.now(timezone.utc).replace(tzinfo=None), index=True)
|