o Jjg-@sddlmZddlmZmZmZmZmZmZm Z ddl m Z ddl m Z ddlmZddlmZmZddlmZmZerBddlmZdd d ZGdddeZGdddeZ  d d!ddZdS)") annotations) TYPE_CHECKINGAnyDictListOptional TypedDictUnion)BaseLanguageModel)StrOutputParser)BasePromptTemplate)RunnableRunnablePassthrough)PROMPT SQL_PROMPTS) SQLDatabasetextstrreturncCs|S)N)strip)rr[/var/www/html/zoom/venv/lib/python3.10/site-packages/langchain/chains/sql_database/query.py_stripsrc@seZdZUdZded<dS)SQLInputInput for a SQL Chain.rquestionN__name__ __module__ __qualname____doc____annotations__rrrrrs  rc@s"eZdZUdZded<ded<dS)SQLInputWithTablesrrrz List[str]table_names_to_useNrrrrrr"s  r"Nllmr dbrpromptOptional[BasePromptTemplate]kintBRunnable[Union[SQLInput, SQLInputWithTables, Dict[str, Any]], str]cs|dur|}n jtvrtj}nt}hd|jt|jr,td|jd|d|jvr8|jjd}ddfd dd }t j di|d dB|jt |d B|j d gdBt BtBS)a2 Create a chain that generates SQL queries. *Security Note*: This chain generates SQL queries for the given database. The SQLDatabase class provides a get_table_info method that can be used to get column information as well as sample data from the table. To mitigate risk of leaking sensitive data, limit permissions to read and scope to the tables that are needed. Optionally, use the SQLInputWithTables input type to specify which tables are allowed to be accessed. Control access to who can submit requests to this chain. See https://python.langchain.com/docs/security for more information. Args: llm: The language model to use. db: The SQLDatabase to generate the query for. prompt: The prompt to use. If none is provided, will choose one based on dialect. Defaults to None. See Prompt section below for more. k: The number of results per select statement to return. Defaults to 5. Returns: A chain that takes in a question and generates a SQL query that answers that question. Example: .. code-block:: python # pip install -U langchain langchain-community langchain-openai from langchain_openai import ChatOpenAI from langchain.chains import create_sql_query_chain from langchain_community.utilities import SQLDatabase db = SQLDatabase.from_uri("sqlite:///Chinook.db") llm = ChatOpenAI(model="gpt-3.5-turbo", temperature=0) chain = create_sql_query_chain(llm, db) response = chain.invoke({"question": "How many employees are there"}) Prompt: If no prompt is provided, a default prompt is selected based on the SQLDatabase dialect. If one is provided, it must support input variables: * input: The user question plus suffix " SQLQuery: " is passed here. * top_k: The number of results per select statement (the `k` argument to this function) is passed in here. * table_info: Table definitions and sample rows are passed in here. If the user specifies "table_names_to_use" when invoking chain, only those will be included. Otherwise, all tables are included. * dialect (optional): If dialect input variable is in prompt, the db dialect will be passed in here. Here's an example prompt: .. code-block:: python from langchain_core.prompts import PromptTemplate template = '''Given an input question, first create a syntactically correct {dialect} query to run, then look at the results of the query and return the answer. Use the following format: Question: "Question here" SQLQuery: "SQL Query to run" SQLResult: "Result of the SQLQuery" Answer: "Final answer here" Only use the following tables: {table_info}. Question: {input}''' prompt = PromptTemplate.from_template(template) N>inputtop_k table_infozhPrompt must have input variables: 'input', 'top_k', 'table_info'. Received prompt with input variables: z. Full prompt: dialect)r/cSs |ddS)Nrz SQLQuery: rxrrrs z(create_sql_query_chain..csj|ddS)Nr#) table_names)get_table_infogetr0r&rrr2s)r,r.cSsdd|DS)NcSsi|] \}}|dvr||qS))rr#r).0r)vrrr s z...)itemsr0rrrr2s)r-z SQLResult:)stopr)r/rr differenceinput_variableslistpartial_variables ValueErrorpartialrassignrbindr r)r%r&r'r) prompt_to_useinputsrr6rcreate_sql_query_chain!s@P       rF)rrrr)Nr$) r%r r&rr'r(r)r*rr+) __future__rtypingrrrrrrr langchain_core.language_modelsr langchain_core.output_parsersr langchain_core.promptsr langchain_core.runnablesr r$langchain.chains.sql_database.promptrr*langchain_community.utilities.sql_databaserrrr"rFrrrrs $