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