models.py

from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, sessionmaker
from sqlalchemy import create_engine
from passlib.apps import custom_app_context as pwd_context


Base = declarative_base()

class Restaurant(Base):
    __tablename__ = 'restaurant'

    name =Column(String(80), nullable = False)
    id = Column(Integer, primary_key = True)
    address = Column(String(80), nullable = False) 
    image = Column(String(80), nullable = False)

    @property
    def serialize(self):
    	return {
            'id': self.id,
    		'name': self.name,
    		'address': self.address,
            'image': self.image
    	}

class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    username = Column(String(32), index=True)
    picture = Column(String)
    email = Column(String, index=True)
    password_hash = Column(String(64))

    def hash_password(self, password):
        self.password_hash = pwd_context.encrypt(password)

    def verify_password(self, password):
        return pwd_context.verify(password, self.password_hash)

    def generate_auth_token(self, expiration=600):
        s = Serializer(secret_key, expires_in = expiration)
        return s.dumps({'id': self.id})

    @staticmethod
    def verify_auth_token(token):
        s=Serializer(secret_key)
        try:
            data = s.loads(token)
        except SignatureExpired:
            return None
        except BadSignature:
            return None
        user_id = data['id']
        return user_id


engine = create_engine('sqlite:///restaurants.db')
Base.metadata.create_all(engine)