SocialNetwork

1
import datetime
2
import sqlalchemy
3
from dateutil.relativedelta import relativedelta
4
from flask_login import UserMixin
5
from sqlalchemy import orm
6
from sqlalchemy_serializer import SerializerMixin
7
from werkzeug.security import generate_password_hash, check_password_hash
8
from pytils import dt
9

10
import humanize
11

12
from .db_session import SqlAlchemyBase
13

14

15
class Post(SqlAlchemyBase, SerializerMixin):
16
    __tablename__ = 'posts'
17

18
    id = sqlalchemy.Column(sqlalchemy.Integer,
19
                           primary_key=True, autoincrement=True)
20

21
    text = sqlalchemy.Column(sqlalchemy.String, nullable=False)
22
    created_date = sqlalchemy.Column(sqlalchemy.DateTime, default=datetime.datetime.now)
23

24
    user_id = sqlalchemy.Column(sqlalchemy.Integer,
25
                                sqlalchemy.ForeignKey("users.id"))
26
    user = orm.relation('User')
27

28
    likes = sqlalchemy.Column(sqlalchemy.Integer, default=0)
29

30
    def get_formatted_date(self):
31
        return humanize.naturaltime(datetime.datetime.now() - self.created_date)
32

33