class UserLikeAsso(db.Model):
__tablename__ = 'user_like_asso'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer)
object_id = db.Column(db.Integer)
atype = db.Column(db.String(20))
date_create = db.Column(db.DateTime, default=datetime.now)
class UserFollowAsso(db.Model):
__tablename__ = 'user_follow_asso'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer)
user_id_to = db.Column(db.Integer)
date_create = db.Column(db.DateTime, default=datetime.now)
class Comment(db.Model):
__tablename__ = 'comment'
id = db.Column(db.Integer, primary_key=True)
post_id = db.Column(db.Integer)
author_id = db.Column(db.Integer)
content = db.Column(db.String(1000))
date_create = db.Column(db.DateTime, default=datetime.now)
@cached_property
def json(self):
return dict(id=self.id,
post_id=self.post_id,
author_id=self.author_id,
content=self.content,
date_create=self.date_create)
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50), unique=True)
email = db.Column(db.String(50), unique=True)
password = db.Column(db.String(100))
pic_small = db.Column(db.String(100))
pic_big = db.Column(db.String(100))
gender = db.Column(db.Boolean)
date_create = db.Column(db.DateTime, default=datetime.now)
date_update = db.Column(db.DateTime, default=datetime.now)
@cached_property
def json(self):
return dict(id=self.id,
username=self.username,
email=self.email,
pic_small=self.pic_small,
pic_big=self.pic_big,
date_create=self.date_create,
date_update=self.date_update)
class Action(db.Model):
__tablename__ = 'action'
id = db.Column(db.Integer, primary_key=True)
post_id = db.Column(db.Integer)
author_id = db.Column(db.Integer)
atype = db.Column(db.String(20))
payload = db.Column(db.String(1000))
date_create = db.Column(db.DateTime, default=datetime.now)
@cached_property
def json(self):
return dict(id=self.id,
post_id=self.post_id,
author_id=self.author_id,
atype=self.atype,
payload=self.payload,
date_create=self.date_create)
class Item(db.Model):
__tablename__ = 'item'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(300))
content = db.Column(db.Text())
author_id = db.Column(db.Integer)
atype = db.Column(db.String(20))
url = db.Column(db.String(300))
post_id = db.Column(db.Integer, index=True)
show = db.Column(db.Boolean, default=True, index=True)
status = db.Column(db.String(20))
liked_by = db.Column(ARRAY(db.Integer, mutable=True), default=[])
date_create = db.Column(db.DateTime, default=datetime.now)
date_update = db.Column(db.DateTime, default=datetime.now)
@cached_property
def json(self):
return dict(id=self.id,
title=self.title,
content=self.content,
author_id=self.author_id,
atype=self.atype,
url=self.url,
post_id=self.post_id,
show=self.show,
status=self.status,
liked_by=self.liked_by,
date_create=self.date_create,
date_update=self.date_create)
class Post(db.Model):
__tablename__ = 'post'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(300))
content = db.Column(db.Text())
pic_small = db.Column(db.String(255))
pic_big = db.Column(db.String(255))
author_id = db.Column(db.Integer, db.ForeignKey(User.id), index=True)
show = db.Column(db.Boolean, index=True)
recommended = db.Column(db.Boolean, default=False, index=True)
visite_count = db.Column(db.Integer, default=0)
liked_by = db.Column(ARRAY(db.Integer, mutable=True), default=[])
date_create = db.Column(db.DateTime, default=datetime.now)
date_update = db.Column(db.DateTime, default=datetime.now)
author = db.relation(User, innerjoin=True, lazy="joined")
@cached_property
def json(self):
return dict(id=self.id,
title=self.title,
content=self.content,
pic_big=self.pic_big,
pic_small=self.pic_small,
author_id=self.author_id,
show=self.show,
recommended=self.recommended,
visite_count=self.visite_count,
liked_by=self.liked_by,
date_create=self.date_create,
date_update=self.date_update)