ó ;t/Uc@sJddlmZddlmZddlmZdefd„ƒYZdS(i(tIDENTITY(tConnectionPooli(t BaseAdaptertTeradataAdapterc BseZd5Zidd6dd6dd6dd6dd 6d d 6dd 6d d6dd6dd6dd6dd6dd6dd6dd6dd6d d6dd 6dd!6dd"6d#d$6d%d&6dd'6d(d)6d*d+6Zd,d6d-eiied6d.„Zd/ed0„Zd1„Z d2„Z d3d4„Z RS(7tpyodbcsCHAR(1)tbooleansVARCHAR(%(length)s)tstrings VARCHAR(2000)ttexts VARCHAR(4000)tjsontpasswordtBLOBtblobtuploadtINTtintegertBIGINTtbiginttREALtfloattDOUBLEtdoubles NUMERIC(%(precision)s,%(scale)s)tdecimaltDATEtdatetTIMEttimet TIMESTAMPtdatetimes INT GENERATED ALWAYS AS IDENTITYtidt references list:integers list:stringslist:referencet ST_GEOMETRYtgeometrys#BIGINT GENERATED ALWAYS AS IDENTITYsbig-ids big-references REFERENCES %(foreign_key)ss reference FKsL FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_table)s (%(foreign_key)s)s reference TFKisUTF-8c s­|ˆ_dˆ_|ˆ_| r4ˆj||ƒn|ˆ_|ˆ_|ˆ_| ˆ_ˆjƒ|j ddƒd} | |‡fd†} | ˆ_ | r݈j ƒndS(Ntteradatas://icsˆjj||S(N(tdrivertconnect(tcnxnt driver_args(tself(sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyt connector6s( tdbtdbengineturit find_drivert pool_sizetfoldertdb_codect_after_connectiontfind_or_make_work_foldertsplitR&t reconnect( R%R'R)R+R,R-tcredential_decoderR$t adapter_argst do_connecttafter_connectiontruriR&((R%sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyt__init__)s         tcommitcCs$|jjƒtj|||ƒdS(N(tcursortcloseR(R%tactiontreally((sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyR:;s cCsdS(NsLEFT OUTER JOIN((R%((sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyt LEFT_JOINAsc Cs:|r#|\}}|d|7}nd|||||fS(Ns TOP %isSELECT %s %s FROM %s%s%s;(( R%tsql_stsql_ftsql_ttsql_wtsql_otlimitbytlmintlmax((sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pytselect_limitbyEs tcCs|j}d|gS(NsDELETE FROM %s ALL;(t _tablename(R%ttabletmodet tablename((sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyt _truncateKs (spyodbcN( t__name__t __module__tdriversttypestNoneRtTrueR7R:R=RFRL(((sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyRsD    N(t_globalsRt connectionRtbaseRR(((sT/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/teradata.pyts