4.2. More Detailed QueryΒΆ
Condition expressions can be combined with logical operators &
and |
.
from models import Movie
from awstin.dynamodb import DynamoDB
def query_and_project_movies(year, title_range):
dynamodb = DynamoDB()
table = dynamodb[Movie]
query = (Movie.year == year) & (Movie.title.between(*title_range))
return table.query(query)
if __name__ == "__main__":
query_year = 1992
query_range = ("A", "L")
print(
f"Get movies from {query_year} with titles from "
f"{query_range[0]} to {query_range[1]}"
)
movies = query_and_project_movies(query_year, query_range)
for movie in movies:
print(f"{movie.year} : {movie.title}")
print(movie.info)
print()