[sqlalchemy] RelationshipProperty.info in 0.7.x branch.

2012-10-17 Thread Stefano Fontanelli
Hi Michael, do you plan to backport the RelationshipProperty.info attribute in SQLA 0.7? I read the source code and I found Column.info, but seems there is no 'info' attribute in RelationshipProperty. Best Regards, Stefano. -- Stefano Fontanelli Asidev S.r.l. Viale Rinaldo Piaggio, 32 -

Re: [sqlalchemy] Computed Columns

2012-10-17 Thread ThereMichael
The distance function should be this: distance_function = ( (6371 * func.acos(func.cos(func.radians(bindparam('origin_lat'))) * func.cos(func.radians(places_table.c.latitude)) * func.cos(func.radians(places_table.c.longitude) -

Re: [sqlalchemy] Pool_recycle in Oracle (aka Oracle has gone away)

2012-10-17 Thread Ben Hitz
that's not entirely accurate. The Flask-SQLAlchemy extension checks out a connection from the connection pool at request start, returns it at request end. The pool is responsible for dealing with the lifecycle of database connections and can be confiugured to deal with this. To deal with

[sqlalchemy] changes flushed for expunged relationships

2012-10-17 Thread Kent
The attached script fails with sqlalchemy.exc.InvalidRequestError: Instance 'Bug at 0x1e6f3d10' has been deleted. Use the make_transient() function to send this object back to the transient state. While this example is somewhat convoluted, I have a few questions about sqlalchemy behavior