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) 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)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) satoshi_id = db.Column(db.Integer) 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('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('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)
class DonationAddress(db.Model): address = db.Column(db.String, primary_key=True) lastseen = db.Column(db.DateTime)
class Email(db.Model): id = db.Column(db.Integer, primary_key=True) satoshi_id = db.Column(db.Integer) 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)