o iA @s(ddlmZmZddlmZddZdS))requestjsonify)connect_to_databasec Cs&d}d}z}zt}|std|jdd}tjd}tjd}tjd}tjd}tjd}tjd }tjd }tjd } tjd } d } g} |dur^| d7} | ||durk| d7} | ||durx| d7} | ||dur| d7} | ||dur| d7} | ||dur| d7} | ||dur| d7} | || dur| d7} | | | rd| vrd| vr| d| 7} ntddddfWW|r| |r| SS| | | | } | s tddddfWW|r| |r | SSt| dd d!fWW|r| |r$| SStyR}z!tt |ddd"fWYd}~W|rE| |rM| SSd}~wt y}z$td#t |ddd"fWYd}~W|ru| |r}| SSd}~ww|r| |r| ww)$NzDatabase connection errorT) dictionaryZrowidcodecode_iso numeric_codelabeleecactivefavoriteextrasqlz%SELECT * FROM llx_c_country WHERE 1=1z AND rowid = %sz AND code = %sz AND code_iso = %sz AND numeric_code = %sz AND label = %sz AND eec = %sz AND active = %sz AND favorite = %sSELECT; zInvalid SQL inputtrue)messageerroriz No data foundfalsei)datarizInternal server error: )rConnectionErrorcursorrargsgetappendupperrcloseexecutefetchallstr Exception) connectionridrrrr r r r extra_sqlqueryvaluesresulter)J/Users/harjaapdhillon/Desktop/newidea/medvista_backend/Services/Country.py get_countriess                       " (  r+N)flaskrrconfrr+r)r)r)r*s