| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133 |
- from datetime import datetime
- from sqlalchemy import (
- Column,
- Integer,
- BigInteger,
- SmallInteger,
- String,
- DateTime,
- JSON,
- UniqueConstraint,
- Index,
- )
- from app.core.database import Base
- class BookerEntry(Base):
- __tablename__ = "booker_entries"
- id = Column(BigInteger, primary_key=True, autoincrement=True)
- node_id = Column(String(64), nullable=False)
- identifier = Column(String(64), nullable=False)
- enable = Column(SmallInteger, nullable=False, default=0)
- debug = Column(SmallInteger, nullable=False, default=0)
- need_account = Column(SmallInteger, nullable=False, default=1)
- need_proxy = Column(SmallInteger, nullable=False, default=1)
- proxy_pool = Column(JSON, nullable=False, default=list)
- proxy_cd = Column(Integer, nullable=False, default=300)
- session_max_life = Column(Integer, nullable=False, default=1800)
- active_time_start = Column(String(5), nullable=False, default="00:00")
- active_time_end = Column(String(5), nullable=False, default="23:59")
- website = Column(String(512), nullable=False, default="")
- booker = Column(JSON, nullable=False, default=dict)
- plugin_config = Column(JSON, nullable=False, default=dict)
- appointment_types = Column(JSON, nullable=False, default=list)
- free_config = Column(JSON, nullable=False, default=dict)
- version = Column(Integer, nullable=False, default=0)
- updated_by = Column(String(64), nullable=True, default="system")
- created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
- updated_at = Column(
- DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False
- )
- __table_args__ = (
- UniqueConstraint("node_id", "identifier", name="uk_booker_node_identifier"),
- Index("idx_booker_identifier", "identifier"),
- Index("idx_booker_updated_at", "updated_at"),
- )
- class SentinelEntry(Base):
- __tablename__ = "sentinel_entries"
- id = Column(BigInteger, primary_key=True, autoincrement=True)
- node_id = Column(String(64), nullable=False)
- identifier = Column(String(64), nullable=False)
- enable = Column(SmallInteger, nullable=False, default=0)
- debug = Column(SmallInteger, nullable=False, default=0)
- need_account = Column(SmallInteger, nullable=False, default=1)
- need_proxy = Column(SmallInteger, nullable=False, default=1)
- proxy_pool = Column(JSON, nullable=False, default=list)
- proxy_cd = Column(Integer, nullable=False, default=300)
- session_max_life = Column(Integer, nullable=False, default=1800)
- active_time_start = Column(String(5), nullable=False, default="00:00")
- active_time_end = Column(String(5), nullable=False, default="23:59")
- website = Column(String(512), nullable=False, default="")
- sentinel = Column(JSON, nullable=False, default=dict)
- plugin_config = Column(JSON, nullable=False, default=dict)
- appointment_types = Column(JSON, nullable=False, default=list)
- free_config = Column(JSON, nullable=False, default=dict)
- version = Column(Integer, nullable=False, default=0)
- updated_by = Column(String(64), nullable=True, default="system")
- created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
- updated_at = Column(
- DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False
- )
- __table_args__ = (
- UniqueConstraint("node_id", "identifier", name="uk_sentinel_node_identifier"),
- Index("idx_sentinel_identifier", "identifier"),
- Index("idx_sentinel_updated_at", "updated_at"),
- )
- class StandaloneEntry(Base):
- __tablename__ = "standalone_entries"
- id = Column(BigInteger, primary_key=True, autoincrement=True)
- node_id = Column(String(64), nullable=False)
- order_id = Column(String(64), nullable=True)
- identifier = Column(String(64), nullable=False)
- enable = Column(SmallInteger, nullable=False, default=1)
- debug = Column(SmallInteger, nullable=False, default=0)
- plugin_config = Column(JSON, nullable=False, default=dict)
- account = Column(JSON, nullable=False, default=dict)
- proxy_pool = Column(JSON, nullable=False, default=list)
- query_wait = Column(JSON, nullable=False, default=dict)
- login_interval = Column(Integer, nullable=False, default=1800)
- session_max_life = Column(Integer, nullable=False, default=1800)
- active_time_start = Column(String(5), nullable=False, default="00:00")
- active_time_end = Column(String(5), nullable=False, default="23:59")
- appointment_types = Column(JSON, nullable=False, default=list)
- user_preferences = Column(JSON, nullable=False, default=dict)
- free_config = Column(JSON, nullable=False, default=dict)
- version = Column(Integer, nullable=False, default=0)
- updated_by = Column(String(64), nullable=True, default="system")
- created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
- updated_at = Column(
- DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False
- )
- __table_args__ = (
- UniqueConstraint("node_id", "identifier", name="uk_standalone_node_identifier"),
- Index("idx_standalone_identifier", "identifier"),
- Index("idx_standalone_order_id", "order_id"),
- Index("idx_standalone_updated_at", "updated_at"),
- )
- class NodeConfigurationRevision(Base):
- __tablename__ = "node_configuration_revisions"
- id = Column(BigInteger, primary_key=True, autoincrement=True)
- entry_type = Column(String(32), nullable=False, index=True)
- entry_id = Column(BigInteger, nullable=False, index=True)
- version = Column(Integer, nullable=False, default=0)
- action = Column(String(32), nullable=False, default="update")
- snapshot = Column(JSON, nullable=False, default=dict)
- updated_by = Column(String(64), nullable=True, default="system")
- created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
- __table_args__ = (
- Index("idx_node_config_rev_type_id", "entry_type", "entry_id"),
- )
|