class APIResponse(orm.Model): __tablename__ = 'tb_api_response' __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) timestamp_start = orm.Float(allow_null=False, precision=5) timestamp_end = orm.Float(allow_null=False, precision=5) ip_address = orm.String(max_length=100, allow_null=False) api_response = orm.JSON(allow_null=False) city = orm.String(max_length=100, allow_null=False)
class SMRModel(orm.Model): __tablename__ = 'SMRModel' __metadata__ = self.metadata __database__ = self.database UniProt = orm.String(max_length=50, primary_key=True) coordinates = orm.String(max_length=500, primary_key=True) unp_beg = orm.Integer() unp_end = orm.Integer() identity = orm.Float() similarity = orm.Float() coverage = orm.Float() oligo_state = orm.String(max_length=50) with_ligand = orm.Boolean() select_rank = orm.Integer() select_tag = orm.Boolean()
class LitemallGoodsProduct(BaseModel): __tablename__ = 'litemall_goods_product' goods_id = orm.Integer() spec_id = orm.Integer() price = orm.Float() number = orm.Integer() url = orm.String(length=125)
class Account(orm.Table): user = orm.Foreign(User) type = orm.String(choices=["Normal", "Special",], default="Normal") balance = orm.Float(blank=True) def __repr__(self): return "<Account: %s's %s>"%(self.user.firstName, self.type)
class PISAInterfaceDict(orm.Model): __tablename__ = 'PISAInterfaceDict' __metadata__ = self.metadata __database__ = self.database entity_id_1 = orm.Integer() chain_id_1 = orm.String(max_length=50) struct_asym_id_1 = orm.String(max_length=50) struct_asym_id_in_assembly_1 = orm.String(max_length=50) asym_id_rank_1 = orm.Integer() model_id_1 = orm.Integer() molecule_type_1 = orm.Text() surface_range_1 = orm.JSON(allow_null=True) interface_range_1 = orm.JSON(allow_null=True) entity_id_2 = orm.Integer() chain_id_2 = orm.String(max_length=50) struct_asym_id_2 = orm.String(max_length=50) struct_asym_id_in_assembly_2 = orm.String(max_length=50) asym_id_rank_2 = orm.Integer() model_id_2 = orm.Integer() molecule_type_2 = orm.Text() surface_range_2 = orm.JSON(allow_null=True) interface_range_2 = orm.JSON(allow_null=True) pdb_id = orm.String(max_length=4, primary_key=True) assembly_id = orm.Integer(primary_key=True) interface_id = orm.Integer(primary_key=True) use_au = orm.Boolean() css = orm.Float() is_polymer_1 = orm.Boolean() is_polymer_2 = orm.Boolean()
class Person(orm.Table): firstName = orm.String() lastName = orm.String(choices=["Hinton", 3]) height = orm.Float(blank=True) age = orm.Integer(blank=True) def __repr__(self): return "<Person: %s %s>"%(self.firstName, self.lastName)
class Person(orm.Table): firstName = orm.String() lastName = orm.String() height = orm.Float(default="Bob") age = orm.Integer(blank=True) def __repr__(self): return "<Person: %s %s>" % (self.firstName, self.lastName)
class User(orm.Table): firstName = orm.String() lastName = orm.String() height = orm.Float(blank=True) age = orm.Integer(blank=True) def __repr__(self): return "<User: %s %s>" % (self.firstName, self.lastName)
class LitemallOrder(BaseModel): __tablename__ = 'litemall_order' user_id = orm.Integer() order_sn = orm.String(length=63) order_status = orm.Integer() consignee = orm.String(length=63) mobile = orm.String(length=63) address = orm.String(length=127) message = orm.String(length=512) goods_price = orm.Float() freight_price = orm.Float() coupon_price = orm.Float() order_price = orm.Float() ship_sn = orm.String(length=63) ship_channel = orm.String(length=63) ship_time = orm.Datetime() confirm_time = orm.Datetime() end_time = orm.Datetime()
class LitemallCoupon(BaseModel): __tablename__ = 'litemall_coupon' name = orm.String(length=63) description = orm.String(length=127) tag = orm.String(length=63) total = orm.Integer() discount = orm.Float() min = orm.Float() limitation = orm.Integer() type = orm.Integer() status = orm.Integer() goods_type = orm.Integer() goods_value = orm.String(length=1023) code = orm.String(length=63) time_type = orm.Integer() days = orm.Integer() start_time = orm.Datetime() end_time = orm.Datetime()
class Station(orm.Model): """ Represents a bikeshare "station" """ __tablename__ = 'stations' __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) station_num = orm.String(max_length=10, unique=True) station_lat = orm.Float() station_long = orm.Float() def __repr__(self): return str(self.station_num) def __str__(self): return str(self.station_num)
class LitemallOrderGoods(BaseModel): __tablename__ = 'litemall_order_goods' order_id = orm.Integer() goods_id = orm.Integer() goods_name = orm.String(length=127) goods_sn = orm.String(length=63) product_id = orm.Integer() number = orm.Integer() price = orm.Float() pic_url = orm.String(length=255)
class rcsb_cluster_membership(orm.Model): __tablename__ = 'rcsb_cluster_membership' __metadata__ = self.metadata __database__ = self.database rcsb_id = orm.Text() score = orm.Float() identity = orm.Integer(primary_key=True) cluster_id = orm.Integer(primary_key=True) pdb_id = orm.String(max_length=4, primary_key=True) entity_id = orm.Integer(primary_key=True)
class Todo(orm.Model): __tablename__ = "todo" __metadata__ = metadata __database__ = database id = orm.Integer(primary_key=True) created = orm.DateTime(default=datetime.datetime.now) modified = orm.DateTime(default=datetime.datetime.now, onupdate=datetime.datetime.now) description = orm.Text(allow_blank=True) value = orm.Float(allow_null=True) data = orm.JSON(default={})
class FuelTable(orm.Model): __tablename__ = "fuels" __database__ = db __metadata__ = metadata id = orm.Integer(primary_key=True) name = orm.String(max_length=30) fuel_level = orm.Integer(minimum=0, maximum=100) reserves = orm.Float() buy_order = orm.Boolean() guild_id = orm.String(max_length=50)
class LitemallCart(BaseModel): __tablename__ = 'litemall_cart' user_id = orm.Integer() goods_id = orm.Integer() goods_sn = orm.String(length=63) goods_name = orm.String(length=127) product_id = orm.Integer() price = orm.Float() number = orm.Integer() checked = orm.TinyInteger(length=1) pic_url = orm.String(length=255)
class Example(orm.Model): __tablename__ = "example" __metadata__ = metadata __database__ = database id = orm.Integer(primary_key=True) created = orm.DateTime(default=datetime.datetime.now) created_day = orm.Date(default=datetime.date.today) created_time = orm.Time(default=time) description = orm.Text(allow_blank=True) value = orm.Float(allow_null=True) data = orm.JSON(default={})
class SelectedMappingMeta(orm.Model): __tablename__ = 'SelectedMappingMeta' __metadata__ = self.metadata __database__ = self.database UniProt = orm.String(max_length=50, primary_key=True) pdb_id = orm.String(max_length=4, primary_key=True) entity_id = orm.Integer(primary_key=True) struct_asym_id = orm.String(max_length=10, primary_key=True) chain_id = orm.String(max_length=10) bs_score = orm.Float() select_rank = orm.Integer() select_tag = orm.Boolean() after_select_rank = orm.Integer()
class LitemallGoods(BaseModel): __tablename__ = 'litemall_goods' goods_sn = orm.String(length=63) name = orm.String(length=127) category_id = orm.Integer() brand_id = orm.Integer() gallery = orm.String(length=1023) keywords = orm.String(length=255) brief = orm.String(length=255) is_on_sale = orm.TinyInteger(length=1) sort_order = orm.Integer() pic_url = orm.String(length=255) unit = orm.String(length=31) retail_price = orm.Float() detail = orm.Text()
class Product(orm.Model): registry = models fields = { "id": orm.Integer(primary_key=True), "uuid": orm.UUID(allow_null=True), "created": orm.DateTime(default=datetime.datetime.now), "created_day": orm.Date(default=datetime.date.today), "created_time": orm.Time(default=time), "data": orm.JSON(default={}), "description": orm.Text(allow_blank=True), "huge_number": orm.BigInteger(default=0), "price": orm.Decimal(max_digits=5, decimal_places=2, allow_null=True), "status": orm.Enum(StatusEnum, default=StatusEnum.DRAFT), "value": orm.Float(allow_null=True), }
class PI(orm.Model): __tablename__ = 'PI' __metadata__ = self.metadata __database__ = self.database UniProt = orm.String(max_length=50, primary_key=True) pdb_id = orm.String(max_length=4, primary_key=True) entity_id = orm.Integer(primary_key=True) struct_asym_id = orm.String(max_length=10, primary_key=True) chain_id = orm.String(max_length=10) assembly_id = orm.Integer(primary_key=True) model_id = orm.Integer() struct_asym_id_in_assembly = orm.String(max_length=10, primary_key=True) interface_id = orm.Integer(primary_key=True) css = orm.Float() i_select_tag = orm.Boolean() i_select_rank = orm.Integer() pdb_beg = orm.Integer() pdb_end = orm.Integer()
class ResidueMappingRange(orm.Model): __tablename__ = 'ResidueMappingRange' __metadata__ = self.metadata __database__ = self.database UniProt = orm.String(max_length=20, primary_key=True) pdb_id = orm.String(max_length=4, primary_key=True) entity_id = orm.Integer(primary_key=True) chain_id = orm.String(max_length=10) struct_asym_id = orm.String(max_length=10, primary_key=True) auth_pdb_beg = orm.Integer() auth_pdb_end = orm.Integer() pdb_beg = orm.Integer(primary_key=True) pdb_end = orm.Integer(primary_key=True) unp_beg = orm.Integer(primary_key=True) unp_end = orm.Integer(primary_key=True) # Special: author_insertion_code = orm.String(max_length=10, allow_null=True, allow_blank=True, default='') residue_name = orm.String(max_length=10, allow_null=True, allow_blank=True, default='') observed_ratio = orm.Float() multiple_conformers = orm.JSON(allow_null=True) conflict_code = orm.String(max_length=3, allow_null=True)
class PythonPackageVersion(orm.Model): __tablename__ = "python_packages_versions" __database__ = context.database __metadata__ = context.metadata id = orm.Integer(primary_key=True) package = orm.ForeignKey(PythonPackage) user_id = orm.Integer(index=True, allow_null=True) size = orm.Integer() version = orm.Text() requires_python = orm.Text() yanked = orm.Boolean(default=False) comment_text = orm.Text(allow_null=True) yanked_reason = orm.Text(allow_null=True) filetype = orm.String(max_length=30) metadata_version = orm.Float() downloads = orm.Integer(default=0) filename = orm.Text(allow_null=False) md5_digest = orm.Text(allow_null=True) description = orm.Text(allow_null=True) sha256_digest = orm.Text(allow_null=True) upload_time = orm.DateTime(default=datetime.now) requires_dist = orm.Text(allow_null=True) description_content_type = orm.Text(allow_null=True) python_version = orm.Text(allow_null=True) @staticmethod def cast_upload_to_dict(filename: str, upload: DistInfoModel) -> Dict[str, Any]: return dict( version=upload.version, description=upload.description, comment_text=upload.comment, filetype=upload.filetype, metadata_version=upload.metadata_version, filename=filename, md5_digest=upload.md5_digest, requires_python=upload.requires_python, sha256_digest=upload.sha256_digest, description_content_type=upload.description_content_type.value if upload.description_content_type else None, requires_dist=";".join(upload.requires_dist) if upload.requires_dist else None, python_version=upload.python_version, ) @classmethod async def create_by_dist_info( cls, *, filename: str, package: PythonPackage, size: int, dist_info: DistInfoModel, user_id: Optional[int]) -> "PythonPackageVersion": info_dict = cls.cast_upload_to_dict(filename, dist_info) return await cls.objects.create(package=package, size=size, user_id=user_id, **info_dict) async def update_by_dist_info( self, *, filename: str, package: PythonPackage, size: int, dist_info: DistInfoModel) -> "PythonPackageVersion": info_dict = self.cast_upload_to_dict(filename, dist_info) return await self.update(package=package, size=size, **info_dict)