Hmmm... pickle was one thing I failed to consider when I changed the adodbapi .fetchxxx methods to return a sequence-like object (_SQLrow) rather than an actual tuple. Since I have never had the need to use pickle, I have never tested it. Frankly, it never occurred to me that one would ever want to serialize data which just came in from a data base.<br>
<br> As you have noticed, data in an _SQLrow object are not converted into Python types until extracted from the object by its _getValue() method. In previous versions, the conversion was done before you received the data.<br>
<br> The quickest workaround would be (in your code) to simply call tuple() on the returned row object before pickling it. That should give the same result as before, when tuple() was called internally.<br><br> If this is something which is done frequently, then a perhaps a suitable method should be added to the class definition of _SQLrow() so that pickle would work on it directly. Is __getstate__() what one uses for this?<br>
--<br>Vernon<br><br><div class="gmail_quote">On Tue, Oct 19, 2010 at 7:57 AM, William Dode <span dir="ltr"><<a href="mailto:wilk@flibuste.net">wilk@flibuste.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi,<br>
<br>
Since adodbapi 2.4 it's not more possible to pickle a recordset when<br>
there is a datetime column in the result. I've digged, it's because<br>
PyTime object are kept in _SQLRow<br>
<br>
Is there a workaround ?<br>
<br>
thanks<br>
<font color="#888888"><br>
--<br>
William Dodé - <a href="http://flibuste.net" target="_blank">http://flibuste.net</a><br>
Informaticien Indépendant<br>
<br>
_______________________________________________<br>
DB-SIG maillist - <a href="mailto:DB-SIG@python.org">DB-SIG@python.org</a><br>
<a href="http://mail.python.org/mailman/listinfo/db-sig" target="_blank">http://mail.python.org/mailman/listinfo/db-sig</a><br>
</font></blockquote></div><br>