raf wrote:
> Hi,
>
> Having just started looking at pygresql-5+ (python-2.7),
> I have another question.
>
> How do I suppress the conversion of timestamp with time zone values
> from a string to a datetime.datetime object with a pgdb.timezone object
> as the tzinfo? I want to parse them myself and use my own choice of tzinfo.
>
> Based on the changelog and looking at pgdb.py, I tried the following but
> none of them worked:
>
> pgdb.set_typecast('timestamp', None)
> pgdb.set_typecast('timestamptz', None) # I expected this one to work
> pgdb.set_typecast('timestamp with time zone', None)
>
> Here's what I tried:
>
> #!/usr/bin/env python
> import pgdb
> try: pgdb.set_typecast('timestamptz', None)
> except AttributeError: pass
> connection = pgdb.connect(host='XXX', database='XXX', user='XXX',
> password='XXX')
> cursor = connection.cursor()
> cursor.execute("select cast('2016-01-01 12:22:22+11' as timestamp with time
> zone)")
> rows = cursor.fetchall()
> print('%r' % rows[0][0])
> # pygresql-4.2.2 outputs '2016-01-01 12:22:22+11' (which then needs to be
> parsed)
> # pygresql-5.0.1 outputs datetime.datetime(2016, 1, 1, 12, 22, 22,
> tzinfo=<pgdb.timezone object at 0x11461f0>)
>
> Any suggestions?
>
> cheers,
> raf
Even though the changelog doumentation says that
set_typecast() with None as the second argument is
how to deactivate typecast functions, this isn't true.
That just makes it use the default typecast function
for the type in question which is what I want to avoid.
What does work (lucky guess) is using str() as the typecast
function:
pgdb.set_typecast('timestamptz', str) # Python2 at least
cheers,
raf
_______________________________________________
PyGreSQL mailing list
[email protected]
https://mail.vex.net/mailman/listinfo.cgi/pygresql
