i& SSKJrJrJr SSKJrJr SSKJr SSK J r J r J r J r SSKJr SSKJr SSKJr SSKJr SS KJrJr SS KJrJr SS KJr SS KrSS KrSS K J!r! \"SSSS9r"\RF"SSSSSSS9r$\!"S5r%Sr&\"5r'\"\'54S\4Sjjr(S q)S q*S q+S q,Sr-Sr.Sr/S r0S!\1S"\ \14S#jr2S$\1S%\3S"\ \ \1\ 44S&jr4"S'S(\5r5"S)S*\5r6\"RoS+5S,5r8\"RoS-5\"\(54S.\14S/jj5r9\"RoS05\"\(54S1\1S.\14S2jj5r:\"RwS3\6S49\"\(54S5\5S.\14S6jj5r<\=S7:XaSS K>r>\>R~"S8S9S:S;S<9 g g )=)FastAPI HTTPExceptionDepends) HTTPBearerHTTPAuthorizationCredentials) BaseModel)ListDictAnyOptional) ChatOllama) SQLDatabase)Chroma)HuggingFaceEmbeddings) HumanMessage SystemMessage) create_enginetext)URLN)Pathz*Agriculture Chat-to-SQL API (Local Ollama)z7Text-to-SQL using local llama3.2:3b-instruct via Ollamaz0.1.1)title descriptionversionzpostgresql+psycopg2postgreszgQube1_#@96740z 139.59.87.82i8 four_s_india) drivernameusernamepasswordhostportdatabasezschema_chunks.jsonz"testing-2026-kolkata-llama-api-key credentialscVUR[:wa [SSS9eUR$)NizInvalid API Key status_codedetail)r"API_KEYr)r"s $/var/www/html/dynamic-report/main.pyverify_api_keyr)-s*')4EFF  " ""c8[c[[SS9q[$)NT) pool_pre_ping)enginerdb_urlr*r( get_enginer0;s ~vT: Mr*cB[c[[55q[$N)dbrr0r/r*r(get_dbr4As z  & Ir*c[c[R5(d [S5e[ [SSS9n[ R "U5nSSS5 WVs/sHo"SPM nnUVs/sHo"RS05PM nn[SS9n[R"UUUS S 9q[$!,(df  Ni=fs snfs snf) Nu2schema_chunks.json missing – run ingestion firstrzutf-8)encodingrmetadataz&sentence-transformers/all-MiniLM-L6-v2) model_nameagri_schema_local)texts embedding metadatascollection_name) vectorstoreSCHEMA_CHUNKS_PATHexists RuntimeErroropenjsonloadgetrr from_texts)fchunkscr;r= embeddingss r(get_vectorstorerLGs!((**ST T $cG <YYq\F=%++Fq6F+4:;FqUU:r*F ;*6^_ '' /  = <,;sB5C2C 5 Cc6[c [SSSSSS9q[$)Nzllama3.2:3b-instruct-q4_0giizhttp://localhost:11434)model temperaturenum_ctx num_predictbase_url)llmr r/r*r(get_llmrT]s' {--   Jr*rreturncUR"5n[R"SU[R[R-5nU(aUR S5R5$[R"SU[R[R-5nU(aUR S5R5$[R"SU[R[R-5nU(aWUR S5R5nUR 5RS5(aURS5S-$UR"5nUHMnUR5nUR 5RS5(dM9URS5S-s $ g)Nz```sql\s*(.*?)\s*```z```\s*(SELECT\s+.*?)\s*```z(SELECT\s+.*?)(?:\n{2,}|$|;)SELECT;) stripresearchDOTALL IGNORECASEgroupupper startswithrstrip splitlines)rmatchsqllineslinestrippeds r( extract_sqlrims> ::>  & &x 0 0??3'#- - r*remax_rowsc R[5R5nUR[U55n[ UR 55n/n[ U5H/upgXa:a O'UR[[XG555 M1 UsSSS5 $!,(df  g=fr2) r0connectexecuterlistkeys enumerateappenddictzip)rerjconnresultcolumnsrowsirows r(run_sqlrzsy    4d3i(v{{}%'FA} KKS./ 0(  s A5B B&c4\rSrSr%\\S'Sr\\\S'Sr g) QueryRequestquestionrjr/N) __name__ __module__ __qualname____firstlineno__str__annotations__rjr int__static_attributes__r/r*r(r|r|sM!Hhsm!r*r|c\rSrSr%\\S'Sr\\\S'Sr\\ \ \\ 4\S'Sr \\ \S'Sr\\\S'Sr\\\S'S rg) QueryResponser~N generated_sqlrw row_countnatural_answererrorr/)rrrrrrrr rwr r r rrrrrr/r*r(rrs[M#'M8C='+/D(4S#X' (/#Ix}#$(NHSM(E8C=r*rz/healthc# SSS.$7f)Nokz ollama-llama3.2:3b-instruct-q4_0)statusrSr/r/r*r(healthrs#E FFsz/tables_cT# [[5R55nSU0$7f)Ntables)sortedr4get_usable_table_names)rrs r( list_tablesrs% FH335 6F f s&(z/table/{table_name} table_namecF# [5RU/5nXS.$7f)N)tableinfo)r4get_table_info_no_throw)rrrs r(get_table_infors" 8 + +ZL 9D ..s!z/query)response_modelreqc ,# [5RURSS9nSRSU55nSnX4- nSnSUSURS 3n[ 5R [ US 9[US 9/5nURR5n[U5n U (d8UR5RS 5(aURS 5S -n U (d[URUS S9$[XR 5n [URU U ['U 5S9$!["a+n [URU S[%U 53S9sSn A $Sn A ff=f!["an [)S[%U 5S9eSn A ff=f7f)N)kz c38# UHoRv M g7fr2) page_content).0ds r( ask..s;dnndsu SPECIAL RULE FOR STATE: Column 'state' is character varying(255) → string/text. ALWAYS use quotes: state = 'West Bengal' or state = '4' (never state = 4 without quotes). Do NOT use numeric comparison without CAST or quotes.uYou are a strict PostgreSQL SQL generator. Output ONLY the SQL query — nothing else. No explanation, no markdown, no code blocks, no text before or after the SQL. STRICT RULES - YOU MUST FOLLOW: - Use ONLY tables that appear EXACTLY in the schema context below. - NEVER invent or use tables like 'farmer_csv_records', 'users_csv', or any name not listed. - If no suitable table exists → output exactly: INSUFFICIENT SCHEMA - For counting farmers → MUST use 'upload_farmer' or 'agri_users' tables. - Column 'state' is string → always use quotes: 'West Bengal' or '4' - Use COUNT(*) for row counts - End every query with semicolon ; - Never INSERT, UPDATE, DELETE, DROPzSchema context: z Question: z SQL query:)contentrXrYz@Model did not produce valid SQL. Try rephrasing or check schema.)r~rrzSQL execution failed: )r~rr)r~rrwrir$)rLsimilarity_searchr~joinrTinvokerrrrZrir`rarbrrzrj Exceptionrlenr) rrdocscontext state_hint system_prompt user_promptresponse raw_outputrerwexes r(askrsL< 223<<12E++;d;; D   (   <<.  9## - 0  -%   %%++- *%z'')44X>>##C(3.C )X  3 -D\\$i     !.s2wi8   <CF;;rs43E,,'537?*!  6I  $      ./ . <?Fx?P# <#      ,  chsmB   T#s(^(< "9" I GG&~6 3:>3J/S/S/ /(=1*1.*AM<<M