]j 8dZddlZddlZddlmZGddZy)z#Tablib - SQL INSERT Export Support.NUnsupportedFormatcZeZdZdZdZdZedZed dZ edZ edZ y) SQLFormatz-Export Dataset rows as SQL INSERT statements.sql)rc|yt|tr|rdSdSt|ttjfr t |St|t r+ ||k(r$|t dt d fvr t|Syt|tjrd|jddSt|tjrd |jdSt |jdd }d|dS#t$rYywxYw) z(Render a Python value as an SQL literal.NULLTRUEFALSEinfz TIMESTAMP ' )sep'zDATE 'z'') isinstanceboolintdecimalDecimalstrfloatrepr Exceptiondatetime isoformatdatereplace)valuetexts J/var/www/zogu/zoguvenv/lib/python3.12/site-packages/tablib/formats/_sql.py_render_literalzSQLFormat._render_literal s = eT ""6 / / ec7??3 4u:  eU # E>eE%L5<-3P&P;& eX.. / S!9 :!< < eX]] +EOO-.a0 05z!!#t,4&{  s(C?? D  D Nc z|xst|ddxsd}t|}dj||n|j |jng}|rd|dnd}g}|jD]6} djfd | D} |j d ||d | d 8d j|d z|rdzSdzS)z Return SQL INSERT statements for Dataset rows. :param table: optional table name; defaults to dataset.title or 'data' titleN export_table,z ()z, c3@K|]}j|yw)N)r!).0vclss r z'SQLFormat.export_set..8sC!s2215Csz INSERT INTO z VALUES (z); zCOMMIT; )getattrrjoinheaders_dataappend) r+datasettablecolumnscommittbl tbl_identcolumns_headers statementsrowvaluess ` r export_setzSQLFormat.export_set(s Hww6H.H 88".#*??#>B 6EB/q1" == CYYCsCCF   yk/):)F82N   yy$t+f{MM"MMc td)zImporting SQL is not supported.zSQL import is not supported.r)r+r3 in_streamkwargss r import_setzSQLFormat.import_set>s >??r>cy)z+Always return False: no autodetect for SQL.F)r+streams r detectzSQLFormat.detectCsr>)NNF) __name__ __module__ __qualname____doc__r# extensions staticmethodr! classmethodr=rBrFrDr>r rrsa7 EJ4NN*@@r>r)rJrr exceptionsrrrDr>r rOs)*>>r>