class Billterm(DeclarativeBaseGuid): __tablename__ = 'billterms' __table_args__ = {} # column definitions guid = Column('guid', VARCHAR(length=32), primary_key=True, nullable=False, default=lambda: uuid.uuid4().hex) name = Column('name', VARCHAR(length=2048), nullable=False) description = Column('description', VARCHAR(length=2048), nullable=False) refcount = Column('refcount', INTEGER(), nullable=False) invisible = Column('invisible', INTEGER(), nullable=False) parent_guid = Column('parent', VARCHAR(length=32), ForeignKey('billterms.guid')) type = Column('type', VARCHAR(length=2048), nullable=False) duedays = Column('duedays', INTEGER()) discountdays = Column('discountdays', INTEGER()) _discount_num = Column('discount_num', BIGINT()) _discount_denom = Column('discount_denom', BIGINT()) discount = hybrid_property_gncnumeric(_discount_num, _discount_denom) cutoff = Column('cutoff', INTEGER()) # relation definitions children = relation('Billterm', back_populates='parent', cascade='all, delete-orphan', collection_class=CallableList, ) parent = relation('Billterm', back_populates='children', remote_side=guid, )
class Video(Base): # 表名称 __tablename__ = 'video' id = Column(BIGINT(), primary_key=True) aweme_id = Column(BIGINT(), nullable=False) title = Column(String(length=500), nullable=False) nickname = Column(String(length=255), nullable=False)
class Employee(DeclarativeBaseGuid): __tablename__ = 'employees' __table_args__ = {} # column definitions username = Column('username', VARCHAR(length=2048), nullable=False) id = Column('id', VARCHAR(length=2048), nullable=False) language = Column('language', VARCHAR(length=2048), nullable=False) acl = Column('acl', VARCHAR(length=2048), nullable=False) active = Column('active', INTEGER(), nullable=False) currency_guid = Column('currency', VARCHAR(length=32), ForeignKey('commodities.guid'),nullable=False) ccard_guid = Column('ccard_guid', VARCHAR(length=32), ForeignKey('accounts.guid')) _workday_num = Column('workday_num', BIGINT(), nullable=False) _workday_denom = Column('workday_denom', BIGINT(), nullable=False) workday = hybrid_property_gncnumeric(_workday_num, _workday_denom) _rate_num = Column('rate_num', BIGINT(), nullable=False) _rate_denom = Column('rate_denom', BIGINT(), nullable=False) rate = hybrid_property_gncnumeric(_rate_num, _rate_denom) addr_name = Column('addr_name', VARCHAR(length=1024)) addr_addr1 = Column('addr_addr1', VARCHAR(length=1024)) addr_addr2 = Column('addr_addr2', VARCHAR(length=1024)) addr_addr3 = Column('addr_addr3', VARCHAR(length=1024)) addr_addr4 = Column('addr_addr4', VARCHAR(length=1024)) addr_phone = Column('addr_phone', VARCHAR(length=128)) addr_fax = Column('addr_fax', VARCHAR(length=128)) addr_email = Column('addr_email', VARCHAR(length=256)) addr = composite(Address, addr_addr1, addr_addr2, addr_addr3, addr_addr4, addr_email, addr_fax, addr_name, addr_phone) # relation definitions currency= relation('Commodity') credit_account = relation('Account')
class Invoice(DeclarativeBaseGuid): __tablename__ = 'invoices' __table_args__ = {} # column definitions id = Column('id', VARCHAR(length=2048), nullable=False) date_opened = Column('date_opened', _DateTime()) date_posted = Column('date_posted', _DateTime()) notes = Column('notes', VARCHAR(length=2048), nullable=False) active = Column('active', INTEGER(), nullable=False) currency_guid = Column('currency', VARCHAR(length=32), ForeignKey('commodities.guid'),nullable=False) owner_type = Column('owner_type', INTEGER()) owner_guid = Column('owner_guid', VARCHAR(length=32)) term_guid = Column('terms', VARCHAR(length=32), ForeignKey('billterms.guid')) billing_id = Column('billing_id', VARCHAR(length=2048)) post_txn_guid = Column('post_txn', VARCHAR(length=32), ForeignKey('lots.guid')) post_lot_guid = Column('post_lot', VARCHAR(length=32), ForeignKey('transactions.guid')) post_acc_guid = Column('post_acc', VARCHAR(length=32), ForeignKey('accounts.guid')) billto_type = Column('billto_type', INTEGER()) billto_guid = Column('billto_guid', VARCHAR(length=32)) _charge_amt_num = Column('charge_amt_num', BIGINT()) _charge_amt_denom = Column('charge_amt_denom', BIGINT()) charge_amt = hybrid_property_gncnumeric(_charge_amt_num, _charge_amt_denom) # relation definitions # todo: check all relations and understanding of types... term = relation('Billterm') currency = relation('Commodity') post_account = relation('Account') post_lot = relation('Lot') post_txn = relation('Transaction')
class TaxtableEntry(DeclarativeBase): __tablename__ = 'taxtable_entries' __table_args__ = {'sqlite_autoincrement': True} # column definitions id = Column('id', INTEGER(), primary_key=True, nullable=False) taxtable_guid = Column('taxtable', VARCHAR(length=32), ForeignKey('taxtables.guid'), nullable=False) account_guid = Column('account', VARCHAR(length=32), ForeignKey('accounts.guid'), nullable=False) _amount_num = Column('amount_num', BIGINT(), nullable=False) _amount_denom = Column('amount_denom', BIGINT(), nullable=False) amount = hybrid_property_gncnumeric(_amount_num, _amount_denom) type = Column('type', ChoiceType({1: "value", 2: "percentage"}), nullable=False) # relation definitions taxtable = relation('Taxtable', back_populates='entries') account = relation('Account') def __init__(self, type, amount, account, taxtable=None): self.type = type self.amount = amount self.account = account if taxtable: self.taxtable = taxtable def __unirepr__(self): return u"TaxEntry<{} {} in {}>".format(self.amount, self.type, self.account.name)
class SlaveMasterInfo(SAFRSBase, Base): __tablename__ = "slave_master_info" Number_of_lines = Column(INTEGER(10), nullable=False) Master_log_name = Column(TEXT, nullable=False) Master_log_pos = Column(BIGINT(20), nullable=False) Host = Column(CHAR(64)) User_name = Column(TEXT) User_password = Column(TEXT) Port = Column(INTEGER(10), nullable=False) Connect_retry = Column(INTEGER(10), nullable=False) Enabled_ssl = Column(TINYINT(1), nullable=False) Ssl_ca = Column(TEXT) Ssl_capath = Column(TEXT) Ssl_cert = Column(TEXT) Ssl_cipher = Column(TEXT) Ssl_key = Column(TEXT) Ssl_verify_server_cert = Column(TINYINT(1), nullable=False) Heartbeat = Column(Float, nullable=False) Bind = Column(TEXT) Ignored_server_ids = Column(TEXT) Uuid = Column(TEXT) Retry_count = Column(BIGINT(20), nullable=False) Ssl_crl = Column(TEXT) Ssl_crlpath = Column(TEXT) Enabled_auto_position = Column(TINYINT(1), nullable=False) Channel_name = Column(CHAR(64), primary_key=True) Tls_version = Column(TEXT)
class BudgetAmount(DeclarativeBase): """ A GnuCash BudgetAmount Attributes: amount (:class:`decimal.Decimal`): the budgeted amount account (:class:`piecash.core.account.Account`): the budgeted account budget (:class:`Budget`): the budget of the amount """ __tablename__ = 'budget_amounts' __table_args__ = {} # column definitions id = Column('id', INTEGER(), primary_key=True, nullable=False) budget_guid = Column('budget_guid', VARCHAR(length=32), ForeignKey('budgets.guid'), nullable=False) account_guid = Column('account_guid', VARCHAR(length=32), ForeignKey('accounts.guid'), nullable=False) period_num = Column('period_num', INTEGER(), nullable=False) _amount_num = Column('amount_num', BIGINT(), nullable=False) _amount_denom = Column('amount_denom', BIGINT(), nullable=False) amount = hybrid_property_gncnumeric(_amount_num, _amount_denom) # relation definitions account = relation('Account', back_populates='budget_amounts') budget = relation('Budget', back_populates="amounts") def __repr__(self): return "<BudgetAmount {}={}>".format(self.period_num, self.amount)
class Day(db.Model): __tablename__ = 'day' id = Column(String(50), primary_key=True, index=True) object_id = Column(String(50), unique=True, index=True) day = Column(Integer()) if os.environ["ENV"] == 'production': day_mm = Column( String(10, collation="utf8mb4_myanmar_ci", convert_unicode=True)) sehri_time_desc_mm_uni = Column( String(30, collation="utf8mb4_myanmar_ci", convert_unicode=True)) sehri_time_desc_mm_zawgyi = Column( String(30, collation="utf8mb4_myanmar_ci", convert_unicode=True)) iftari_time_desc_mm_zawgyi = Column( String(30, collation="utf8mb4_myanmar_ci", convert_unicode=True)) iftari_time_desc_mm_uni = Column( String(30, collation="utf8mb4_myanmar_ci", convert_unicode=True)) dua_mm_uni = Column( String(3000, collation="utf8mb4_myanmar_ci", convert_unicode=True)) dua_mm_zawgyi = Column( String(3000, collation="utf8mb4_myanmar_ci", convert_unicode=True)) dua_ar = Column( String(1000, collation="utf8_general_ci", convert_unicode=True)) else: day_mm = Column(String(10)) sehri_time_desc_mm_uni = Column(String(30)) sehri_time_desc_mm_zawgyi = Column(String(30)) iftari_time_desc_mm_zawgyi = Column(String(30)) iftari_time_desc_mm_uni = Column(String(30)) dua_ar = Column(String(1000)) dua_mm_uni = Column(String(3000)) dua_mm_zawgyi = Column(String(3000)) calendar_day = Column(String(30), default=str( strftime("%a, %d %b %Y %X +0000", gmtime()))) hijari_day = Column(String(30), default=str(strftime("%a, %d %b %Y %X +0000", gmtime()))) sehri_time_desc = Column(String(30)) iftari_time_desc = Column(String(30)) dua_en = Column(String(200)) sehri_time = Column(String(30), default=str("4:30 am")) iftari_time = Column(String(30), default=str("7:30 pm")) is_kadir = Column(Boolean, default=False) country_id = Column(String(255), ForeignKey("country.object_id")) state_id = Column(String(255), ForeignKey("state.object_id")) created_date = Column(BIGINT(), default=calendar.timegm( datetime.datetime.utcnow().utctimetuple())) # updated_date = Column(String(50), default=str(strftime("%a, %d %b %Y %X +0000", gmtime()))) updated_date = Column(BIGINT(), default=calendar.timegm( datetime.datetime.utcnow().utctimetuple()))
class Ports(DeclarativeBase): """ports model""" __tablename__ = 'ports' #column definitions id = Column(u'id', BIGINT(), primary_key=True, nullable=False) protocol = Column(u'protocol', VARCHAR(length=50), nullable=False) portnum = Column(u'portnum', BIGINT(), nullable=False) enabled = Column(u'enabled', INTEGER(), nullable=False, default=0)
class SlotNumeric(Slot): __mapper_args__ = { 'polymorphic_identity': KVP_Type.KVP_TYPE_NUMERIC } _python_type = (tuple, decimal.Decimal) _numeric_val_num = Column('numeric_val_num', BIGINT(), nullable=True, default=0) _numeric_val_denom = Column('numeric_val_denom', BIGINT(), nullable=True, default=1) value = hybrid_property_gncnumeric(_numeric_val_num, _numeric_val_denom)
class InnodbTableStat(SAFRSBase, Base): __tablename__ = 'innodb_table_stats' database_name = Column(String(64, 'utf8_bin'), primary_key=True, nullable=False) table_name = Column(String(64, 'utf8_bin'), primary_key=True, nullable=False) last_update = Column(TIMESTAMP, nullable=False, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP")) n_rows = Column(BIGINT(20), nullable=False) clustered_index_size = Column(BIGINT(20), nullable=False) sum_of_other_index_sizes = Column(BIGINT(20), nullable=False)
class Price(DeclarativeBaseGuid): """ A single Price for a commodity. Attributes: commodity (:class:`Commodity`): commodity to which the Price relates currency (:class:`Commodity`): currency in which the Price is expressed date (:class:`datetime.datetime`): datetime object representing the time at which the price is relevant source (str): source of the price type (str): last, ask, bid, unknown, nav value (:class:`decimal.Decimal`): the price itself """ __tablename__ = 'prices' __table_args__ = {} # column definitions commodity_guid = Column('commodity_guid', VARCHAR(length=32), ForeignKey('commodities.guid'), nullable=False) currency_guid = Column('currency_guid', VARCHAR(length=32), ForeignKey('commodities.guid'), nullable=False) date = Column('date', _DateTime, nullable=False) source = Column('source', VARCHAR(length=2048)) type = Column('type', VARCHAR(length=2048)) _value_num = Column('value_num', BIGINT(), nullable=False) _value_denom = Column('value_denom', BIGINT(), nullable=False) value = hybrid_property_gncnumeric(_value_num, _value_denom) # relation definitions commodity = relation('Commodity', back_populates="prices", foreign_keys=[commodity_guid], ) currency = relation('Commodity', foreign_keys=[currency_guid], ) def __init__(self, commodity, currency, date, value, type="unknown", source="user:price"): self.commodity = commodity self.currency = currency assert isinstance(date, datetime.datetime) self.date = date self.value = value self.type = type self.source = source def __unirepr__(self): return u"Price<{:%Y-%m-%d} : {} {}/{}>".format(self.date, self.value, self.currency.mnemonic, self.commodity.mnemonic)
class DataFresh(Base): __tablename__ = 'min1kline_ltc' idkey = Column(Integer(), primary_key=True) timemark = Column(BIGINT()) openprice = Column(Float()) highprice = Column(Float()) lowprice = Column(Float()) closeprice = Column(Float()) tradevol = Column(Float()) count = Column(BIGINT())
class Country(db.Model): __tablename__ = 'country' id = Column(String(50), primary_key=True, index=True) object_id = Column(String(50), unique=True, index=True) name = Column(VARCHAR(100), unique=True) state = relationship("State", uselist=True) # article = relationship("Article", back_populates="source") remark = Column(String(50)) created_date = Column(BIGINT(), default=calendar.timegm(datetime.datetime.utcnow().utctimetuple())) updated_date = Column(BIGINT(), default=calendar.timegm(datetime.datetime.utcnow().utctimetuple()))
class Invoice(DeclarativeBaseGuid): __tablename__ = 'invoices' __table_args__ = {} # column definitions id = Column('id', VARCHAR(length=2048), nullable=False) date_opened = Column('date_opened', _DateTime()) date_posted = Column('date_posted', _DateTime()) notes = Column('notes', VARCHAR(length=2048), nullable=False) active = Column('active', INTEGER(), nullable=False) currency_guid = Column('currency', VARCHAR(length=32), ForeignKey('commodities.guid'), nullable=False) owner_type = Column('owner_type', INTEGER()) owner_guid = Column('owner_guid', VARCHAR(length=32)) # owner = generic_relationship(owner_type, owner_guid, # map_type2discriminator={"Customer": 2, # "Vendor": 1, # }) term_guid = Column('terms', VARCHAR(length=32), ForeignKey('billterms.guid')) billing_id = Column('billing_id', VARCHAR(length=2048)) post_txn_guid = Column('post_txn', VARCHAR(length=32), ForeignKey('lots.guid')) post_lot_guid = Column('post_lot', VARCHAR(length=32), ForeignKey('transactions.guid')) post_acc_guid = Column('post_acc', VARCHAR(length=32), ForeignKey('accounts.guid')) billto_type = Column('billto_type', INTEGER()) billto_guid = Column('billto_guid', VARCHAR(length=32)) _charge_amt_num = Column('charge_amt_num', BIGINT()) _charge_amt_denom = Column('charge_amt_denom', BIGINT()) charge_amt = hybrid_property_gncnumeric(_charge_amt_num, _charge_amt_denom) # relation definitions # todo: check all relations and understanding of types... term = relation('Billterm') currency = relation('Commodity') post_account = relation('Account') post_lot = relation('Lot') post_txn = relation('Transaction') entries = relation( 'Entry', back_populates='invoice', cascade='all, delete-orphan', collection_class=CallableList, ) def __unirepr__(self): return u"Invoice<{}>".format(self.id)
class InnodbIndexStat(SAFRSBase, Base): __tablename__ = 'innodb_index_stats' database_name = Column(String(64, 'utf8_bin'), primary_key=True, nullable=False) table_name = Column(String(64, 'utf8_bin'), primary_key=True, nullable=False) index_name = Column(String(64, 'utf8_bin'), primary_key=True, nullable=False) last_update = Column(TIMESTAMP, nullable=False, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP")) stat_name = Column(String(64, 'utf8_bin'), primary_key=True, nullable=False) stat_value = Column(BIGINT(20), nullable=False) sample_size = Column(BIGINT(20)) stat_description = Column(String(1024, 'utf8_bin'), nullable=False)
class CompareTypeSpecificityTest(TestBase): @testing.fixture def impl_fixture(self): from alembic.ddl import impl from sqlalchemy.engine import default return impl.DefaultImpl(default.DefaultDialect(), None, False, True, None, {}) def test_typedec_to_nonstandard(self, impl_fixture): class PasswordType(TypeDecorator): impl = VARBINARY def copy(self, **kw): return PasswordType(self.impl.length) def load_dialect_impl(self, dialect): if dialect.name == "default": impl = sqlite.NUMERIC(self.length) else: impl = VARBINARY(self.length) return dialect.type_descriptor(impl) impl_fixture.compare_type(Column("x", sqlite.NUMERIC(50)), Column("x", PasswordType(50))) @testing.combinations( (VARCHAR(30), String(30), False), (VARCHAR(30), String(40), True), (VARCHAR(30), Integer(), True), (DECIMAL(10, 5), Numeric(10, 5), False), (DECIMAL(10, 5), Numeric(12, 5), True), (DECIMAL(10, 5), DateTime(), True), (Numeric(), Numeric(scale=5), False), (INTEGER(), Integer(), False), (BIGINT(), Integer(), True), (BIGINT(), BigInteger(), False), (BIGINT(), SmallInteger(), True), (INTEGER(), SmallInteger(), True), (Integer(), String(), True), (DateTime(), DateTime(timezone=False), False), (DateTime(), DateTime(timezone=True), True), (DateTime(timezone=False), DateTime(timezone=True), True), id_="ssa", argnames="compare_from,compare_to,expected", ) def test_compare_type(self, impl_fixture, compare_from, compare_to, expected): is_( impl_fixture.compare_type(Column("x", compare_from), Column("x", compare_to)), expected, )
class TickerFresh(Base): __tablename__ = 'ticker' idkey = Column(Integer(), primary_key=True) date = Column(BIGINT()) buyprice = Column(Float()) highprice = Column(Float()) lastprice = Column(Float()) lowprice = Column(Float()) sellprice = Column(Float()) tradevol = Column(Float()) count = Column(BIGINT())
class SlaveRelayLogInfo(SAFRSBase, Base): __tablename__ = "slave_relay_log_info" Number_of_lines = Column(INTEGER(10), nullable=False) Relay_log_name = Column(TEXT, nullable=False) Relay_log_pos = Column(BIGINT(20), nullable=False) Master_log_name = Column(TEXT, nullable=False) Master_log_pos = Column(BIGINT(20), nullable=False) Sql_delay = Column(INTEGER(11), nullable=False) Number_of_workers = Column(INTEGER(10), nullable=False) Id = Column(INTEGER(10), nullable=False) Channel_name = Column(CHAR(64), primary_key=True)
class Potions(DataModel): __tablename__ = 'potions' id = Column(BIGINT().with_variant(INTEGER, 'sqlite'), primary_key=True) potency_id = Column(BIGINT().with_variant(INTEGER, 'sqlite'), ForeignKey('potion_potency.id')) type_id = Column(BIGINT().with_variant(INTEGER, 'sqlite'), ForeignKey('potion_types.id')) def __init__(self, potency_id, type_id): self.id = None self.potency_id = potency_id self.type_id = type_id
class Work(Base): # 表名称 __tablename__ = 'uc' id = Column(BIGINT(), primary_key=True) url = Column(String(length=1024), nullable=False) thumbnails = Column(String(length=500), nullable=False) title = Column(String(length=255), nullable=False) video_height = Column(BIGINT(), nullable=False) video_width = Column(BIGINT(), nullable=False) url_md5 = Column(String(length=255), nullable=False) type = Column(String(length=255), nullable=False) status = Column(Integer, nullable=False)
def get_twitter_table(table_name, metadata): twitter_table = Table(table_name, metadata, Column('t_id', BIGINT(), primary_key=True), Column('t_tweets', String(), nullable=False), Column('t_id', BIGINT(), primary_key=True), Column('t_tweets', String(), nullable=False), Column('t_len', SMALLINT(), nullable=False), Column('t_date', DATE(), nullable=False), Column('t_source', String(100), nullable=False), Column('t_likes', SMALLINT(), nullable=False), Column('t_retweet', SMALLINT(), nullable=False), Column('t_sentiment', SMALLINT(), nullable=False)) return twitter_table
class Stats(DeclarativeBase): """stats model""" __tablename__ = 'stats' #column definitions id = Column(u'id', BIGINT(), primary_key=True, nullable=False) lbid = Column(u'lbid', BIGINT(), ForeignKey('loadbalancers.id'), primary_key=True, nullable=False) period_start = Column(u'period_start', DATETIME(), nullable=False) period_end = Column(u'period_end', DATETIME(), nullable=False) bytes_out = Column(u'bytes_out', BIGINT(), nullable=False) status = Column(u'status', VARCHAR(length=50), nullable=False)
class Customer(DeclarativeBaseGuid): __tablename__ = 'customers' __table_args__ = {} # column definitions name = Column('name', VARCHAR(length=2048), nullable=False) id = Column('id', VARCHAR(length=2048), nullable=False) notes = Column('notes', VARCHAR(length=2048), nullable=False) active = Column('active', INTEGER(), nullable=False) _discount_num = Column('discount_num', BIGINT()) _discount_denom = Column('discount_denom', BIGINT()) discount = hybrid_property_gncnumeric(_discount_num, _discount_denom) _credit_num = Column('credit_num', BIGINT(), nullable=False) _credit_denom = Column('credit_denom', BIGINT(), nullable=False) credit = hybrid_property_gncnumeric(_credit_num, _credit_denom) currency_guid = Column('currency', VARCHAR(length=32), ForeignKey('commodities.guid'),nullable=False) tax_override = Column('tax_override', INTEGER(), nullable=False) addr_name = Column('addr_name', VARCHAR(length=1024)) addr_addr1 = Column('addr_addr1', VARCHAR(length=1024)) addr_addr2 = Column('addr_addr2', VARCHAR(length=1024)) addr_addr3 = Column('addr_addr3', VARCHAR(length=1024)) addr_addr4 = Column('addr_addr4', VARCHAR(length=1024)) addr_phone = Column('addr_phone', VARCHAR(length=128)) addr_fax = Column('addr_fax', VARCHAR(length=128)) addr_email = Column('addr_email', VARCHAR(length=256)) addr = composite(Address, addr_addr1, addr_addr2, addr_addr3, addr_addr4, addr_email, addr_fax, addr_name, addr_phone) shipaddr_name = Column('shipaddr_name', VARCHAR(length=1024)) shipaddr_addr1 = Column('shipaddr_addr1', VARCHAR(length=1024)) shipaddr_addr2 = Column('shipaddr_addr2', VARCHAR(length=1024)) shipaddr_addr3 = Column('shipaddr_addr3', VARCHAR(length=1024)) shipaddr_addr4 = Column('shipaddr_addr4', VARCHAR(length=1024)) shipaddr_phone = Column('shipaddr_phone', VARCHAR(length=128)) shipaddr_fax = Column('shipaddr_fax', VARCHAR(length=128)) shipaddr_email = Column('shipaddr_email', VARCHAR(length=256)) shipaddr = composite(Address, shipaddr_addr1, shipaddr_addr2, shipaddr_addr3, shipaddr_addr4, shipaddr_email, shipaddr_fax, shipaddr_name, shipaddr_phone) term_guid = Column('terms', VARCHAR(length=32), ForeignKey('billterms.guid')) tax_included = Column('tax_included', INTEGER()) taxtable_guid = Column('taxtable', VARCHAR(length=32), ForeignKey('taxtables.guid')) # relation definitions taxtable = relation('Taxtable') currency= relation('Commodity') term = relation('Billterm')
class NdbBinlogIndex(SAFRSBase, Base): __tablename__ = "ndb_binlog_index" Position = Column(BIGINT(20), nullable=False) File = Column(String(255), nullable=False) epoch = Column(BIGINT(20), primary_key=True, nullable=False) inserts = Column(INTEGER(10), nullable=False) updates = Column(INTEGER(10), nullable=False) deletes = Column(INTEGER(10), nullable=False) schemaops = Column(INTEGER(10), nullable=False) orig_server_id = Column(INTEGER(10), primary_key=True, nullable=False) orig_epoch = Column(BIGINT(20), primary_key=True, nullable=False) gci = Column(INTEGER(10), nullable=False) next_position = Column(BIGINT(20), nullable=False) next_file = Column(String(255), nullable=False)
class PotionInventory(DataModel): __tablename__ = 'potion_inventory' id = Column(BIGINT().with_variant(INTEGER, 'sqlite'), primary_key=True) potion_id = Column(BIGINT().with_variant(INTEGER, 'sqlite'), ForeignKey('potions.id')) price = Column(INTEGER, nullable=False) amount = Column(INTEGER, nullable=False) on_sale = Column(BOOLEAN, nullable=False) def __init__(self, potion_id, price, amount, on_sale=False): self.id = None self.potion_id = potion_id self.price = price self.on_sale = on_sale self.amount = amount
class Node(DeclarativeBase): """node model""" __tablename__ = 'nodes' #column definitions address = Column(u'address', VARCHAR(length=128), nullable=False) enabled = Column(u'enabled', INTEGER(), nullable=False) id = Column(u'id', BIGINT(), primary_key=True, nullable=False) lbid = Column(u'lbid', BIGINT(), ForeignKey('loadbalancers.id'), nullable=False) port = Column(u'port', INTEGER(), nullable=False) status = Column(u'status', VARCHAR(length=128), nullable=False) weight = Column(u'weight', INTEGER(), nullable=False) backup = Column(u'backup', INTEGER(), nullable=False, default=0)
class Issue(Base): __tablename__ = 'issue' id = Column(String(50), primary_key=True, index=True) object_id = Column(String(50), unique=True, index=True) url = Column(String(255)) issue_number = Column(String(20)) source_id = Column(String(255), ForeignKey("source.object_id")) article = relationship("Article", uselist=True) created_date = Column(BIGINT(), default=calendar.timegm( datetime.datetime.utcnow().utctimetuple())) updated_date = Column(BIGINT(), default=calendar.timegm( datetime.datetime.utcnow().utctimetuple()))
class Update(Base): """ Update class that represents a device update """ __tablename__ = 'updates' id: int = Column(INT(), primary_key=True, autoincrement=True) codename: str = Column(VARCHAR(30), nullable=False) version: str = Column(VARCHAR(20), nullable=False) android: str = Column(VARCHAR(5), nullable=False) branch: str = Column(VARCHAR(15), nullable=False) type: str = Column(VARCHAR(11), nullable=False) method: str = Column(VARCHAR(8), nullable=False) size: str = Column(BIGINT(), nullable=True) md5: str = Column(CHAR(32), unique=True, nullable=True) filename: str = Column(TEXT(), unique=True, nullable=True) link: str = Column(TEXT(), nullable=False) changelog: str = Column(TEXT(), nullable=True, default='Bug fixes and system optimizations.') date: str = Column(DATE(), nullable=True) inserted_on: str = Column(TIMESTAMP(), default=current_timestamp()) def __repr__(self): return f"<Update(codename={self.codename}, version={self.version}, branch={self.branch}, method={self.method})>" def __str__(self): return str({k: v for k, v in self.__dict__.items() if not k.startswith("_")})
class SlaveWorkerInfo(SAFRSBase, Base): __tablename__ = "slave_worker_info" Id = Column(INTEGER(10), primary_key=True, nullable=False) Relay_log_name = Column(TEXT, nullable=False) Relay_log_pos = Column(BIGINT(20), nullable=False) Master_log_name = Column(TEXT, nullable=False) Master_log_pos = Column(BIGINT(20), nullable=False) Checkpoint_relay_log_name = Column(TEXT, nullable=False) Checkpoint_relay_log_pos = Column(BIGINT(20), nullable=False) Checkpoint_master_log_name = Column(TEXT, nullable=False) Checkpoint_master_log_pos = Column(BIGINT(20), nullable=False) Checkpoint_seqno = Column(INTEGER(10), nullable=False) Checkpoint_group_size = Column(INTEGER(10), nullable=False) Checkpoint_group_bitmap = Column(LargeBinary, nullable=False) Channel_name = Column(CHAR(64), primary_key=True, nullable=False)