class QiInfoProject(Base):
__tablename__ = 'qi_info_project'
insert_time = Column(INTEGER(11))
is_deleted = Column(SMALLINT(6),
nullable=False,
server_default=text("'0'"))
id = Column(INTEGER(11), primary_key=True)
proj_code = Column(VARCHAR(24), nullable=False, unique=True)
pro_name = Column(VARCHAR(255), nullable=False)
create_uid = Column(VARCHAR(255), nullable=False)
create_time = Column(DateTime, nullable=False)
original_project = Column(VARCHAR(128), nullable=False)
lm_id = Column(String(255))
qi_template = Column(INTEGER(11), nullable=False)
proj_desc = Column(String(500))
class BaseRunningEvent(BASE):
__tablename__ = 'BaseRunningEvent'
event_id = Column(INTEGER(12), primary_key=True, auto_increment=True, default=0)
game_id = Column(VARCHAR(12), primary_key=True)
year = Column(INTEGER(5))
date = Column(DATE)
running_team = Column(VARCHAR(3))
pitching_team = Column(VARCHAR(3))
event = Column(VARCHAR(2))
base = Column(VARCHAR(2))
runner = Column(VARCHAR(8))
pitcher = Column(VARCHAR(8))
catcher = Column(VARCHAR(8))
inning = Column(SMALLINT(3))
outs = Column(TINYINT(1))
class ProjectPackage(Base):
__tablename__ = 'project_package'
project_id = Column(INTEGER(),
ForeignKey('projects.project_id', ondelete='cascade'),
primary_key=True)
pkg_def_id = Column(INTEGER(),
ForeignKey('package_definitions.pkg_def_id',
ondelete='cascade'),
primary_key=True)
app_id = Column(SMALLINT(display_width=6),
ForeignKey('app_definitions.AppID', ondelete='cascade'),
primary_key=True)
app_definition = relationship('AppDefinition', uselist=False)
package_definition = relationship('PackageDefinition', uselist=False)
project = relationship('Project', uselist=False)
class IncomeType(db.Model):
__tablename__ = "income_types"
id = db.Column(SMALLINT(unsigned=True), primary_key=True)
# 收入科目名称
name = db.Column(db.String(50), nullable=False)
# 收入科目层级，主营业务收入层级为 0
level = db.Column(TINYINT(unsigned=True), nullable=False, default=0)
# 本科目的下一层级科目
sub_types = db.relationship(
'IncomeType',
secondary='income_type_relation',
primaryjoin=(income_type_relation.c.sup_type == id),
secondaryjoin=(income_type_relation.c.sub_type == id),
backref=db.backref('sup_type', lazy='dynamic'),
lazy='dynamic')
# 本科目下的收入
incomes = db.relationship('Income', backref='incomes', lazy='dynamic')
class QiInfoWarning(Base):
__tablename__ = 'qi_info_warning'
insert_time = Column(INTEGER(11))
is_deleted = Column(SMALLINT(6),
nullable=False,
server_default=text("'0'"))
id = Column(INTEGER(11), primary_key=True)
create_uid = Column(VARCHAR(255), nullable=False)
create_time = Column(DateTime, nullable=False)
warning_name = Column(VARCHAR(64), nullable=False)
hit_rules = Column(VARCHAR(1000))
hit_rules_id = Column(VARCHAR(1000))
message = Column(VARCHAR(255))
ding_talk = Column(VARCHAR(1024))
apps = Column(VARCHAR(1024))
warning_desc = Column(VARCHAR(200))
class OmsCartItem(Base):
__tablename__ = 'oms_cart_item'
__table_args__ = {'comment': '购物车表'}
id = Column(BIGINT(20), primary_key=True)
product_id = Column(ForeignKey('pms_product.id',
ondelete='RESTRICT',
onupdate='RESTRICT'),
index=True)
product_sku_id = Column(BIGINT(20))
member_id = Column(ForeignKey('ums_member.id',
ondelete='RESTRICT',
onupdate='RESTRICT'),
index=True)
quantity = Column(INTEGER(11), comment='购买数量')
price = Column(DECIMAL(10, 2), comment='添加到购物车的价格')
product_pic = Column(VARCHAR(1000), comment='商品主图')
product_name = Column(VARCHAR(500), comment='商品名称')
product_sub_title = Column(VARCHAR(500), comment='商品副标题（卖点）')
product_sku_code = Column(VARCHAR(200), comment='商品sku条码')
member_nickname = Column(VARCHAR(500), comment='会员昵称')
create_date = Column(DateTime, comment='创建时间')
modify_date = Column(DateTime, comment='修改时间')
delete_status = Column(INTEGER(11),
server_default=text("'0'"),
comment='是否删除')
product_category_id = Column(ForeignKey('pms_product_category.id',
ondelete='RESTRICT',
onupdate='RESTRICT'),
index=True,
comment='商品分类')
product_brand = Column(ForeignKey('pms_brand.id',
ondelete='RESTRICT',
onupdate='RESTRICT'),
index=True)
product_sn = Column(VARCHAR(200))
product_attr = Column(
VARCHAR(500),
comment='商品销售属性:[{"key":"颜色","value":"颜色"},{"key":"容量","value":"4G"}]')
max_number = Column(INTEGER(11))
checked = Column(SMALLINT(1))
member = relationship('UmsMember')
pms_brand = relationship('PmsBrand')
product_category = relationship('PmsProductCategory')
product = relationship('PmsProduct')
class QiCallDuration(Base):
__tablename__ = 'qi_call_duration'
insert_time = Column(INTEGER(11))
is_deleted = Column(SMALLINT(6),
nullable=False,
server_default=text("'0'"))
id = Column(INTEGER(11), primary_key=True)
call_start_time = Column(DateTime)
call_id = Column(VARCHAR(64), nullable=False, unique=True)
duration = Column(INTEGER(11), nullable=False)
effective_duration = Column(INTEGER(11), nullable=False)
silence_duration = Column(INTEGER(11), nullable=False)
cust_effective = Column(INTEGER(11), nullable=False)
agent_effective = Column(INTEGER(11), nullable=False)
cust_silence = Column(INTEGER(11), nullable=False)
agent_silence = Column(INTEGER(11), nullable=False)
class QiInfoMapRule(Base):
__tablename__ = 'qi_info_map_rule'
insert_time = Column(INTEGER(11))
is_deleted = Column(SMALLINT(6),
nullable=False,
server_default=text("'0'"))
id = Column(INTEGER(11), primary_key=True)
template_id = Column(INTEGER(11), nullable=False)
template_name = Column(VARCHAR(50), nullable=False)
rule_type = Column(INTEGER(11), nullable=False)
rule_type_name = Column(VARCHAR(50), nullable=False)
rule_id = Column(INTEGER(11), nullable=False)
rule_name = Column(VARCHAR(50), nullable=False)
rule_score = Column(INTEGER(11), nullable=False)
show_desc = Column(String(255), nullable=False)
warning_id = Column(INTEGER(11), server_default=text("'0'"))
class AccountActivitySchema( object ):
acct_id = Column( Integer, primary_key=True, index=True )
updated = Column( DateTime, primary_key=True, index=True )
created = Column( DateTime)
from_vol_bytes = Column( BIGINT(unsigned=True), default=0 )
from_ret_days = Column( SMALLINT(unsigned=True), default=0 )
from_sub_rate = Column( MEDIUMINT(unsigned=True), default=0 )
from_plan_id = Column( SMALLINT(unsigned=True), default=0 )
from_sched_id = Column( SMALLINT(unsigned=True), default=0 )
from_bill_per = Column( String(length=2), default='' )
from_bill_chan = Column( SMALLINT(unsigned=True), default=0 )
to_vol_bytes = Column( BIGINT(unsigned=True), default=0 )
to_ret_days = Column( SMALLINT(unsigned=True), default=0 )
to_sub_rate = Column( MEDIUMINT(unsigned=True), default=0 )
to_plan_id = Column( SMALLINT(unsigned=True), default=0 )
to_sched_id = Column( SMALLINT(unsigned=True), default=0 )
to_bill_per = Column( String(length=2), default='' )
to_bill_chan = Column( SMALLINT(unsigned=True), default=0)
trial_exp = Column( DateTime, default=None )
class BuoyStatusInfo(Base):
__tablename__ = 'nt_plfbztxxb'
ID = Column(BigInteger, primary_key=True, autoincrement=True)
PLFBQZH = Column(Unicode(64), nullable=False)
GCRQSJ = Column(DateTime)
JMZT = Column(SMALLINT(unsigned=True))
ZBWD = Column(DOUBLE)
DYDY = Column(DOUBLE)
ZTHGJD = Column(DOUBLE)
ZTFYJD = Column(DOUBLE)
ZTFWJD = Column(DOUBLE)
CXCQW = Column(TINYINT(unsigned=True))
KMGGLW = Column(TINYINT(unsigned=True))
ZTSJJSW = Column(TINYINT(unsigned=True))
ZTSJYXW = Column(TINYINT(unsigned=True))
GPSSJJSW = Column(TINYINT(unsigned=True))
GPSJSSJYXW = Column(TINYINT(unsigned=True))
GPSDWSJYXW = Column(TINYINT(unsigned=True))
YXJSWXS = Column(TINYINT(unsigned=True))
JD = Column(DOUBLE)
WD = Column(DOUBLE)
__table_args__ = (UniqueConstraint(PLFBQZH,
GCRQSJ,
name="station_sampling_process"), )
@classmethod
def get_unique(cls, session, override=False, **fieldnames):
cache = session._unique_cache = getattr(session, '_unique_cache', {})
key = (cls, fieldnames['PLFBQZH'], fieldnames['GCRQSJ'])
o = cache.get(key)
if o is None:
if override:
session.query(cls).filter(
cls.PLFBQZH == fieldnames['PLFBQZH'],
cls.GCRQSJ == fieldnames['GCRQSJ']).delete()
o = cls(**fieldnames)
session.add(o)
else:
o = session.query(cls).filter_by(
PLFBQZH=fieldnames['PLFBQZH'],
GCRQSJ=fieldnames['GCRQSJ']).first()
if o is None:
o = cls(**fieldnames)
session.add(o)
cache[key] = o
class FlaskStateHost(db.Model):
__bind_key__ = Config.DEFAULT_BIND_SQLITE
__tablename__ = "flask_state_host"
id = db.Column(INTEGER(unsigned=True), autoincrement=True)
create_time = db.Column(DATETIME, server_default=func.now())
update_time = db.Column(DATETIME, server_default=func.now(), onupdate=func.now())
# host
cpu = db.Column(FLOAT(unsigned=True), server_default=text("0"))
cpus = db.Column(String(128), server_default="[]")
memory = db.Column(FLOAT(unsigned=True), server_default=text("0"))
load_avg = db.Column(String(32), server_default="")
disk_usage = db.Column(FLOAT(unsigned=True), server_default=text("0"))
boot_seconds = db.Column(INTEGER(unsigned=True), server_default=text("0"))
ts = db.Column(BIGINT(unsigned=True), server_default=text("0"))
# redis
used_memory = db.Column(INTEGER(unsigned=True), server_default=text("0"))
used_memory_rss = db.Column(INTEGER(unsigned=True), server_default=text("0"))
connected_clients = db.Column(SMALLINT(unsigned=True), server_default=text("0"))
uptime_in_seconds = db.Column(INTEGER(unsigned=True), server_default=text("0"))
mem_fragmentation_ratio = db.Column(FLOAT(unsigned=True), server_default=text("0"))
keyspace_hits = db.Column(INTEGER(unsigned=True), server_default=text("0"))
keyspace_misses = db.Column(INTEGER(unsigned=True), server_default=text("0"))
hits_ratio = db.Column(FLOAT(unsigned=True), server_default=text("0"))
delta_hits_ratio = db.Column(FLOAT(unsigned=True), server_default=text("0"))
__table_args__ = (
db.PrimaryKeyConstraint("id"),
db.Index("idx_ts", ts.desc()),
{
"extend_existing": True,
},
)
def __repr__(self):
return "<FlaskStateHost cpu: {}, memory:{}, load_avg:{}, disk_usage:{}, boot_seconds:{}, ts:{}>".format(
self.cpu,
self.memory,
self.load_avg,
self.disk_usage,
self.boot_seconds,
self.ts,
)
class Pictures(db.Model):
__tablename__ = 'pictures'
picture_id = Column(SMALLINT(unsigned=True),
nullable=False,
primary_key=True)
#exposure_id = Column(SMALLINT(unsigned=True), nullable=False)
timestamp = Column(TIMESTAMP, nullable=False)
filepath = Column(String(50), nullable=False)
exposure = relationship("Exposures",
secondary="exposures_pictures",
viewonly=True)
def __init__(self, filepath):
self.timestamp = datetime.today()
#Should exposures have a filepath and that just gets grabbed from there?
self.filepath = filepath
class Country(Base):
__tablename__ = 'country'
Code = Column(CHAR(3), primary_key=True, server_default=text("''"))
Name = Column(CHAR(52), nullable=False, server_default=text("''"))
Continent = Column(Enum('Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America'), nullable=False, server_default=text("'Asia'"))
Region = Column(CHAR(26), nullable=False, server_default=text("''"))
SurfaceArea = Column(Float(10), nullable=False, server_default=text("'0.00'"))
IndepYear = Column(SMALLINT(6))
Population = Column(INTEGER(11), nullable=False, server_default=text("'0'"))
LifeExpectancy = Column(Float(3))
GNP = Column(Float(10))
GNPOld = Column(Float(10))
LocalName = Column(CHAR(45), nullable=False, server_default=text("''"))
GovernmentForm = Column(CHAR(45), nullable=False, server_default=text("''"))
HeadOfState = Column(CHAR(60))
Capital = Column(INTEGER(11))
Code2 = Column(CHAR(2), nullable=False, server_default=text("''"))
class QiResultsAppeal(Base):
__tablename__ = 'qi_results_appeal'
insert_time = Column(INTEGER(11))
is_deleted = Column(SMALLINT(6),
nullable=False,
server_default=text("'0'"))
id = Column(INTEGER(11), primary_key=True)
call_id = Column(VARCHAR(64), nullable=False)
appeal_time = Column(DateTime, nullable=False)
appeal_uid = Column(INTEGER(11), nullable=False)
appeal_id = Column(INTEGER(11), nullable=False, index=True)
appeal_reason = Column(VARCHAR(500), nullable=False)
appeal_result = Column(INTEGER(11), nullable=False)
conduct_time = Column(DateTime)
conduct_uid = Column(INTEGER(11))
pre_score = Column(INTEGER(11), nullable=False)
current_scores = Column(INTEGER(11))
class AreaDatabase(TableBase):
quote_id = sa.Column(INTEGER(unsigned=True), nullable=False, primary_key=True)
database_id = sa.Column(INTEGER(unsigned=True), nullable=False)
entity = sa.Column(sa.ForeignKey('appentitys.entity', ondelete="CASCADE", onupdate='RESTRICT'),
nullable=False)
subtype = sa.Column(VARCHAR(64), nullable=False)
host = sa.Column(VARCHAR(200), default=None, nullable=False)
port = sa.Column(SMALLINT(unsigned=True), default=3306, nullable=False)
user = sa.Column(VARCHAR(64), default=None, nullable=False)
passwd = sa.Column(VARCHAR(128), default=None, nullable=False)
ro_user = sa.Column(VARCHAR(64), default=None, nullable=False)
ro_passwd = sa.Column(VARCHAR(128), default=None, nullable=False)
character_set = sa.Column(VARCHAR(64), default='utf8', nullable=True)
__table_args__ = (
sa.UniqueConstraint('entity', 'subtype', name='type_unique'),
InnoDBTableBase.__table_args__
)
class OrderDetails(Base):
__tablename__ = 'orderdetails'
orderNumber = Column(Integer, primary_key=True)
productCode = Column(String(15), ForeignKey('products.productCode'))
quantityOrdered = Column(Integer)
priceEach = Column(DOUBLE())
orderLineNumber = Column(SMALLINT(6))
products = relationship("Products")
def __repr__(self):
return """orderNumber: {}, productCode: {}, quantityOrdered: {},
priceEach: {}, orderLineNumber: {}""".format(self.orderNumber,
self.productCode,
self.quantityOrdered,
self.priceEach,
self.orderLineNumber)
class TracerPercentilesCold( Base):
__tablename__ = 'tracer_percentiles_cold'
__table_args__ = {'mysql_engine':'InnoDB'}
deployment = Column( String(length=20),primary_key=True )
cluster = Column( String(length=20),primary_key=True )
index_type = Column( String(length=20),primary_key=True )
period = Column( String(length=20),primary_key=True )
start_date = Column( Date ,primary_key=True )
end_date = Column( Date )
pcnt_LT30 = Column('pcnt_LT2', Numeric(6,5))
min_latency = Column( Numeric(6,1))
max_latency = Column( Numeric(6,1))
ninty_five = Column('95th_secs',Numeric(10,1))
ninty_eight = Column('98th_secs', Numeric(10,1))
ninty_nine = Column('99th_secs', Numeric(10,1))
reporting_secs = Column( Numeric(10,1))
period_secs = Column( Numeric(10,1))
percent_of_period = Column( Numeric(6,5))
ndays = Column( SMALLINT(2))
pcnt_LT_sec_thresh = Column( Numeric(6,5))
@property
def repcluster( self ):
return self.cluster + self.index_type[0]
@hybrid_method
def clusterdata(self, clusterrep):
return (self.cluster + self.index_type[0]) == clusterrep
def __repr__(self):
return "<TracerPercentiles ({}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}>".format(
self.repcluster,
self.period,
self.start_date,
self.end_date,
self.pcnt_LT30,
self.min_latency,
self.max_latency,
self.ninty_five,
self.ninty_eight,
self.ninty_nine,
self.reporting_secs,
self.period_secs
)
class Exposures(db.Model):
__tablename__ = 'exposures'
exposures_id = Column(SMALLINT(unsigned=True),
nullable=False,
primary_key=True)
pi_id = Column(SMALLINT, ForeignKey('pi.pi_id'), nullable=False)
start_time = Column(TIMESTAMP, nullable=False)
end_time = Column(TIMESTAMP)
#updated = Column(TINYINT(unsigned=True), nullable=False)
pictures = relationship("Pictures",
secondary="exposures_pictures",
viewonly=True)
def __init__(self, pi_id):
self.pi_id = pi_id
self.start_time = datetime.today()
self.end_time = None
class UmsMemberReceiveAddres(Base):
__tablename__ = 'ums_member_receive_address'
__table_args__ = {'comment': '会员收货地址表'}
id = Column(BIGINT(20), primary_key=True)
member_id = Column(ForeignKey('ums_member.id',
ondelete='RESTRICT',
onupdate='RESTRICT'),
index=True)
name = Column(VARCHAR(100), comment='收货人名称')
phone_number = Column(VARCHAR(64))
default_status = Column(SMALLINT(6), comment='是否为默认')
post_code = Column(VARCHAR(100), comment='邮政编码')
province = Column(VARCHAR(100), comment='省份/直辖市')
city = Column(VARCHAR(100), comment='城市')
region = Column(VARCHAR(100), comment='区')
detail_address = Column(VARCHAR(128), comment='详细地址(街道)')
member = relationship('UmsMember')
class City(Base):
__tablename__ = "city"
city_id = Column(SMALLINT(5), primary_key=True)
city = Column(String(50), nullable=False)
country_id = Column(
ForeignKey("country.country_id",
ondelete="RESTRICT",
onupdate="CASCADE"),
nullable=False,
index=True,
)
last_update = Column(
TIMESTAMP,
nullable=False,
server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"),
)
country = relationship("Country")
class TblParticipant(BaseModel):
__tablename__ = 'tblParticipant'
__table_args__ = (Index('par_pil_id', 'pil_id', 'comp_id'), )
par_id = Column(INTEGER(11), primary_key=True, autoincrement=True)
comp_id = Column(INTEGER(11),
ForeignKey('tblCompetition.comp_id'),
index=True)
civl_id = Column(INTEGER(10), index=True)
pil_id = Column(INTEGER(11))
ID = Column(INTEGER(4))
name = Column(String(50))
birthdate = Column(Date)
sex = Column(Enum('M', 'F'), nullable=False, server_default=text("'M'"))
nat = Column(CHAR(10))
glider = Column(String(100))
glider_cert = Column(String(20))
# parClass = Column(String(50))
sponsor = Column(String(100))
fai_valid = Column(TINYINT(1), nullable=False, server_default=text("'1'"))
fai_id = Column(String(20))
xcontest_id = Column(String(20))
live_id = Column(String(10))
telegram_id = Column(INTEGER(11))
team = Column(String(100))
nat_team = Column(TINYINT(4), nullable=False, server_default=text("'1'"))
status = Column(
Enum('confirmed', 'wild card', 'waiting list', 'cancelled',
'waiting for payment'))
ranking = Column(MEDIUMINT(9))
paid = Column(TINYINT(1), server_default=text("'0'"))
hours = Column(SMALLINT(6))
@classmethod
def get_dicts(cls, comp_id: int) -> list:
""" returns a list of rows"""
P = aliased(cls)
with db_session() as db:
print(f'session id: {id(db)}')
return [
el.as_dict()
for el in db.query(P).filter_by(comp_id=comp_id).all()
]
class AAWSC( OwnersBase, AAWSBase ):
__tablename__ = 'aawsc'
__table_args__ = {'mysql_engine':'InnoDB'}
cc = Column( SMALLINT(unsigned=True) )
pdStat = Column( String(length=6) )
def __repr__(self):
return "<AAWSC([{id},{upd}] ${frate},{fvol}b,{fret}d,{fper} -> ${trate},{tvol}b,{tret}d,{tper})>".format(
id = self.acct_id,
upd = self.updated,
frate = self.frate,
fvol = self.fGB,
fret = self.fDays,
fper = self.fPer,
trate = self.trate,
tvol = self.tGB,
tret = self.tDays,
tper = self.tPer,
)
class Products(Base):
__tablename__ = 'products'
productCode = Column(String(15), primary_key=True)
productName = Column(String(70))
productLine = Column(String(50))
productScale = Column(String(10))
productVendor = Column(String(50))
productDescription = Column(Text())
quantityInStock = Column(SMALLINT(6))
buyPrice = Column(DOUBLE())
MSRP = Column(DOUBLE())
def __repr__(self):
return """<Product(productCode: {}, productName: {}, productLine: {},
ProductScale: {}, productVendor: {}, productDescription: {},
quantityInStock: {}, buyPrice: {}, MSRP: {}""".format(
self.productCode, self.productName, self.productLine,
self.productScale, self.productVendor, self.productDescription,
self.quantityInStock, self.buyPrice, self.MSRP)
class DefaultSpec(Base):
__tablename__ = 'default_specs'
spec_id = Column(u'specID',
INTEGER(),
ForeignKey('host_specs.specID', ondelete='cascade'),
primary_key=True)
app_id = Column(u'AppID',
SMALLINT(display_width=6),
ForeignKey('app_definitions.AppID', ondelete='cascade'),
primary_key=True)
environment_id = Column(u'environmentID',
INTEGER(),
ForeignKey('environments.environmentID',
ondelete='cascade'),
primary_key=True)
priority = Column(INTEGER(display_width=4),
nullable=False,
server_default='10')
host_spec = relationship('HostSpec', uselist=False)
class Character(Base):
__tablename__ = 'characters'
guid = Column(INTEGER(11), primary_key=True, autoincrement=True)
account_id = Column('account', ForeignKey('accounts.id', ondelete='CASCADE', onupdate='CASCADE'), nullable=False, index=True, server_default=text("0"), comment='Account Identifier')
name = Column(String(12), nullable=False, index=True, server_default=text("''"))
race = Column(TINYINT(3), nullable=False, server_default=text("0"))
class_ = Column('class', TINYINT(3), nullable=False, server_default=text("0"))
gender = Column(TINYINT(3), nullable=False, server_default=text("0"))
level = Column(TINYINT(3), nullable=False, server_default=text("0"))
xp = Column(INTEGER(11), nullable=False, server_default=text("0"))
money = Column(INTEGER(11), nullable=False, server_default=text("0"))
skin = Column(TINYINT(3), nullable=False, server_default=text("0"))
face = Column(TINYINT(3), nullable=False, server_default=text("0"))
hairstyle = Column(TINYINT(3), nullable=False, server_default=text("0"))
haircolour = Column(TINYINT(3), nullable=False, server_default=text("0"))
facialhair = Column(TINYINT(3), nullable=False, server_default=text("0"))
bankslots = Column(TINYINT(3), nullable=False, server_default=text("0"))
talentpoints = Column(INTEGER(11), nullable=False, server_default=text("0"))
skillpoints = Column(INTEGER(11), nullable=False, server_default=text("0"))
position_x = Column(Float, nullable=False, server_default=text("0"))
position_y = Column(Float, nullable=False, server_default=text("0"))
position_z = Column(Float, nullable=False, server_default=text("0"))
map = Column(INTEGER(11), nullable=False, server_default=text("0"), comment='Map Identifier')
orientation = Column(Float, nullable=False, server_default=text("0"))
taximask = Column(LONGTEXT)
online = Column(TINYINT(3), nullable=False, index=True, server_default=text("0"))
totaltime = Column(INTEGER(11), nullable=False, server_default=text("0"))
leveltime = Column(INTEGER(11), nullable=False, server_default=text("0"))
extra_flags = Column(INTEGER(11), nullable=False, server_default=text("0"))
zone = Column(INTEGER(11), nullable=False, server_default=text("0"))
taxi_path = Column(Text)
drunk = Column(SMALLINT(5), nullable=False, server_default=text("0"))
health = Column(INTEGER(10), nullable=False, server_default=text("0"))
power1 = Column(INTEGER(10), nullable=False, server_default=text("0"))
power2 = Column(INTEGER(10), nullable=False, server_default=text("0"))
power3 = Column(INTEGER(10), nullable=False, server_default=text("0"))
power4 = Column(INTEGER(10), nullable=False, server_default=text("0"))
power5 = Column(INTEGER(10), nullable=False, server_default=text("0"))
account = relationship('Account')
class TaskAirspaceCheckView(BaseModel):
__table__ = Table(
'TaskAirspaceCheckView', metadata,
Column('task_id', INTEGER(11), primary_key=True),
Column('airspace_check', TINYINT(1)),
Column('notification_distance', SMALLINT(4)),
Column('function',
Enum('linear', 'non-linear'),
server_default=text("'linear'")),
Column('h_outer_limit', SMALLINT(4)),
Column('h_inner_limit', SMALLINT(4)), Column('h_boundary',
SMALLINT(4)),
Column('h_boundary_penalty', Float(3)),
Column('h_max_penalty', Float(3)), Column('v_outer_limit',
SMALLINT(4)),
Column('v_inner_limit', SMALLINT(4)), Column('v_boundary',
SMALLINT(4)),
Column('v_boundary_penalty', Float(3)),
Column('v_max_penalty', Float(3)))
class Run(BASE):
__tablename__ = 'Run'
run_id = Column(INTEGER(12),
primary_key=True,
auto_increment=True,
default=0)
game_id = Column(VARCHAR(12), primary_key=True)
year = Column(INTEGER(5))
date = Column(DATE)
scoring_team = Column(VARCHAR(3))
conceding_team = Column(VARCHAR(3))
scoring_player = Column(VARCHAR(8))
batter = Column(VARCHAR(8))
responsible_pitcher = Column(VARCHAR(8))
is_earned = Column(BOOLEAN(3))
is_team_earned = Column(BOOLEAN(3))
is_rbi = Column(BOOLEAN(3))
is_sp = Column(BOOLEAN(3))
inning = Column(SMALLINT(3))
outs = Column(TINYINT(1))
class Customer(BASE):
__tablename__ = 'customer'
customer_id = Column('customer_id',
SMALLINT(unsigned=True),
nullable=False,
primary_key=True,
autoincrement=True)
first_name = Column('first_name', String(45))
last_name = Column('last_name', String(45), nullable=False)
email_address = Column('email_address', String(45), nullable=False)
last_login = Column('last_login', TIMESTAMP, nullable=False)
last_update = Column('last_update', TIMESTAMP, nullable=False)
# ratings = relationship('product', secondary='customer_rating', viewonly=True)
# orders = relationship('product', secondary='customer_order', viewonly=True)
# shopping_cart = relationship('product', secondary='customer_shopping_cart', viewonly=True)
wishlist = relationship('Product',
secondary='customer_wishlist',
viewonly=True)
# address = relationship('address', secondary='customer_address', viewonly=True)
__table_args__ = (PrimaryKeyConstraint('customer_id', name='PRIMARY'),
Index('idx_customers_last_name', 'last_name'))
def __init__(self, first_name, last_name, email_address):
self.first_name = first_name
self.last_name = last_name
self.email_address = email_address
self.last_login = datetime.today()
self.last_update = datetime.today()
def __repr__(self):
return "\nCustomer(customer_id = {self.customer_id}, " \
"\n\tfirst_name = {self.first_name}," \
"\n\tlast_name = {self.last_name}," \
"\n\temail_address = {self.email_address}," \
"\n\tlast_login = {self.last_login}," \
"\n\tlast_update = {self.last_update})".format(self=self)
class CobraTaskInfo(db.Model):
__tablename__ = 'tasks'
id = db.Column(INTEGER(unsigned=True),
primary_key=True,
autoincrement=True,
nullable=False)
target = db.Column(db.String(255), nullable=True, default=None)
branch = db.Column(db.String(64), nullable=True, default=None)
scan_way = db.Column(SMALLINT(6), nullable=True, default=None)
new_version = db.Column(db.String(40), nullable=True, default=None)
old_version = db.Column(db.String(40), nullable=True, default=None)
time_consume = db.Column(db.Integer, nullable=True, default=None)
time_start = db.Column(db.Integer, nullable=True, default=None)
time_end = db.Column(db.Integer, nullable=True, default=None)
file_count = db.Column(db.Integer, nullable=True, default=None)
code_number = db.Column(db.Integer, nullable=True, default=None)
status = db.Column(TINYINT(4), nullable=True, default=0)
created_at = db.Column(db.DateTime, nullable=True, default=None)
updated_at = db.Column(db.DateTime, nullable=True, default=None)
def __init__(self, target, branch, scan_way, new_version, old_version,
time_consume, time_start, time_end, file_count, code_number,
status, created_at, updated_at):
self.target = target
self.branch = branch
self.scan_way = scan_way
self.new_version = new_version
self.old_version = old_version
self.time_consume = time_consume
self.time_start = time_start
self.time_end = time_end
self.file_count = file_count
self.code_number = code_number
self.status = status
self.created_at = created_at
self.updated_at = updated_at
def __repr__(self):
return '<task_info %r - %r>' % (self.id, self.target)
class Family(Base):
__tablename__ = 'family'
id = Column(BIGINT(20), primary_key=True, unique=True)
accession = Column(String(45), unique=True)
version = Column(SMALLINT(5), server_default=text("'1'"))
name = Column(String(45), unique=True)
classification_id = Column(ForeignKey('classification.id'), index=True)
description = Column(Text)
consensus = Column(Text)
date_created = Column(DateTime)
date_modified = Column(DateTime)
date_deleted = Column(DateTime)
target_site_cons = Column(String(30))
author = Column(TINYTEXT)
deposited_by_id = Column(INTEGER(11))
curation_state_id = Column(ForeignKey('curation_state.id'), index=True)
disabled = Column(TINYINT(1), server_default=text("'0'"))
refineable = Column(TINYINT(1), server_default=text("'0'"))
model_consensus = Column(Text)
model_mask = Column(Text)
hmm_build_method_id = Column(BIGINT(20))
cons_build_method_id = Column(BIGINT(20))
length = Column(INTEGER(11))
hmm_maxl = Column(INTEGER(11))
hmm_general_threshold = Column(Float(asdecimal=True))
seed_ref = Column(MEDIUMTEXT)
title = Column(String(80))
curation_notes = Column(Text)
source_method_id = Column(ForeignKey('source_method.id'), index=True)
source_method_desc = Column(Text)
source_assembly_id = Column(ForeignKey('assembly.id'), index=True)
classification = relationship('Classification')
curation_state = relationship('CurationState')
source_assembly = relationship('Assembly')
source_method = relationship('SourceMethod')
repeatmasker_stages = relationship('RepeatmaskerStage',
secondary='family_has_search_stage')
