class rental_info(db.Model):
id = db.Column(db.Integer, primary_key=True)
movie = db.Column(db.Integer, db.ForeignKey('movies.id'))
rented_by = db.Column(db.Integer,db.ForeignKey('user_v2.id'))
rented_to_date = db.Column(db.DateTime, nullable=False, default=False)
class Tweet(db.Model):
id = db.Column(db.Integer, primary_key=True)
tweet = db.Column(db.String(250), index=True)
timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user_v2.id'))
def __repr__(self):
return '<Tweet {}>'.format(self.tweet)
def reference_col(tablename, nullable=False, pk_name='id', **kwargs):
"""Column that adds primary key foreign key reference.
Usage: ::
category_id = reference_col('category')
category = relationship('Category', backref='categories')
"""
return db.Column(db.ForeignKey('{0}.{1}'.format(tablename, pk_name)),
nullable=nullable,
**kwargs)
class Survey(db.Model):
__table__ = 'survey'
id = db.Column(db.Integer, primary_key=True, index=True)
description = db.Column(db.String(250), index=True)
startdate = db.Column(db.DateTime)
enddate = db.Column(db.DateTime)
status = db.Column(db.Boolean, default=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
questions = db.relationship('Question',
backref='questions',
lazy='dynamic')
response = db.Column(db.String(250), index=True)
def __repr__(self):
return "<Survey {}".format(self.description)
class TokenBlocklist(db.Model):
"""Blocklist representation"""
id = db.Column(db.Integer, primary_key=True)
jti = db.Column(db.String(36), nullable=False, unique=True)
token_type = db.Column(db.String(10), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False)
revoked = db.Column(db.Boolean, nullable=False)
expires = db.Column(db.DateTime, nullable=False)
user = db.relationship("User", lazy="joined")
def to_dict(self):
return {
"token_id": self.id,
"jti": self.jti,
"token_type": self.token_type,
"user_identity": self.user_identity,
"revoked": self.revoked,
"expires": self.expires,
}
class TokenBlacklist(db.Model):
"""Blacklist representation
"""
id = db.Column(db.Integer, primary_key=True)
jti = db.Column(db.String(36), nullable=False, unique=True)
token_type = db.Column(db.String(10), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
revoked = db.Column(db.Boolean, nullable=False)
expires = db.Column(db.DateTime, nullable=False)
user = db.relationship('User', lazy='joined')
def to_dict(self):
return {
'token_id': self.id,
'jti': self.jti,
'token_type': self.token_type,
'user_identity': self.user_identity,
'revoked': self.revoked,
'expires': self.expires
}
from myapi.extensions import db, pwd_context
# from .tweet import Tweet
followers = db.Table(
'followers',
db.Column('follower_id', db.Integer, db.ForeignKey('user_v2.id')),
db.Column('followed_id', db.Integer, db.ForeignKey('user_v2.id')))
class User(db.Model):
"""Basic user model
"""
__tablename__ = "user_v2"
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(80), unique=True, nullable=False)
password = db.Column(db.String(255), nullable=False)
tweets = db.relationship('Tweet', backref='tweet_user', lazy='dynamic')
followed = db.relationship('User',
secondary=followers,
primaryjoin=(followers.c.follower_id == id),
secondaryjoin=(followers.c.followed_id == id),
backref=db.backref('follower', lazy='dynamic'),
lazy='dynamic')
active = db.Column(db.Boolean, default=False)
def __init__(self, **kwargs):
super(User, self).__init__(**kwargs)
self.password = pwd_context.hash(self.password)
class Answer(db.Model):
__table__ = 'answer'
id = db.Column(db.Integer, primary_key=True, index=True)
question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
answering = db.Column(db.String(250), index=True)
class OfferedAnswer(db.Model):
__table__ = 'offeredanswer'
id = db.Column(db.Integer, primary_key=True, index=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
response = db.Column(db.String(250), index=True)
class Question(db.Model):
__table__ = "question"
id = db.Column(db.Integer, primary_key=True, index=True)
survey_id = db.Column(db.Integer, db.ForeignKey('survey.id'))
question_type = db.Column(db.String(100), index=True)
question = db.Column(db.String(250), index=True)