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 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 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 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 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,