Peewee integration for Muffin framework
Project description
muffin-peewee-aio – Peewee ORM integration to Muffin framework.
Requirements
python >= 3.7
Installation
Muffin Peewee should be installed using pip:
$ pip install muffin-peewee-aio
You can install optional database drivers with:
$ pip install muffin-peewee-aio[aiosqlite] $ pip install muffin-peewee-aio[aiopg] $ pip install muffin-peewee-aio[asyncpg] $ pip install muffin-peewee-aio[aiomysql]
Usage
from muffin import Application
from muffin_peewee import Plugin as Peewee
# Create Muffin Application
app = Application('example')
# Initialize the plugin
# As alternative: db = Peewee(app, **options)
db = Peewee()
db.setup(app, PEEWEE_CONNECTION='postgresql://postgres:postgres@localhost:5432/database')Options
Name |
Default value |
Desctiption |
CONNECTION |
sqlite:///db.sqlite |
Database URL |
CONNECTION_PARAMS |
{} |
Additional params for DB connection |
AUTO_CONNECTION |
True |
Automatically get a connection from db for a request |
AUTO_TRANSACTION |
True |
Automatically wrap a request into a transaction |
MIGRATIONS_ENABLED |
True |
Enable migrations with |
MIGRATIONS_PATH |
"migrations" |
Set path to the migrations folder |
You are able to provide the options when you are initiliazing the plugin:
db.setup(app, connection='DB_URL')Or setup it inside Muffin.Application config using the PEEWEE_ prefix:
PEEWEE_CONNECTION = 'DB_URL'Muffin.Application configuration options are case insensitive
Queries
class Test(db.Model):
data = peewee.CharField()
@app.route('/')
async def view(request):
return [t.data async for t in Test.select()]Manage connections
# Set configuration option `MANAGE_CONNECTIONS` to False
# Use context manager
@app.route('/')
async def view(request):
# Aquire a connection
async with db.manager.connection():
# Work with db
# ...Migrations
Create migrations:
$ muffin example:app peewee_create [NAME] [--auto]
Run migrations:
$ muffin example:app peewee_migrate [NAME] [--fake]
Rollback migrations:
$ muffin example:app peewee_rollback [NAME]
List migrations:
$ muffin example:app peewee_list
Clear migrations from DB:
$ muffin example:app peewee_clear
Merge migrations:
$ muffin example:app peewee_merge
Bug tracker
If you have any suggestions, bug reports or annoyances please report them to the issue tracker at https://github.com/klen/muffin-peewee-aio/issues
Contributing
Development of Muffin Peewee happens at: https://github.com/klen/muffin-peewee-aio
Contributors
klen (Kirill Klenov)
License
Licensed under a MIT license.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file muffin-peewee-aio-0.6.5.tar.gz.
File metadata
- Download URL: muffin-peewee-aio-0.6.5.tar.gz
- Upload date:
- Size: 7.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.9.16
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 3aed70f5eafee84925d41c6a0ab26343174289429f053b97f24f433e7aceb796 |
|
| MD5 | 60d07d1b34522b2f50624e6d7d025177 |
|
| BLAKE2b-256 | f3cc496b7510be8d982b7255eaead2c146e510881d553d7be841514fc44dacf1 |
File details
Details for the file muffin_peewee_aio-0.6.5-py3-none-any.whl.
File metadata
- Download URL: muffin_peewee_aio-0.6.5-py3-none-any.whl
- Upload date:
- Size: 7.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.9.16
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 3c9d30a67c7fb254c027488b7a1f10ee9327e140e497dee3d6aee0c639ad8bba |
|
| MD5 | 910507f2797d0c688bd563e244141150 |
|
| BLAKE2b-256 | c18755e3e833dd4d88d2a48a59600721bdc066bab683b8b081bebf4297a3eea4 |
