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 UserGroup(orm.Model):
__tablename__ = USER_GROUP_TABLENAME
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True, allow_null=False)
user = orm.ForeignKey(User)
group = orm.ForeignKey(Group)
class RegistrarNotifier(orm.Model):
__tablename__ = "registrar_notifiers"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
registrar = orm.ForeignKey(Registrar)
notifier = orm.ForeignKey(Notifier)
class UserRelations(orm.Model):
__tablename__ = "relations"
__metadata__ = metadata
__database__ = database
id = orm.Integer(primary_key=True)
owner = orm.ForeignKey(User)
target = orm.ForeignKey(User)
kind = orm.String(max_length=10, index=True, default="friend")
class FeedListItem(model.Model):
feed_list = model.ForeignKey(FeedList)
feed = model.ForeignKey(Feed)
@classmethod
def get_feeds(cls, feed_list):
feeds = []
for i in FeedListItem.all(feed_list=feed_list):
feeds.append(i.feed)
return feeds
class EntryListItem(model.Model):
entry_list = model.ForeignKey(EntryList)
entry = model.ForeignKey(Entry)
@classmethod
def get_articles(cls, entry_list):
articles = []
for i in EntryListItem.all(entry_list=entry_list):
articles.append(Entry.get(id=i.id))
return articles
class Comment(BaseModel):
__tablename__ = "comment"
__database__ = database
__metadata__ = metadata
user_id = orm.ForeignKey(User, allow_null=True)
article_id = orm.ForeignKey(Articles, allow_null=True)
content = orm.String(max_length=255, allow_null=True)
parent_id = orm.Integer(allow_null=True)
to_uid = orm.Integer(allow_null=True)
level_flag = orm.String(allow_null=True, max_length=255)
class User(orm.Model):
__tablename__ = 'Users'
__metadata__ = metadata
__database__ = database
id = orm.Integer(primary_key=True, index=True)
user_name = orm.String(unique=True, index=True, max_length=100)
email = orm.String(unique=True, max_length=100)
hashed_password = orm.String(max_length=100)
user_info = orm.ForeignKey(UserInfo)
user_security = orm.ForeignKey(UserSecurity)
user_email = orm.ForeignKey(UserEmail)
class ArticleTag(BaseModel):
__tablename__ = 'articles_tags'
__database__ = database
__metadata__ = metadata
article_id = orm.ForeignKey(
Articles,
allow_null=True
)
tag_id = orm.ForeignKey(
Tags,
allow_null=True
)
class FilterItem(model.Model):
filter = model.ForeignKey(Filter)
entry = model.ForeignKey(Entry)
@classmethod
def get_articles(cls, filter_, limit='ALL', offset=0):
entries = []
for item in FilterItem.all(separator='OR',
order_by='-id',
limit=limit,
offset=offset,
filter=filter_):
entries.append(Entry.get(id=item.entry.id))
return entries
class Member(orm.Model):
registry = models
fields = {
"id": orm.Integer(primary_key=True),
"team": orm.ForeignKey(Team, on_delete=orm.SET_NULL, allow_null=True),
"email": orm.String(max_length=100),
}
class ActivationCode(BaseModel):
__tablename__ = "activatecode"
__database__ = database
__metadata__ = metadata
code = orm.String(max_length=6, min_length=6, allow_null=True)
user_id = orm.ForeignKey(User, allow_null=True)
class FeedList(model.Model):
name = model.Field()
user = model.ForeignKey(User)
@classmethod
def check_unique(cls, user, name):
return FeedList.is_unique(user=user, name=name)
class Team(orm.Model):
registry = models
fields = {
"id": orm.Integer(primary_key=True),
"org": orm.ForeignKey(Organisation, on_delete=orm.RESTRICT),
"name": orm.String(max_length=100),
}
class Token(orm.Model):
__tablename__ = "token"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
token = orm.String(max_length=256)
user = orm.ForeignKey(to=User, allow_null=False)
class Combination(orm.Model):
__metadata__ = metadata
__database__ = database
__tablename__ = "combinations"
id = orm.Integer(primary_key=True)
name = orm.Text()
language = orm.ForeignKey(Language)
class Toy(orm.Model):
__tablename__ = "toys"
__database__ = config.Database
__metadata__ = Common
id = orm.Integer(primary_key=True)
name = orm.String(max_length=100)
owner = orm.ForeignKey(Animal)
class Track(orm.Model):
registry = models
fields = {
"id": orm.Integer(primary_key=True),
"album": orm.ForeignKey("Album", on_delete=orm.CASCADE),
"title": orm.String(max_length=100),
"position": orm.Integer(),
}
class Member(orm.Model):
__tablename__ = "member"
__metadata__ = metadata
__database__ = database
id = orm.Integer(primary_key=True)
team = orm.ForeignKey(Team)
email = orm.String(max_length=100)
class Thread(orm.Model):
__tablename__ = 'threads'
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True)
slug = orm.String(index=True, unique=True, min_length=4, max_length=4)
board = orm.ForeignKey(Board)
class Team(orm.Model):
__tablename__ = "team"
__metadata__ = metadata
__database__ = database
id = orm.Integer(primary_key=True)
org = orm.ForeignKey(Organisation)
name = orm.String(max_length=100)
class Track(orm.Model):
__tablename__ = "track"
__metadata__ = metadata
__database__ = database
id = orm.Integer(primary_key=True)
album = orm.ForeignKey(Album)
title = orm.String(max_length=100)
position = orm.Integer()
class Note(orm.Model):
__tablename__ = "notes"
__database__ = database
__metadata__ = metadata
id = orm.Integer(primary_key=True, index=True)
notebook = orm.ForeignKey(Notebook)
text = orm.String(max_length=100)
completed = orm.Boolean(default=False)
class AnswerHistory(orm.Model):
__tablename__ = 'answer_history'
__metadata__ = metadata
__database__ = db
id = orm.Integer(primary_key=True, index=True)
answer = orm.Integer()
created_date = orm.DateTime(default=datetime.now())
word = orm.ForeignKey(Word)
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 Translate(models.Model):
__tablename__ = 'translates'
__metadata__ = metadata
__database__ = db
id = orm.Integer(primary_key=True, index=True)
created_date = orm.DateTime(default=datetime.now())
word = orm.ForeignKey(Word)
text = orm.String(max_length=256)
part_of_speech = fields.Enum(PartOfSpeechEnum)
class SecTestA(orm.Model):
__metadata__ = metadata
__tablename__ = "sectest"
__database__ = database
id = orm.Integer(primary_key=True)
result = orm.Integer()
code = orm.String(max_length=25)
suite = orm.ForeignKey(SecTestSuiteA)
created = orm.DateTime()
modified = orm.DateTime()
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 Report(orm.Model):
__tablename__ = "reports"
__database__ = database
__metadata__ = metadata
activity_id = orm.Integer(primary_key=True)
strava_athlete = orm.ForeignKey(StravaAthlete)
title = orm.String(max_length=500)
datetime = orm.DateTime()
notebook_filename = orm.String(max_length=200)
html_filename = orm.String(max_length=200)
