ó ;t/Uc@snddlZddlZddlZddlmZddlmZddlmZdefd„ƒYZ dS( iÿÿÿÿNi(tIDENTITY(t cx_Oraclei(t BaseAdaptert OracleAdapterc BseZd:ZeZidd6dd6dd6dd6dd6dd 6dd 6d d 6d d6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6dd!6dd"6d#d$6d%d&6Zd'„Zd(„Zd)„Zd*„Z d+„Z d,„Z d-„Z d.„Z d/„Zd0d;d1eiied;d2„Zd3„Zejd4ƒZd;d5„Zd6„Zd7„Zd8„Zd;d9„ZRS(<RsCHAR(1)tbooleansVARCHAR2(%(length)s)tstringtCLOBttexttjsontpasswordtblobtuploadtINTtintegertNUMBERtbiginttFLOATtfloatt BINARY_DOUBLEtdoubles NUMERIC(%(precision)s,%(scale)s)tdecimaltDATEtdatesCHAR(8)ttimetdatetimesNUMBER PRIMARY KEYtids}NUMBER, CONSTRAINT %(constraint_name)s FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)st references list:integers list:stringslist:referencesbig-ids 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 %s_trigger((tselft tablename((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyt trigger_name+scCsdS(NsLEFT OUTER JOIN((R((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyt LEFT_JOIN.scCsdS(Nsdbms_random.value((R((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pytRANDOM1scCsd|j||ƒS(NsDEFAULT %s NOT NULL(t represent(Rtdefaultt field_type((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pytNOT_NULL4scCs#d|j|ƒ|j|dƒfS(NsREGEXP_LIKE(%s, %s)R(texpand(Rtfirsttsecond((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pytREGEXP7scCs$|j}d|j|fd|gS(NsDROP TABLE %s %s;sDROP SEQUENCE %s;(t_sequence_nametsqlsafe(Rttabletmodet sequence_name((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyt_drop;s c Cs||re|\}}t|ƒdkr5|d|} n d|} d||||||||| |f Sd|||||fS(Nis AND w_row > %isWHERE w_row > %isnSELECT %s %s FROM (SELECT w_tmp.*, ROWNUM w_row FROM (SELECT %s FROM %s%s%s) w_tmp WHERE ROWNUM<=%i) %s %s %s;sSELECT %s %s FROM %s%s%s;(tlen( Rtsql_stsql_ftsql_ttsql_wtsql_otlimitbytlmintlmaxt sql_w_row((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pytselect_limitby?s  &cCsFtj|||ƒ}t|ƒdkrBd|d |d f}n|S(Nis%s_%s__constrainti i(Rtconstraint_nameR.(RRt fieldnameR9((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyR9IscCsõ|dkr)tjt|ƒƒ}d|S|dkrwt|tjtjfƒrc|jƒd }n t|ƒ}d|S|dkrñt|tjƒr´|jƒd jdd ƒ}n5t|tjƒrÝ|jƒd d }n t|ƒ}d |SdS( NR s :CLOB('%s')Ri sto_date('%s','yyyy-mm-dd')RitTt s 00:00:00s%to_date('%s','yyyy-mm-dd hh24:mi:ss')( tbase64t b64encodetstrt isinstanceRRt isoformattreplacetNone(Rtobjt fieldtype((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pytrepresent_exceptionsOs      isUTF-8c sÏ|ˆ_dˆ_|ˆ_| r4ˆj||ƒn|ˆ_|ˆ_|ˆ_| ˆ_ˆjƒdˆ_ |j ddƒd} d|kršt |dCLOB\('([^']+|'')*'\))cCsÉ|p g}d}x‡tr›|jj|ƒ}|s7Pn||jdƒ t|ƒ||jdƒ}|j|jdƒdd!jddƒƒ|d7}qW|ddkr¹|d }n|j ||ƒS( Nitclobiiþÿÿÿs''t'iÿÿÿÿt;( RXt oracle_fixtmatchtstartR?tendtappendtgroupRBt log_execute(Rtcommandtargstitm((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyR`~s  .) c Ks~|jp|j}|jj}|j}|j}|j|ƒ|jd|ƒ|jdtd|d|d|d|ƒƒdS(NsFCREATE SEQUENCE %s START WITH 1 INCREMENT BY 1 NOMAXVALUE MINVALUE -1;s± CREATE OR REPLACE TRIGGER %(trigger_name)s BEFORE INSERT ON %(tablename)s FOR EACH ROW DECLARE curr_val NUMBER; diff_val NUMBER; PRAGMA autonomous_transaction; BEGIN IF :NEW.%(id)s IS NOT NULL THEN EXECUTE IMMEDIATE 'SELECT %(sequence_name)s.nextval FROM dual' INTO curr_val; diff_val := :NEW.%(id)s - curr_val - 1; IF diff_val != 0 THEN EXECUTE IMMEDIATE 'alter sequence %(sequence_name)s increment by '|| diff_val; EXECUTE IMMEDIATE 'SELECT %(sequence_name)s.nextval FROM dual' INTO curr_val; EXECUTE IMMEDIATE 'alter sequence %(sequence_name)s increment by 1'; END IF; END IF; SELECT %(sequence_name)s.nextval INTO :NEW.%(id)s FROM DUAL; END; RRR,R(t_rnamet _tablenamet_idtnameR(t _trigger_nameR`tdict(RtqueryR*RlRtid_nameR,R((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pytcreate_sequence_and_triggersŒs    cCs1|j}|jd|ƒt|jjƒdƒS(NsSELECT %s.currval FROM dual;i(R(R`tlongtcursortfetchone(RR*R,((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyt lastrowid¨s cCstd„|jjDƒƒrpg|jD]F}tg|D]-}t|ƒtjkr]|jƒn|^q6ƒ^q&S|jjƒSdS(Ncss"|]}|dtjkVqdS(iN(RtLOB(t.0tx((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pys ·s( tanyRyt descriptionttuplettypeRR|treadtfetchall(Rtrtc((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyt _fetchall¶sQcCs3|dk r(|jd|j||fS|j|S(NR<(RCtQUOTE_TEMPLATE(RRtot((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyt sqlsafe_table½s (s cx_OracleN(t__name__t __module__tdriverstFalsetcommit_on_alter_tablettypesRRRR#R'R-R8R9RFRCRRXR_R]tretcompileRdR`RwR{R‡RŠ(((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyR s\               ( R=RR‘t_globalsRRRtbaseRR(((sR/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/packages/dal/pydal/adapters/oracle.pyts