Initializing a Flask App and Setting Up the Database

Introduction: Getting Started with Your Cooking App

Welcome to your first step in building the AI Cooking Helper! In this lesson, you will learn how to set up the foundation of your web application using Flask, a popular Python web framework. Flask is lightweight, easy to use, and perfect for beginners who want to build web apps quickly. By the end of this lesson, you will have a working Flask project that is connected to a database. This setup is essential for storing recipes, user data, and more as you continue to develop your cooking app. Everything you learn here will be used in future lessons as you add more features and functionality.

Python Project Structure Basics

Before we dive in, let’s quickly remind ourselves how Python projects are usually organized. A typical Python project has a main file (like main.py) that starts the application, and folders (like app/) that hold different parts of the code, such as routes and models. For example, your project might look like this: cooking_helper/ │ ├── main.py └── app/ ├── __init__.py ├── routes.py └── models.py main.py is where your application starts. The app/ folder keeps your code organized by separating routes (URLs) and models (database structure). This structure helps keep your code clean and easy to manage as your project grows.

Using a Virtual Environment

Before you start installing packages for your project, it’s a best practice to use a virtual environment. A virtual environment is an isolated space on your computer where you can install Python packages just for your project, without affecting other projects or system-wide packages. This helps prevent dependency conflicts and makes it easier to manage your project’s requirements. To create and activate a virtual environment, use the following commands in your project directory: On macOS/Linux: python3 -m venv venv source venv/bin/activate On Windows: python -m venv venv venv\Scripts\activate python3 -m venv venv (or python -m venv venv on Windows) creates a new virtual environment in a folder named venv. source venv/bin/activate (or venv\Scripts\activate on Windows) activates the virtual environment. Once activated, any packages you install (like Flask or SQLAlchemy) will only be available inside this environment. When you’re done working, you can deactivate the environment by running deactivate. Note: In some online coding environments (like CodeSignal), you may not need to set up a virtual environment because the environment is already managed for you. However, for your own projects on your computer, always use a virtual environment to keep things organized and avoid conflicts.

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal

Connecting SQLAlchemy and Creating the Database

Now, let’s connect SQLAlchemy to your Flask app. SQLAlchemy is a library that helps you work with databases using Python code instead of SQL commands.

First, you need to import your database object that will hold the connection between your database and the Flask application. In this project, it’s defined in app/models.py as db. You also need to initialize it with your Flask app.

Python

from app.models import db

def create_app():
    app = Flask(__name__)
    app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///recipes.db'
    app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

    db.init_app(app)
    return app

from app.models import db

def create_app():
    app = Flask(__name__)
    app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///recipes.db'
    app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

    db.init_app(app)
    return app

db.init_app(app) connects your database to the Flask app.

To make sure your database tables are created, you need to call db.create_all() inside the app context. This tells SQLAlchemy to create any tables you have defined in your models.

Python

from flask import Flask
from app.models import db

def create_app():
    app = Flask(__name__)
    app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///recipes.db'
    app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

    db.init_app(app)

    with app.app_context():
        db.create_all()

    return app

from flask import Flask
from app.models import db

def create_app():
    app = Flask(__name__)
    app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///recipes.db'
    app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

    db.init_app(app)

    with app.app_context():
        db.create_all()

    return app

with app.app_context(): sets up the application context, which is needed for database operations.
db.create_all() creates all tables defined in your models if they don’t already exist. For production applications with evolving schemas, migration tools like Flask-Migrate are typically used, but db.create_all() is suitable for our initial setup and development.

Introduction: Getting Started with Your Cooking App

Python Project Structure Basics

Using a Virtual Environment

Join the 1M+ learners on CodeSignal

Setting Up a Flask Application

Connecting SQLAlchemy and Creating the Database

Registering Blueprints for Clean Code Organization

Running the App and Using the Flask Shell

Summary and What’s Next