ó ;t/Uc@sfddlmZddlmZddlmZdZdefd„ƒYZdefd „ƒYZd S( i(tIDENTITY(tpyodbci(t BaseAdaptersii***lineitemsequencet IngresAdapterc BseZd3Zidd6dd6dd6dd6dd6d d 6dd 6d d 6dd6dd6dd6dd6dd6dd6dd6ded6dd6dd 6dd!6dd"6d#ed$6d%d&6d'd(6d)d*6Zd+„Zd,„Zd-„Zd.d4d/e iie d4d0„Z d1„Z d2„Z RS(5RsCHAR(1)tbooleansVARCHAR(%(length)s)tstringtCLOBttexttjsontpasswordtBLOBtblobtuploadtINTEGER4tintegertBIGINTtbiginttFLOATtfloattFLOAT8tdoubles NUMERIC(%(precision)s,%(scale)s)tdecimaltANSIDATEtdatesTIME WITHOUT TIME ZONEttimesTIMESTAMP WITHOUT TIME ZONEtdatetimes2int not null unique with default next value for %stids[INT, FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)st references list:integers list:stringslist:references5bigint not null unique with default next value for %ssbig-ids^BIGINT, FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)ss big-referencesz, CONSTRAINT FK_%(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)ss reference FKsŽ CONSTRAINT FK_%(foreign_table)s_PK FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_table)s (%(foreign_key)s) ON DELETE %(on_delete_action)ss reference TFKcCsdS(NsLEFT OUTER JOIN((tself((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyt LEFT_JOIN*scCsdS(NsRANDOM()((R((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pytRANDOM-sc Csj|rS|\}}||} | r6|d| f7}n|rS|d|f7}qSnd|||||fS(Ns FIRST %d s OFFSET %dsSELECT %s %s FROM %s%s%s;(( Rtsql_stsql_ftsql_ttsql_wtsql_otlimitbytlmintlmaxt fetch_amt((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pytselect_limitby0s  isUTF-8c s"|ˆ_dˆ_tˆ_|ˆ_| r=ˆj||ƒn|ˆ_|ˆ_|ˆ_| ˆ_ ˆj ƒ|j ddƒd} | j ƒ} x| j dƒr¬| d} qWd| krÂ| } n+| } d}d}d}d||| f} | |‡fd †}|ˆ_| rˆjƒndS( Ntingrest:it/t=tIngress(local)s!Driver={%s};Server=%s;Database=%scsˆjj||S(N(tdrivertconnect(tcnxnt driver_args(R(sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyt connectorWs(tdbtdbengineRt_driverturit find_drivert pool_sizetfoldertdb_codect_after_connectiontfind_or_make_work_foldertsplittlstript startswithR2t reconnect(RR3R6R8R9R:tcredential_decoderR1t adapter_argst do_connecttafter_connectiontconnstrtrurit database_nametdefault_driver_nametvnodet servertypeR2((RsR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyt__init__;s4             cKs°t|dƒrUd|jdjg|jD]}d|^q(ƒf}|j|ƒnWd|j}|jt|ƒ}|jd|ƒ|j|ƒ|jd|jdfƒdS(Nt _primarykeysmodify %s to btree unique on %ss, s'%s's%s_iisqscreate sequence %sR(thasattrt _tablenametjoint primarykeytexecutetreplacetINGRES_SEQNAME(Rtqueryttabletargstxtmodify_tbl_sqlt tmp_seqname((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pytcreate_sequence_and_triggers_s-  cCs2d|}|jd|ƒt|jjƒdƒS(Ns%s_iisqsselect current value for %si(RQtlongtcursortfetchone(RRURY((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyt lastrowidps (spyodbcN(t__name__t __module__tdriversRSttypesRRR(tNoneRtTrueRKRZR^(((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyR sD      " tIngresUnicodeAdaptercBsÄeZd,Zidd6dd6dd6dd6dd6d d 6d d 6d d6dd6dd6dd6dd6dd6dd6dd6ded6dd 6dd!6dd"6dd#6d$ed%6d&d'6d(d)6d*d+6ZRS(-RsCHAR(1)RsNVARCHAR(%(length)s)RtNCLOBRRR R R sVARCHAR(%(length)s)R R RRRRRRRs NUMERIC(%(precision)s,%(scale)s)RRRsTIME WITHOUT TIME ZONERsTIMESTAMP WITHOUT TIME ZONERs7INTEGER4 not null unique with default next value for %sRs`INTEGER4, FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)sRs list:integers list:stringslist:references5BIGINT not null unique with default next value for %ssbig-ids^BIGINT, FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)ss big-referencesz, CONSTRAINT FK_%(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)ss reference FKsŽ CONSTRAINT FK_%(foreign_table)s_PK FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_table)s (%(foreign_key)s) ON DELETE %(on_delete_action)ss reference TFK(spyodbc(R_R`RaRSRb(((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyRevs4  N( t_globalsRRaRtbaseRRSRRe(((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/ingres.pyts j