[sqlalchemy] Re: relationship trouble

2011-10-27 Thread Jakob L.
I found the problem. I executed a query where I check against the parents name instad of the parent. Silly mistake, sorry for wasting your time. Since I write the query in a different place I didn't know it was actually the framework that executed it. -- You received this message because you

[sqlalchemy] relationship trouble

2011-10-26 Thread Jakob L.
Hi! I added a new self-referential relationship to one of my tables but since I couldn't find how to create the new column through SA I added it to the db manually after checking how it's been done before. The code looks like this (using elixir): class User(Entity): username =

[sqlalchemy] Re: relationship trouble

2011-10-26 Thread Jakob L.
Sorry, I named the new field parent_username and the index ix_user_parent_username -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/pPpCbKKCWnAJ. To post to

[sqlalchemy] max() with SQLAlchemy 0.4.7

2011-10-11 Thread Jakob L.
Sorry if this has already been posted but couldn't find any docs for 0.4 nor any examples where columns aren't used in the query. As I understand, you can't use columns in queries in 0.4. So how should I write: session.query(Media.id, func.max(Media.sort_order)).first() -- You received

Re: [sqlalchemy] max() with SQLAlchemy 0.4.7

2011-10-11 Thread Jakob L.
select([func.max(Media.c.sort_order)]) works great! Thanx! //J -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/CtRlzNOa1DUJ. To post to this group, send