class BlogPostTranslation(db.Model): id = db.Column(db.Integer, primary_key=True) blog_post_id = db.Column(db.Integer, db.ForeignKey('blog_post.id')) language_id = db.Column(db.Integer, db.ForeignKey('language.id')) blog_post = db.relationship("BlogPost", back_populates="translations") language = db.relationship("Language", back_populates="blog_posts") translators = db.relationship("Translator", secondary=blog_post_translators, back_populates="blog_posts") def __repr__(self): return '<BlogPostTranslation {} - {}>'.format(self.blog_post.slug, self.language.ietf)
class Quote(db.Model): id = db.Column(db.Integer, primary_key=True) text = db.Column(db.String()) date = db.Column(db.Date) medium = db.Column(db.String()) email_id = db.Column(db.Integer, db.ForeignKey('email.id')) post_id = db.Column(db.Integer, db.ForeignKey('post.satoshi_id')) categories = db.relationship('QuoteCategory', secondary=quote_categories, backref=db.backref('quotes', lazy='dynamic')) def __repr__(self): return '<Quote %r>' % (self.id)
class Email(db.Model): id = db.Column(db.Integer, primary_key=True) satoshi_id = db.Column(db.Integer, unique=True) url = db.Column(db.String()) subject = db.Column(db.String()) sent_from = db.Column(db.String()) date = db.Column(db.DateTime) text = db.Column(db.String()) source = db.Column(db.String()) source_id = db.Column(db.String()) quotes = db.relationship("Quote", backref="email") parent_id = db.Column(db.Integer, db.ForeignKey('email.id')) replies = db.relationship('Email', backref=db.backref('parent', remote_side=[id]), lazy='dynamic') thread_id = db.Column(db.Integer, db.ForeignKey('email_thread.id')) def __repr__(self): return '<Email %r - %r>' % (self.subject, self.source_id)
class BlogPost(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String()) author = db.relationship('Author', secondary=blogauthors, backref=db.backref('blogposts', lazy='dynamic')) date = db.Column(db.Date) added = db.Column(db.Date) slug = db.Column(db.String()) excerpt = db.Column(db.String()) languages = db.Column(db.String()) series_id = db.Column(db.Integer, db.ForeignKey('blog_series.id')) series_index = db.Column(db.Integer) def __repr__(self): return '<BlogPost %r>' % (self.title)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) satoshi_id = db.Column(db.Integer, unique=True) url = db.Column(db.String()) subject = db.Column(db.String()) poster_name = db.Column(db.String()) poster_url = db.Column(db.String()) post_num = db.Column(db.Integer) # Post number in thread is_displayed = db.Column(db.Boolean) nested_level = db.Column(db.Integer) date = db.Column(db.DateTime) text = db.Column(db.String()) quotes = db.relationship("Quote", backref="post") thread_id = db.Column(db.Integer, db.ForeignKey('forum_thread.id')) def __repr__(self): return '<Post %r>' % (self.subject)
poster_url = db.Column(db.String()) post_num = db.Column(db.Integer) # Post number in thread is_displayed = db.Column(db.Boolean) nested_level = db.Column(db.Integer) date = db.Column(db.DateTime) text = db.Column(db.String()) quotes = db.relationship("Quote", backref="post") thread_id = db.Column(db.Integer, db.ForeignKey('forum_thread.id')) def __repr__(self): return '<Post %r>' % (self.subject) quote_categories = db.Table( 'quote_categories', db.Column('quote_id', db.Integer, db.ForeignKey('quote.id')), db.Column('quote_category_id', db.Integer, db.ForeignKey('quote_category.id'))) class QuoteCategory(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String()) slug = db.Column(db.String()) def __repr__(self): return '<QuoteCategory %r>' % (self.slug) class Quote(db.Model): id = db.Column(db.Integer, primary_key=True)
def __repr__(self): return '<Email %r>' % (self.subject) class Post(db.Model): id = db.Column(db.Integer, primary_key = True) url = db.Column(db.String()) name = db.Column(db.String()) date = db.Column(db.DateTime) text = db.Column(db.String()) source = db.Column(db.String()) def __repr__(self): return '<Post %r>' % (self.name) authors = db.Table('authors', db.Column('doc_id', db.Integer, db.ForeignKey('doc.id')), db.Column('author_id', db.Integer, db.ForeignKey('author.id')) ) blogauthors = db.Table('blogauthors', db.Column('blog_post_id', db.Integer, db.ForeignKey('blog_post.id')), db.Column('author_id', db.Integer, db.ForeignKey('author.id')) ) class Author(db.Model): id = db.Column(db.Integer, primary_key = True) first = db.Column(db.String()) middle = db.Column(db.String()) last = db.Column(db.String()) slug = db.Column(db.String())