I am looking to filter specific columns in a table, but I cannot find
how to do this. I can filter by setting these columns to a value, but
not just grabbing the entire column. In SQL, I want to do this:
"SELECT artist FROM artist_table", where the only column kept is
artist. The reason I want to do this is so that I can run a distinct()
on the Query object returned to get the distinct artists and also
distinct genres. Here is a sample of what I am doing now without
filtering to get the data I need:
tuples = Session.query(Albums).add_entity(Songs).join('songs').all()
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
