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