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())
