how to use sqlalchemy for sql?

Question

select category_id, (select category.name from category where category.id = category_id ) as category_name from ( select distinct category_id as category_id from model join category on ( category.id = model.category_id) ) as R

... self.current_session.query(Model.category_id).join(Category).distinct()

But how to know category_name ?

Step 1. Format your code using {}. Step 2. Clarify your question with -- perhaps -- the actual error message you're actually getting. — S.Lott
– S.Lott, Commented Feb 2, 2011 at 12:26

Gary van der Merwe · Accepted Answer · 2011-02-02 12:30:20Z

1

for model, category in self.current_session.query(Model, Category).join(Category).distinct():
    print model.category_id, category.name

answered Feb 2, 2011 at 12:30

Gary van der Merwe

9,6524 gold badges58 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to use sqlalchemy for sql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related