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().
Este exercício faz parte do curso
Introduction to Databases in Python
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# Import create_engine, MetaData
# Define an engine to connect to chapter5.sqlite: engine
engine = create_engine(____)
# Initialize MetaData: metadata
metadata = ____