node_configuration.py 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133
  1. from datetime import datetime
  2. from sqlalchemy import (
  3. Column,
  4. Integer,
  5. BigInteger,
  6. SmallInteger,
  7. String,
  8. DateTime,
  9. JSON,
  10. UniqueConstraint,
  11. Index,
  12. )
  13. from app.core.database import Base
  14. class BookerEntry(Base):
  15. __tablename__ = "booker_entries"
  16. id = Column(BigInteger, primary_key=True, autoincrement=True)
  17. node_id = Column(String(64), nullable=False)
  18. identifier = Column(String(64), nullable=False)
  19. enable = Column(SmallInteger, nullable=False, default=0)
  20. debug = Column(SmallInteger, nullable=False, default=0)
  21. need_account = Column(SmallInteger, nullable=False, default=1)
  22. need_proxy = Column(SmallInteger, nullable=False, default=1)
  23. proxy_pool = Column(JSON, nullable=False, default=list)
  24. proxy_cd = Column(Integer, nullable=False, default=300)
  25. session_max_life = Column(Integer, nullable=False, default=1800)
  26. active_time_start = Column(String(5), nullable=False, default="00:00")
  27. active_time_end = Column(String(5), nullable=False, default="23:59")
  28. website = Column(String(512), nullable=False, default="")
  29. booker = Column(JSON, nullable=False, default=dict)
  30. plugin_config = Column(JSON, nullable=False, default=dict)
  31. appointment_types = Column(JSON, nullable=False, default=list)
  32. free_config = Column(JSON, nullable=False, default=dict)
  33. version = Column(Integer, nullable=False, default=0)
  34. updated_by = Column(String(64), nullable=True, default="system")
  35. created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
  36. updated_at = Column(
  37. DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False
  38. )
  39. __table_args__ = (
  40. UniqueConstraint("node_id", "identifier", name="uk_booker_node_identifier"),
  41. Index("idx_booker_identifier", "identifier"),
  42. Index("idx_booker_updated_at", "updated_at"),
  43. )
  44. class SentinelEntry(Base):
  45. __tablename__ = "sentinel_entries"
  46. id = Column(BigInteger, primary_key=True, autoincrement=True)
  47. node_id = Column(String(64), nullable=False)
  48. identifier = Column(String(64), nullable=False)
  49. enable = Column(SmallInteger, nullable=False, default=0)
  50. debug = Column(SmallInteger, nullable=False, default=0)
  51. need_account = Column(SmallInteger, nullable=False, default=1)
  52. need_proxy = Column(SmallInteger, nullable=False, default=1)
  53. proxy_pool = Column(JSON, nullable=False, default=list)
  54. proxy_cd = Column(Integer, nullable=False, default=300)
  55. session_max_life = Column(Integer, nullable=False, default=1800)
  56. active_time_start = Column(String(5), nullable=False, default="00:00")
  57. active_time_end = Column(String(5), nullable=False, default="23:59")
  58. website = Column(String(512), nullable=False, default="")
  59. sentinel = Column(JSON, nullable=False, default=dict)
  60. plugin_config = Column(JSON, nullable=False, default=dict)
  61. appointment_types = Column(JSON, nullable=False, default=list)
  62. free_config = Column(JSON, nullable=False, default=dict)
  63. version = Column(Integer, nullable=False, default=0)
  64. updated_by = Column(String(64), nullable=True, default="system")
  65. created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
  66. updated_at = Column(
  67. DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False
  68. )
  69. __table_args__ = (
  70. UniqueConstraint("node_id", "identifier", name="uk_sentinel_node_identifier"),
  71. Index("idx_sentinel_identifier", "identifier"),
  72. Index("idx_sentinel_updated_at", "updated_at"),
  73. )
  74. class StandaloneEntry(Base):
  75. __tablename__ = "standalone_entries"
  76. id = Column(BigInteger, primary_key=True, autoincrement=True)
  77. node_id = Column(String(64), nullable=False)
  78. order_id = Column(String(64), nullable=True)
  79. identifier = Column(String(64), nullable=False)
  80. enable = Column(SmallInteger, nullable=False, default=1)
  81. debug = Column(SmallInteger, nullable=False, default=0)
  82. plugin_config = Column(JSON, nullable=False, default=dict)
  83. account = Column(JSON, nullable=False, default=dict)
  84. proxy_pool = Column(JSON, nullable=False, default=list)
  85. query_wait = Column(JSON, nullable=False, default=dict)
  86. login_interval = Column(Integer, nullable=False, default=1800)
  87. session_max_life = Column(Integer, nullable=False, default=1800)
  88. active_time_start = Column(String(5), nullable=False, default="00:00")
  89. active_time_end = Column(String(5), nullable=False, default="23:59")
  90. appointment_types = Column(JSON, nullable=False, default=list)
  91. user_preferences = Column(JSON, nullable=False, default=dict)
  92. free_config = Column(JSON, nullable=False, default=dict)
  93. version = Column(Integer, nullable=False, default=0)
  94. updated_by = Column(String(64), nullable=True, default="system")
  95. created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
  96. updated_at = Column(
  97. DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False
  98. )
  99. __table_args__ = (
  100. UniqueConstraint("node_id", "identifier", name="uk_standalone_node_identifier"),
  101. Index("idx_standalone_identifier", "identifier"),
  102. Index("idx_standalone_order_id", "order_id"),
  103. Index("idx_standalone_updated_at", "updated_at"),
  104. )
  105. class NodeConfigurationRevision(Base):
  106. __tablename__ = "node_configuration_revisions"
  107. id = Column(BigInteger, primary_key=True, autoincrement=True)
  108. entry_type = Column(String(32), nullable=False, index=True)
  109. entry_id = Column(BigInteger, nullable=False, index=True)
  110. version = Column(Integer, nullable=False, default=0)
  111. action = Column(String(32), nullable=False, default="update")
  112. snapshot = Column(JSON, nullable=False, default=dict)
  113. updated_by = Column(String(64), nullable=True, default="system")
  114. created_at = Column(DateTime, default=datetime.utcnow, nullable=False)
  115. __table_args__ = (
  116. Index("idx_node_config_rev_type_id", "entry_type", "entry_id"),
  117. )