[sqlalchemy] SQLAlchemy training

2014-10-16 Thread erikj
Hi, We're organizing a 1 day training on using databases with Python and using SQLAlchemy. The training will be on November 5, and will take place at our offices in Belgium. More info can be found here : http://www.conceptive.be/training.html If you or a colleague are interested, feel free to

Re: [sqlalchemy] Child count as an object property

2014-10-16 Thread Michael Bayer
What's the group_by 1 do? Didn't you mean group_by parent_id? Sent from my iPhone On Oct 16, 2014, at 10:29 AM, Ryan Kelly rpkell...@gmail.com wrote: Hi: I'm trying to figure out if there is some way to generate a child_count property on my object that is computed using SQL, in some

Re: [sqlalchemy] Child count as an object property

2014-10-16 Thread Michael Bayer
Sent from my iPhone On Oct 16, 2014, at 10:29 AM, Ryan Kelly rpkell...@gmail.com wrote: Hi: I'm trying to figure out if there is some way to generate a child_count property on my object that is computed using SQL, in some sane way. I've tried various approaches, none of which has

Re: [sqlalchemy] Child count as an object property

2014-10-16 Thread Simon King
GROUP BY 1 means group by the first column in the select, doesn't it? Which in this case would be parent_id. Simon On Thu, Oct 16, 2014 at 4:34 PM, Michael Bayer mike...@zzzcomputing.com wrote: What's the group_by 1 do? Didn't you mean group_by parent_id? Sent from my iPhone On Oct 16,

Re: [sqlalchemy] Routing Session and query count problem

2014-10-16 Thread Jeff Oliver
On Wednesday, October 15, 2014 2:55:22 PM UTC-7, Michael Bayer wrote: The system currently locates the bind via the tables present in the selectable, as when you bind to a mapper, the tables that the mapper selects from are extracted and also set up. Issue is added at

[sqlalchemy] Search/Filter using M2M relationships

2014-10-16 Thread Peter Petersky
Hi! i'm currently having these Models: conn_tags_table = sql.Table('conn_tags', Base.metadata, sql.Column('conn_id', sql.Integer, ForeignKey( 'connection.id')), sql.Column('tag_id', sql.Integer, ForeignKey('tag.id')) ) class Connection(Base): Connection

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

2014-10-16 Thread Marc Van Olmen
Second attempt because Google Groups doesn't seems to show my question. hi, I'm running into an issue where unpickle a column from slqalchmey managed database in python 2.7.5 + sqlaymchy 0.9.3 + posgresql 9.2.3 is giving different result when I use sqlalchemy to load the pickled column or when