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
