app\models(1).py

from datetime import datetime
import hashlib
from werkzeug.security import generate_password_hash, check_password_hash
from itsdangerous import TimedJSONWebSignatureSerializer as Serializer
from flask import current_app
from flask_login import UserMixin, AnonymousUserMixin
from . import db, login_manager

class User(db.Model, UserMixin):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(64), unique=True, index=True)
    username = db.Column(db.String(64), unique=True, index=True)
    role_id = db.Column(db.Integer, db.ForeignKey('roles.id'))
    password_hash = db.Column(db.String(128))
    confirmed = db.Column(db.Boolean, default=False)
    about_me = db.Column(db.Text())
    member_since = db.Column(db.DateTime(), default=datetime.utcnow)
    last_seen = db.Column(db.DateTime(), default=datetime.utcnow)
    avatar_hash = db.Column(db.String(32))

@property
def password(self):
  	 raise AttributeError('password is not a readable attribute')

@password.setter
def password(self, password):
   	self.password_hash = generate_password_hash(password)

def verify_password(self, password):
    return check_password_hash(self.password_hash, password)

def generate_confirmation_token(self, expiration=3600):
   	s = Serializer(current_app.config['SECRET_KEY'], expiration)
   	return s.dumps({'confirm': self.id}).decode('utf-8')

def confirm(self, token):
  	s = Serializer(current_app.config['SECRET_KEY'])
   	try:
      		 data = s.loads(token.encode('utf-8'))
   	except:
       		return False
   	if data.get('confirm') != self.id:
       		return False
   	self.confirmed = True
   	db.session.add(self)
   	return True

def ping(self):
    self.last_seen = datetime.utcnow()
    db.session.add(self)

def gravatar_hash(self):
    return hashlib.md5(self.email.lower().encode('utf-8')).hexdigest()

def gravatar(self, size=100, default='identicon', rating='g'):
    url = 'https://secure.gravatar.com/avatar'
        hash = self.avatar_hash or self.gravatar_hash()
        return '{url}/{hash}?s={size}&d={default}&r={rating}'.format(
               url=url, hash=hash, size=size, default=default, rating=rating)

def __repr__(self):
   	return '<User %r>' % self.username

@login_manager.user_loader
def load_user(user_id):
	  return User.query.get(int(user_id))