Skip to main content

SQLAlchemy database migrations for Flask applications using Alembic.

Project description

Flask-Migrate

Build status

Flask-Migrate is an extension that handles SQLAlchemy database migrations for Flask applications using Alembic. The database operations are provided as command-line arguments under the flask db command.

Installation

Install Flask-Migrate with pip:

pip install Flask-Migrate

Example

This is an example application that handles database migrations through Flask-Migrate:

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from flask_migrate import Migrate

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'

db = SQLAlchemy(app)
migrate = Migrate(app, db)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(128))

With the above application you can create the database or enable migrations if the database already exists with the following command:

$ flask db init

Note that the FLASK_APP environment variable must be set according to the Flask documentation for this command to work. This will add a migrations folder to your application. The contents of this folder need to be added to version control along with your other source files.

You can then generate an initial migration:

$ flask db migrate

The migration script needs to be reviewed and edited, as Alembic currently does not detect every change you make to your models. In particular, Alembic is currently unable to detect indexes. Once finalized, the migration script also needs to be added to version control.

Then you can apply the migration to the database:

$ flask db upgrade

Then each time the database models change repeat the migrate and upgrade commands.

To sync the database in another system just refresh the migrations folder from source control and run the upgrade command.

To see all the commands that are available run this command:

$ flask db --help

Resources

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

Flask-Migrate-4.0.7.tar.gz (21.8 kB view details)

Uploaded Source

Built Distribution

Flask_Migrate-4.0.7-py3-none-any.whl (21.1 kB view details)

Uploaded Python 3

File details

Details for the file Flask-Migrate-4.0.7.tar.gz.

File metadata

  • Download URL: Flask-Migrate-4.0.7.tar.gz
  • Upload date:
  • Size: 21.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.12.0

File hashes

Hashes for Flask-Migrate-4.0.7.tar.gz
Algorithm Hash digest
SHA256 dff7dd25113c210b069af280ea713b883f3840c1e3455274745d7355778c8622
MD5 eaeddc08bcc2f1910647ff246e597bff
BLAKE2b-256 3be24008fc0d298d7ce797021b194bbe151d4d12db670691648a226d4fc8aefc

See more details on using hashes here.

Provenance

File details

Details for the file Flask_Migrate-4.0.7-py3-none-any.whl.

File metadata

File hashes

Hashes for Flask_Migrate-4.0.7-py3-none-any.whl
Algorithm Hash digest
SHA256 5c532be17e7b43a223b7500d620edae33795df27c75811ddf32560f7d48ec617
MD5 2860c09a26a203c7376b4a6282788685
BLAKE2b-256 9301587023575286236f95d2ab8a826c320375ed5ea2102bb103ed89704ffa6b

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page