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

Exercise

Inserting multiple records at once

It's time to practice inserting multiple records at once!

As Jason showed you in the video, when inserting multiple records at once, you do not use the .values() method. Instead, you'll want to first build a list of dictionaries that represents the data you want to insert, with keys being the names of the columns. in the .execute() method, you can pair this list of dictionaries with an insert statement, which will insert all the records in your list of dictionaries.

Instructions

100 XP
  • Build a list of dictionaries called values_list with two dictionaries. In the first dictionary set name to 'Anna', count to 1, amount to 1000.00, and valid to True. In the second dictionary of the list, set name to 'Taylor', count to 1, amount to 750.00, and valid to False.
  • Build an insert statement for the data table for a multiple insert, save it as stmt.
  • Execute stmt with the values_list via connection and store the results. Make sure values_list is the second argument to .execute().
  • Print the rowcount of the results.