class ResearchDoc(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String()) author = db.relationship('Author', secondary=researchauthors, backref=db.backref('researchdocs', lazy='dynamic')) date = db.Column(db.String()) slug = db.Column(db.String()) formats = db.relationship('Format', secondary=researchformats, backref=db.backref('researchdocs', lazy='dynamic')) categories = db.relationship('Category', secondary=researchcategories, backref=db.backref('researchdocs', lazy='dynamic')) doctype = db.Column(db.String()) external = db.Column(db.String()) lit_id = db.Column(db.Integer) def __repr__(self): return '<ResearchDoc %r>' % (self.title) @property def authors_string(self): return get_authors_string(self)
class Doc(db.Model): id = db.Column(db.Integer, primary_key = True) title = db.Column(db.String()) author = db.relationship('Author', secondary = authors, backref=db.backref('docs', lazy='dynamic')) date = db.Column(db.String()) slug = db.Column(db.String()) formats = db.relationship('Format', secondary = formats, backref=db.backref('docs', lazy='dynamic')) categories = db.relationship('Category', secondary = categories, backref=db.backref('docs', lazy='dynamic')) doctype = db.Column(db.String()) def __repr__(self): return '<Doc %r>' % (self.title)
class BlogSeries(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String()) slug = db.Column(db.String()) blogposts = db.relationship("BlogPost", backref=db.backref('series')) def __str__(self): return self.title def __repr__(self): return '<BlogSeries %r>' % (self.title)
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) slug = db.Column(db.String()) excerpt = db.Column(db.String()) def __repr__(self): return '<BlogPost %r>' % (self.title)
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 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 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)