def get_limited_services(self, start_index, number_of_services):
query_sql = """ select * from tenant_service WHERE ID > 0 limit {0},{1}""".format(
str(start_index), str(number_of_services))
services = service_repo.get_services_by_raw_sql(query_sql)
return services
def get_services_counts(self):
query_count_sql = """select count(1) as num from tenant_service"""
count = service_repo.get_services_by_raw_sql(query_count_sql)
logger.debug(count)
return count