Hey Rick,

Unicode stuff doesn't work well in psycopg1 either.  I'm all for not
supporting it anymore, as making the mistake of starting off in it cost me a
few days tracking down strange problems.

It's documented in the wiki and in the mailing list, but I agree there's no
good reason (besides version confusion) to use psycopg1 vs psycopg2.
-G

On Tuesday, May 16, 2006, 7:10:20 PM, you wrote:
> I believe all of the database modules expect and return "native" Python
> datetime objects (which were added in Python 2.3).

> Import and use "datetime" instead of "mx.DateTime". See the Python docs for
> usage.

> Rick



> On 5/12/06, Dimi Shahbaz <[EMAIL PROTECTED]> wrote:
>>
>> Here is a test case that fails with the sqlalchemy-trunk.  Create 2
>> files, in the first:
>>
>> import mx.DateTime as mxDateTime
>> from sqlalchemy import *
>>
>> e = create_engine("postgres://database=test", echo=True)
>>
>> test = Table("test", e,
>>    Column("id", String, primary_key=True),
>>    Column("date", DateTime),
>> )
>> class Test(object):
>>    pass
>> Test.mapper = mapper(Test, test)
>>
>> try:
>>    test.drop()
>> except:
>>    pass
>> test.create()
>>
>> date = mxDateTime.now()
>>
>> t = Test()
>> t.id = '1'
>> t.date = date
>>
>> objectstore.flush()
>> s = Test.mapper.get_by(id='1')
>> print mxDateTime.Age(mxDateTime.now(), s.date)
>>
>>
>>
>>
>> The last line of the output of this program is correct:
>> YYYY-MM-DD HH:MM:(+00)
>>
>> (because the timedelta is zero).
>>
>>
>>
>> Now in another file, do this (I've just removed the drop/create/
>> inserts):
>>
>> import mx.DateTime as mxDateTime
>> from sqlalchemy import *
>>
>> e = create_engine("postgres://database=test", echo=True)
>>
>> test = Table("test", e,
>>    Column("id", String, primary_key=True),
>>    Column("date", DateTime),
>> )
>> class Test(object):
>>    pass
>> Test.mapper = mapper(Test, test)
>>
>> s = Test.mapper.get_by(id='1')
>> print mxDateTime.Age(mxDateTime.now(), s.date)
>>
>>
>>
>>
>> This fails with:
>> Traceback (most recent call last):
>>    File "saDateTest2.py", line 15, in ?
>>      print mxDateTime.Age(mxDateTime.now(), s.date)
>>    File "/usr/lib/python2.3/site-packages/mx/DateTime/DateTime.py",
>> line 842, in RelativeDateTimeDiff
>>      diff = date1 - date2
>> TypeError: unsupported operand type(s) for -: 'DateTime' and
>> 'datetime.datetime'
>>
>>
>>
>> So the type of test.date is different between the two.  I'd assume it
>> should always be an mx.DateTime, so that I can use it in mx methods
>> such as Age() without a lot of trouble.
>>
>>
>> I'm not sure if this is related:
>> http://article.gmane.org/gmane.comp.python.sqlalchemy.user/1672
>>
>>
>> --
>> Dimi Shahbaz, Software Engineer Specialist
>> California PASS Program
>> www.cyberhigh.fcoe.k12.ca.us
>>
>>
>>
>>
>>
>>
>> -------------------------------------------------------
>> Using Tomcat but need to do more? Need to support web services, security?
>> Get stuff done quickly with pre-integrated technology to make your job
>> easier
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>> _______________________________________________
>> Sqlalchemy-users mailing list
>> Sqlalchemy-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>>



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to