class ProductModels(db.Model): __tablename__ = 'Product' id = db.Column(db.Integer, primary_key=True) id_category = db.Column(db.Integer) id_company = db.Column(db.Integer) name = db.Column(db.String(250), index=True, unique=True) description = db.Column(db.String(500)) image = db.Column(db.String(500)) id_cloudinary = db.Column(db.String(500)) id_imagekit = db.Column(db.String(500)) stock = db.Column(db.Integer) price = db.Column(db.Integer) def __init__(self, id_category, id_company, name, description, image, id_cloudinary, id_imagekit, stock, price): self.id_category = id_category self.id_company = id_company self.id_imagekit = id_imagekit self.name = name self.description = description self.image = image self.id_cloudinary = id_cloudinary self.stock = stock self.price = price
class User(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) nickname = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) def __repr__(self): return '<User %r>' % (self.nickname)
class Conversations(db.Model): __tablename__ = 'conversations' cookie = db.Column(db.String(1024), primary_key=True) currentBernard = db.Column(db.String(1024)) currentRobert = db.Column(db.String(1024)) currentJacques = db.Column(db.String(1024)) def __repr__(self): return '<Cookie %r>' % (self.cookie)
class Service(db.Model): __tablename__ = "Service" id = db.Column(db.Integer, primary_key=True) type = db.Column(db.String(50)) desc = db.Column(db.String(50)) fee = db.Column(db.FLOAT) def __init__(self, type, desc, fee): self.type = type self.desc = desc self.fee = fee
class UsersModel(db.Model): __tablename__ = 'Users' id = db.Column(db.Integer, primary_key=True) id_company = db.Column(db.Integer) name = db.Column(db.String(60), index=True, unique=True) email = db.Column(db.String(60), index=True, unique=True) address = db.Column(db.String(500)) password = db.Column(db.String(128)) no_telp = db.Column(db.String(15)) user_role_id = db.Column(db.Integer) token = db.Column(db.String(500)) status = db.Column(db.String(50)) code_activated = db.Column(db.String(50)) def __init__(self, name, email,no_telp, password, user_role_id,token, id_company, address, status,code_activated): self.name = name self.no_telp = no_telp self.email = email self.password = password self.user_role_id = user_role_id self.token = token self.id_company = id_company self.address = address self.status = status self.code_activated = code_activated
class Post(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(128), nullable=False) content = db.Column(db.Text, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) image_path = db.Column(db.String(128), nullable=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) user = db.relationship('User', backref=db.backref('posts', lazy=True)) def __repr__(self): return '<post {}>'.format(self.title)
class Card(db.Model): __tablename__ = "Card" id = db.Column(db.Integer, primary_key=True) owner_id = db.Column(db.Integer, db.ForeignKey('User.id'), nullable=False) owner = db.relationship('User', backref=db.backref('cards', lazy=True), foreign_keys=[owner_id]) card_num = db.Column(db.String(16)) bank = db.Column(db.String(5)) def __init__(self, owner, card_num, bank): self.owner = owner self.card_num = card_num self.bank = bank
class ApptTimeSlot(db.Model): __tablename__ = "ApptTimeSlot" id = db.Column(db.Integer, primary_key=True) slot = db.Column(db.String(5)) def __init__(self, slot): self.slot = slot
class Appt(db.Model): __tablename__ = "Appt" id = db.Column(db.Integer, primary_key=True) owner_id = db.Column(db.Integer, db.ForeignKey('User.id'), nullable=False) owner = db.relationship('User', backref=db.backref('appts', lazy=True), foreign_keys=[owner_id]) pet_id = db.Column(db.Integer, db.ForeignKey('Pet.id'), nullable=False) pet = db.relationship('Pet', backref=db.backref('appts', lazy=True), foreign_keys=[pet_id]) appt_date = db.Column(db.DATE) appt_timeslot_id = db.Column(db.Integer, db.ForeignKey('ApptTimeSlot.id'), nullable=False) appt_timeslot = db.relationship('ApptTimeSlot', backref=db.backref('appt', lazy=True), foreign_keys=[appt_timeslot_id]) status = db.Column(db.String(10), default="Submitted") update_date = db.Column(db.DATE, default=datetime.now) def __init__(self, owner_id, pet_id, appt_date, appt_timeslot_id): self.owner_id = owner_id self.pet_id = pet_id self.appt_date = appt_date self.appt_timeslot_id = appt_timeslot_id
class CategoryModels(db.Model): __tablename__ = 'Category' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(250), index=True, unique=True) def __init__(self, name): self.name = name
class AuthorityModels(db.Model): __tablename__ = 'Authority' id = db.Column(db.Integer, primary_key=True) name_authority = db.Column(db.String(250)) def __init__(self, name_authority): self.name_authority = name_authority
class ProductModels(db.Model): __tablename__ = 'Product' id = db.Column(db.Integer, primary_key=True) category_id = db.Column(db.Integer) name = db.Column(db.String(250), index=True, unique=True) description = db.Column(db.String(500)) image = db.Column(db.String(500)) stock = db.Column(db.Integer) price = db.Column(db.Integer) def __init__(self, category_id, name, description, image, stock, price): self.category_id = category_id self.name = name self.description = description self.image = image self.stock = stock self.price = price
class User(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(128), nullable=False, unique=True, ) password = db.Column(db.String(128), nullable=False) email = db.Column(db.String(128), nullable=True) role = db.Column(db.String, default='user') is_active = db.Column(db.Boolean, nullable=False, default=False) @staticmethod def generate_hash(password): return sha256.hash(password) @staticmethod def verify_hash(password, hash): return sha256.verify(password, hash) def __repr__(self): return '<user {}>'.format(self.username)
class UsersRoleModels(db.Model): __tablename__ = 'Users_role' id = db.Column(db.Integer, primary_key=True) name_user_role = db.Column(db.String(250)) authorities = db.Column(db.Integer) def __init__(self, name_user_role, authorities): self.name_user_role = name_user_role self.authorities = authorities
class Pet(db.Model): __tablename__ = "Pet" id = db.Column(db.Integer, primary_key=True) owner_id = db.Column(db.Integer, db.ForeignKey('User.id'), nullable=False) owner = db.relationship('User', backref=db.backref('pets', lazy=True), foreign_keys=[owner_id]) name = db.Column(db.String(20)) breed = db.Column(db.String(20)) gender = db.Column(db.CHAR(1)) dob = db.Column(db.DATE, default=datetime.now) def __init__(self, owner, name, breed, gender, dob): self.owner = owner self.name = name self.breed = breed self.gender = gender self.dob = dob
class UsersModel(db.Model): __tablename__ = 'Users' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60), index=True, unique=True) email = db.Column(db.String(60), index=True, unique=True) password = db.Column(db.String(128)) status = db.Column(db.Boolean, default=False) position = db.Column(db.String(200)) role_id = db.Column(db.Integer) token = db.Column(db.String(500)) def __init__(self, name, email, password, status, position, role_id, token): self.name = name self.email = email self.password = password self.status = status self.position = position self.role_id = role_id self.token = token
class Address(db.Model): __tablename__ = 'Address' id = db.Column(db.Integer, primary_key=True) city = db.Column(db.String(20)) street = db.Column(db.String(50)) post_code = db.Column(db.INTEGER) def __init__(self, city, street, post_code): self.city = city self.street = street self.post_code = post_code def __str__(self): return "{street},{city},{post}".format(street=self.street, city=self.city, post=self.post_code) def to_html(self): return "{street}</br>{city}</br>{post}".format(street=self.street, city=self.city, post=self.post_code)
class TransactionModels(db.Model): __tablename__ = 'Transaction' id = db.Column(db.Integer, primary_key=True) id_company = db.Column(db.Integer) id_user_company = db.Column(db.Integer) id_user_buyer = db.Column(db.Integer) buyer_name = db.Column(db.String(250)) date_time = db.Column(db.TIMESTAMP(timezone=True)) amount_of_charge = db.Column(db.Float) def __init__(self, id_company, id_user_company, id_user_buyer, buyer_name, date_time, amount_of_charge): self.id_company = id_company self.id_user_company = id_user_company self.id_user_buyer = id_user_buyer self.buyer_name = buyer_name self.date_time = date_time self.amount_of_charge = amount_of_charge
class CompanyModels(db.Model): __tablename__ = 'Company' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(250)) address = db.Column(db.String(500)) no_telp = db.Column(db.BigInteger) facebook = db.Column(db.String(250)) instagram = db.Column(db.String(250)) email = db.Column(db.String(60), index=True, unique=True) website = db.Column(db.String(250)) def __init__(self, name, address, no_telp, facebook, instagram, email, website): self.name = name self.address = address self.no_telp = no_telp self.facebook = facebook self.instagram = instagram self.email = email self.website = website
class User(db.Model): __tablename__ = 'User' id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(20)) last_name = db.Column(db.String(20)) email = db.Column(db.String(50)) password = db.Column(db.String(50)) dob = db.Column(db.DATE, default=datetime.now) gender = db.Column(db.CHAR(1)) phone = db.Column(db.String(10)) home_number = db.Column(db.String(10)) work_number = db.Column(db.String(10)) address_id = db.Column(db.Integer, db.ForeignKey('Address.id'), nullable=False) address = db.relationship('Address') active = db.Column(db.BOOLEAN) admin = db.Column(db.BOOLEAN) register_date = db.Column(db.DATETIME, default=datetime.now) def __init__(self, email, password, first_name="first", last_name="last", dob=None, gender=None, phone="000000", home_number="000000", work_number="000000", address=None, active=True, admin=False, register_date=None): self.first_name = first_name self.last_name = last_name self.email = email self.password = password self.dob = dob self.gender = gender self.phone = phone self.home_number = home_number self.work_number = work_number self.address = address self.active = active self.admin = admin self.register_date = register_date def is_authenticated(self): return True def is_active(self): return self.active def is_anonymous(self): return False def get_id(self): return self.id def is_admin(self): return self.admin def __repr__(self): return '<User %r,%r>' % (self.first_name, self.last_name)