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 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 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 Message(orm.Model):
__tablename__ = "message"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
subject = orm.Text(allow_null=False)
message = orm.Text(allow_null=False)
class Good(orm.Model):
__metadata__ = metadata
__database__ = database
__tablename__ = "goods"
id = orm.Integer(primary_key=True)
name = orm.Text()
product_url = orm.Text()
image_url = orm.Text()
price = orm.Text()
combination = orm.ForeignKey(Combination)
class Post(orm.Model):
__tablename__ = "posts"
__database__ = database
__metadata__ = metadata
objects = PostQuerySet()
id = orm.Integer(primary_key=True)
title = orm.String(max_length=300)
description = orm.Text(allow_blank=True) # Social cards and RSS
content = orm.Text(allow_blank=True)
created = orm.DateTime(index=True)
modified = orm.DateTime(index=True)
published = orm.DateTime(allow_null=True)
image_url = URLField(allow_null=True)
image_caption = orm.Text(allow_null=True)
@property
def is_published(self) -> bool:
return self.published is not None
async def update(self, **kwargs) -> None:
kwargs["modified"] = datetime.now()
await super().update(**kwargs)
async def publish(self):
assert not self.is_published
await self.update(published=datetime.now())
async def _get_relative_id(self,
previous: bool = True) -> typing.Optional[int]:
if not self.published:
return None
filters = {
"published__lt" if previous else "published__gt": self.published
}
order_by = ("-" if previous else "") + "published"
results = await (Post.objects.published_only().filter(
**filters).order_by(order_by).all())
return results[0].id if results else None
async def get_previous_id(self) -> typing.Optional[int]:
return await self._get_relative_id(previous=True)
async def get_next_id(self) -> typing.Optional[int]:
return await self._get_relative_id(previous=False)
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 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 WSTournamentEn(ReceiverImagesMixin):
"""Weiß Schwarz - English Edition - Monthly Shop Tournament Card service. This is a receiver service.
Get all English Edition - Monthly Shop Tournament Cards."""
MODULE = "Weiß Schwarz - English Tournament"
MODELS_METADATA, MODEL_IDENTIFIER, MODELS = identifier_factory(
orm.Text(primary_key=True))
_EN_URL = 'https://en.ws-tcg.com/events/'
_PUBLIC_URL = True
_RECEIVER_CONFIG = ReceiverConfig
async def _load_publications(self):
html = await self._get_site_content(url=self._EN_URL)
beautiful_soap = BeautifulSoup(html, 'html5lib')
months = beautiful_soap.findAll('div', class_='monthWrap')
for month in months:
cards = month.findAll('img')
title_str = self._add_html_tag(month.find('h4').text.strip(),
tag=self._TITLE_HTML_TAG)
title = RichText(data=title_str, format_data=FormatData.HTML)
for card in cards:
publication = await self._create_publication_from_img(
img=card, rich_title=title)
if publication:
transaction_data = TransactionData(
transaction_id=publication.publication_id,
publications=[publication])
await self._put_in_queue(transaction_data=transaction_data)
class Combination(orm.Model):
__metadata__ = metadata
__database__ = database
__tablename__ = "combinations"
id = orm.Integer(primary_key=True)
name = orm.Text()
language = orm.ForeignKey(Language)
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 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 PythonPackage(orm.Model):
__tablename__ = "python_packages"
__database__ = context.database
__metadata__ = context.metadata
id = orm.Integer(primary_key=True)
user_id = orm.Integer(allow_null=True, index=True)
name = orm.Text(allow_null=False, index=True)
author = orm.Text(allow_null=True)
summary = orm.Text(allow_null=True)
license = orm.Text(allow_null=True)
keywords = orm.Text(allow_null=True)
home_page = orm.Text(allow_null=True)
maintainer = orm.Text(allow_null=True)
project_urls = orm.Text(allow_null=True)
author_email = orm.Text(allow_null=True)
maintainer_email = orm.Text(allow_null=True)
@staticmethod
def cast_dist_info_to_data(upload: DistInfoModel) -> Dict[str, Any]:
return dict(
name=upload.name,
summary=upload.summary,
license=upload.license,
keywords=upload.keywords,
home_page=upload.home_page,
author=upload.author,
author_email=upload.author_email,
project_urls=";".join(upload.project_urls) if upload.project_urls else None,
maintainer=upload.maintainer,
maintainer_email=upload.maintainer_email,
)
@classmethod
async def create_by_dist_info(
cls, *, upload: DistInfoModel, user_id: Optional[int]
) -> "PythonPackage":
upload_dict = cls.cast_dist_info_to_data(upload)
return await cls.objects.create(**upload_dict, user_id=user_id)
async def update_by_dist_info(self, upload: DistInfoModel) -> None:
upload_dict = self.cast_dist_info_to_data(upload)
await self.update(**upload_dict)
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 WeiBo(orm.Model):
__tablename__ = "weibo"
__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)
class Post(orm.Model):
__tablename__ = 'posts'
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
thread = orm.ForeignKey(Thread)
offset = orm.Integer()
markdown = orm.Text()
datetime = orm.DateTime(default=datetime.datetime.now)
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 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 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 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 Post(app.db.Model):
__tablename__ = "posts"
id = orm.Integer(primary_key=True)
author = orm.ForeignKey(User)
timestamp = orm.DateTime()
content = orm.Text()
@property
def post_time(self):
from datetime import datetime
return datetime.strptime(self.timestamp, "%Y-%m-%d %H:%M:%S.%f")
class VAR_SEQ(orm.Model):
__tablename__ = 'VAR_SEQ'
__metadata__ = self.metadata
__database__ = self.database
ftId = orm.String(max_length=100,
primary_key=True,
allow_blank=True)
Entry = orm.String(max_length=50, primary_key=True)
# AltRange = orm.JSON(allow_null=True)
begin = orm.Integer(allow_null=True)
end = orm.Integer(allow_null=True)
# AltInfo = orm.Text(allow_null=True, allow_blank=True)
before = orm.Text(allow_null=True, allow_blank=True)
after = orm.Text(allow_null=True, allow_blank=True)
# AltIso
description = orm.String(max_length=100,
allow_blank=True,
allow_null=True)
# AltLen = orm.JSON(allow_null=True)
before_len = orm.Integer(allow_null=True)
after_len = orm.Integer(allow_null=True)
evidence = orm.Text(allow_null=True, allow_blank=True)
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 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 ResidueMapping(orm.Model):
__tablename__ = 'ResidueMapping'
__metadata__ = self.metadata
__database__ = self.database
UniProt = orm.String(max_length=50, primary_key=True)
author_insertion_code = orm.String(max_length=50,
allow_null=True,
allow_blank=True,
default='')
author_residue_number = orm.Integer()
chain_id = orm.String(max_length=10)
entity_id = orm.Integer(primary_key=True)
identifier = orm.Text(allow_null=True,
allow_blank=True,
default='')
name = orm.Text(allow_null=True, allow_blank=True, default='')
observed = orm.String(max_length=1)
pdb_id = orm.String(max_length=4, primary_key=True)
pdb_one_letter_code = orm.String(max_length=1, primary_key=True)
residue_number = orm.Integer(primary_key=True)
struct_asym_id = orm.String(max_length=10, primary_key=True)
unp_one_letter_code = orm.String(max_length=1, primary_key=True)
unp_residue_number = orm.Integer(primary_key=True)
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 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 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 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 Setting(orm.Model):
__tablename__ = "setting"
__database__ = database
__metadata__ = metadata
_id = orm.Integer(primary_key=True)
config_id = orm.String(max_length=100)
s_key = orm.String(max_length=100)
s_value = orm.Text(default="")
async def serialize(self, full=False):
await self.load()
return {
"_id": self._id,
"config_id": self.config_id,
"s_key": jsonable_encoder(self.s_key),
"s_value": jsonable_encoder(self.s_value),
}
