Re: [DB-SIG] Some obscurity with paramstyle

2011-07-24 Thread William
. It's not a bottleneck since the parsing is done only one time. -- William Dodé - http://flibuste.net Informaticien Indépendant ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

Re: [DB-SIG] Forking ADODBAPI

2005-10-14 Thread William Dode
om/) Don't you think that it's a little bit overkill for such a litle project ? What if tomorow we must change again ? it can be difficult to find a trac hosting with svn... I'm +1 to try everything to stay at sourceforge. If cvs is not enough we can switch to bazaar-ng to nev

[DB-SIG] adodbapi and cvtMoney

2005-11-30 Thread William Dode
d to hack the cvtMoney function to can get theses decimals. Is it a bug of adodbapi or a bug in the database definition ? -- William Dodé - http://flibuste.net ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

[DB-SIG] how to know the connexion is closed

2006-04-22 Thread William Dode
Hi, I search for a generic way (for psycopg, mysqldb, adodbapi) to know that the connexion is closed, for example because the database server was restarted. I mean for wich database exceptions should i ask again for a connexion ? thanks -- William Dodé - http://flibuste.net

Re: [DB-SIG] how to know the connexion is closed

2006-04-25 Thread William Dode
On 24-04-2006, Dieter Maurer wrote: > William Dode wrote at 2006-4-22 18:53 +: >>I search for a generic way (for psycopg, mysqldb, adodbapi) to >>know that the connexion is closed > > I fear there is no generic way > ok... so, perhaps a solution for postgresql with

Re: [DB-SIG] how to know the connexion is closed

2006-04-25 Thread William Dode
On 24-04-2006, Bill Campbell wrote: > On Mon, Apr 24, 2006, Dieter Maurer wrote: >>William Dode wrote at 2006-4-22 18:53 +: >>>I search for a generic way (for psycopg, mysqldb, adodbapi) to >>>know that the connexion is closed >> >>I fear there is no gene

Re: [DB-SIG] How to pass parameter with LIKE

2006-10-25 Thread William Dode
31103e1, 31103a5, 31103e5 you want to do select mrc_code from blocks where mrc_code in ('31103a1', '31103e1', '31103a5', '31103e5') isnt'it ? -- William Dodé - http://flibuste.net ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

Re: [DB-SIG] questions for Python Database API Specification v2.0

2007-09-10 Thread William Dode
sample code for that. > > If you have it, Could you kindly let me know about it, please? You should look at http://pyodbc.sourceforge.net/ -- William Dodé - http://flibuste.net Informaticien indépendant ___ DB-SIG maillist - DB-SIG@python.org htt

[DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
Hi, How should i do to make adodbapi return datetime instead of mx.DateTime? I tried import adodbapi adodbapi.dateconverter = adodbapi.pythonDateTimeConverter() Maybe i didn't test well, but it doesn't seems to work... thanks -- William Dodé - http://flibuste.net Informaticien I

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
On 10-02-2009, Vernon Cole wrote: > William: > It has always seemed to me that the syntax you tried should work. Perhaps > someday, some "real" Python guru will explain to me why sometimes it does > not, and maybe even tell me how to fix it. Perhaps the module definition is

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
installed or not is enough to change this in a minor version. The question will be, what to do if the release stay compatible with python < 2.3 iirc Guido argued to put this (datetime by default) in the dbapi spec isn'it ? -- William Dodé - http://flibuste.

Re: [DB-SIG] adodbapi return datetime

2009-02-10 Thread William Dode
On 10-02-2009, M.-A. Lemburg wrote: > On 2009-02-10 18:42, William Dode wrote: >> On 10-02-2009, Robert Brewer wrote: >>> Vernon Cole wrote: >>>> Should adodbapi be changed so that datetime.datetime is >>>> the default return type for SQL date-time colum

[DB-SIG] adodbapi 2.4 : not possible to pickle

2010-10-19 Thread William Dode
Hi, Since adodbapi 2.4 it's not more possible to pickle a recordset when there is a datetime column in the result. I've digged, it's because PyTime object are kept in _SQLRow Is there a workaround ? thanks -- William Dodé - http://flibuste.net Informatic

Re: [DB-SIG] adodbapi 2.4 : not possible to pickle

2010-10-21 Thread William Dode
rows, like your SQLRows, maybe it could be fine to can choose to use it or not ? -- William Dodé - http://flibuste.net Informaticien Indépendant ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

[DB-SIG] mogrify/query for adodbapi

2011-02-13 Thread William Dode
tabases ? bye thanks to read my bad english... -- William Dodé - http://flibuste.net Informaticien Indépendant ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-13 Thread William Dode
abase running the execute() method or similar. >>> cur.mogrify("INSERT INTO test (num, data) VALUES (%s, %s)", (42, 'bar')) "INSERT INTO test (num, data) VALUES (42, E'bar')" I use to log it and some times use it to copy and paste. -- William Dodé http://flibuste.net Informaticien Indépendant ___ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-14 Thread William Dode
On 14-02-2011, M.-A. Lemburg wrote: > William Dode wrote: >> On 13-02-2011, Vernon Cole wrote: >>> --===0804799855== >>> Content-Type: multipart/alternative; boundary=0016e644df66158a5b049c2cec40 >>> >>> --0016e644df66158a5b049c2cec40 >

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-15 Thread William Dode
--enig8B948CD4F063A9F68C5802DF" > > This is an OpenPGP/MIME signed message (RFC 2440 and 3156) > --enig8B948CD4F063A9F68C5802DF > Content-Type: text/plain; charset=UTF-8 > Content-Transfer-Encoding: quoted-printable > > [snip] > On 14/02/11 15:49, William Dode wro

[DB-SIG] pg_proboscis 1.0 Released

2008-06-08 Thread James William Pye
pg_proboscis 1.0 has been released. pg_proboscis is a Python programmer's client for PostgreSQL(driver/interface). See [far] below for code examples. Project Site: http://python.projects.postgresql.org/?utm_source=release&utm_medium=email&utm_campaign=pg_proboscis-1.0 It distinguishes itself

[DB-SIG] py-postgresql 0.9 Released: Speed & Query Libraries

2009-06-16 Thread James William Pye
I'm pleased to announce the release of py-postgresql 0.9.0 and 0.8.2. py-postgresql is a Python programmer's client (driver) for PostgreSQL and general toolkit for working with PostgreSQL in Python. http://python.projects.postgresql.org/?utm_source=release&utm_medium=email&utm_campaign=p

[DB-SIG] [ANNOUNCE] py-postgresql v1.0 released

2010-03-30 Thread James William Pye
I'm pleased to announce the release of py-postgresql version 1.0, the pure Python 3 driver for PostgreSQL formerly known as 'pg_proboscis'. Highlights: * CopyManager for connection-to-connection COPY operations. * NotificationManager for receiving asynchronous notifications with payloads. * Advis

Re: [DB-SIG] conn.close() idempotence

2011-11-20 Thread James William Pye
On Oct 18, 2011, at 10:36 PM, Michael Bayer wrote: > I'm +1 for close() on a closed connection being harmless. rollback() already > has this behavior, as the spec specifies "rolls back the start of any pending > transaction", thus allowing for no activity if no transaction is present. yep.. +1