Setup the engine and metadata
In this exercise, your job is to create an engine to the database that will be used in this chapter. Then, you need to initialize its metadata.
Recall how you did this in Chapter 1 by leveraging create_engine() and MetaData().
Cet exercice fait partie du cours
Introduction to Databases in Python
Instructions
- Import
create_engineandMetaDatafromsqlalchemy. - Create an
engineto the chapter 5 database by using'sqlite:///chapter5.sqlite'as the connection string. - Create a MetaData object as
metadata.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
# Import create_engine, MetaData
# Define an engine to connect to chapter5.sqlite: engine
engine = create_engine(____)
# Initialize MetaData: metadata
metadata = ____