ó ;t/Uc@sŠddlZddlZddlmZddlmZddlmZdefd„ƒYZd efd „ƒYZ d efd „ƒYZ d efd„ƒYZ defd„ƒYZ defd„ƒYZ dS(i’’’’Ni(tIDENTITY(t varquote_auxi(t BaseAdaptert MSSQLAdapterc BseZdNZdZdZidd6dd6dd6dd 6dd 6d d 6dd 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6dd!6dd"6d#d#6d$d$6d%d&6d'd(6d)d*6d+d,6Zd-„Zd.„Zd/„Zd0„Z d1„Z d2„Z d3„Z d4„Z d5„Zd6„Zd7„Zd8„Zd9Zd:Zejd;ƒZejd<ƒZejd=ƒZd:dOd>eiied?dOd@„ ZdA„Zd:dOdB„ZdC„ZdD„Z dE„Z!dF„Z"dG„Z#dH„Z$dI„Z%dJ„Z&dK„Z'dL„Z(dM„Z)RS(PtpyodbctTs"%s"tBITtbooleansVARCHAR(%(length)s)tstringtTEXTttexttjsontpasswordtIMAGEtblobtuploadtINTtintegertBIGINTtbiginttFLOATtfloattdoubles NUMERIC(%(precision)s,%(scale)s)tdecimaltDATETIMEtdatesCHAR(8)ttimetdatetimesINT IDENTITY PRIMARY KEYtidsINT NULL, CONSTRAINT %(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)st references list:integers list:stringslist:referencetgeometryt geographysBIGINT IDENTITY PRIMARY KEYsbig-ids‚BIGINT NULL, CONSTRAINT %(constraint_name)s 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 TFKcCsd|S(Ns; ALTER TABLE %s ADD ((tselft tablename((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt concat_add-scCs t|dƒS(Ns[%s](R(R tname((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pytvarquote0scCsd||j|ƒfS(NsDATEPART(%s,%s)(texpand(R tfieldtwhat((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pytEXTRACT3scCsdS(NsLEFT OUTER JOIN((R ((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt LEFT_JOIN6scCsdS(NsNEWID()((R ((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pytRANDOM9scCsdS(Ns NULL((R ((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ALLOW_NULL<scCs|S(N((R tfirsttsecond((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pytCAST?scCs"d|j|ƒ|d|dfS(NsSUBSTRING(%s,%s,%s)ii(R%(R R&t parameters((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt SUBSTRINGBscCsd|S(NsPRIMARY KEY CLUSTERED (%s)((R tkey((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt PRIMARY_KEYEscCs,|dkrd}nd||j|ƒfS(NtLENGTHtLENs%s(%s)(R%(R R,R'((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt AGGREGATEHs  cCsd|j|ƒS(NsLEN(%s)(R%(R R,((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR3Msc Cs:|r#|\}}|d|7}nd|||||fS(Ns TOP %isSELECT %s %s FROM %s%s%s;(( R tsql_stsql_ftsql_ttsql_wtsql_otlimitbytlmintlmax((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pytselect_limitbyPs iis ^(?P.+)$st^(?P[^:@]+)(\:(?P[^@]*))?@(?P[^\:/]+)(\:(?P[0-9]+))?/(?P[^\?]+)(\?(?P.*))?$s%(?P[^=]+)=(?P[^&]*)sUTF-8ięc  sņ|ˆ_dˆ_|ˆ_| r4ˆj||ƒn|ˆ_|ˆ_|ˆ_| ˆ_| ˆ_ˆj ƒ|j ddƒd} d| kr)yVˆj j | ƒ} | s¾t dˆjƒ‚n| jdƒ}|sāt dƒ‚nWn:t k rtjƒd}ˆjjjdƒ|‚nX|}n”ˆjj | ƒ} | sWt d ˆjƒ‚n|| jd ƒƒ}|st d ƒ‚n|| jd ƒƒ}|s„d }n| jdƒ}|sÉt dƒ‚n| jdƒ}|sķt dƒ‚n| jdƒp’d}idd6}| jdƒp!d }xBˆjj|ƒD].}|jdƒ|t|jdƒƒjƒ«s(Ri(R titems((R sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pytCONCATŖscCsd|j|ƒS(Ns %s.STAsText()(R%(R R,((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_ASTEXT±scCs&d|j|ƒ|j||jƒfS(Ns%s.STContains(%s)=1(R%ttype(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_CONTAINS“scCs&d|j|ƒ|j||jƒfS(Ns%s.STDistance(%s)(R%R‰(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_DISTANCE·scCs&d|j|ƒ|j||jƒfS(Ns%s.STEquals(%s)=1(R%R‰(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_EQUALSŗscCs&d|j|ƒ|j||jƒfS(Ns%s.STIntersects(%s)=1(R%R‰(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_INTERSECTS½scCs&d|j|ƒ|j||jƒfS(Ns%s.STOverlaps(%s)=1(R%R‰(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_OVERLAPSĄscCs&d|j|ƒ|j||jƒfS(Ns%s.STTouches(%s)=1(R%R‰(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_TOUCHESÅscCs&d|j|ƒ|j||jƒfS(Ns%s.STWithin(%s)=1(R%R‰(R R,R-((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt ST_WITHINČscCsŗ|j}|dƒrQd}|d jdƒ\}}|rC|}nd||fS|dkr§d}|d jdƒ\}}|r‹|}nd||fSd||fStj|||ƒS( NRii’’’’t(s!geometry::STGeomFromText('%s',%s)Rięs"geography::STGeomFromText('%s',%s)(t startswithR[Rt represent(R tobjt fieldtypet field_is_typeRYtgeotypetparms((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR“Ės     (spyodbcN(*t__name__t __module__tdriverstT_SEPtQUOTE_TEMPLATEttypesR"R$R(R)R*R+R.R0R2R5R3R>tTRUEtFALSEtretcompileR\RdReR~RtTrueRwR}R‚RƒR‡RˆRŠR‹RŒRRŽRRR“(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR s€                =           t MSSQL3AdaptercBsāeZdZidd6dd6dd6dd6dd6d d 6dd 6d d 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6d!d!6d"d"6d#d$6d%d&6d'd(6d)d*6Zd+„Zd,d.d-„ZRS(/sbExperimental support for pagination in MSSQL Requires MSSQL >= 2005, uses `ROW_NUMBER()` RRsVARCHAR(%(length)s)Rs VARCHAR(MAX)R R R R RRRRRRRRRs NUMERIC(%(precision)s,%(scale)s)RRRsTIME(7)RRsINT IDENTITY PRIMARY KEYRsINT NULL, CONSTRAINT %(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)sRs list:integers list:stringslist:referenceRRsBIGINT IDENTITY PRIMARY KEYsbig-ids‚BIGINT NULL, CONSTRAINT %(constraint_name)s 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 TFKc CsX|rA|\}}|dkrC|d|7}d|||||fS|d7}||jdƒd} ||jdƒ } gtt|jdƒƒƒD]} d| ^q“} g|jdƒD] } | ^q¹} gt| | ƒD]\}}d ||f^qŪ}d j|ƒ}d j| ƒ}d |||||||| ||f Sd|||||fS( Nis TOP %isSELECT %s %s FROM %s%s%s;is ORDER BY i t,sf_%ss%s AS %ss, sySELECT %s %s FROM (SELECT %s ROW_NUMBER() OVER (ORDER BY %s) AS w_row, %s FROM %s%s%s) TMP WHERE w_row BETWEEN %i AND %s;(tfindtrangetlenR[tzipRi(R R6R7R8R9R:R;R<R=t sql_o_innert sql_g_innertft sql_f_outert sql_f_innertotnt sql_f_iproxyt sql_f_oproxy((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR>s   2"2&icCs|S(N((R RR€R((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR‚sN(R™Ršt__doc__RžR>R~R‚(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR¤ßs<  t MSSQL4AdaptercBsāeZdZidd6dd6dd6dd6dd6d d 6dd 6d d 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6d!d!6d"d"6d#d$6d%d&6d'd(6d)d*6Zd+„Zd,d.d-„ZRS(/suSupport for "native" pagination Requires MSSQL >= 2012, uses `OFFSET ... ROWS ... FETCH NEXT ... ROWS ONLY` RRsVARCHAR(%(length)s)Rs VARCHAR(MAX)R R R R RRRRRRRRRs NUMERIC(%(precision)s,%(scale)s)RRRsTIME(7)RRsINT IDENTITY PRIMARY KEYRsINT NULL, CONSTRAINT %(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)sRs list:integers list:stringslist:referenceRRsBIGINT IDENTITY PRIMARY KEYsbig-ids‚BIGINT NULL, CONSTRAINT %(constraint_name)s 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 TFKc Cs~|rg|\}}|dkr/|d|7}qg|sL|d|jƒ7}n|d|||f7}nd|||||fS(Nis TOP %is ORDER BY %ss' OFFSET %i ROWS FETCH NEXT %i ROWS ONLYsSELECT %s %s FROM %s%s%s;(R*( R R6R7R8R9R:R;R<R=((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR>9s  icCs|S(N((R RR€R((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR‚JsN(R™RšR³RžR>R~R‚(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR“s<  t MSSQL2AdaptercBsĪeZd+Zidd6dd6dd6dd6dd6d d 6dd 6d d 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6d!d"6d#d$6d%d&6d'd(6Zd)„Zd*„ZRS(,RsCHAR(1)RsNVARCHAR(%(length)s)RtNTEXTR R R R RRRRRRRRRs NUMERIC(%(precision)s,%(scale)s)RRRsCHAR(8)RRsINT IDENTITY PRIMARY KEYRszINT, CONSTRAINT %(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)sRs list:integers list:stringslist:referencesBIGINT IDENTITY PRIMARY KEYsbig-ids}BIGINT, CONSTRAINT %(constraint_name)s 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 TFKcCsBtj|||ƒ}|dkr>|d dkr>d|}n|S(NRR R it'tN(sstringstextsjson(RR“(R R”R•tvalue((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR“ls cCs|j|jdƒƒS(Ntutf8(t log_executetdecode(R ta((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyRxrs(spyodbc(R™RšR›RžR“Rx(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyRµNs8  tVerticaAdaptercBsŻeZd+ZdZidd6dd6dd6dd6dd 6dd 6dd 6d d 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6dd!6dd"6d#d$6Zd%„Zd&d'„Zd(„Zd)„Zd*„Z RS(,Rt tBOOLEANRsVARCHAR(%(length)s)RtBYTEAR R R RRRRRRRRsDOUBLE PRECISIONRs DECIMAL(%(precision)s,%(scale)s)RtDATERtTIMERRRRRs=INT REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)sRs list:integers list:stringslist:references@BIGINT REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)ss big-referencecCsd||j|ƒfS(NsDATE_PART('%s', TIMESTAMP %s)(R%(R R,R'((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR(“sRCcCs |j}d||pdfgS(NsTRUNCATE %s %s;RC(t _tablename(R R|tmodeR!((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyt _truncate–s c CsD|r-|\}}|d|||f7}nd|||||fS(Ns LIMIT %i OFFSET %isSELECT %s %s FROM %s%s%s;(( R R6R7R8R9R:R;R<R=((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR>šs  cCs$|jdƒt|jjƒdƒS(NsSELECT LAST_INSERT_ID();i(RxRyRzR{(R R|((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR}”s cCs |j|ƒS(N(R»(R R½((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyRx„s(spyodbc( R™RšR›RœRžR(RĘR>R}Rx(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyR¾vs:     t SybaseAdapterc BsīeZdZidd6dd6dd6dd6dd6d d 6dd 6d d 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6d!d!6d"d"6d#d$6d%d&6d'd(6d)d*6Zd+d/d,eiied-d/d.„ ZRS(0tSybaseRRsCHAR VARYING(%(length)s)RR R R R R RRRRRRRRRs NUMERIC(%(precision)s,%(scale)s)RRRsCHAR(8)RRsINT IDENTITY PRIMARY KEYRsINT NULL, CONSTRAINT %(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)sRs list:integers list:stringslist:referenceRRsBIGINT IDENTITY PRIMARY KEYsbig-ids‚BIGINT NULL, CONSTRAINT %(constraint_name)s 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 TFKisUTF-8ięc sf|ˆ_dˆ_|ˆ_| r4ˆj||ƒn|ˆ_|ˆ_|ˆ_| ˆ_| ˆ_ˆj ƒ|j ddƒd} d| kr#yVˆj j | ƒ} | s¾t dˆjƒ‚n| jdƒ}|sāt dƒ‚nWq1t k rtjƒd}ˆjjjdƒ|‚q1Xnˆjj |ƒ} | sQt d ˆjƒ‚n|| jd ƒƒ}|s{t d ƒ‚n|| jd ƒƒ}|sŸd }n| jdƒ}|sĆt dƒ‚n| jdƒ}|sēt dƒ‚n| jdƒpłd}d|||f}|jd ||ƒd||ƒƒ||‡fd†}|ˆ_| rbˆjƒndS(Ntsybases://iR@s$Parsing uri string(%s) has no resultRAs DSN requiredsNdGpatch errorsInvalid URI string in DAL: %sRBs User requiredR RCRDsHost name requiredREsDatabase name requiredRFRGssybase:host=%s:%s;dbname=%stpasswdcsˆjj||S(N(RMRN(RARP(R (sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyRQ’s(RERRRSRTRURVRWRXRYRZR[R\R]R^R_R`RaRbRcRdtupdateRQRk(R RERSRURVRWRlRPRmRnRYRoRpRqRARrRBR RDRFRQ((R sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyRwÉsb               N(R™RšR›RžR~RR£Rw(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyRĒ©s@   (R”R`t_globalsRthelpers.methodsRtbaseRRR¤R“RµR¾RĒ(((sQ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/mssql.pyts  Õ78(3