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)}')