SQLA and Flask: Planets Database Example -- More Queries and an API route

Published: 27 November 2023
on channel: Thomas Blum

In this video we continue our example of a simple SQLAlchemy database (just one table containing Planet data). We look a little more carefully at the queries. If we query the entire table (somewhat like a SELECT * in SQL), the result is a list of object. However, if we name specific columns we want in the query, the result is a list of "named tuples." In each case we can cast the results to a list of dictionaries. When we have objects we use __dict__, and when we have named tuples we use _asdict(). We change the query leading to our GridJS datatable, and we add a search functionality. Finally we add an API route that just dumps our the query results as JSON.

Watch video SQLA and Flask: Planets Database Example -- More Queries and an API route online without registration, duration hours minute second in high quality. This video was added by user Thomas Blum 27 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 29 once and liked it 1 people.

215