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