ó [³XMc@sœdZddlZddlmZmZmZddlmZddlm Z ddl m Z ddl m Z ddlmZdd lmZdd lmZd Zd Zd efd„ƒYZdefd„ƒYZdZdZeed„Zd„ZedddeƒZedddeƒZ dd#d„ƒYZ!de!_"de!fd„ƒYZ#dej$fd„ƒYZ%ee#d e&ƒƒd!e fd"„ƒYZ'dS($s* Tests for twisted.enterprise reflectors. iÿÿÿÿN(treactort interfacestdefer(t RowObject(tEQUAL(t SQLReflector(tutil(t makeSQLTests(tsuppress(tunittestt testTablet childTabletTestRowcBs,eZddd d d gZd gZeZRS( t key_stringtvarchartcol2tinttanother_columntColumn4t column_5_(s key_stringR(Rsint(RR(RR(Rsint(s key_stringR(t__name__t __module__t rowColumnst rowKeyColumnst tableNamet rowTableName(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR s  tChildRowcBsMeZd d d d ddgZdgZeZedgdgdd fgZRS(tchildIdRtfooRttest_keytstufftgogogotdataR i(schildIdsint(Rsvarchar(stest_keysvarchar(Rsvarchar(Rsint(sdatasvarchar(schildIdsint(stest_keysvarchar(s key_stringsvarcharN( RRRRtchildTableNameRRtNonetrowForeignKeys(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR"s  s© CREATE TABLE testTable ( key_string varchar(64), col2 integer, another_column varchar(64), Column4 varchar(64), column_5_ integer ) sÈ CREATE TABLE childTable ( childId integer, foo varchar(64), test_key varchar(64), stuff varchar(64), gogogo integer, data varchar(64) ) c Csi}x|jD]ü\}}tj||ƒrGt||ƒ||Usii@( RRt getKeyColumntgetattrR&trandintR"tjointmaptxrangetrstriptsetattr(trowtnulls_okttrailing_spaces_oktvaluestnamettypetvalue((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt randomizeRowGs$   cCsZxS|jD]H\}}t||ƒ||kr d|t||ƒ||fGHtSq WtS(Ns/Mismatch on column %s: |%s| (row) |%s| (values)(RR+tFalsetTrue(R2R5R6R7((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt rowMatches^s tmessages6twisted.enterprise.row is deprecated since Twisted 8.0tcategorys<twisted.enterprise.reflector is deprecated since Twisted 8.0tReflectorTestBasecBs¤eZdZejed ƒd kr-dZndZd„Z d„Z d„Z d„Z d„Z d„Zeege_d „Zd „Zeege_d „ZRS( sf Base class for testing reflectors. @ivar reflector: The reflector created during setup. s%No thread support, no reflector testsidcCst||j|jƒS(N(R9R3R4(tselfR2((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR9}scCs |jƒ}|j|jƒ|S(sW Create and store a reference to a SQL reflector for use by the tests. (tcreateReflectort addCallbackt_cbSetUp(R@td((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt extraSetUp€s cCs ||_dS(N(t reflector(R@RF((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRCˆscCs |jƒS(N(tdestroyReflector(R@((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyttearDown‹scCsdS(N((R@((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRGŽscs‰tƒ}|jddƒˆj|ƒ‰ˆjj|ƒ}‡fd†}‡‡fd†}|j|ƒ|j|ƒ|jˆjƒ|S(s3 Full featured tests of reflector. R tfirstcs:dtdfg}ˆjjtd|ƒ}|jˆjƒS(NR RIt whereClause(RRFtloadObjectsFromRRBtgotData(t_RJRD(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt _loadBacks csIˆjtˆjƒdkdƒˆjd}ˆjt|ˆƒdƒ|S(Nisno rowisno match(t failUnlesstlenR R<(RMtparent(R@R5(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt _getParent¤s (R t assignKeyAttrR9RFt insertRowRBt_cbTestReflector(R@R2RDRNRR((R@R5s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyttest_reflector‘s   csgi‰g}i‰x|tdˆjƒD]h}tƒ}|jd|ƒˆj|ƒ‰dˆd<|_ˆˆ|<|jˆjj|ƒƒd}q%Wt j |ƒ}dg‰‡‡fd†}‡‡‡fd†}‡‡fd†}‡‡‡fd†} ‡fd †} ‡‡‡fd †} ‡‡fd †} ‡fd †} ‡‡fd †}‡‡‡fd†}‡fd†‰‡‡fd†}‡fd†}|j |ƒ|j |ƒ|j |ƒ|j |ƒ|j | ƒ|j | ƒ|j | ƒ|j | ƒ|j | ƒ|j |ƒ|j |ƒ|j | ƒ|j |ƒ|j |ƒ|j | ƒ|j |ƒ|S(NiRRIRcs(ˆjjtdˆƒ}|jˆjƒS(Nt parentRow(RFRKR!RBRL(RMRD(RQR@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt _loadObjectsÂscsˆjtˆjƒˆjkdƒˆjtˆjƒˆjkdtˆjƒƒx8ˆjD]-}ˆjt|ˆ|jƒd|jƒq[WdS(Nsno rows on querysdid not load child rows: %dschild %d does not match(RORPR tnum_iterationst childRowsR<R(RMtchild(RQt child_valuesR@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt_checkLoadObjectsÆscsUˆjtˆjƒˆjkdƒˆjtˆjƒˆjkdtˆjƒƒdS(Nsno rows on queryschild rows added twice!: %d(RORPR RYRZ(RM(RQR@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt_checkLoadObjects2Ïscs#ˆjˆƒˆd<ˆjjˆƒS(Ni(R9RFt updateRow(RM(R@R5RQ(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt _changeParentÕscs:dtdfg}ˆjjtd|ƒ}|jˆjƒS(NR RIRJ(RRFRKRRBRL(RMRJRD(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRNÚscsdˆjtˆjƒdkdƒˆjd}ˆjt|ˆdƒdƒˆdˆ|j@tSQLReflectorTestBasecBs eZdZd„Zd„ZRS(s+ Base class for the SQL reflector. cs׈jƒˆjƒˆ_ˆjjƒˆjrjˆjjdƒ}|j‡fd†ƒ|jd„ƒntj dƒ}|j‡fd†ƒ|j‡fd†ƒˆj r´t p·t ‰|j‡‡fd†ƒ|S(NsDROP TABLE testTablecsˆjjdƒS(NsDROP TABLE childTable(tdbpoolt runOperation(RM(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR)OscSsdS(N(R"(RM((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR)QscsˆjjtƒS(N(RyRztmain_table_schema(RM(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR)UscsˆjjtƒS(N(RyRztchild_table_schema(RM(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR)VscsˆˆjttgƒS(N(RyR R(RM(treflectorClassR@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR)Ys(tstartDBtmakePoolRytstartt can_clearRzRBt addErrbackRtsucceedR"tescape_slashesRtNoSlashSQLReflector(R@RD((R@R}s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRAHs   csHˆjjdƒ}|j‡fd†ƒ‡fd†}|j|ƒ|S(NsDROP TABLE testTablecsˆjjdƒS(NsDROP TABLE childTable(RyRz(RM(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR)_scsˆjjƒˆjƒdS(N(RytclosetstopDB(RM(R@(s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR†as (RyRzRB(R@RDR†((R@s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRG]s  (RRRrRARG(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRxCs tDeprecationTestCasecBs eZdZd„Zd„ZRS(s: Test various deprecations of twisted.enterprise. cCs#d„}|jtdt|ƒdS(s3 Test deprecation of L{RowObject}. cSstƒS(N(R (((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pytwrapperqss6twisted.enterprise.row is deprecated since Twisted 8.0N(t assertWarnstDeprecationWarningt__file__(R@R‰((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyttest_rowDeprecationms   cCs6d„}ddlm}|jtd|j|ƒdS(s6 Test deprecation of L{SQLReflector}. cSs tddƒS(N((RR"(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR‰|siÿÿÿÿ(t sqlreflectors<twisted.enterprise.reflector is deprecated since Twisted 8.0N(ttwisted.enterpriseRŽRŠR‹RŒ(R@R‰RŽ((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyttest_reflectorDeprecationxs   (RRRrRR(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyRˆhs tReflectorTestCaseR…cBseZdZd„ZRS(s; An sql reflector that only escapes single quotes. cCs|jddƒS(Nt's''(treplace(R@ttext((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyt escape_strings(RRRrR•(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyR…Šs(((RrR&ttwisted.internetRRRttwisted.enterprise.rowRttwisted.enterprise.reflectorRttwisted.enterprise.sqlreflectorRRRttwisted.test.test_adbapiRttwisted.trial.utilRtsuppressWarningt twisted.trialR RR!R RR{R|R;R9R<R‹RvRwR?ttimeoutRxtTestCaseRˆtglobalsR…(((s?/usr/lib/python2.7/dist-packages/twisted/test/test_reflector.pyts:      Ï %