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().
Deze oefening maakt deel uit van de cursus
Introduction to Databases in Python
Oefeninstructies
- 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.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# Import create_engine, MetaData
# Define an engine to connect to chapter5.sqlite: engine
engine = create_engine(____)
# Initialize MetaData: metadata
metadata = ____