def nl2sql_lite_generate()

in dbai_src/app.py [0:0]

• 34 lines of code
• 2 McCabe index (conditional complexity)

def nl2sql_lite_generate():
    """
    Invokes the DBAI SQL Generator
    """
    question = request.json["question"]
    logger.info(f"DBAI engine for question : [{question}]")

    try:
        dbai_nl2sql = DBAI_nl2sql(
            proj_id=PROJECT_ID,
            dataset_id=DATASET_ID,
            tables_list=TABLES_LIST
        )
        dbai_response = dbai_nl2sql.get_sql(question)
        sql = dbai_response.generated_sql
        res_id = str(uuid.uuid4())

        logger.info(f"{res_id}\n DBAI response = {dbai_response}")

        results = dbai_response.sql_output
        sql_result = dbai_response.nl_output
        response_string = {
            "result_id": res_id,
            "generated_query": sql,
            "sql_exec_output": results,
            "sql_result": sql_result,
            "error_msg": ""
        }

    except Exception as e:  # pylint: disable=broad-except
        logger.error(
            f"DBAI SQL Generation unsuccessful: [{question}] {e}"
        )
        response_string = {
            "result_id": 0,
            "generated_query": "",
            "sql_exec_output": "",
            "sql_result": str(e),
            "error_msg": "Error in DBAI SQL generation",
        }

    return json.dumps(response_string)