1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Databases in Python
Connected

Exercise

Working on blocks of records

Fantastic work so far! As Jason discussed in the video, sometimes you may have the need to work on a large ResultProxy, and you may not have the memory to load all the results at once. To work around that issue, you can get blocks of rows from the ResultProxy by using the .fetchmany() method inside a loop. With .fetchmany(), give it an argument of the number of records you want. When you reach an empty list, there are no more rows left to fetch, and you have processed all the results of the query. Then you need to use the .close() method to close out the connection to the database.

You'll now have the chance to practice this on a large ResultProxy called results_proxy that has been pre-loaded for you to work with.

Instructions

100 XP
  • Use a while loop that checks if there are more_results.
  • Inside the loop, apply the method .fetchmany() to results_proxy to get 50 records at a time and store those records as partial_results.
  • After fetching the records, if partial_results is an empty list (that is, if it is equal to []), set more_results to False.
  • Loop over the partial_results and, if row.state is a key in the state_count dictionary, increment state_count[row.state] by 1; otherwise set state_count[row.state] to 1.
  • After the while loop, close the ResultProxy results_proxy using .close().
  • Submit the answer to print state_count.