Essential SQLAlchemy by Jason Myers and Rick Copeland

Author:Jason Myers and Rick Copeland
Language: eng
Format: mobi, epub
Publisher: O'Reilly Media, Inc.
Published: 2015-12-08T16:00:00+00:00

It’s also possible to limit the number of results returned if we only need a certain number of them for our application. The following section explains how.

Limiting

In prior examples, we used the first() method to get just a single row back. While our query() gave us the one row we asked for, the actual query ran over and accessed all the results, not just the single record. If we want to limit the query, we can use array slice notation to actually issue a limit statement as part of our query. For example, suppose you only have time to bake two batches of cookies, and you want to know which two cookie types you should make. You can use our ordered query from earlier and add a limit statement to return the two cookie types that are most in need of being replenished. Example 7-9 shows how this can be done.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.