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')