class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) def get_reset_token(self, expires_sec=1800): s = Serializer(app.config['SECRET_KEY'], expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except: return None return User.query.get(user_id) def __repr__(self): return "User( {}, {}, {} )".format(self.email, self.username, self.image_file)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) def __repr__(self): return "User( {}, {}, {} )".format(self.email, self.username, self.image_file)
class UserDetails(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) profile = db.relationship('UserProfile', backref='details', uselist=False) def __repr__(self): return '<User: %r>' % self.username
class UserProfile(db.Model): id = db.Column(db.Integer, primary_key=True) business = db.Column(db.Float, nullable=False) entertainment = db.Column(db.Float, nullable=False) health = db.Column(db.Float, nullable=False) science = db.Column(db.Float, nullable=False) sports = db.Column(db.Float, nullable=False) technology = db.Column(db.Float, nullable=False) userId = db.Column(db.Integer, db.ForeignKey('user_details.id'), nullable=False) def __repr__(self): return '<Id %r>' % self.userId
class ArticleDetails(db.Model): articleId = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255), nullable=False) discription = db.Column(db.String(512), nullable=False) imageurl = db.Column(db.String(255), nullable=False) url = db.Column(db.String(255), nullable=False) score = db.Column(db.Float, nullable=False) publishedAt = db.Column(db.DateTime, nullable=False) category = db.Column(db.String(50), nullable=False) profile = db.relationship('ArticleProfile', backref='details', uselist=False) def __repr__(self): return '<Title %r>' % self.title