How to replace id with attribute corresponding to id of another table

0 votes

Using SQLAlchemy, I can query a bunch of files for their names and who created them:

>>> DBSession.query(Version.name, Version.created_by_id).filter(Version.id.in_(versions_list)).all()
[('file1', 1), ('file2', 2), ('file3', 3)]

The Version.created_by_id corresponds to the user ID. All users reside in a separate table:

>>> DBSession.query(User.id, User.name).all()
[(1, 'Abe'), (2, 'Cal'), (3, 'Dan')]

How can I, with one query, get this result back when I query my files?

[('file1', 'Abe'), ('file2', 'Cal'), ('file3', 'Dan')]

Oct 3, 2018 in Python by eatcodesleeprepeat
• 4,710 points
711 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Python

+1 vote
1 answer

How to replace id with attribute corresponding to id of another table?

Use the following query statement and let ...READ MORE

answered Aug 8, 2018 in Python by Priyaj
• 58,020 points
2,498 views
0 votes
1 answer

How to replace values with None in Pandas data frame in Python?

Actually in later versions of pandas this ...READ MORE

answered Aug 30, 2018 in Python by Priyaj
• 58,020 points
11,762 views
0 votes
1 answer

How to get rid of tensorflow verbose messages with Keras?

If you are using TensorFlow 0.12, you ...READ MORE

answered Jan 24, 2019 in Python by SDeb
• 13,300 points
4,689 views
0 votes
1 answer

How to zip with a list output in Python instead of a tuple output?

Good question - Considering that you are ...READ MORE

answered Feb 7, 2019 in Python by Nymeria
• 3,560 points
1,796 views
0 votes
1 answer

How to get domain name of email ID?

You can use the split method to split the ...READ MORE

answered Mar 28, 2019 in Python by Firoz
1,279 views
0 votes
1 answer

Replace values in data frame with valued of another dataframe.

Hi @Puneeth, you use something like this: f ...READ MORE

answered May 30, 2019 in Python by Ashish
4,085 views
0 votes
2 answers
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 7, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 4,463 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP