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())
def __repr__(self):