[sqlalchemy] Re: Sqlalchemy and pickling data in a column with Postgresql?

2014-10-17 Thread Marc Van Olmen
hi, after further investigating this didn't turn out to be the issue. ORM code was adding the extra keys in the dictionary. you can consider the issue closed, sorry for the noise. marc On Friday, October 17, 2014 12:11:05 AM UTC-4, Marc Van Olmen wrote: Second attempt because Google Groups

[sqlalchemy] Re: Multi-AZ RDS on AWS, failover and SQLAlchemy

2014-10-17 Thread Jonathan Vanasco
Have you tried a Pessimistic Disconnect strategy? http://docs.sqlalchemy.org/en/latest/core/pooling.html#dealing-with-disconnects -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it,

Re: [sqlalchemy] SAWarnings when using history_meta.py versioning and Inheritance.

2014-10-17 Thread Mike Bayer
On 10/17/2014 02:52 PM, JPLaverdure wrote: Hello, It seems a number of SAWarnings are being thrown whenever I instantiate Versioned objects which make use of inheritance: | SAWarning:Implicitlycombining column container_history.changed withcolumn barcoded_container_history.changed under

Re: [sqlalchemy] SAWarnings when using history_meta.py versioning and Inheritance.

2014-10-17 Thread Michael Bayer
On Oct 17, 2014, at 3:50 PM, JPLaverdure jp.laverd...@gmail.com wrote: Hi Michael, My bad, they do indeed only show up on mapping... which takes place when my pyramid app instantiates. Sorry for the confusion :) Still, they could be unnerving for someone deploying the app. Any way to

[sqlalchemy] after_cursor_execute question

2014-10-17 Thread Jonathan Vanasco
the docs just say: (http://docs.sqlalchemy.org/en/latest/core/events.html#sqlalchemy.events.ConnectionEvents.after_cursor_execute) - *statement* http://docs.sqlalchemy.org/en/latest/core/events.html#sqlalchemy.events.ConnectionEvents.after_cursor_execute.params.statement –

Re: [sqlalchemy] after_cursor_execute question

2014-10-17 Thread Jonathan Vanasco
Wonderful. Everything I found referenced to a `statement` or `stmt` was either a non-dialect compiled version (just turning a query into a string via `print`, `str()`, etc), or explicitly passing a dialect into the compile function. -- You received this message because you are subscribed

[sqlalchemy] How does latest sqlalchemy pickle a column?

2014-10-17 Thread Marc Van Olmen
hi, We recently upgraded from SQLAlchemy to 0.4.8 to 0.9.3 also we upgrade psycopg2 etc and we are using postgresql 9.2 We run in a very strange problem that the unpickle of one of the columns is giving different result when we do this in a python procedure call. When I run in the in the orm

Re: [sqlalchemy] How does latest sqlalchemy pickle a column?

2014-10-17 Thread Michael Bayer
This is what I get in SQLAlchemy {'calculateTaxesByID': {('totalPriceEx()',): {}}, 'averageCost': {None: Decimal('7.4838709677419355')}, 'totalPriceEx': {None: Decimal('17.50')}, 'getBasePriceEx': {None: Decimal('17.50')}} This is the result when I rand the following code in