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)