class User(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
def __str__(self):
return '<User %r>' % self.username
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(
db.Integer,
db.ForeignKey('user.id'),
nullable=False,
index=True
)
title = db.Column(db.String(140), unique=True, nullable=False)
content = db.Column(db.String(3000), nullable=False)
date_created = db.Column(db.Date, default=date.today)
is_visible = db.Column(db.Boolean, default=True)
def __str__(self):
return '<Post %r>' % self.title