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 Domain(orm.Model): __tablename__ = "domains" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) name = orm.String(max_length=100, unique=True) registrar = orm.ForeignKey(Registrar) dns = orm.ForeignKey(DNSProvider, allow_null=True) site = orm.ForeignKey(Site, allow_null=True) waf = orm.ForeignKey(WAFProvider, allow_null=True) update_apex = orm.Boolean(default=True) update_a_records = orm.Text(default="www") google_site_verification = orm.String(max_length=64, allow_null=True) state = orm.Text(default="{}") active = orm.Boolean(default=True) async def serialize(self, full=False): r = { "id": self.id, "name": self.name, } if self.registrar.id: r["registrar"] = await self.registrar.serialize() if self.dns.id: r["dns"] = await self.dns.serialize() if self.site.id: r["site"] = await self.site.serialize() if self.waf.id: r["waf"] = await self.waf.serialize() if self.active: r["active"] = True return r
class Trigger(orm.Model): __tablename__ = "trigger" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) rss_url = orm.String(max_length=255) joplin_folder = orm.String(max_length=80, allow_null=True) reddit = orm.String(max_length=80, allow_null=True) mastodon = orm.Boolean(default=False) mail = orm.Boolean(default=False) description = orm.String(max_length=200) date_created = orm.DateTime(default=datetime.datetime.now) date_triggered = orm.DateTime(default=datetime.datetime.now) status = orm.Boolean(default=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 UserEmail(orm.Model): __tablename__ = 'UserEmail' __metadata__ = metadata __database__ = database id = orm.Integer(primary_key=True) email_verify = orm.String(max_length=70, index=True) is_activatet = orm.Boolean(default=False)
class Articles(BaseModel): __tablename__ = 'articles' __database__ = database __metadata__ = metadata title = orm.String(max_length=255, allow_null=True) summary = orm.String(max_length=255, allow_null=True) views = orm.Integer(default=0) comment_num = orm.Integer(default=0) weight = orm.Integer(default=0) content = orm.Text() # txt content_html = orm.Text() # html is_hot = orm.Boolean(default=False) key_words = orm.String(max_length=255, allow_null=True) tag_id = orm.ForeignKey( Tags, allow_null=True ) user_id = orm.ForeignKey( User, allow_null=True ) def __str__(self): return self.title
class IDMapping(orm.Model): __tablename__ = 'IDMapping' __metadata__ = self.metadata __database__ = self.database ftId = orm.String(max_length=20, primary_key=True) Entry = orm.String(max_length=50, primary_key=True) isoform = orm.String(max_length=50, primary_key=True) is_canonical = orm.Boolean()
class Animal(orm.Model): __tablename__ = "animals" __database__ = config.Database __metadata__ = Common id = orm.Integer(primary_key=True) name = orm.String(max_length=100) adopted = orm.Boolean(default=False)
class Note(orm.Model): __tablename__ = "notes" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) text = orm.String(max_length=100) completed = orm.Boolean(default=False)
class Product(orm.Model): tablename = "products" registry = models fields = { "id": orm.Integer(primary_key=True), "name": orm.String(max_length=100), "rating": orm.Integer(minimum=1, maximum=5), "in_stock": orm.Boolean(default=False), }
class Product(orm.Model): __tablename__ = "product" __metadata__ = metadata __database__ = database id = orm.Integer(primary_key=True) name = orm.String(max_length=100) rating = orm.Integer(minimum=1, maximum=5) in_stock = orm.Boolean(default=False)
class StravaAthlete(orm.Model): __tablename__ = "strava_athletes" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) access_token = orm.String(max_length=100) refresh_token = orm.String(max_length=100) token_expiration_datetime = orm.DateTime() backfilled = orm.Boolean(default=False)
class Spiders(orm.Model): __tablename__ = "spiders" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) title = orm.String(max_length=255, allow_null=True, allow_blank=True) publish_time = orm.String(max_length=20, allow_null=True, allow_blank=True) content = orm.Text(allow_null=True, allow_blank=True) group = orm.String(max_length=20, allow_null=True, allow_blank=True) is_activated = orm.Boolean(default=False)
class User(orm.Model): """ User model """ __tablename__ = "Users" __database__ = DATABASE __metadata__ = METADATA id = orm.Integer(primary_key=True, index=True) slackId = orm.String(max_length=255) slackAccessToken = orm.String(max_length=255) spotifyId = orm.String(max_length=255) spotifyExpiresAt = orm.DateTime(max_length=255) spotifyAccessToken = orm.String(max_length=255) spotifyRefreshToken = orm.String(max_length=255) createdAt = orm.DateTime() updatedAt = orm.DateTime() statusSetLastTime = orm.Boolean(default=False) useCustomEmojis = orm.Boolean(default=True)
class Word(models.Model): __tablename__ = 'words' __metadata__ = metadata __database__ = db id = orm.Integer(primary_key=True, index=True) value = orm.String(max_length=64, unique=True) created_date = orm.DateTime(default=datetime.now()) repeat = orm.DateTime(default=datetime.now()) done = orm.Boolean(default=False) user = orm.ForeignKey(User)
class HotData(orm.Model): __tablename__ = "hotdata" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) title = orm.String(max_length=30, allow_null=False) info = orm.Text() search_num = orm.Boolean(default=False, allow_null=False) created_at = orm.DateTime()
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 User(orm.Model): __tablename__ = 'users' __metadata__ = metadata __database__ = db id = orm.Integer(primary_key=True, index=True) github_id = orm.Integer(index=True) username = orm.String(max_length=256) last_login = orm.DateTime(default=datetime.now()) created_date = orm.DateTime(default=datetime.now()) avatar_url = orm.String(allow_null=True, max_length=256) is_admin = orm.Boolean(default=False)
class TodoList(orm.Model): __tablename__ = "todo" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) title = orm.String(max_length=30, allow_null=False) status = orm.Boolean(default=False) info = orm.Text() created_at = orm.DateTime() updated_at = orm.DateTime() deleted_at = orm.DateTime()
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 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 User(orm.Model): __tablename__ = "user" __metadata__ = metadata __database__ = database id = orm.Integer(primary_key=True) name = orm.String(max_length=100, unique=True, index=True) password = orm.String(max_length=100) language = orm.String(max_length=10) is_active = orm.Boolean() @classmethod async def create(cls, name: str, password: str, **kwargs): password = hashlib.sha256(password.encode()).hexdigest() return await cls.objects.create(name=name, password=password, **kwargs)
class Notes(orm.Model): registry = models tablename = 'notes' fields = { 'id': orm.Integer(title="ID", primary_key=True, read_only=True), 'created': orm.DateTime(title="Created", default=datetime.datetime.now, read_only=True), 'text': orm.String(title="Text", max_length=100), 'completed': orm.Boolean(title="Completed", default=False) }
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 INTERACTION(orm.Model): __tablename__ = 'INTERACTION' __metadata__ = self.metadata __database__ = self.database accession1 = orm.String(max_length=100, primary_key=True) accession2 = orm.String(max_length=100, primary_key=True) gene = orm.String(max_length=100, allow_null=True, allow_blank=True) interactor1 = orm.String(max_length=100, primary_key=True) interactor2 = orm.String(max_length=100, primary_key=True) organismDiffer = orm.Boolean() experiments = orm.Integer() chain1 = orm.Text(allow_null=True, allow_blank=True) chain2 = orm.Text(allow_null=True, allow_blank=True) accession = orm.String(max_length=50, primary_key=True)
class User(BaseModel): __tablename__ = "user" __database__ = database __metadata__ = metadata username = orm.String(max_length=50) password = orm.String(max_length=255) email = orm.String(max_length=50, unique=True, index=True) phone = orm.String(allow_null=True, max_length=11) nickname = orm.String(allow_null=True, max_length=50) avatar = orm.String(allow_null=True, max_length=255) status = orm.String(allow_null=True, max_length=10) is_active = orm.Boolean(default=False) def __str__(self): return self.username
class profile_id(orm.Model): __tablename__ = 'profile_id' __metadata__ = self.metadata __database__ = self.database pdb_id = orm.String(max_length=4, primary_key=True) entity_id = orm.Integer(primary_key=True) molecule_type = orm.Text() # redundant chain_id = orm.String(max_length=10) # redundant struct_asym_id = orm.String(max_length=10, primary_key=True) assembly_id = orm.Integer(primary_key=True) model_id = orm.Integer() asym_id_rank = orm.Integer() oper_expression = orm.Text(allow_blank=True) symmetry_operation = orm.Text(allow_blank=True) symmetry_id = orm.Text(allow_blank=True) struct_asym_id_in_assembly = orm.Integer(primary_key=True) au_subset = orm.Boolean() details = orm.Text()
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 Person(orm.Model): __tablename__ = "person" __database__ = app.database __metadata__ = app.metadata id = orm.Integer(primary_key=True) name = orm.String(max_length=100) age = orm.Integer() balance = orm.Integer(default=0) balance_decimal_places = orm.Integer(default=0) currency = orm.String(default='$', max_length=5) email = orm.String(max_length=100) address = orm.String(max_length=300, allow_blank=True) is_favorite = orm.Boolean(default=False) @property def balance_exact(self): return Decimal(self.balance).shift(self.balance_decimal_places)
class Site(orm.Model): __tablename__ = "sites" __database__ = database __metadata__ = metadata id = orm.Integer(primary_key=True) label = orm.String(max_length=100, unique=True) hosting = orm.ForeignKey(Hosting) active = orm.Boolean(default=True) async def serialize(self, full=False): await self.load() r = { "id": self.id, "label": self.label, "hosting": await self.hosting.serialize(), "active": self.active } return r