[ANN]pre-release DBAPI2.0 for ADO

Michel Orengo morganea at bellatlantic.net
Wed Jul 5 14:26:41 EDT 2000


Hi all,
I enclosed a very preliminary version of the DBAPI 2.0 for ADO (Microsoft
Active X Data Object) - ADODBpy. It is built on top of another module called
ADOpy which give a more "pythonic" interface to ADO (I've posted this module
few days ago)

ADODBpy is still largely incomplete (does not deal with exceptions for
instance). It is released to get a feedback from the python community.

Some examples to get you started:

import ADODBpy

db = ADODBpy.connect('MyDB', 'MyUser', 'MyPassword')
cur = db.cursor()
cur.execute('select * from mytable')
tup = cur.fetchone()

#now because it is build on top of ADOpy, we can access also the
properties/methods of the
#underlying ADOobject
print db.provider
print cur.fields.Item('col').Value
# or better:
print cur['col']

Hope this help.
Cheers,
Michel


begin 666 ADODBpy.zip
M4$L#!!0``@`(`%QOW"@DOGOS3 0``(P-```(````041/<'DN<'G-5LUNXS80
MO@?(.TR=@^3&$;+;4X.F11JG0 Y)C'3;+1H8`DV-8VYE4B#I.%KTF?H0^V0[
M)!69EI5NVAQ:(0ADSO_WS0QU`$=?>O;W#N!L?%/5)W#!3 V7TJ*>,XXP5]I)
MG,)+O#B]]UI8BQ)F-5P)OL 2;C3*>Y7!9#4K!8>Q6C(A,Z=[K>!<5;46]PL+
M(Y *;MVK at 5LTJ!^P& &3A3M_S[1FT at HTL%XP:Q0^H,Z:D/1JA))PG+W=WZ.#
M`WBW$ :6JEB5"(*JD84!JZ#2ZD$4"(QD&F%0U7:AI. #KQ1*)K50L<<$3ET5
M6ADUMY_^@C-NQ0/^1F]C9AG<S#X at MV83DOZ8!'QDRXHBSYC!`E9&R'N0S%E"
MB,C5<A/QQ)N+9:6TA;60W[PE<<9+@=)Z$9>2TNA(LK$P%;-\D2:4YOC'[%Q)
M2<D0#LGPR2R;:%6A=K"E`Y_QSVJE.0Z&V:^L7"&Y3:YJ)W"I)KUFOQ 3<#F.
M3=S1-5NV!EOZ$V;,6NDB-IB8M2XV[F\JE&E(4AM+"N[PXA'YRF*:&"RI#O@:
MYII at NJK?L5F)34WSLB!U,LI^$E at 6)DVX*M\D0SC at A#LKC8(9GFS4TN&3AC>O
M-*'NI$UJVU9!NF/E+:_5>@1V at 6"H;N+"+IJ)B<GS)Q%E_G=$3+HAIB#,`Q?/
M<; BD"_'?7#+K&HP[L%6=;$-2=PB)WV#-G5*^ 6L.V#?!32FVQBVV)P9J-4*
M')8&,01T[:UI_C at -K%$$F5D00A34A)$ND& /.#I4BUJR)>V&JFTD8&&LQ-PI
MU+!&&EAC:8IBK88;2^SUN2"3`@F0PDT at +0@7:C )2T /LF9NR;O39)R2-6+F
M!K?VJE1U&9@#Y2<]:G2W:/;W&N*-)5#N1Z"Q/6H'O3W9&>W]O=R1:!S(F)&D
M$B5QDOXP^6Y=?']W=O3[U/\[_#.\LZ./QT??3@^'KB_W]WA)70`YP>W?J!.!
MG at +GD.?W2$A9G><I,3RGS4KM,VPTW).[`XH;$L]6%565NK.[X^GPT+^\.9EN
M]*VN(VOW/#2SW43R<3+*)0`U\@&&VR8:[4K+8+F1X"/'BF:'G(@9->6%UDIW
M at G72_:"$3 -VV5S(@I5E&@*.$D at Z47=3C]/?3CM>9,%A6!2[]OVU1/6T_#MB
M<^PIRKMAPF"G]C2"+K!I>M@<A=@QJ?^8U1YLS-_0^10RLOAOR'L9:13RM?3X
M0'E>"&[S_,[YGFY[]?QP1E=&8*9-*N9EVTO2ZB33L)[#K\[X"HO+EO _L(X=
M-LUWWJZG2U+N4$9WF+.*-D5T#[5+8[BU-804MHW9?"OITR1Y<3'/?J,,NM\H
M at XAH6O%/P> KNM&2G9[LTAUT3UNSN,CEDNZ7%U78NCR]5G)KDBBC5NB^Z9R\
M+ZE_CX//, at 8!2],?PG?7IJ\VI6ZN]/]WL6V>KRNWT^VOJ_F96-'*;==MS^"9
MG049-LXP+B=8;9?X&5!+`P04``(`" !K8N4H!G'^:A\'``!O% ``"@```$%$
M3T1"<'DN<'FU5VU/X\86_ at P2_^&4B.+T>JV$95^*RI5@`[V1N@$!V]6JJJ*)
M/4GFKNWQSHQATU_?<V8\SCAA6?JA"(%]SC/G;<Z;>_#B>S][NSTX&UV-SJ\_
MG<"(&39CFL/9]1B.D@',I2(N at 9XCB7 ?E3"&ES!;P7N1+GD.5XJ7"YG =3W+
M10HC63!1)H2=2'@GJY42BZ6!&$H)-_2HX89KKNYY%@,K,Z)_9$JQT at BNX6')
MC);\GJND48F/6L at 2!LEP;W=O5Q255(;LKE;0$Z7A:LY2#@_"+)TW#<*L*JYC
M\IK?B8)#C]R=B3(3Y<(J3F5I5)T:J30)WMLU2\59IMF<FQ6<PA!ZI32@:\7!
M+(4&_,4#W,:-Y3E42MZ+C--Q5HD<C<[QV#Z&=G]OMV**%=JL<DZT+P53G_=)
M20^#4NJU8K(/$=[,A![V=JW%`97^.*HVK*@V69;H9%TJ6=R)]+/>%-HRG)Q'
M<1U&H.^;X"[7A3'C<PI1P4Q4]4_V=G?$')9,,V-45,6'EY9U:#D[BIM:E5 E
MCAKM'WQZ<5"\.,C at X'\G!^]/#F[W^XCCN>8=O->38_*9I9PWFHQ:A3#D(H/.
M?TUY94+61);<F=L[%R53=.&S>C[GRE'3G&D-MP83A:GL0BFIH at LK!7/1ZJH0
MX'&8P"6F5=3!;Z&<E*<Q8Y_0C<I'0;Z2OX=Q_ YZ"W=5<<7(*98_!T[V+; )
MK)X+5L\4?*WD`BNFP# ^!SZ1YK:NJ-!Y]C1^?9NC<^Q\=]@6KF;_YZE-!\JA
MZ524PDRGD>;Y//[IGN4UURX]B9(X`N:'>VA/I47E#TFSY$XG);M]`U%"<-SR
M?/(-.L!?OHD;TDN;^Y[ZPO;!V[N;\>17JL>N5Y&%X@\,CWZ.H<>R=TNF6N+1
M8&B)O\ER\3M3'=[;&(!XYRB[);XYBBWQUP_CT5KTP!%MK /9+T/9'SO"AR\'
M]DB7BL5Y/IZ<W7QZVI&W5JXKU$#=L26CJBW.*P@,V>"BSLF']^<7-T_J/'8>
MCG at J"I:W]%=-C$82YQUOR2\;LBT/'G@]=&+.I<PY*UOZZP;_KE8X/]-5$"9W
M/Y.ZX$JD+?VX.7"+]1'H/?)DM#%'Y6LYKYWB.U&N0OI18]"'4HM%R3&FB\ZQ
MG[OL#N]ME[>M\PUT`)NZ,?"CL[N+N_'[BZ="_\:'V$["-BXNMT;G&^3CANPF
M9$M^%9!OW71L>/#ZV(J_Q(G=.01DX,W5Q_'H*>M0]NNFJBKL;K at Y@=T2I%L4
MV$S6QJT+.&&2)/$'^V$GPA6 at 1*G8=2.[R"1K0M^WI=217(.!3)<QU+ at WQ4!M
M[4&J+&A1LL))]QBDE86-U8D*3CGJ':Y>.O)()?-\QM+/FUA/[Z+36FELO<[$
MDA7\]! '.] I9&$8WSD`L?H--6'HYSU?>XPPJP(C(6VP at S&-^"!J3IB/6%'@
M((W=VPU/T5W-3?_QKKXVCH1W)"0=9!_OENZ/PXPO! UU$.90`[,Q1'C3NDD>
M_' *AX>N-UL/+/'4\MK T6J[TN(O8 at Q;:L9UJD35N.^6D3;2#ZFL2X-TZO0N
MSEAIN&VFC3/T2$IB^,FNF1P3,9Q8_"M/:\.C-6X-B^'8WYZ'.:'2+P(A^O2/
M/V/O.57#Z7 C?XC.OY*Q[?DM/IY#?O#F+MC>&#+\-+3;VMH=^"\,7&S71$07
MK(K<=AG:V7<#4B.Q$\38QG8KPY*+QO7&BBU1P=#=DOE=:?W&(3R:7 J>9QIS
MC0YBO at R:;QYCN1=7ET'Z3%.F381T3,*)?,#$PR3$L'%*/^4SW.+]HKN=,^[=
M at JU2BPKVWYUF+=K9SD2\;$NG[QM!^PO6^L*E1S(/_. at W@BS-JVP`8\.+2+CK
MV&GJP;*2"?.]EK[,IJG,^"-]UF&)T,C(A*YRMIHV)>3X(SX7-(&0YE"BV32[
ML+/4U"Q?HRJ,B]"NYASBVE.:8&*A!1:[&7Q+Q,:A.L^G\O-:`7[3B!E>O88?
M8?#U:& '2YZ-]021K-T0-B.=L H[=A9%KCK;@&"?#]R-H>-6[$>)G4.M+YB=
M9""V.&=<?Z.\L>A6VR6N^9>IG$_#OO"OE+E%H*VHB&>^!6[4/N5;4.-V<=ZP
M+JB29Q>Q_0[E)EUB!PC&65LZ6*%6(!4A=#X+NP6SP<J%ICBX6GFL5"ZW2X7.
M^#L/,4VU)+_3[M]OXU7(>S[!<-LYZ_6;NLIY1)(ZS at 772TER.F@_0UPI8(Q/
MFD?H#J0M9X2_$&PG;5G[`%I3'I:X-$%$?%QPJ(M15/JVIT6"OF10[B,^XP%7
MSJ1"P']<&GQ;C_]^1Q&AKS@%@XOLV/X=DS<L?L+"?V 3-F-15K4AIW5P!^$H
MGMK2I52W_]<G<4ULC at 8GJ0CSNL E$'J026XM7M(20HE6R@>2ZS]KPR41=S_<
M;F+:_NB_W__\QI.6U/*"K;/OB$EP_K'=T6]A)5;[WU!+`0(4`!0``@`(`%QO
MW"@DOGOS3 0``(P-```(``````````$```"V at 0````!!1$]P>2YP>5!+`0(4
M`!0``@`(`&MBY2@&<?YJ'P<``&\4```*``````````$`( "V at 7($``!!1$]$
<0G!Y+G!Y4$L%!@`````"``(`;@```+D+````````
`
end




More information about the Python-list mailing list