def __get_data_direct(self,
sp_name,
params: ParamsObject,
is_cacheable=True,
cache_key_prefix="",
is_multiple_rs=False):
data = None
if params is None:
params = []
if is_multiple_rs:
data = self.normal_repo.get_direct_multiple(
sp_name, params.get_params_list())
else:
data = self.normal_repo.get_direct(sp_name,
params.get_params_list())
return data
def __add_update_delete_direct(self,
sp_name,
params: ParamsObject,
flag="ADD"):
data = None
if flag == "ADD":
data = self.normal_repo.add_direct(sp_name,
params.get_params_list())
elif flag == "UPDATE":
data = self.normal_repo.update_direct(sp_name,
params.get_params_list())
elif flag == "DELETE":
data = self.normal_repo.delete_direct(sp_name,
params.get_params_list())
else:
pass
return data
def get_cache_key(self, object, params: ParamsObject):
try:
params_list = params.get_params_list()
prefix = ""
if object != "" and object is not None:
prefix = object
key = ''.join(str(e) if e is not None else "" for e in params_list)
return prefix + ':' + key
except Exception as ex:
pass
def __add_update_delete_direct_transactional(self,
sp_name,
params: ParamsObject,
flag="ADD"):
data = None
self.begin_transaction()
if flag == "ADD":
data = self.transaction_repo.add_direct(sp_name,
params.get_params_list())
elif flag == "UPDATE":
data = self.transaction_repo.update_direct(
sp_name, params.get_params_list())
elif flag == "DELETE":
data = self.transaction_repo.delete_direct(
sp_name, params.get_params_list())
else:
pass
self.commit()
return data
def get_data_list_object_any_paginated(self, sp_name, params: ParamsObject):
"""
:description: This method allows user to get the data list object for any procedure which always returns the model object with pagination
:param sp_name: Procedure name to call
:param params: list of parameters
:return: List of model object
"""
if base.DEBUG_ENABLED:
LoggingHelper().log_debug(self.__class__, "", params)
try:
self.get_cursor(db_type="R").callproc(sp_name, params.get_params_list())
list_cursor_object = self.data_as_cursor_list_multiple_rs()
return self.post_get_data_list_object_paginated(list_cursor_object)
except Exception as ex:
if base.DEBUG_ENABLED:
LoggingHelper().log_error(self.__class__, "", str(ex))
if isinstance(ex, DatabaseException) or isinstance(ex, KaroException):
raise DatabaseException(self.db_error_code, ex.error_message, self.data)
else:
raise DatabaseException(self.db_error_code, str(ex), self.data)
finally:
self.close_cursor()
if base.DEBUG_ENABLED:
LoggingHelper().log_debug(self.__class__, "", self.data)
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sBSSubjectDtlObjectGetList"
self.params_list = params.get_params_list()
def get_products_by_search(self, params: ParamsObject):
return self.get_direct_multiple("sGetProductBySearch",
params.get_params_list())
def get_products_by_subcategory(self, params: ParamsObject):
return self.get_direct_multiple("sGetProductBySubCategory",
params.get_params_list())
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sProductObjectGetList"
self.params_list = params.get_params_list()
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sUniversityObjectGetList"
self.params_list = params.get_params_list()
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sStudentAYObjectGetList"
self.params_list = params.get_params_list()
def customer_authentication(self, params: ParamsObject):
# return params.get_params_list()
return self.get_direct("sCustomerAuthenticate",
params.get_params_list())
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sCustomerAddressObjectGetList"
self.params_list = params.get_params_list()
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sCollegeBranchObjectGetList"
self.params_list = params.get_params_list()
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sSubCategoryObjectGetList"
self.params_list = params.get_params_list()
def pre_get_list_object(self, params: ParamsObject):
self.sp_name = "sOrderItemObjectGetList"
self.params_list = params.get_params_list()