class CenterEmployee(db.Model):
cenId = db.Column(MEDIUMINT(8, unsigned=True),
db.ForeignKey('center.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
primary_key=True)
empId = db.Column(MEDIUMINT(8, unsigned=True),
db.ForeignKey('employee.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
primary_key=True)
data = db.relationship('Employee', backref='centers', lazy='subquery')
accId = db.Column(MEDIUMINT(8, unsigned=True),
db.ForeignKey('ce_access.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
nullable=False)
access = db.relationship('CeAccess',
backref='center_employees',
lazy='subquery')
moderator = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
roster = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='1')
class Touchbiz(Base):
__tablename__ = 'sales_touchbiz'
__table_args__ = {'mysql_engine': 'InnoDB'}
acct_id = Column(MEDIUMINT(unsigned=True), primary_key=True)
sales_rep_id = Column(MEDIUMINT(unsigned=True),
ForeignKey('sales_reps.id'))
created = Column(DateTime, primary_key=True)
modified = Column(DateTime)
plan_type = Column(String(length=20))
tier = Column(String(length=100))
retention = Column(Integer)
volume = Column(String(length=50))
sub_rate = Column(Integer)
billing_period = Column(String(length=50))
payment_method = Column(String(length=30))
owner = relationship("SalesReps",
lazy='joined',
backref=backref("sales_touchbiz", uselist=False))
def __repr__(self):
return "<touchbiz({},{},{})>".format(self.acct_id, self.created,
self.sales_rep_id,
self.billing_period,
self.plan_type,
self.payment_method)
class AreaCn(Base):
__tablename__ = 'area_cn'
code = Column(MEDIUMINT(6), primary_key=True, server_default=text("'0'"), comment='政区划代码')
parent_code = Column(MEDIUMINT(6), nullable=False, server_default=text("'0'"), comment='父节点code')
title = Column(String(64), nullable=False)
type = Column(TINYINT(1), nullable=False, server_default=text("'0'"), comment='0 省、直辖市；1 市、市辖区； 2 区、县')
class Motif(Base):
__tablename__ = 'motif'
motif_acc = Column(String(7), primary_key=True)
motif_id = Column(String(40), index=True)
description = Column(String(75))
author = Column(TINYTEXT)
seed_source = Column(TINYTEXT)
gathering_cutoff = Column(Float(5, True))
trusted_cutoff = Column(Float(5, True))
noise_cutoff = Column(Float(5, True))
cmbuild = Column(TINYTEXT)
cmcalibrate = Column(TINYTEXT)
type = Column(String(50))
num_seed = Column(BIGINT(20))
average_id = Column(Float(5, True))
average_sqlen = Column(Float(7, True))
ecmli_lambda = Column(Float(10, True))
ecmli_mu = Column(Float(10, True))
ecmli_cal_db = Column(MEDIUMINT(9), server_default=text("'0'"))
ecmli_cal_hits = Column(MEDIUMINT(9), server_default=text("'0'"))
maxl = Column(MEDIUMINT(9), server_default=text("'0'"))
clen = Column(MEDIUMINT(9), server_default=text("'0'"))
match_pair_node = Column(TINYINT(1), server_default=text("'0'"))
hmm_tau = Column(Float(10, True))
hmm_lambda = Column(Float(10, True))
wiki = Column(String(80))
created = Column(DateTime, nullable=False)
updated = Column(
TIMESTAMP,
nullable=False,
server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
class Sector(Base):
__tablename__ = 'sectors'
id = Column(INTEGER(unsigned=True), Sequence('sector_id_seq'), primary_key=True)
mcc = Column(SMALLINT(unsigned=True), nullable=False)
mnc = Column(SMALLINT(unsigned=True), nullable=False)
node_id = Column(INTEGER(unsigned=True), nullable=False)
sector_id = Column(TINYINT(unsigned=True), nullable=False)
pci = Column(SMALLINT(unsigned=True), default=-1, nullable=False)
lat = Column(DECIMAL(8, 6))
lng = Column(DECIMAL(9, 6))
range = Column(MEDIUMINT(unsigned=True))
samples = Column(MEDIUMINT(unsigned=True))
created = Column(INTEGER(unsigned=True))
updated = Column(INTEGER(unsigned=True))
def __repr__(self):
return "<Sector(id='%s', enb='%s', sector='%s')>" % (self.id, self.node_id, self.sector_id)
__table_args__ = (
Index('sectors_index', 'mcc', 'mnc', 'node_id', 'sector_id'),
UniqueConstraint('mcc', 'mnc', 'node_id', 'sector_id', name='unique_sector'),
# ForeignKeyConstraint(['mcc', 'mnc', 'node_id',], ['nodes.mcc', 'nodes.mnc', 'nodes.node_id'])
)
class OFFERBIDPEROFFER(Base):
__tablename__ = "OFFER_BIDPEROFFER"
ID = Column(INTEGER(11), primary_key=True)
DUID = Column(ForeignKey("nemweb_meta.DUID.ID"), index=True)
SETTLEMENTDATE = Column(DateTime, index=True)
OFFERDATE = Column(DateTime, index=True)
PERIODID = Column(TINYINT(4), index=True)
VERSIONNO = Column(MEDIUMINT(9), index=True)
BIDTYPE = Column(ForeignKey("BIDTYPE.ID"), index=True)
MAXAVAIL = Column(MEDIUMINT(9))
ROCUP = Column(SMALLINT(6))
ROCDOWN = Column(SMALLINT(6))
BANDAVAIL1 = Column(SMALLINT(6))
BANDAVAIL2 = Column(SMALLINT(6))
BANDAVAIL3 = Column(SMALLINT(6))
BANDAVAIL4 = Column(SMALLINT(6))
BANDAVAIL5 = Column(SMALLINT(6))
BANDAVAIL6 = Column(SMALLINT(6))
BANDAVAIL7 = Column(SMALLINT(6))
BANDAVAIL8 = Column(SMALLINT(6))
BANDAVAIL9 = Column(SMALLINT(6))
BANDAVAIL10 = Column(SMALLINT(6))
LASTCHANGED = Column(DateTime, index=True)
BIDTYPE1 = relationship("BIDTYPE")
DUID1 = relationship("DUID")
class TblTaskWaypoint(BaseModel):
__tablename__ = 'tblTaskWaypoint'
wpt_id = Column(INTEGER(11), primary_key=True, autoincrement=True)
task_id = Column(ForeignKey('tblTask.task_id', ondelete='SET NULL'),
index=True)
num = Column(TINYINT(4), nullable=False)
name = Column(CHAR(6), nullable=False)
rwp_id = Column(INTEGER(11))
lat = Column(Float, nullable=False)
lon = Column(Float, nullable=False)
altitude = Column(SMALLINT(6), nullable=False, server_default=text("'0'"))
description = Column(String(80))
time = Column(MEDIUMINT(9))
type = Column(Enum('waypoint', 'launch', 'speed', 'endspeed', 'goal'),
index=True,
server_default=text("'waypoint'"))
how = Column(Enum('entry', 'exit'), server_default=text("'entry'"))
shape = Column(Enum('circle', 'semicircle', 'line'),
server_default=text("'circle'"))
angle = Column(SMALLINT(6))
radius = Column(MEDIUMINT(9))
ssr_lat = Column(Float)
ssr_lon = Column(Float)
partial_distance = Column(Float)
task = relationship('TblTask')
@classmethod
def from_task_id(cls, task_id: int) -> list:
""" returns a list of rows"""
W = aliased(cls)
with db_session() as db:
print(f'session id: {id(db)}')
return db.query(W).filter_by(task_id=task_id).order_by(W.num).all()
class CharacterSkill(Base):
__tablename__ = 'character_skills'
guid = Column(ForeignKey('characters.guid', ondelete='CASCADE', onupdate='CASCADE'), primary_key=True, nullable=False, index=True, server_default=text("0"))
skill = Column(MEDIUMINT(9), primary_key=True, nullable=False, server_default=text("0"))
value = Column(MEDIUMINT(9), nullable=False, server_default=text("0"))
max = Column(MEDIUMINT(9), nullable=False, server_default=text("0"))
character = relationship('Character')
class Machine(db.Model):
__tablename__ = 'machine'
id = Column(INTEGER(10), primary_key=True)
user_id = Column(ForeignKey('user.id'), nullable=False, index=True)
cpu = Column(Float, nullable=False)
memory = Column(MEDIUMINT(8), nullable=False)
disk_size = Column(MEDIUMINT(8), nullable=False)
user = relationship('User')
class FamilyHasBufferStage(Base):
__tablename__ = 'family_has_buffer_stage'
family_id = Column(ForeignKey('family.id'),
primary_key=True,
nullable=False)
repeatmasker_stage_id = Column(ForeignKey('repeatmasker_stage.id'),
primary_key=True,
nullable=False,
index=True)
start_pos = Column(MEDIUMINT(8), primary_key=True, nullable=False)
end_pos = Column(MEDIUMINT(8), primary_key=True, nullable=False)
family = relationship('Family')
repeatmasker_stage = relationship('RepeatmaskerStage')
class TblTrackWaypoint(BaseModel):
__tablename__ = 'tblTrackWaypoint'
__table_args__ = (Index('track_id'), )
trw_id = Column(INTEGER(11), primary_key=True)
track_id = Column(INTEGER(11), nullable=False, index=True)
wpt_id = Column(INTEGER(11))
name = Column(String(10))
rawtime = Column(MEDIUMINT(9), nullable=False)
lat = Column(Float, nullable=False)
lon = Column(Float, nullable=False)
altitude = Column(SMALLINT(6), nullable=False)
@classmethod
def from_track_list(cls, ids: list) -> list:
with db_session() as db:
return db.query(cls).filter(cls.track_id.in_(ids)).all()
@classmethod
def from_track(cls, track_id: int) -> list:
with db_session() as db:
return db.query(cls).filter_by(track_id=track_id).all()
@classmethod
def get_dict_list(cls, ids: list) -> list:
with db_session() as db:
return [
el.as_dict()
for el in db.query(cls).filter(cls.track_id.in_(ids)).all()
]
class BarDataTicksSchema(Base):
__tablename__ = 'bar_data_ticks'
__table_args__ = {'mysql_engine': 'MyISAM', 'comment': '分钟频率数据表'}
date = Column(DATE,
comment='记录日期',
server_default=text('0'),
primary_key=True)
time = Column(TIME,
comment='记录时间',
server_default=text('0'),
primary_key=True)
interval = Column(SMALLINT(5, unsigned=True),
comment='周期(分)',
server_default=text('1'),
primary_key=True)
volume = Column(MEDIUMINT(8, unsigned=True),
comment='成交量',
nullable=False,
server_default=text('0'))
open_price = Column(FLOAT, comment='开盘价', nullable=False)
high_price = Column(FLOAT, comment='最高价', nullable=False)
low_price = Column(FLOAT, comment='最低价', nullable=False)
close_price = Column(FLOAT, comment='收盘价', nullable=False)
def __repr__(self):
return "<BarDataTicksSchema(date='%s', time='%s', interval='%s', volume'%s', open_price'%s', high_price'%s', low_price'%s', close_price'%s')>" % (
self.date, self.time, self.interval, self.volume, self.open_price,
self.high_price, self.low_price, self.close_price)
class Group(TableBase):
group_id = sa.Column(INTEGER(unsigned=True),
nullable=False,
primary_key=True,
autoincrement=True)
name = sa.Column(VARCHAR(64), default=None, nullable=False)
platfrom_id = sa.Column(MEDIUMINT(unsigned=True),
nullable=False,
default=0)
warsvr = sa.Column(BOOLEAN, default=False, nullable=False)
desc = sa.Column(VARCHAR(256), nullable=True)
areas = orm.relationship(GameArea,
backref='group',
lazy='select',
cascade='delete,delete-orphan')
entitys = orm.relationship(AppEntity,
backref='group',
lazy='select',
cascade='delete,delete-orphan')
packages = orm.relationship(Package,
backref='group',
lazy='select',
cascade='delete,delete-orphan')
__table_args__ = (sa.UniqueConstraint('name', name='group_unique'),
InnoDBTableBase.__table_args__)
class Misc(Base):
"""This model contains all possible MySQL types"""
__tablename__ = "misc"
id = Column(Integer, primary_key=True)
big_integer_field = Column(BigInteger, default=0)
big_integer_unsigned_field = Column(BIGINT(unsigned=True), default=0)
large_binary_field = Column(LargeBinary, nullable=True)
boolean_field = Column(Boolean, default=False)
char_field = Column(CHAR(255), nullable=True)
date_field = Column(Date, nullable=True)
date_time_field = Column(DateTime, nullable=True)
decimal_field = Column(DECIMAL(10, 2), nullable=True)
float_field = Column(Float(12, 4), default=0)
integer_field = Column(Integer, default=0)
integer_unsigned_field = Column(INTEGER(unsigned=True), default=0)
tinyint_field = Column(TINYINT, default=0)
tinyint_unsigned_field = Column(TINYINT(unsigned=True), default=0)
mediumint_field = Column(MEDIUMINT, default=0)
mediumint_unsigned_field = Column(MEDIUMINT(unsigned=True), default=0)
if environ.get("LEGACY_DB", "0") == "0":
json_field = Column(JSON, nullable=True)
nchar_field = Column(NCHAR(255), nullable=True)
numeric_field = Column(Numeric(12, 4), default=0)
unicode_field = Column(Unicode(255), nullable=True)
real_field = Column(REAL(12, 4), default=0)
small_integer_field = Column(SmallInteger, default=0)
small_integer_unsigned_field = Column(SMALLINT(unsigned=True), default=0)
string_field = Column(String(255), nullable=True)
text_field = Column(Text, nullable=True)
time_field = Column(Time, nullable=True)
varbinary_field = Column(VARBINARY(255), nullable=True)
varchar_field = Column(VARCHAR(255), nullable=True)
timestamp_field = Column(TIMESTAMP, default=current_timestamp())
dupe = Column(Boolean, index=True, default=False)
class Node(Base):
__tablename__ = 'nodes'
id = Column(INTEGER(unsigned=True), Sequence('node_id_seq'), primary_key=True)
mcc = Column(SMALLINT(unsigned=True), nullable=False)
mnc = Column(SMALLINT(unsigned=True), nullable=False)
node_id = Column(INTEGER(unsigned=True), nullable=False)
lat = Column(DECIMAL(8, 6), nullable=False)
lng = Column(DECIMAL(9, 6), nullable=False)
mean_lat = Column(DECIMAL(8, 6))
mean_lng = Column(DECIMAL(9, 6))
samples = Column(MEDIUMINT(unsigned=True))
created = Column(INTEGER(unsigned=True))
updated = Column(INTEGER(unsigned=True))
def __repr__(self):
return "<Node(mcc='%s', mnc='%s' id='%s', enb='%s')>" % (self.mcc, self.mnc, self.id, self.node_id)
__table_args__ = (
Index('nodes_index', 'mcc', 'mnc', 'node_id'),
UniqueConstraint('mcc', 'mnc', 'node_id', name='unique_node')
)
class LoginInfo(Base):
__tablename__ = 'login_info'
id = Column(MEDIUMINT(8), primary_key=True)
employee_id = Column(MEDIUMINT(8),
nullable=False,
server_default=text("'0'"))
login = Column(String(100, 'utf8_unicode_ci'),
nullable=False,
server_default=text("''"))
password = Column(String(250, 'utf8_unicode_ci'),
nullable=False,
server_default=text("''"))
account_type = Column(String(25, 'utf8_unicode_ci'),
nullable=False,
server_default=text("'User'"))
class OFFERBIDDAYOFFER(Base):
__tablename__ = "OFFER_BIDDAYOFFER"
ID = Column(INTEGER(11), primary_key=True)
DUID = Column(ForeignKey("nemweb_meta.DUID.ID"), index=True)
SETTLEMENTDATE = Column(DateTime, index=True)
OFFERDATE = Column(DateTime, index=True)
VERSIONNO = Column(SMALLINT(6), index=True)
BIDTYPE = Column(ForeignKey("BIDTYPE.ID"), index=True)
DAILYENERGYCONSTRAINT = Column(INTEGER(11))
PRICEBAND1 = Column(DECIMAL(7, 2))
PRICEBAND2 = Column(DECIMAL(7, 2))
PRICEBAND3 = Column(DECIMAL(7, 2))
PRICEBAND4 = Column(DECIMAL(7, 2))
PRICEBAND5 = Column(DECIMAL(7, 2))
PRICEBAND6 = Column(DECIMAL(7, 2))
PRICEBAND7 = Column(DECIMAL(7, 2))
PRICEBAND8 = Column(DECIMAL(7, 2))
PRICEBAND9 = Column(DECIMAL(7, 2))
PRICEBAND10 = Column(DECIMAL(7, 2))
MINIMUMLOAD = Column(MEDIUMINT(9))
LASTCHANGED = Column(DateTime, index=True)
ENTRYTYPE = Column(CHAR(5), index=True)
T1 = Column(TINYINT(4))
T2 = Column(TINYINT(4))
T3 = Column(TINYINT(4))
T4 = Column(TINYINT(4))
BIDTYPE1 = relationship("BIDTYPE")
DUID1 = relationship("DUID")
def load_dialect_impl(self, dialect):
"""Load dialect dependent implementation."""
if dialect.name == 'mysql':
return dialect.type_descriptor(
MEDIUMINT(self.display_width, unsigned=self.unsigned))
else:
return dialect.type_descriptor(Integer)
class CeAccess(db.Model):
id = db.Column(MEDIUMINT(8, unsigned=True),
primary_key=True,
autoincrement=True)
level = db.Column(VARCHAR(255), nullable=False)
addDoc = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
modDoc = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
delDoc = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
addBiz = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
modBiz = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
delBiz = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
impBiz = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
arcBiz = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
class Document(db.Model):
id = db.Column(MEDIUMINT(8, unsigned=True),
primary_key=True,
autoincrement=True)
typId = db.Column(TINYINT(2, unsigned=True),
db.ForeignKey('doc_type.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
nullable=False)
type = db.relationship('DocType', backref='documents', lazy='subquery')
bizId = db.Column(MEDIUMINT(8, unsigned=True),
db.ForeignKey('business.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
nullable=False)
store = db.Column(VARCHAR(255), nullable=True)
expiry = db.Column(db.DateTime, nullable=False)
class Embed(Base):
__tablename__ = 'embeds'
id = Column(INT(unsigned=True), primary_key=True)
title = Column(String(256), nullable=False, default='')
description = Column(String(2048), nullable=False, default='')
color = Column(MEDIUMINT(unsigned=True))
class TaskObjectView(BaseModel):
__table__ = Table(
'TaskObjectView', metadata,
Column('task_id', INTEGER(11), primary_key=True),
Column('comp_code', String(8)), Column('comp_name', String(100)),
Column('comp_site', String(100)),
Column('time_offset', MEDIUMINT(9), server_default=text("'0'")),
Column('comp_class',
Enum('PG', 'HG', 'mixed'),
server_default=text("'PG'")), Column('comp_id', INTEGER(11)),
Column('date', Date), Column('task_name', String(100)),
Column('task_num', TINYINT(4)), Column('reg_id', INTEGER(11)),
Column('region_name', String(40)),
Column('window_open_time', MEDIUMINT(9)),
Column('task_deadline', MEDIUMINT(9)),
Column('window_close_time', MEDIUMINT(9)),
Column('check_launch', Enum('on',
'off'), server_default=text("'off'")),
Column('start_time', MEDIUMINT(9)),
Column('SS_interval', SMALLINT(6), server_default=text("'0'")),
Column('start_iteration', TINYINT(4)),
Column('start_close_time', MEDIUMINT(9)),
Column('stopped_time', MEDIUMINT(9)), Column('task_type', String(21)),
Column('distance', Float), Column('opt_dist', Float),
Column('opt_dist_to_SS', Float), Column('opt_dist_to_ESS', Float),
Column('SS_distance', Float),
Column('QNH', Float(7), server_default=text("'1013.250'")),
Column('comment', Text),
Column('locked', TINYINT(3), server_default=text("'0'")),
Column('airspace_check', TINYINT(1)), Column('openair_file',
String(40)),
Column('cancelled', TINYINT(1), server_default=text("'1'")),
Column('track_source', String(40)), Column('task_path', String(40)),
Column('comp_path', String(40)), Column('igc_config_file', String(80)))
class OverlapSegment(Base):
__tablename__ = 'overlap_segment'
family_overlap_id = Column(ForeignKey('family_overlap.id'),
primary_key=True,
nullable=False,
index=True)
family1_start = Column(MEDIUMINT(8), primary_key=True, nullable=False)
family1_end = Column(MEDIUMINT(8), primary_key=True, nullable=False)
family2_start = Column(MEDIUMINT(8), primary_key=True, nullable=False)
family2_end = Column(MEDIUMINT(8), primary_key=True, nullable=False)
strand = Column(Enum('+', '-'), primary_key=True, nullable=False)
evalue = Column(String(15))
identity = Column(String(6))
coverage = Column(String(6))
cigar = Column(Text)
family_overlap = relationship('FamilyOverlap')
class Family(Base):
__tablename__ = 'family'
rfam_acc = Column(String(7), primary_key=True, unique=True)
rfam_id = Column(String(40), nullable=False, index=True)
auto_wiki = Column(ForeignKey('wikitext.auto_wiki'),
nullable=False,
index=True)
description = Column(String(75))
author = Column(TINYTEXT)
seed_source = Column(TINYTEXT)
gathering_cutoff = Column(Float(5, True))
trusted_cutoff = Column(Float(5, True))
noise_cutoff = Column(Float(5, True))
comment = Column(LONGTEXT)
previous_id = Column(TINYTEXT)
cmbuild = Column(TINYTEXT)
cmcalibrate = Column(TINYTEXT)
cmsearch = Column(TINYTEXT)
num_seed = Column(BIGINT(20))
num_full = Column(BIGINT(20))
num_genome_seq = Column(BIGINT(20))
num_refseq = Column(BIGINT(20))
type = Column(String(50))
structure_source = Column(TINYTEXT)
number_of_species = Column(BIGINT(20))
number_3d_structures = Column(INTEGER(11))
tax_seed = Column(MEDIUMTEXT)
ecmli_lambda = Column(Float(10, True))
ecmli_mu = Column(Float(10, True))
ecmli_cal_db = Column(MEDIUMINT(9), server_default=text("'0'"))
ecmli_cal_hits = Column(MEDIUMINT(9), server_default=text("'0'"))
maxl = Column(MEDIUMINT(9), server_default=text("'0'"))
clen = Column(MEDIUMINT(9), server_default=text("'0'"))
match_pair_node = Column(TINYINT(1), server_default=text("'0'"))
hmm_tau = Column(Float(10, True))
hmm_lambda = Column(Float(10, True))
created = Column(DateTime, nullable=False)
updated = Column(
TIMESTAMP,
nullable=False,
server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
wikitext = relationship('Wikitext')
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 TaskFormulaView(BaseModel):
__table__ = Table(
'TaskFormulaView', metadata,
Column('task_id', INTEGER(11), primary_key=True),
Column('comp_id', INTEGER(11), index=True),
Column('formula_type', String(10)),
Column('formula_version', INTEGER(8)),
Column('formula_name', String(50)),
Column('overall_validity',
Enum('ftv', 'all', 'round'),
server_default=text("'ftv'")),
Column('validity_param', Float(4), server_default=text("'0.750'")),
Column('validity_ref',
Enum('day_quality', 'max_score'),
server_default=text("'day_quality'")),
Column('nominal_goal', Float(3), server_default=text("'0.30'")),
Column('min_dist', MEDIUMINT(9), server_default=text("'5000'")),
Column('nominal_dist', MEDIUMINT(9), server_default=text("'45000'")),
Column('nominal_time', SMALLINT(6), server_default=text("'5400'")),
Column('nominal_launch', Float(3), server_default=text("'0.96'")),
Column('formula_distance', Enum('on', 'difficulty', 'off')),
Column('formula_departure', Enum('leadout', 'departure', 'off')),
Column('formula_arrival', Enum('position', 'time', 'off')),
Column('formula_time', Enum('on', 'off')),
Column('lead_factor', Float(4)), Column('no_goal_penalty', Float(4)),
Column('glide_bonus', Float(4), server_default=text("'4.00'")),
Column('tolerance', Float(6)),
Column('min_tolerance', INTEGER(4), server_default=text("'5'")),
Column('arr_alt_bonus', Float), Column('arr_min_height', SMALLINT(6)),
Column('arr_max_height', SMALLINT(6)),
Column('validity_min_time', SMALLINT(6)),
Column('score_back_time', SMALLINT(6), server_default=text("'300'")),
Column('max_JTG', SMALLINT(6)), Column('JTG_penalty_per_sec',
Float(4)),
Column('scoring_altitude',
Enum('GPS', 'QNH'),
server_default=text("'GPS'")), Column('team_scoring',
TINYINT(1)),
Column('team_size', INTEGER(4)), Column('max_team_size', INTEGER(4)),
Column('country_scoring', TINYINT(1)),
Column('country_size', INTEGER(4)),
Column('max_country_size', INTEGER(4)))
class TblTrackWaypoint(BaseModel):
__tablename__ = 'tblTrackWaypoint'
trw_id = Column(INTEGER(11), primary_key=True)
track_id = Column(INTEGER(11), nullable=False, index=True)
wpt_id = Column(INTEGER(11))
name = Column(String(10))
rawtime = Column(MEDIUMINT(9), nullable=False)
lat = Column(Float, nullable=False)
lon = Column(Float, nullable=False)
altitude = Column(SMALLINT(6), nullable=False)
class SalesStages(Base):
__tablename__ = 'sales_stages'
__table_args__ = {'mysql_engine': 'InnoDB'}
id = Column(MEDIUMINT(unsigned=True), primary_key=True)
name = Column(String(length=100))
def __repr__(self):
return "<SalesStages({},{})>".format(
self.id,
self.first,
)
class CenterBusiness(db.Model):
cenId = db.Column(MEDIUMINT(8, unsigned=True),
db.ForeignKey('center.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
primary_key=True)
bizId = db.Column(MEDIUMINT(8, unsigned=True),
db.ForeignKey('business.id',
onupdate='RESTRICT',
ondelete='RESTRICT'),
primary_key=True)
details = db.relationship('Business', backref='centers', lazy='joined')
archived = db.Column(TINYINT(1, unsigned=True),
nullable=False,
server_default='0')
def doc_by_id(self, doc):
return self.details.documents.filter_by(id=doc).first_or_404()
def doc_type_list(self):
return self.details.documents.with_entities(Document.typId).all()
class TblTask(BaseModel):
__tablename__ = 'tblTask'
task_id = Column(INTEGER(11), primary_key=True, autoincrement=True)
comp_id = Column(ForeignKey('tblCompetition.comp_id'), index=True)
task_last_update = Column(
TIMESTAMP,
nullable=False,
server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
task_num = Column(TINYINT(4), nullable=False)
task_name = Column(String(100))
date = Column(Date, nullable=False)
reg_id = Column(ForeignKey('tblRegion.reg_id'), index=True)
window_open_time = Column(MEDIUMINT(9))
window_close_time = Column(MEDIUMINT(9))
check_launch = Column(Enum('on', 'off'), server_default=text("'off'"))
start_time = Column(MEDIUMINT(9))
start_close_time = Column(MEDIUMINT(9))
SS_interval = Column(SMALLINT(6),
nullable=False,
server_default=text("'0'"))
start_iteration = Column(TINYINT(4))
task_deadline = Column(MEDIUMINT(9))
stopped_time = Column(MEDIUMINT(9))
tasResultsType = Column(String(20))
task_type = Column(Enum('race', 'elapsed time', 'free distance',
'distance with bearing'),
server_default=text("'race'"))
distance = Column(Float)
opt_dist = Column(Float)
opt_dist_to_SS = Column(Float)
opt_dist_to_ESS = Column(Float)
SS_distance = Column(Float)
cancelled = Column(TINYINT(1), server_default=text("'0'"))
time_offset = Column(MEDIUMINT(9))
formula_distance = Column(Enum('on', 'difficulty', 'off'))
formula_departure = Column(Enum('leadout', 'departure', 'off'))
formula_arrival = Column(Enum('position', 'time', 'off'))
formula_time = Column(Enum('on', 'off'))
arr_alt_bonus = Column(Float)
max_JTG = Column(SMALLINT(6))
no_goal_penalty = Column(Float)
tolerance = Column(Float)
airspace_check = Column(TINYINT(1))
openair_file = Column(String(40))
QNH = Column(Float, nullable=False, server_default=text("'1013.25'"))
comment = Column(Text)
locked = Column(TINYINT(3), nullable=False, server_default=text("'0'"))
task_path = Column(String(40))
reg = relationship('TblRegion')
comp = relationship('TblCompetition')
Results = relationship('TblTaskResult')