Menu
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.
350
all() method. The Query object, when asked to return full entities, will deduplicate entries based on primary key, meaning if the same primary key value would appear in the results more than once, only one object of that primary key would be present.
One of the key aspects of any data science workflow is the sourcing, cleaning, and storing of raw data in a form that can be used upstream. This process is commonly referred to as “Extract-Transform-Load,” or ETL for short.
The grouping is done with the group_by() query method, which takes the column to use for the grouping as an argument, same as the GROUP BY counterpart in SQL. The statement ends by calling subquery() , which tells SQLAlchemy that our intention for this query is to use it inside a bigger query instead of on its own.
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()
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
