Michael,
as mentioned in the last post, on windows mx.DateTime is required,
otherwise I get an error.
On windows I have psycopg1 installed and on linux psycopg2, That seems
to be the reason for the problem.

ALex.

On 5/21/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
mxDateTimes are not supported by the SA datetime objects....any
reason you cant use datetime.datetime ?

On May 21, 2006, at 4:18 AM, Alex Greif wrote:

> The following code works on windows but crashes on linux. It uses
> SA 0.1.7.
> I am not sure whether the first import line makes problems, but as I
> said it works fine on windows. Both running Python-2.4.2
>
> any help is appreciated
>
> Alex.
>
>
> #######  code  ###########
>
> import mx.DateTime.DateTime as mxDateTime
> from sqlalchemy import *
>
> e = create_engine("postgres://database=test", echo=True)
>
> test = Table("test", e,
>               Column("id", Integer, primary_key=True),
>               Column("date", Date),
>               Column("last_entry", Time),
>             )
> class Test(object):
>      pass
> Test.mapper = mapper(Test, test)
>
> try:
>  test.drop()
> except:
>  pass
> test.create()
>
> t = Test()
> t.date = mxDateTime(2004,12,30)
> t.last_entry = mxDateTime(2004,12,31,23,55,56.345)
>
> objectstore.flush()
>
>
>
> #######  error message  ########
>
> [2006-05-21 10:14:06,398] [engine]:
> DROP TABLE test
> [2006-05-21 10:14:06,398] [engine]: None
> [2006-05-21 10:14:06,431] [engine]:
> CREATE TABLE test(
>        id SERIAL NOT NULL PRIMARY KEY,
>        date DATE,
>        last_entry TIME
> )
>
>
> [2006-05-21 10:14:06,431] [engine]: None
> [2006-05-21 10:14:06,505] [engine]: select nextval('test_id_seq')
> [2006-05-21 10:14:06,505] [engine]: None
> [2006-05-21 10:14:06,509] [engine]: INSERT INTO test (id, date,
> last_entry) VALUES (%(id)s, %(date)s, %(last_entry)s)
> [2006-05-21 10:14:06,509] [engine]: {'date': <DateTime object for
> '2004-12-30 00:00:00.00' at 40232598>, 'last_entry': <DateTime object
> for '2004-12-31 23:55:56.34' at 404c6250>, 'id': 1L}
> Traceback (most recent call last):
>  File "test2.py", line 25, in ?
>    objectstore.flush()
>  File "build/bdist.linux-i686/egg/sqlalchemy/mapping/objectstore.py",
> line 260, in flush
>  File "build/bdist.linux-i686/egg/sqlalchemy/mapping/objectstore.py",
> line 81, in flush
>  File "build/bdist.linux-i686/egg/sqlalchemy/mapping/unitofwork.py",
> line 249, in flush
>  File "build/bdist.linux-i686/egg/sqlalchemy/mapping/unitofwork.py",
> line 374, in execute
>  File "build/bdist.linux-i686/egg/sqlalchemy/mapping/unitofwork.py",
> line 527, in execute
>  File "build/bdist.linux-i686/egg/sqlalchemy/mapping/mapper.py", line
> 616, in save_obj
>  File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 473, in
> execute
>  File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 378, in
> execute
>  File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 355, in
> execute
>  File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 646, in
> execute_compiled
>  File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 641,
> in proxy
>  File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 692,
> in execute
>  File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 712,
> in _execute
> sqlalchemy.exceptions.SQLError: (ProgrammingError) can't adapt 'INSERT
> INTO test (id, date, last_entry) VALUES (%(id)s, %(date)s,
> %(last_entry)s)' {'date': <DateTime object for '2004-12-30
> 00:00:00.00' at 40232598>, 'last_entry': <DateTime object for
> '2004-12-31 23:55:56.34' at 404c6250>, 'id': 1L}
>
>
> -------------------------------------------------------
> 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&kid0709&bid&3057&dat1642
> _______________________________________________
> 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&kid0709&bid&3057&dat1642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to