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)