Skip to main content

Peewee ORM integration for Flask framework

Project description

The Flask-PW – Peewee ORM intergration for Flask framework.

The plugin configures DB connection and provides some tools such as migrations and signals. It also provides Peewee ORM support for Flask-Debugtoolbar

Requirements

  • python 2.7+,3.4+

Installation

Flask-PW should be installed using pip:

pip install flask-pw

Usage

Settings

Flask-PW settings (default values):

# Connection URI
PEEWEE_DATABASE_URI = 'sqlite:///peewee.sqlite'

# Connection params (for example for pgsql: { encoding: 'utf-8' })
PEEWEE_CONNECTION_PARAMS = {}

# Path to directory which contains migrations
PEEWEE_MIGRATIONS = 'migrations'

# Path to module which contains you applications' Models
# Needed by automatic migrations
PEEWEE_MODELS_MODULE = ''

# Models which should be ignored in migrations
PEEWEE_MODELS_IGNORE = []

# Base models class
# Use `db.Model` as your models' base class for automatically DB binding
PEEWEE_MODELS_CLASS = <flask_pw.Model>

# Don't connect to db when request starts and close when it ends automatically
PEEWEE_MANUAL = False

Example

import peewee as pw
from flask import Flask

from flask_pw import Peewee


app = Flask(__name__)

app.config['PEEWEE_DATABASE_URI'] = 'sqlite:///:memory:'

db = Peewee(app)


class User(db.Model):

    name = pw.CharField(255)
    title = pw.CharField(127, null=True)
    active = pw.BooleanField(default=True)
    rating = pw.IntegerField(default=0)


@User.post_save.connect
def update(user, created=False):
    if created:
        # Do something

Migrations

If you use Flask-Script just add ‘db’ command to your manager:

manager = Manager(create_app)
manager.add_command('db', db.manager)

And use db create, db migrate and db rollback commands.

If you use Flask >= 0.11 connect the plugin’s command to your CLI:

pw = Peewee(app)
app.cli.add_command(pw.cli, 'db')
if __name__ == '__main__':
    with app.app_context():
        app.cli()

Flask-Debugtoolbar

Just add flask_pw.debugtoolbar.PeeweeDebugPanel to Flask-Debugtoolbar panels in your application’s configuration:

DEBUG_TB_PANELS = [
    'flask_debugtoolbar.panels.versions.VersionDebugPanel',
    'flask_debugtoolbar.panels.timer.TimerDebugPanel',
    'flask_debugtoolbar.panels.headers.HeaderDebugPanel',
    'flask_debugtoolbar.panels.request_vars.RequestVarsDebugPanel',
    'flask_debugtoolbar.panels.template.TemplateDebugPanel',
    'flask_debugtoolbar.panels.sqlalchemy.SQLAlchemyDebugPanel',
    'flask_debugtoolbar.panels.logger.LoggingPanel',
    'flask_debugtoolbar.panels.profiler.ProfilerDebugPanel',

    # Add the Peewee panel
    'flask_pw.flask_debugtoolbar.PeeweeDebugPanel',
]

Enjoy!

Bug tracker

If you have any suggestions, bug reports or annoyances please report them to the issue tracker at https://github.com/klen/flask-pw/issues

Contributing

Development of The Flask-pw happens at: https://github.com/klen/flask-pw

Contributors

License

Licensed under a MIT license (See LICENSE)

If you wish to express your appreciation for the project, you are welcome to send a postcard to:

Kirill Klenov
pos. Severny 8-3
MO, Istra, 143500
Russia

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-PW-0.2.2.tar.gz (7.9 kB view details)

Uploaded Source

Built Distribution

Flask_PW-0.2.2-py2.py3-none-any.whl (10.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file Flask-PW-0.2.2.tar.gz.

File metadata

  • Download URL: Flask-PW-0.2.2.tar.gz
  • Upload date:
  • Size: 7.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for Flask-PW-0.2.2.tar.gz
Algorithm Hash digest
SHA256 6027480f87b66b702491dd6ece37d4dbf86e67c1b1990dbc2de51f8b2f152a52
MD5 d0ec99805b84626c3be86ed9a0499194
BLAKE2b-256 8324e8b9bd3c63f46d126e49cb0d07ededf2926d64cc81e29cf6f1054d6229b5

See more details on using hashes here.

File details

Details for the file Flask_PW-0.2.2-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for Flask_PW-0.2.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 3ab3ecc740dc4802bf4ce8d20e88fe2c4d885cab9ef52dfaae97519809e3835d
MD5 bd1feb47dcea992c114530c8f76befde
BLAKE2b-256 433c31de8211a7a31a16e3c01443b3e1013e0be5b90b1ae190ae01b949a1f154

See more details on using hashes here.

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