class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(120), nullable=False)
image = db.Column(db.String(120))
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return '<User %r>' % self.username
class User(db.Model):
id = db.Column(db.Integer, primary_key = True, autoincrement = True)
username = db.Column(db.String(80), unique = True)
password = db.Column(db.String(32))
head_url = db.Column(db.String(256))
images = db.relationship('Image', backref='user', lazy='dynamic')
def __init__(self, username, password):
self.username = username
self.password = password
self.head_url = 'http://images.nowcoder.com/head/' + str(random.randint(0, 1000)) + 't.png'
def __repr__(self):
return '<User %d %s>' %(self.id, self.username)
class Linkpost(db.Model):
id = db.Column(db.Integer, primary_key=True)
linktitle = db.Column(db.String(100), nullable=False)
newdate_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
newcontent = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return "Linkpost('{self.linktitle}', '{self.newdate_posted}')"
class Comment(db.Model):
id = db.Column(db.Integer, primary_key = True, autoincrement = True)
content = db.Column(db.String(1024))
image_id = db.Column(db.Integer, db.ForeignKey('image.id'))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
status = db.Column(db.Integer, default = 0)
user = db.relationship('User')
def __init__(self, content, image_id, user_id):
self.content = content
self.image_id = image_id
self.user_id = user_id
def __repr__(self):
return '<Comment %d %s>' %(self.id, self.content)
class Image(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
url = db.Column(db.String(512))
created_date = db.Column(db.DateTime)
comments = db.relationship('Comment')
def __init__(self, url, user_id):
self.url = url
self.user_id = user_id
self.created_date = datetime.now()
def __repr__(self):
return '<Image %d %s>' %(self.id, self.url)