Creating tables (db.create_all) in Flask - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import the Flask class.

Flask

from flask import [1]

Drag options to blanks, or click blank then click option'

AModel

BApp

CDatabase

DFlask

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'App' instead of 'Flask' will cause an import error.

Trying to import 'Database' or 'Model' from flask is incorrect.

The Flask class is imported from the flask package to create the app instance.

2fill in blank

medium

Complete the code to create a Flask app instance.

Flask

app = [1](__name__)

Drag options to blanks, or click blank then click option'

AFlask

BApp

Ccreate_app

DApplication

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Application' or 'App' will cause a NameError.

Using 'create_app' is a pattern but not the class constructor.

The Flask class is called with __name__ to create the app instance.

3fill in blank

hard

Fix the error in the code to initialize SQLAlchemy with the app.

Flask

db = SQLAlchemy()
db.[1](app)

Drag options to blanks, or click blank then click option'

Ainitialize

Bstart

Cinit_app

Dcreate

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'initialize' or 'start' causes AttributeError.

Using 'create' is not a method of SQLAlchemy instance.

The method to link the SQLAlchemy object to the Flask app is init_app.

4fill in blank

hard

Fill both blanks to define a simple model with an id primary key and a name column.

Flask

class User(db.Model):
    id = db.Column(db.[1], primary_key=True)
    name = db.Column(db.[2](50))

Drag options to blanks, or click blank then click option'

AInteger

BString

CText

DFloat

Attempts:

3 left

💡 Hint

Common Mistakes

Using Text for id causes errors.

Using Float for name is incorrect.

The id column uses Integer type and is primary key. The name column uses String with max length 50.

5fill in blank

hard

Fill all three blanks to create tables in the database after app context is pushed.

Flask

with app.[1]():
    db.[2]()
    print('[3] tables created!')

Drag options to blanks, or click blank then click option'

Aapp_context

Bcreate_all

CDatabase

DApp

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'App' instead of 'app_context' causes errors.

Calling 'create' instead of 'create_all' misses table creation.

Use app_context() to push context, then call create_all() to create tables, and print a confirmation message.