Peewee-AIO integration for Muffin framework
Project description
muffin-peewee-aio – Peewee ORM integration to Muffin framework.
Requirements
python >= 3.8
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 |
PYTEST_SETUP_DB |
True |
Manage DB schema and connection in pytest |
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
Hashes for muffin_peewee_aio-0.16.2-py3-none-any.whl
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 47ff903695029f1d51d4261d0eb4788d59b88eba6359946d5fff4247f0823683 |
|
| MD5 | 3ccb7b28b70909e31e0c97a4807d9fe5 |
|
| BLAKE2b-256 | 53903458d99c47a58d2ef42a03dde3b69ef69f032788404ae02951862f759af2 |
