Re: [sqlalchemy] Decimals generated as strings in query

2015-04-13 Thread Gabriel Becedillas
Dear Michael, Thanks a lot for your reply. In trying to narrow the problem as much as possible, I missed something important in my example. I'm actually doing an UPDATE, not a SELECT. When I wrote 'I tried casting my decimals using sqlalcheme.cast(..., sqlalchemy.Numeric(precision=16, scale=8))

Re: [sqlalchemy] Decimals generated as strings in query

2015-04-13 Thread Mike Bayer
On 4/13/15 2:25 PM, Gabriel Becedillas wrote: Dear Michael, Thanks a lot for your reply. In trying to narrow the problem as much as possible, I missed something important in my example. I'm actually doing an UPDATE, not a SELECT. When I wrote 'I tried casting my decimals using

Re: [sqlalchemy] Decimals generated as strings in query

2015-04-13 Thread Gabriel Becedillas
Thanks a lot Mike. Although I did see the Specify 'fetch' or False for the synchronize_session parameter in the error I associated that with a connection-time parameter and I thought 'no.. that has nothing to do with my problem'. My bad. Thanks a lot. On Mon, Apr 13, 2015 at 3:31 PM, Mike Bayer

Re: [sqlalchemy] Decimals generated as strings in query

2015-04-13 Thread Mike Bayer
On 4/13/15 11:50 AM, Gabriel Becedillas wrote: Dear all, I have a table that has 2 numeric columns, and I'm writing a query that performs some arithmetic on the filter clause between those columns and a Decimal. The problem that I'm facing is that I don't get any results at all. After a

Re: [sqlalchemy] polymorphic inheritance and unique constraints

2015-04-13 Thread Mike Bayer
On 4/13/15 4:59 PM, Richard Gerd Kuesters | Pollux Automation wrote: well, this didn't work with upstream 1.0 - sorry, I was in another project and couldn't test it myself. you're not doing the same thing this user was doing in any case... Traceback (most recent call last): File

Re: [sqlalchemy] polymorphic inheritance and unique constraints

2015-04-13 Thread Richard Gerd Kuesters | Pollux Automation
well, this didn't work with upstream 1.0 - sorry, I was in another project and couldn't test it myself. Traceback (most recent call last): File database_test.py, line 46, in module from plx.db.core import * File ../src/plx/db/core.py, line 901, in module

Re: [sqlalchemy] GeoAlchemy2 mutation tracking on Geometry Column?

2015-04-13 Thread Mike Bayer
On 4/9/15 1:38 PM, joe meiring wrote: Is there some way to implement mutation tracking on a sqlalchemy2 Geometry (POLYGON) Column? Can I just wrap it in a MutableDict can I? I haven't worked with geoalchemy in many years, I'd advise just give it a try and/or dig into geoalchemy's source to

[sqlalchemy] Decimals generated as strings in query

2015-04-13 Thread Gabriel Becedillas
Dear all, I have a table that has 2 numeric columns, and I'm writing a query that performs some arithmetic on the filter clause between those columns and a Decimal. The problem that I'm facing is that I don't get any results at all. After a while I realized that the SQL statement getting