41 lines
1.3 KiB
Python
41 lines
1.3 KiB
Python
from sqlalchemy import create_engine, Column, Integer, String, Text, Boolean, DateTime
|
|
from sqlalchemy.orm import declarative_base, sessionmaker
|
|
from datetime import datetime
|
|
|
|
DATABASE_URL = "sqlite:///./gtravel.db"
|
|
|
|
engine = create_engine(DATABASE_URL, connect_args={"check_same_thread": False})
|
|
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
|
|
|
|
Base = declarative_base()
|
|
|
|
class AgencySetting(Base):
|
|
__tablename__ = "agency_settings"
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
setting_key = Column(String, unique=True, index=True)
|
|
setting_value = Column(String)
|
|
|
|
class Tour(Base):
|
|
__tablename__ = "tours"
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
category = Column(String, index=True) # tour, surf, volcano
|
|
title_en = Column(String)
|
|
title_es = Column(String)
|
|
desc_en = Column(Text)
|
|
desc_es = Column(Text)
|
|
price = Column(String)
|
|
image_url = Column(String)
|
|
|
|
class LeadForm(Base):
|
|
__tablename__ = "lead_forms"
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
name = Column(String)
|
|
email = Column(String)
|
|
phone = Column(String)
|
|
message = Column(Text)
|
|
interested_in = Column(String)
|
|
wants_retell_ai = Column(Boolean, default=False)
|
|
created_at = Column(DateTime, default=datetime.utcnow)
|
|
|
|
Base.metadata.create_all(bind=engine)
|