pydb2-discuss

Re: [PyDB2-discuss] New release on sourceforge?

[??? <yo...@li...>]

T2gsIEkndmUgZm9yZ290IHRvIGZpeCB0aGUgbm90b3Jpb3VzIHRpbWVzdGFtcCBidWcgYWJvdXQg
dGhlIGZyYWN0aW9uIHBhcnQgIDotKA0KDQpJIHRoaW5rIEkndmUgZml4ZWQgdGhlIGJ1ZyByaWdo
dCBub3cgYW5kIHVwbG9hZGVkIHRvIHRoZSBzYW1lIHBsYWNlLg0KWW91IGNhbiBnZXQgYnkgYW5v
bnltb3VzIGZ0cCBhdCBwZW9wbGUubGludXhrb3JlYS5jby5rci9wdWIvREIyL3NyYy4NClRoZSBm
aWxlbmFtZSBpcyB0aGUgc2FtZSBhcyB0aGUgcHJldmlvdXMgb25lLg0KDQpDYW4geW91IHBsZWFz
ZSBjaGVjayB0aGlzIGZvciBtZT8NCg0KVGhhbmtzLg0KDQpGWUksIEkndmUgaW5jbHVkZSB0aGUg
dWdseSBwYXJ0IHJlbGF0ZWQgdG8gdGltZXN0YW1wIHN0cmluZyBidWlsZGluZzoNCg0KICAgICAg
ICBjYXNlIFNRTF9DX1RZUEVfVElNRVNUQU1QOg0KICAgICAgICAgICAgICAgIHRpbWVzdGFtcFN0
ID0gKihUSU1FU1RBTVBfU1RSVUNUICopKGJ1Zik7DQogICAgICAgICAgICAgICAgc2l6ZSA9IDI2
ICsgMTsNCiAgICAgICAgICAgICAgICB0ZW1wU3RyID0gKGNoYXIgKikgTVlfTUFMTE9DKHNpemUp
Ow0KICAgICAgICAgICAgICAgIG1lbXNldCh0ZW1wU3RyLCAwLCBzaXplKTsNCiAgICAgICAgICAg
ICAgICBzcHJpbnRmKHRlbXBTdHIsDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICIl
MDRkLSUwMmQtJTAyZC0lMDJkLiUwMmQuJTAyZC4iLA0KICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICB0aW1lc3RhbXBTdC55ZWFyLA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICB0aW1lc3RhbXBTdC5tb250aCwNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdGlt
ZXN0YW1wU3QuZGF5LA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB0aW1lc3RhbXBT
dC5ob3VyLA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB0aW1lc3RhbXBTdC5taW51
dGUsDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRpbWVzdGFtcFN0LnNlY29uZCk7
DQoNCiAgICAgICAgICAgICAgICAvKiBmZmZmZmYgcGFydCAqLw0KDQogICAgICAgICAgICAgICAg
ZnJhY3Rpb25QYXJ0ID0gKGNoYXIgKilNWV9NQUxMT0Moc2l6ZSk7DQogICAgICAgICAgICAgICAg
bWVtc2V0KGZyYWN0aW9uUGFydCwgMCwgc2l6ZSk7DQogICAgICAgICAgICAgICAgc3ByaW50Zihm
cmFjdGlvblBhcnQsICIlMDlkIiwgKHVuc2lnbmVkIGludCl0aW1lc3RhbXBTdC5mcmFjdGlvbik7
DQogICAgICAgICAgICAgICAgZnJhY3Rpb25QYXJ0WzZdID0gJ1wwJzsNCiAgICAgICAgICAgICAg
ICBzdHJjYXQodGVtcFN0ciwgZnJhY3Rpb25QYXJ0KTsNCg0KICAgICAgICAgICAgICAgIC8qIHZh
bCA9IFB5U3RyaW5nX0Zyb21TdHJpbmdBbmRTaXplKHRlbXBTdHIsIDI2KTsgKi8gLyogcGFyYW5v
aWQ/ICovDQogICAgICAgICAgICAgICAgdmFsID0gUHlTdHJpbmdfRnJvbVN0cmluZyh0ZW1wU3Ry
KTsNCg0KICAgICAgICAgICAgICAgIE1ZX0ZSRUUodGVtcFN0cik7DQogICAgICAgICAgICAgICAg
TVlfRlJFRShmcmFjdGlvblBhcnQpOw0KDQogICAgICAgICAgICAgICAgYnJlYWs7DQoNCiAgLS0t
LS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLSANCiAgRnJvbTogSmFjbyBTbXV0cyANCiAgVG86ID8/
PyANCiAgQ2M6IERhbiBTY290dCA7IHB5ZGIyLWRpc2N1c3NAbGlzdHMuc291cmNlZm9yZ2UubmV0
IDsgcHlkYjItZGlzY3Vzcy1hZG1pbkBsaXN0cy5zb3VyY2Vmb3JnZS5uZXQgDQogIFNlbnQ6IFdl
ZG5lc2RheSwgTWFyY2ggMDksIDIwMDUgMTozMCBBTQ0KICBTdWJqZWN0OiBSZTogW1B5REIyLWRp
c2N1c3NdIE5ldyByZWxlYXNlIG9uIHNvdXJjZWZvcmdlPw0KDQoNCg0KICBJIGtub3cgbGl0dGxl
IGFib3V0IEMsIGJ1dCBJJ2xsIGdsYWRseSB0ZXN0IGl0IHVzaW5nIHNvbWUgZGIyIHNjcmlwdHMg
SSB1c2UgYXQgd29yayANCg0KICBkb2VzIHRoaXMgY29kZWJhc2UgYWRkcmVzcyB0aGUgdGltZXN0
YW1wIGlzc3VlICh0aGVyZSBpcyBhIHBhdGNoIGZvciBpdCkgPyANCg0KDQoNCg0KICAgICAgICAi
Pz8/IiA8eW9uZ0BsaW51eGtvcmVhLmNvLmtyPiANCiAgICAgICAgU2VudCBieTogcHlkYjItZGlz
Y3Vzcy1hZG1pbkBsaXN0cy5zb3VyY2Vmb3JnZS5uZXQgDQogICAgICAgIDIwMDUvMDMvMDggMDI6
MjkgUE0gDQogICAgICAgVG8gIkRhbiBTY290dCIgPGRlbmlhbHNAZ21haWwuY29tPiwgPHB5ZGIy
LWRpc2N1c3NAbGlzdHMuc291cmNlZm9yZ2UubmV0PiAgDQogICAgICAgICAgICAgIGNjICANCiAg
ICAgICAgICAgICAgU3ViamVjdCBSZTogW1B5REIyLWRpc2N1c3NdIE5ldyByZWxlYXNlIG9uIHNv
dXJjZWZvcmdlPyANCg0KICAgICAgICAgICAgICANCg0KICAgICAgIA0KDQoNCg0KICBIaX4gZXZl
cnlvbmUsDQoNCiAgSSd2ZSBqdXN0IHJlZmFjdG9yZWQgdGhlIG1vZHVsZSBhbmQgdXBsb2FkZWQg
dG8gZnRwOi8vcGVvcGxlLmxpbnV4a29yZWEuY28ua3IvcHViL0RCMi9zcmMuDQogIENhbiB5b3Ug
cGxlYXNlIHJldmlldyB0aGUgc291cmNlIGNvZGU/DQoNCiAgSSdtIHN1cmUgdGhhdCB0aGlzIHZl
cnNpb24gaXMgbXVjaCBiZXR0ZXIgdGhhbiB0aGUgcHJldmlvdXMgb25lLg0KICBJdCBpbmNsdWRl
cyB1bml0dGVzdCBjb2RlIG5vdy4NCg0KICBTb29uZXIgb3IgbGF0ZXIsIEkgd291bGQgbGlrZSB0
byB1cGxvYWQgdGhpcyB2ZXJzaW9uIHRvIHNmLm5ldC4NCg0KICAtLS0tLSBPcmlnaW5hbCBNZXNz
YWdlIC0tLS0tIA0KICBGcm9tOiAiRGFuIFNjb3R0IiA8ZGVuaWFsc0BnbWFpbC5jb20+DQogIFRv
OiA8cHlkYjItZGlzY3Vzc0BsaXN0cy5zb3VyY2Vmb3JnZS5uZXQ+DQogIFNlbnQ6IFR1ZXNkYXks
IEZlYnJ1YXJ5IDAxLCAyMDA1IDY6MjAgQU0NCiAgU3ViamVjdDogUmU6IFtQeURCMi1kaXNjdXNz
XSBOZXcgcmVsZWFzZSBvbiBzb3VyY2Vmb3JnZT8NCg0KDQogID4gT24gTW9uLCAzMSBKYW4gMjAw
NSAxNzoxMjowMCArMDkwMCwgPz8/IDx5b25nQGxpbnV4a29yZWEuY28ua3I+IHdyb3RlOg0KICA+
PiBIaSBEYW4sDQogID4+IA0KICA+PiAtLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tDQogID4+
IEZyb206ICJEYW4gU2NvdHQiIDxkZW5pYWxzQGdtYWlsLmNvbT4NCiAgPj4gVG86IDxweWRiMi1k
aXNjdXNzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldD4NCiAgPj4gU2VudDogU3VuZGF5LCBKYW51YXJ5
IDMwLCAyMDA1IDU6MjQgQU0NCiAgPj4gU3ViamVjdDogUmU6IFtQeURCMi1kaXNjdXNzXSBOZXcg
cmVsZWFzZSBvbiBzb3VyY2Vmb3JnZT8NCiAgPj4gDQogID4+IA0KICA+PiA+IEhpIFl1dmFsLCBN
YW4tWW9uZzoNCiAgPj4gPg0KICA+PiA+IEFueSBjaGFuY2Ugb2YgdGhhdCAxLjAgcmVsZWFzZSBo
YXBwZW5pbmc/DQogID4+IA0KICA+PiBZdXZhbCwgSSB3YW50IHlvdSB0byByZWxlYXNlIDEuMC4g
IEluIGZhY3QsIEkgZG9uJ3Qga25vdyBob3cgdG8gcmVsZWFzZSBhIG5ldyB2ZXJzaW9uIGluIHNm
Lm5ldC4NCiAgPiANCiAgPiBZdXZhbCwgd2hlbiB5b3UgY3JlYXRlIHRoZSByZWxlYXNlLCBsZXQg
bWUga25vdyBhbmQgSSdsbCB1cGRhdGUgdGhlDQogID4gUHl0aG9uIFBhY2thZ2UgSW5kZXggZW50
cnkgZm9yIHRoZSBwcm9qZWN0Lg0KICA+IA0KICA+PiA+IEFsc28sIGl0IHdvdWxkIGJlIGEgcmVh
bGx5IG5pY2UgZm9sbG93LXVwIGlmIE1hbi1Zb25nIGNvdWxkIHByb2R1Y2UNCiAgPj4gPiB0aGUg
d2luMzIgYmluYXJpZXMgZm9yIHRoZSByZWxhdGl2ZWx5IHJlY2VudCBQeXRob24gMi40IHJlbGVh
c2UuDQogID4+IA0KICA+PiBTdXJlLg0KICA+IA0KICA+IEV4Y2VsbGVudCENCiAgPiANCiAgPj4g
PiBXaGVuIHlvdSBzdGFydCBkZXZlbG9waW5nIHRoZSAxLjEgYnJhbmNoLCB3b3VsZCB5b3UgY29u
c2lkZXINCiAgPj4gPiBpbnN0aXR1dGluZyBhIGJhc2ljIENvbnRyaWJ1dG9yIExpY2Vuc2UgQWdy
ZWVtZW50IChDTEEpIGxpa2UgRWNsaXBzZQ0KICA+PiA+IGFuZCBBcGFjaGUgZG8/IFRoZSBDTEEg
aXMgYSBsZWdhbCBwcm9jZXNzIHRoYXQgYXNrcyB3b3VsZC1iZQ0KICA+PiA+IGNvbnRyaWJ1dG9y
cyAmIHRoZSBjb250cmlidXRvcnMnIGVtcGxveWVycyB0byBzaWduIG9mZiBvbiBhIGZvcm0NCiAg
Pj4gPiBzdGF0aW5nIHRoYXQgdGhlIGNvZGUgdGhleSBhcmUgY29udHJpYnV0aW5nIGlzIHJpZ2h0
ZnVsbHkgdGhlaXJzIHRvDQogID4+ID4gY29udHJpYnV0ZSAtLSBiYXNpY2FsbHkgYSB3YXkgb2Yg
YXZvaWRpbmcgYW55IGNvbnRyaWJ1dGlvbnMgZnJvbSBzaGFkeQ0KICA+PiA+IHNvdXJjZXMuDQog
ID4+ID4NCiAgPj4gPiBNeSBlbXBsb3llciBpcyBhIGJpdCB3YXJ5IG9mIHByb2plY3RzIHRoYXQg
ZG9uJ3QgaGF2YSBhIENMQSBwcm9jZXNzLA0KICA+PiA+IHNvIEkgY2FuJ3QgYmUgdG9vIHVzZWZ1
bCB0byB0aGUgZWZmb3J0IHdpdGhvdXQgaXQgOiggVW5sZXNzIHlvdSBjYWxsDQogID4+ID4gc2Vu
ZGluZyByZXF1ZXN0cyBhbmQgbGl0dGxlIHJlbWluZGVyIG5vdGVzIHRvIHRoZSBtYWlsaW5nIGxp
c3QNCiAgPj4gPiB1c2VmdWwuLi4NCiAgPj4gPg0KICA+PiA+IERhbg0KICA+PiANCiAgPj4gT2Yg
Y291cnNlIQ0KICA+IA0KICA+IFRoYXQncyBncmVhdCEgRm9yIGZ1cnRoZXIgaW5mb3JtYXRpb24g
b24gdGhlIENvbnRyaWJ1dG9yIExpY2Vuc2luZw0KICA+IEFncmVlbWVudCAoUHl0aG9uIGl0c2Vs
ZiBhZG9wdGVkIGEgQ0xBIHByb2Nlc3MgZWFybGllciB0aGlzIG1vbnRoKSB5b3UNCiAgPiBjYW4g
bG9vayBhdCBodHRwOi8vd3d3LnB5dGhvbi5vcmcvcHNmL2NvbnRyaWIuaHRtbA0KICA+IA0KICA+
IFRoaXMgaXMgcmVhbGx5IGV4Y2l0aW5nOyB3aXRoIHRoZXNlIHN0ZXBzIGluIHBsYWNlIEkgdGhp
bmsgdGhpcw0KICA+IHByb2plY3Qgd2lsbCByZWFsbHkgdGFrZSBvZmYgYW5kIGJlY29tZSBtb3Jl
IGFjdGl2ZSBhZ2Fpbi4NCiAgPiANCiAgPiANCiAgPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogID4gVGhpcyBTRi5OZXQgZW1haWwgaXMg
c3BvbnNvcmVkIGJ5OiBJbnRlbGxpVklFVyAtLSBJbnRlcmFjdGl2ZSBSZXBvcnRpbmcNCiAgPiBU
b29sIGZvciBvcGVuIHNvdXJjZSBkYXRhYmFzZXMuIENyZWF0ZSBkcmFnLSYtZHJvcCByZXBvcnRz
LiBTYXZlIHRpbWUNCiAgPiBieSBvdmVyIDc1JSEgUHVibGlzaCByZXBvcnRzIG9uIHRoZSB3ZWIu
IEV4cG9ydCB0byBET0MsIFhMUywgUlRGLCBldGMuDQogID4gRG93bmxvYWQgYSBGUkVFIGNvcHkg
YXQgaHR0cDovL3d3dy5pbnRlbGxpdmlldy5jb20vZ28vb3Nkbl9ubA0KICA+IF9fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQogID4gUHlEQjItZGlzY3VzcyBt
YWlsaW5nIGxpc3QNCiAgPiBQeURCMi1kaXNjdXNzQGxpc3RzLnNvdXJjZWZvcmdlLm5ldA0KICA+
IGh0dHBzOi8vbGlzdHMuc291cmNlZm9yZ2UubmV0L2xpc3RzL2xpc3RpbmZvL3B5ZGIyLWRpc2N1
c3MNCiAgPiANCg==

Re: [PyDB2-discuss] New release on sourceforge?

[Dan S. <de...@gm...>]

Attached is a small patch for setup.py to hopefully improve the build
experience on both Windows and on UNIX (DB2DIR is the environment
variable exported by ~/sqllib/db2profile, and because DB2 allows you
to install into any directory on Windows I thought it made sense to
support alternate install directories using the same mechanism).

Now to actually put the code through its paces :)

Dan

On 3/8/05, ??? <yo...@li...> wrote:
> =20
> Oh, I've forgot to fix the notorious timestamp bug about the fraction par=
t=20
> :-(=20
>  =20
> I think I've fixed the bug right now and uploaded to the same place.=20
> You can get by anonymous ftp at
> people.linuxkorea.co.kr/pub/DB2/src.=20
> The filename is the same as the previous one.=20
>  =20
> Can you please check this for me?=20
>  =20
> Thanks.=20
>  =20
> FYI, I've include the ugly part related to timestamp string building:=20
>  =20
>         case SQL_C_TYPE_TIMESTAMP:
>                 timestampSt =3D *(TIMESTAMP_STRUCT *)(buf);
>                 size =3D 26 + 1;
>                 tempStr =3D (char *) MY_MALLOC(size);
>                 memset(tempStr, 0, size);
>                 sprintf(tempStr,
>                               =20
> "%04d-%02d-%02d-%02d.%02d.%02d.",
>                                 timestampSt.year,
>                                 timestampSt.month,
>                                 timestampSt.day,
>                                 timestampSt.hour,
>                                 timestampSt.minute,
>                                 timestampSt.second);=20
>  =20
>                 /* ffffff part */=20
>  =20
>                 fractionPart =3D (char *)MY_MALLOC(size);
>                 memset(fractionPart, 0, size);
>                 sprintf(fractionPart, "%09d", (unsigned
> int)timestampSt.fraction);
>                 fractionPart[6] =3D '\0';
>                 strcat(tempStr, fractionPart);=20
>  =20
>                 /* val =3D
> PyString_FromStringAndSize(tempStr, 26); */ /* paranoid? */
>                 val =3D PyString_FromString(tempStr);=20
>  =20
>                 MY_FREE(tempStr);
>                 MY_FREE(fractionPart);=20
>  =20
>                 break;
> =20
> =20
> ----- Original Message -----=20
> From: Jaco Smuts=20
> To: ???=20
> Cc: Dan Scott ; pyd...@li... ;
> pyd...@li...=20
> Sent: Wednesday, March 09, 2005 1:30 AM=20
> Subject: Re: [PyDB2-discuss] New release on sourceforge?=20
>=20
>=20
> I know little about C, but I'll gladly test it using some db2 scripts I u=
se
> at work=20
>=20
> does this codebase address the timestamp issue (there is a patch for it) =
?=20
>=20
>=20
>=20
>=20
> =20
>  "???" <yo...@li...>=20
> Sent by: pyd...@li...=20
>=20
> 2005/03/08 02:29 PM=20
> =20
> To "Dan Scott" <de...@gm...>,
> <pyd...@li...>=20
> =20
> cc=20
> =20
> Subject Re: [PyDB2-discuss] New release on sourceforge?
> =20
> =20
>=20
>=20
>=20
> Hi~ everyone,
>=20
> I've just refactored the module and uploaded to
> ftp://people.linuxkorea.co.kr/pub/DB2/src.
> Can you please review the source code?
>=20
> I'm sure that this version is much better than the previous one.
> It includes unittest code now.
>=20
> Sooner or later, I would like to upload this version to sf.net.
>=20
> ----- Original Message -----=20
> From: "Dan Scott" <de...@gm...>
> To: <pyd...@li...>
> Sent: Tuesday, February 01, 2005 6:20 AM
> Subject: Re: [PyDB2-discuss] New release on sourceforge?
>=20
>=20
> > On Mon, 31 Jan 2005 17:12:00 +0900, ??? <yo...@li...> wrote:
> >> Hi Dan,
> >>=20
> >> ----- Original Message -----
> >> From: "Dan Scott" <de...@gm...>
> >> To: <pyd...@li...>
> >> Sent: Sunday, January 30, 2005 5:24 AM
> >> Subject: Re: [PyDB2-discuss] New release on sourceforge?
> >>=20
> >>=20
> >> > Hi Yuval, Man-Yong:
> >> >
> >> > Any chance of that 1.0 release happening?
> >>=20
> >> Yuval, I want you to release 1.0.  In fact, I don't know how to releas=
e a
> new version in sf.net.
> >=20
> > Yuval, when you create the release, let me know and I'll update the
> > Python Package Index entry for the project.
> >=20
> >> > Also, it would be a really nice follow-up if Man-Yong could produce
> >> > the win32 binaries for the relatively recent Python 2.4 release.
> >>=20
> >> Sure.
> >=20
> > Excellent!
> >=20
> >> > When you start developing the 1.1 branch, would you consider
> >> > instituting a basic Contributor License Agreement (CLA) like Eclipse
> >> > and Apache do? The CLA is a legal process that asks would-be
> >> > contributors & the contributors' employers to sign off on a form
> >> > stating that the code they are contributing is rightfully theirs to
> >> > contribute -- basically a way of avoiding any contributions from sha=
dy
> >> > sources.
> >> >
> >> > My employer is a bit wary of projects that don't hava a CLA process,
> >> > so I can't be too useful to the effort without it :( Unless you call
> >> > sending requests and little reminder notes to the mailing list
> >> > useful...
> >> >
> >> > Dan
> >>=20
> >> Of course!
> >=20
> > That's great! For further information on the Contributor Licensing
> > Agreement (Python itself adopted a CLA process earlier this month) you
> > can look at http://www.python.org/psf/contrib.html
> >=20
> > This is really exciting; with these steps in place I think this
> > project will really take off and become more active again.

Re: [PyDB2-discuss] New release on sourceforge?

[Jaco S. <jac...@cl...>]

--- setup.py	2005-06-29 09:32:27.316161600 -0400=0A+++ setup.py.new	2005-07=
-04 18:30:35.035497600 -0400=0A@@ -8,23 +8,23 @@=0A import sys=0A import os=
=0A =0A-# specifiy your DB2 root if auto-find doesn't work=0A+# specify you=
r DB2 root if auto-find doesn't work=0A # (with trailing /)=0A-# ex) DB2=5F=
ROOT =3D "/opt/IBM/db2/V8.1/"=0A-DB2=5FROOT =3D ""=0A+# ex) DB2DIR =3D "/op=
t/IBM/db2/V8.1/"=0A+DB2DIR =3D os.environ['DB2=5FHOME']=0A =0A-def get=5Fdb=
2=5Froot():=0A-	for v in [ '/opt/IBM/db2', '/usr/IBMdb2' ]:=0A+def get=5Fdb=
2=5Froot(dirs =3D [ '/opt/IBM/db2', '/usr/IBMdb2' ]):=0A+	for v in dirs:=0A=
 		if os.path.exists(v):=0A 			files =3D os.listdir(v)=0A 			for vv in file=
s:=0A 				if vv[:1] =3D=3D "V" and vv.find(".") > 0:=0A 					return "%s/%s/=
" % (v, vv)=0A 	else:=0A-		return DB2=5FROOT=0A+		return DB2DIR=0A =0A if s=
ys.platform[:5] =3D=3D 'win32': # Win32=0A-	db2=5Froot=5Fdir =3D 'C:\\Progr=
am Files\\SQLLIB\\'=0A+	db2=5Froot=5Fdir =3D get=5Fdb2=5Froot(['C:/Program =
Files/SQLLIB/'])=0A 	db2lib =3D 'db2cli'=0A else:=0A 	db2=5Froot=5Fdir =3D =
get=5Fdb2=5Froot()=0A=