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.

Cet exercice fait partie du cours

Introduction to Databases in Python

Afficher le cours

Instructions

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.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Build a list of dictionaries: values_list
values_list = [
    {'name': ____, 'count': ____, 'amount': ____, 'valid': ____},
    ____
]

# Build an insert statement for the data table: stmt
stmt = ____

# Execute stmt with the values_list: results
results = connection.execute(____, ____)

# Print rowcount
print(results.rowcount)

Modifier et exécuter le code