class wishList(db.Model): #__tablename__ = 'wishlist' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), index=True) holder = db.Column(db.Integer, ForeignKey('users.id'), nullable=False) query = db.Query("wishList") def __init__(self, title, holder): self.title = title self.holder = holder def __repr__(self): return "Wishlist {}".format(self.title)
class Users(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80)) firstname = db.Column(db.String(80)) lastname = db.Column(db.String(80)) sex = db.Column(db.String(50)) email = db.Column(db.String(120), index=True, unique=True, nullable=False) password = db.Column(db.String(54), nullable=False) registered_on = db.Column(db.DateTime, nullable=False) image = db.Column(db.LargeBinary) query = db.Query("Users") def __init__(self, username, firstname, lastname, sex, email, password, registered_on, image): self.username = username self.firstname = firstname.title() self.lastname = lastname.title() self.sex = sex.upper() self.email = email.lower() self.password = bcrypt.generate_password_hash(password) self.registered_on = registered_on self.image = image def set_password(self, password): self.password = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password, password) def is_authenticated(self): return True def is_active(self): return True def is_anonymous(self): return False # def get_id(self): # try: # return unicode(self.id) # python 2 support # except NameError: # return str(self.id) # python 3 support def __repr__(self): return '<User {0}>'.format(self.email)
class WishL(db.Model): id = db.Column(db.Integer, primary_key=True) holder = db.Column(db.Integer, ForeignKey('users.id'), nullable=False) title = db.Column(db.String(64), index=True) description = db.Column(db.String, index=True) url = db.Column(db.String, index=True) list_id = db.Column(db.Integer, ForeignKey('wish_list.id'), nullable=False) query = db.Query("WishL") def __init__(self, holder, title, description, url, list_id): self.title = title self.description = description self.url = url self.holder = holder self.list_id = list_id def __repr__(self): return 'Wish {}'.format(self.title)