Create the table to the database
Having setup the engine and initialized the metadata, you will now define the census
table object and then create it in the database using the metadata
and engine
from the previous exercise. To create it in the database, you will have to use the .create_all()
method on the metadata
with engine
as the argument.
It may help to refer back to the Chapter 4 exercise in which you learned how to create a table.
This exercise is part of the course
Introduction to Databases in Python
Exercise instructions
- Import
Table
,Column
,String
, andInteger
fromsqlalchemy
. - Define a
census
table with the following columns:'state'
- String - length of 30'sex'
- String - length of 1'age'
- Integer'pop2000'
- Integer'pop2008'
- Integer
- Create the table in the database using the
metadata
andengine
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import Table, Column, String, and Integer
# Build a census table: census
census = Table('census', metadata,
Column('state', ____),
Column(____, ____),
____,
____,
____)
# Create the table in the database
____