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)
