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().
This exercise is part of the course
Introduction to Databases in Python
Exercise 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.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import create_engine, MetaData
# Define an engine to connect to chapter5.sqlite: engine
engine = create_engine(____)
# Initialize MetaData: metadata
metadata = ____