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={})