Hey All,
This really looks exactly like the unicode problems I was having.
http://www.sqlalchemy.org/trac/ticket/86
Are you using psycopg1 or psycopg2? Tried convert_unicode? Test case passes
using psycopg2 in 1419.
-G
On Tuesday, May 9, 2006, 2:05:19 AM, you wrote:
> Dennis,
> FWIW, Your test script runs ok for me with sqlite and the latest svn
> trunk. You might want try running it with the trunk+PG.
> Sean
> On Mon, 2006-05-08 at 16:45 -0600, Dennis Muhlestein wrote:
>> On 5/8/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
>> im not able to reproduce this problem, i can send unicode()
>> into
>> get_by or SQL constructs directly no problem. i also dont
>> immediately see anything that could cause it to construe a
>> unicode
>> string as anything other than a literal value (unless the
>> unicode()
>> function on your end is being clobered by something?) can you
>> attach
>> a fully working test case ?
>>
>> I'm using Postgresql 8.1.3 on Linux. The attached test case produces
>> the following output on both of my machines:
>>
>> ____SNIP_____
>> > python test.py
>> working: dennis
>> Traceback (most recent call last):
>> File "test.py", line 30, in ?
>> t=Test.get_by(username=unicode('dennis'))
>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/mapper.py", line
>> 258, in get_by
>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", line
>> 58, in get_by
>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", line
>> 137, in select_whereclause
>> File "build/bdist.linux-i686/egg/sqlalchemy/mapping/query.py", line
>> 213, in _select_statement
>> 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) ERROR: column
>> "dennis" does not exist
>>
>> SELECT test.username AS test_username, test.id AS test_id
>> FROM test
>> WHERE test.username = dennis
>> LIMIT 1 'SELECT test.username AS test_username, test.id AS test_id
>> \nFROM test \nWHERE test.username = %(test_username)s \n LIMIT
>> 1' {'test_username': u'dennis'}
>> _____END SNIP_________
>>
>> Let me know if you need any additional information about my
>> environment or library versions. (SQLAlchemy 0.1.7)
>>
>> Thanks
>> -Dennis
> -------------------------------------------------------
> 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
