Sqlalchemy - add columns to a query

Question

For example I am using the chinook database and I would like to convert the Name field into a slug. Slugify is a function from awesome-slugify.

Something like this in SQL

Select *, slugify(Name) as name_slug
from Artist

In sqlalchemy I have tried:

artist = Artist.query.add_columns(name_slug=slugify(Artist.Name)).all()

and

artist = Artist.query.add_columns(name_slug=[slugify(a.Name) for a in Artist.Name]).all()

I can generate a list of name slugs by doing to following in the terminal:

art = models.Artist.query.all()
name_slug = [slugify(a.Name) for a in art]
print(name_slug)

But I am not certain how to tie it all together.

juanitogan · Accepted Answer · 2017-08-06 02:38:40Z

24

I don't have slugify to test, but this is probably what you are looking for:

artist = Artist.query.add_columns(slugify(Artist.Name).label("name_slug")).all()

answered Aug 6, 2017 at 2:38

juanitogan

1,8781 gold badge23 silver badges37 bronze badges

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

Comments

Alex · Accepted Answer · 2023-10-19 05:07:02Z

1

Similarly with select statements: stmt = sa.select(Artist.Age)

new_stmt = stmt.add_columns(Artist.Name)

answered Oct 19, 2023 at 5:07

Alex

111 bronze badge

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Sqlalchemy - add columns to a query

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related