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)
