def add_role(self, role, app):
try:
RoleModel.insert({'name': role.name, 'state': role.state})
message = f'''Se agregó el role : {role.name} {role.state}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def all_business(self, app):
try:
business = BusinessModel.get()
result = {}
if business:
result = business.serialize()
return helper.handler_response(app, 201, 'Lista de Empresas', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_business(self, business_id, app):
try:
delete = BusinessModel.where('id', business_id).delete()
message = f'''No se encontró el business_id : {business_id}'''
if delete:
message = f'''Se eliminó el business_id : {business_id}'''
return helper.handler_response(app, 201, f'Buscar business_id: {business_id}', message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_product(self, pro_id, app):
try:
product = ProductModel.where('product_id', pro_id).first()
result = {}
if product:
result = product.serialize()
return helper.handler_response(app, 201, f'Buscar product_id: {pro_id}', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_user(self, users_id, app):
try:
user = UsersModel.where('id', users_id).first()
result = {}
if user:
result = user.serialize()
return helper.handler_response(app, 201, f'Buscar user_id: {users_id}', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def login(self, app, username, password):
try:
user_found = UsersModel.where_user(username).first()
if user_found and user_found.password_valid(password):
return helper.handler_response(app, 201, 'Logeado con exito')
message = f'El usuario y/o contraseña son incorrectas: {username}'
return helper.handler_response(app, 401, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_role(self, app):
try:
role = RoleModel.get()
result = {}
if role:
result = role.serialize()
return helper.handler_response(app, 201, 'Lista de Roles', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_business(self, business_id, app):
try:
business = BusinessModel.where('id', business_id).first()
result = {}
if business:
result = business.serialize()
return helper.handler_response(app, 201, f'Buscar user_id: {business_id}', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_product(self, app):
try:
product = ProductModel.get()
result = {}
if product:
result = product.serialize()
return helper.handler_response(app, 201, 'Lista de productos', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_factu(self, fact_id, app):
try:
factura = BillModel.where('bill_id', fact_id).delete()
message = f''' No se encontro la factura: {fact_id}'''
if factura > 0:
message = f''' Se elimino la factura: {fact_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_factu(self, app):
try:
factura = BillModel.get()
result = {}
if factura:
result = factura.serialize()
return helper.handler_response(app, 201, 'Lista de factura',
result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_product(self, pro_id, app):
try:
product = ProductModel.where('product_id', pro_id).delete()
message = f''' No se encontro el producto: {pro_id}'''
if product > 0:
message = f''' Se elimino el producto: {pro_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_pb(self, pb_id, app):
try:
pb = ProductBillModel.where('Product_bill_id', pb_id).delete()
message = f''' No se encontro el registro: {pb_id}'''
if pb > 0:
message = f''' Se elimino al registro: {pb_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_company(self, app):
try:
company = CompanyModel.get()
result = {}
if company:
result = company.serialize()
return helper.handler_response(app, 201, 'Lista de Companias',
result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_pivote(self, app):
piv_dic = {}
try:
piv = PivoteModel.get()
piv.load('company', 'role', 'users')
piv_dic = piv.serialize()
message = f''' Lista total del Pivote: RO_CO_US'''
return helper.handler_response(app, 201, message, piv_dic)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_role(self, rol_id, app):
try:
role = RoleModel.where('role_id', rol_id).delete()
message = f''' No se encontro el rol: {rol_id}'''
if role > 0:
message = f''' Se elimino el rol: {rol_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_pb(self, app):
pb_dic = {}
try:
pb = ProductBillModel.get()
pb.load('product_id', 'bill_id')
pb_dic = pb.serialize()
message = f''' Lista total del Pivote: RO_CO_US'''
return helper.handler_response(app, 201, message, pb_dic)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_users(self, user_id, app):
try:
user = UsersModel.where('users_id', user_id).delete()
message = f''' No se encontro el usuario: {user_id}'''
if user > 0:
message = f''' Se elimino al usuario: {user_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_role(self, rol_id, app):
try:
role = RoleModel.where('role_id', rol_id).first()
result = {}
if role:
result = role.serialize()
return helper.handler_response(app, 201,
f'Buscar rol_id: {rol_id}', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_company(self, comp_id, app):
try:
company = CompanyModel.where('company_id', comp_id).delete()
message = f''' No se encontro la Compania: {comp_id}'''
if company > 0:
message = f''' Se elimino la compania: {comp_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def viewAll_user(self, app):
try:
user = UsersModel.get()
result = {}
if user:
result = user.serialize()
return helper.handler_response(app, 201, 'Lista de Usuarios',
result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_pivote(self, piv_id, app):
try:
pivote = PivoteModel.where('ro_co_us_id', piv_id).delete()
message = f''' No se encontro el registro: {piv_id}'''
if pivote > 0:
message = f''' Se elimino al registro: {piv_id}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_pb(self, pb_id, app):
try:
pb = ProductBillModel\
.where('Product_bill_id', pb_id).first()
result = {}
if pb:
result = pb.serialize()
return helper.handler_response(app, 201, f'Buscar piv_id: {pb_id}',
result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_role(self, role_id, app):
try:
delete = RoleModel.where('id', role_id).delete()
message = f'''No se encontró el role_id : {role_id}'''
if delete:
message = f'''Se eliminó el role_id : {role_id}'''
return helper.handler_response(app, 201,
f'Buscar role i_id: {role_id}',
message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_company(self, comp_id, app):
try:
company = CompanyModel.where('company_id', comp_id).first()
result = {}
if company:
result = company.serialize()
return helper.handler_response(app, 201,
f'Buscar company_id: {comp_id}',
result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def delete_user(self, user_id, app):
try:
delete = UserModel.where('id', user_id).delete()
message = f'''No se encontró el user_id : {user_id}'''
if delete:
message = f'''Se eliminó el user_id : {user_id}'''
return helper.handler_response(app, 201,
f'Buscar user i_id: {user_id}',
message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_factu(self, fact_id, app):
try:
factura = BillModel.where('bill_id', fact_id).first()
result = {}
if factura:
result = factura.serialize()
return helper.handler_response(app, 201,
f'Buscar factura_id: {fact_id}',
result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def find_pivote(self, piv_id, app):
try:
piv = PivoteModel\
.where('ro_co_us_id', piv_id).first()
result = {}
if piv:
result = piv.serialize()
return helper.handler_response(app, 201,
f'Buscar piv_id: {piv_id}', result)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def add_business(self, business, app):
try:
BusinessModel.insert({
'name': business.name,
'ruc': business.ruc,
'address': business.address
})
message = f'''Se agregó la empresa : {business.name} {business.ruc}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
def add_user(self, user, app):
try:
UserModel.insert({
'name': user.name,
'last_name': user.last_name,
'age': user.age
})
message = f'''Se agregó el usuario : {user.name} {user.last_name}'''
print(message)
return helper.handler_response(app, 201, message)
except Exception as e:
return helper.handler_response(app, 500, f'{str(e)}')
