r@;j!ddlZddlZddlZddlZddlZddlZddlmZddlm Z Gddej Z e dkrej dSdS)N) constants)EnsureDispatchc~eZdZdZdZddZddZdZdZd Z d Z d Z d Z d Z dZdZdZdZdZdZdZdS) TestStuffcd|_d|_dx|_|_ tjd}n#t $rtjj dz|_dD]+} td|z}n)#tj $rY(wxYwtjd|d}||jt"jt"j}|d|j}YnwxYwt-j||_|j|_ |jd |jzn!#t,jt,jf$rYnwxYw||jd |jzd dS) Npywin32test_usersTEST_ODBC_CONNECTION_STRINGz.mdb)z.36z.35z.30z DAO.DBEnginezCan't find a DB enginerzA B B B B DN+    D   H   . !        sF1.D A42D4BDBB DD"E11FFc|j |jd|jzn@#tjtjf$r"}t d|jz|Yd}~nd}~wwxYw|jd|_|j |jd|_|j - tj |j dS#t$rYdSwxYwdS)Nr zFailed to delete test table %s) rr"r r r#r$printcloserr runlinkOSError)r&whys r,tearDownzTestStuff.tearDownQs 8  N  !4t~!EFFFFJ/ N N N6GMMMMMMMM N HNN   DH 9 IOO   DI   '  $*+++++     ( 's'",A)A$$A);C C$#C$Frank Frank Millmanc||jd|jz||gd||jd|jz|gd||jd|jz|gddS)Nz:insert into %s (userid, username) values (?,?)-select * from %s where userid = ?r/select * from %s where username = ?r%rr"r lowerr&useridusernames r,test_insert_selectzTestStuff.test_insert_selectc  H  .!"         H  .!         H   .!!!"         c||jd|jz||gd||jd|jz|gd||jd|jz|gddS)Nz9insert into %s (userid, username) values (?,?)r8r9rr:r;r=s r,test_insert_select_unicodez$TestStuff.test_insert_select_unicoderArBc:d}d}|||dS)Nut-àòutest-àò name)rDr=s r,test_insert_select_unicode_extz(TestStuff.test_insert_select_unicode_exts(' ''99999rBc tdD]}|jd|jz||jd|jd|dd|gd|jd|d |jd dg|j}|dt ||d }||d |dS) Ndz#delete from %s where userid='Frank'z insert into z (userid, z) values (?,?)r5r8zselect z from z where userid = ?r)rangerr"r r% fetchmanylen)r& fieldNamevaluexrowsrows r, _test_valzTestStuff._test_vals!s , ,A H  BT^S T T T     V4>VVYVVVe$     H  L)LL4>LLL    8%%''D   QD * * *q'C   SVU + + + +! , ,rBc^|dd|dddS)Nbitfieldr8rrQr&s r,testBitzTestStuff.testBits0 z1%%% z1%%%%%rBc|dd|dd|dtjdS)Nintfieldr8r)rQsysmaxsizerUs r,testIntzTestStuff.testIntsF z1%%% z1%%% z3;/////rBc^|dd|dddS)N floatfieldg)\(?rrTrUs r, testFloatzTestStuff.testFloats0 |T*** |Q'''''rBc2|dddS)Nr?foorTrUs r, testVarcharzTestStuff.testVarchars z5)))))rBc8|dddzdS)zETest a long text field in excess of internal cursor data size (65536) longtextfieldabcpNrTrUs r,testLongVarcharzTestStuff.testLongVarchars   66666rBcR|dtddzdS)zDTest a long raw field in excess of internal cursor data size (65536)longbinaryfieldsreNrQ memoryviewrUs r,testLongBinaryzTestStuff.testLongBinarys* (*Y5F*G*GHHHHHrBcL|dtddS)NrawfieldsrirUs r,testRawzTestStuff.testRaws% z:.A#B#BCCCCCrBc2|dddS)zTest a unicode character that would be mangled if bound as plain character. For example, previously the below was returned as ascii 'a' r?uāNrTrUs r, test_widecharzTestStuff.test_widechars z8,,,,,rBcXddl}dD]"}|j|}|d|#dS)Nr))il '; datefield)datetimerQ)r&rxvds r, testDateszTestStuff.testDatessJ. + +A!!1%A NN; * * * * + +rBc||jd|jzddgd||jd|jzdgd||jd|jzd|t |jdddS) N-insert into %s (userid,username) values (?,?)r5r6r8zupdate %s set username = ?select * from %srr%rr"r rKfetchonerUs r,test_set_nonzero_lengthz!TestStuff.test_set_nonzero_lengths  H  ?$.P/*         H  9DNJWI V V     ))*rs  %%%%%%433333t9t9t9t9t9!t9t9t9n zHMOOOOOrB