[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-08 Thread volx
All has been working fine in 0.6, Mike. Thanks. Out of curiosity how do you unit test against Oracle. Do you use some kind of mock object? On Oct 4, 10:01 am, Michael Bayer mike...@zzzcomputing.com wrote: On Oct 3, 2009, at 5:18 PM, volx wrote: Hi Mike: Thank you for that. I will try

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-03 Thread volx
:05 PM, volx wrote: My module is called sandbox.py After importing it to ipython and letting it run, here's what I get for the test you suggested: In [47]: (sandbox.price_sources.c.desciption=='EJV').right.type Out[47]: OracleChar(length=100, convert_unicode=False, assert_unicode

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-02 Thread volx
1, 2:48 pm, Michael Bayer mike...@zzzcomputing.com wrote: volx wrote: Here's my program, modified as you suggest. It also creates the table so you can try it on any instance of Oracle. No joy on the result. Seems like the set_inputsizes isn't called? How can I tell for certain? import

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-01 Thread volx
...@zzzcomputing.com wrote: volx wrote: cx_Oracle actually has thread on that a topic at http://sourceforge.net/mailarchive/message.php?msg_id=47BED8B8.3983.0... It boils down to having to specify a type for input parameter. Is that something I could plug-in as a decorator or would that need

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-10-01 Thread volx
, Michael Bayer mike...@zzzcomputing.com wrote: volx wrote: Micheal: Thanks for your help thus far. Unfortunately I don't think the get_dbapi_type method gets called. From reading your code I see how it should be called from pre_exec - setinputsizes - get_dbapi_type but empirical

[sqlalchemy] padding of CHAR fields, inconsistent where clause; Oracle example

2009-09-30 Thread volx
Hello all: Consider table: CREATE TABLE PRICE_SOURCES ( ID decimal(22) PRIMARY KEY NOT NULL, DESCRIPTION char(100) NOT NULL ) and this screen dump from ipython session: In [28]: import cx_Oracle In [29]: from sqlalchemy.ext.sqlsoup import SqlSoup In [30]: con =

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-09-30 Thread volx
= :someparam, dict (someparam='EJV ')).fetchall() Out[49]: [(149, 'EJV ')] On Sep 30, 2:18 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Sep 30, 2:07 pm, volx victor.o...@gmail.com wrote: Hello all: Consider table: CREATE TABLE PRICE_SOURCES (    ID decimal(22) PRIMARY KEY NOT NULL

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-09-30 Thread volx
, 'EJV ')] Any help would be appreciated. On Sep 30, 2:36 pm, volx victor.o...@gmail.com wrote: I have just now and it looks that this post probably belongs on cx_Oracle mailing list. In [47]: cursor.execute(select * from price_sources where desciption = :someparam, dict(someparam='EJV

[sqlalchemy] Re: padding of CHAR fields, inconsistent where clause; Oracle example

2009-09-30 Thread volx
, volx victor.o...@gmail.com wrote: cx_Oracle actually has thread on that a topic athttp://sourceforge.net/mailarchive/message.php?msg_id=47BED8B8.3983.0... It boils down to having to specify a type for input parameter. Is that something I could plug-in as a decorator or would that need