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 Game(orm.Model):
__tablename__ = "notes"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
state = orm.String(max_length=18)
owner = orm.JSON()
challenger = orm.JSON(default={}, allow_null=True)
winner = orm.Integer(allow_null=True)
status = orm.String(max_length=10)
class OTHER_DB_REFERENCES(orm.Model):
__tablename__ = 'other_dbReferences'
__metadata__ = self.metadata
__database__ = self.database
type = orm.String(primary_key=True, max_length=100)
id = orm.String(primary_key=True, max_length=100)
properties = orm.JSON(allow_null=True)
isoform = orm.String(primary_key=True,
max_length=100,
allow_blank=True)
evidences = orm.JSON(allow_null=True)
accession = orm.String(primary_key=True, max_length=100)
class StatsChainSeq(orm.Model):
__tablename__ = 'StatsChainSeq'
__metadata__ = self.metadata
__database__ = self.database
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)
OBS_INDEX = orm.JSON()
OBS_COUNT = orm.Integer()
OBS_RATIO_ARRAY = orm.Text()
BINDING_LIGAND_INDEX = orm.JSON()
BINDING_LIGAND_COUNT = orm.Integer()
class INFO(orm.Model):
__tablename__ = 'INFO'
__metadata__ = self.metadata
__database__ = self.database
accession = orm.String(max_length=100, primary_key=True)
id = orm.String(max_length=100)
proteinExistence = orm.Text(allow_null=True, allow_blank=True)
info = orm.JSON()
organism = orm.JSON()
secondaryAccession = orm.JSON(allow_null=True)
protein = orm.JSON()
gene = orm.JSON()
sequence = orm.Text()
length = orm.Integer()
class ALTERNATIVE_PRODUCTS(orm.Model):
__tablename__ = 'ALTERNATIVE_PRODUCTS'
__metadata__ = self.metadata
__database__ = self.database
isoform = orm.String(max_length=50, primary_key=True)
name = orm.JSON(allow_null=True)
synonyms = orm.JSON(allow_null=True)
sequenceStatus = orm.String(max_length=50)
VAR_SEQ = orm.JSON(allow_null=True)
accession = orm.String(max_length=50, primary_key=True)
else_iso = orm.JSON(allow_null=True)
iso_range = orm.JSON(allow_null=True)
iso_range_len = orm.Integer(allow_null=True)
sequence = orm.Text(allow_null=True)
length = orm.Integer(allow_null=True)
class StatsProteinEntitySeq(orm.Model):
__tablename__ = 'StatsProteinEntitySeq'
__metadata__ = self.metadata
__database__ = self.database
pdb_id = orm.String(max_length=4, primary_key=True)
molecule_type = orm.Text()
entity_id = orm.Integer(primary_key=True)
ca_p_only = orm.Boolean()
SEQRES_COUNT = orm.Integer()
STD_INDEX = orm.JSON()
STD_COUNT = orm.Integer()
NON_INDEX = orm.JSON()
NON_COUNT = orm.Integer()
UNK_INDEX = orm.JSON()
UNK_COUNT = orm.Integer()
ARTIFACT_INDEX = orm.JSON()
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 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 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 Hosting(orm.Model):
__tablename__ = "hosting"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
label = orm.String(max_length=100, unique=True)
agent_module = orm.String(max_length=100)
state = orm.JSON()
active = orm.Boolean(default=True)
async def serialize(self, full=False):
await self.load()
return {"id": self.id, "label": self.label}
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 DNSProvider(orm.Model):
__tablename__ = "dns_providers"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
label = orm.String(max_length=100, unique=True)
agent_module = orm.String(max_length=100)
state = orm.JSON()
active = orm.Boolean(default=True)
async def serialize(self, full=False):
await self.load()
r = {"id": self.id, "label": self.label}
if full:
r['agent_module'] = self.agent_module
r['active'] = self.active
return r
class FEATURES(orm.Model):
__tablename__ = 'features'
__metadata__ = self.metadata
__database__ = self.database
type = orm.String(primary_key=True, max_length=100)
category = orm.String(primary_key=True, max_length=100)
description = orm.Text(allow_null=True, allow_blank=True)
begin = orm.Integer(primary_key=True)
end = orm.Integer(primary_key=True)
molecule = orm.String(primary_key=True,
max_length=100,
allow_blank=True)
ftId = orm.String(max_length=100,
allow_null=True,
allow_blank=True)
evidences = orm.JSON(allow_null=True)
alternativeSequence = orm.Text(allow_null=True, allow_blank=True)
accession = orm.String(primary_key=True, max_length=100)
class Registrar(orm.Model):
__tablename__ = "registrars"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
label = orm.String(max_length=100, unique=True)
agent_module = orm.String(max_length=100)
state = orm.JSON()
active = orm.Boolean(default=True)
updated_time = orm.DateTime()
async def serialize(self, full=False):
await self.load()
r = {
"id": self.id,
"label": self.label,
"updated_time": jsonable_encoder(self.updated_time)
}
return r
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 Data(orm.Model):
__tablename__ = "data"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
character = orm.ForeignKey(Character)
level = orm.Integer()
energy_shield = orm.Integer()
life = orm.Integer()
pob_export = orm.Text()
max_dps = orm.Integer()
max_dps_skill = orm.String(max_length=255)
character_class = orm.String(max_length=255)
data = orm.JSON()
last_update = orm.DateTime(allow_null=True)
@staticmethod
async def create_data(**kwargs):
await Data.objects.create(**kwargs)
class RequestCache(object):
__tablename__ = "sheet_request_cache"
id = orm.Integer(primary_key=True)
request_id = orm.Text()
data = orm.JSON(default={})