class Country(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
alpha_2 = db.Column(db.String(5), nullable=False)
alpha_3 = db.Column(db.String(5), nullable=False)
name = db.Column(db.String(50), nullable=False)
numeric = db.Column(db.String(10), nullable=False)
official_name = db.Column(db.String(100), nullable=True)
class Requestion(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
book_name = db.Column(db.String(20), nullable=False)
author_name = db.Column(db.String(20), unique=True, nullable=False)
book_dept = db.Column(db.String(20), nullable=False)
book_implementation = db.Column(db.String(500), nullable=False)
class Cart(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
book_name = db.Column(db.String(100), nullable=False)
author_name = db.Column(db.String(20), unique=True, nullable=False)
book_dept = db.Column(db.String(20), nullable=False)
isbn_number = db.Column(db.String(20), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='defaultbook.jpg')
username = db.Column(db.String(20), nullable=False)
typeofmembership = db.Column(db.String(20), nullable=False)
no_of_copies = db.Column(db.Integer, nullable=False)
first_name = db.Column(db.String(20), nullable=False)
class Books(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
book_name = db.Column(db.String(100), nullable=False)
author_name = db.Column(db.String(30), nullable=False)
book_dept = db.Column(db.String(20), nullable=False)
book_cost = db.Column(db.String(20), nullable=False)
book_des = db.Column(db.String(10000), nullable=False)
year_published = db.Column(db.String(20), nullable=False)
book_pub = db.Column(db.String(50), nullable=False)
isbn_number = db.Column(db.String(20), unique=True, nullable=False)
image_file = db.Column(db.String(20),
nullable=False,
default='defaultbook.jpg')
no_of_pages = db.Column(db.Integer, nullable=False)
no_of_copies = db.Column(db.Integer, nullable=False)
no_ofCopies = db.Column(db.Integer, nullable=False)
floor_no = db.Column(db.Integer, nullable=False)
rack_no = db.Column(db.Integer, nullable=False)
shelf_no = db.Column(db.Integer, nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.now())
'''def __init__(self,book_name,author_name,book_dept,
class BorrowBook(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), nullable=False)
book_name = db.Column(db.String(100), nullable=False)
author_name = db.Column(db.String(20), nullable=False)
book_dept = db.Column(db.String(20), nullable=False)
isbn_number = db.Column(db.String(20), unique=True, nullable=False)
borrow_time = db.Column(db.DateTime,
nullable=False,
default=datetime.now())
renew_time = db.Column(db.DateTime,
nullable=False,
default=datetime.now() + timedelta(minutes=5))
image_file = db.Column(db.String(20),
nullable=False,
default='defaultbook.jpg')
fine = db.Column(db.Integer, nullable=False, default=0)
class Users(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(20), nullable=False)
last_name = db.Column(db.String(20), nullable=False)
date_of_birth = db.Column(db.String(10), nullable=False)
door_no = db.Column(db.String(3), nullable=False)
street_name = db.Column(db.String(70), nullable=False)
area_name = db.Column(db.String(20), nullable=False)
country = db.Column(db.String(20), nullable=False)
state = db.Column(db.String(20), nullable=False)
postal_code = db.Column(db.String(7), nullable=False)
mobile_number = db.Column(db.String(14), nullable=False)
username = db.Column(db.String(20), unique=True, nullable=False)
typeofmembership = db.Column(db.String(20),
nullable=False,
default='LibrarianAccount')
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)
security = db.Column(db.String(20), nullable=False)
Account_type = db.Column(db.String(20), nullable=False)
def get_reset_token(self, expires_sec=1800):
s = Serializer(webapp.config['SECRET_KEY'], expires_sec)
return s.dumps({str(id): self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(user_id):
s = Serializer(webapp.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
'''def __init__(self,first_name,last_name,date_of_birth,door_no,street_name,