class Comments(db.Model):
__tablename__ = "comments"
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
post_id = db.Column(db.Integer, db.ForeignKey('post.id'),
nullable=False) # commentを１つだけ表示のため
comment = db.Column(db.String(1000), nullable=False)
created_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
class Comments(db.Model):
__tablename__ = 'comments'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
post_id = db.Column(db.Integer, db.ForeignKey('posts.id'), nullable=False)
comment = db.Column(db.String(280), nullable=False)
create_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
update_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
class Posts(db.Model):
__tablename__ = 'posts'
id = db.Column(db.Integer,primary_key=True)
user_id = db.Column(db.Integer,db.ForeignKey('users.id'),nullable=False)
title = db.Column(db.String(250),nullable=False)
content= db.Column(db.String(250),nullable=False)
likes = db.Column(db.String(250),nullable=False)
created_at = db.Column(db.DateTime,nullable=False,default=datetime.now)
updated_at = db.Column(db.DateTime,nullable=False,default=datetime.now,onupdate=datetime.now)
class Post(db.Model):
__tablename__ = "post"
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
comments = db.relationship('Comment', backref="post", lazy=True)
post = db.Column(db.String(1000), nullable=False)
created_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
class Friendships(db.Model):
__tablename__ = 'friendships'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer)
user_following_id = db.Column(db.Integer,
db.ForeignKey('users.id'),
nullable=False)
create_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
update_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
class Profile(db.Model):
__tablename__ = "profile"
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
first_name = db.Column(db.String(255), nullable=False)
last_name = db.Column(db.String(255), nullable=False)
address = db.Column(db.String(255), nullable=False)
occupation = db.Column(db.String(255), nullable=False)
birthday = db.Column(db.String(255), nullable=False)
skills = db.Column(db.String(255), nullable=False)
created_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
updated_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
class Posts(db.Model):
__tablename__ = 'posts'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
title = db.Column(db.String(30), nullable=False)
content = db.Column(db.String(280), nullable=False)
create_at = db.Column(db.DateTime, nullable=False, default=datetime.now)
update_at = db.Column(db.DateTime,
nullable=False,
default=datetime.now,
onupdate=datetime.now)
comments = db.relationship(('Comments'), backref="author", lazy=True)
# inherting db, creating the database table, creating modes
from pytweet.database import db
from datetime import datetime
from flask_login import UserMixin
followtable = db.Table(
'followtable',
db.Column('source_user_id',
db.Integer,
db.ForeignKey('users.id'),
index=True),
db.Column('target_user_id',
db.Integer,
db.ForeignKey('users.id'),
index=True),
db.UniqueConstraint('source_user_id',
'target_user_id',
name='unique_friendships'))
class User(db.Model, UserMixin
): # this UserMixin is for our login to keep the session data
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
password = db.Column(db.String(100), nullable=False)
email = db.Column(db.String(200), nullable=True)
bio = db.Column(db.String(280), nullable=True)
