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)
