Python SqlHelper._get_rand_tableno示例

示例#1

def _search_nutrients_by_fdcid(connection, fdc_id):
    script = []
    rand_id = SqlHelper._get_rand_tableno()
    for l in sql_script_nutrition_list_for_fdcid:
        script.append(l.format(rand_id, fdc_id))
    result_index = 1

    return _get_nutrient_list(connection.queries(script, result_index))

示例#2

def _search_foods_by_nutrient(connection, nutrient, food_name):
    script = []
    rand_id = SqlHelper._get_rand_tableno()
    for l in sql_script_food_descr_nutrient:
        script.append(l.format(rand_id, nutrient, food_name, 'ASC'))
    result_index = 1

    return connection.queries(script, result_index)