This chapter focuses solely on retrieving records from a database using SQLAlchemy. You’ll learn how to fetch single or multiple records efficiently using various querying methods.

Fetching a Single Record

To retrieve a single record, use query() and apply filters. For instance, to find a product by its name:

python

Here, .filter(Product.name == "Laptop") selects products with the name "Laptop," and .first() returns the first matching record or None.

Fetching Multiple Records

To retrieve multiple records, combine filter() with .all(). For example, to list all products:

python

To filter products, e.g., those priced above $1000, modify the query:

python

Using get() for Primary Key Lookups

For efficient retrieval by primary key, use get(). For example, fetching a product with ID 1:

python

Limiting Results

To limit the number of records retrieved, apply .limit(). For example, to fetch the first 3 products:

python

By mastering these techniques, you’ll efficiently retrieve the data you need, whether it’s a single record, multiple filtered results, or a limited subset.