SQLAlchemy factories for pyramid_services
Project description
SQLAlchemy factories for pyramid_services.
This module provides removing SQLAlchemy’s boiler plates from your pyramid application codes.
In your pastedeploy.ini:
sqlalchemy.url = ENGINE://DBUSER:PASSWORD@DBHOST/DBNAME
In your application factory:
config.include('pyramid_services_sqlalchemy')
In your views:
from pyramid_services_sqlalchemy import get_tm_session def aview(request): db = get_tm_session(request)
or you can use request.find_service:
from pyramid_services_sqlalchemy import IDBSession def aview(request): db = request.find_service(IDBSession)
If you want to use multiple connections, pastedeploy.ini:
sqlalchemy.names = readonly readwrite sqlalchemy.readonly.url = ENGINE://READ_DBUSER:PASSWORD@DBHOST/DBNAME sqlalchemy.readwrite.url = ENGINE://WRITE_DBUSER:PASSWORD@DBHOST/DBNAME
and in your views:
from pyramid_services_sqlalchemy import get_tm_session def aview(request): db = get_tm_session(request, name='readonly') def a_write_view(request): db = get_tm_session(request, name='readwrite')
Change History
0.1.1 - 2018-08-11
Update README
0.1 - 2018-08-11
Initial release.
Project details
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
Close
Hashes for pyramid_services_sqlalchemy-0.1.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1a77489cf528cb0e10c4336ecd097c95e7712da1438572a6bc390f5bfca7353b |
|
MD5 | b60b6c71904e91285dfbc7c7d196789a |
|
BLAKE2b-256 | 18e236c0f1d081837dfa9d50f017d1009ccfb6c139913a2ceafc0b51f46277dd |
Close
Hashes for pyramid_services_sqlalchemy-0.1.1-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 11a9c39424a1d240a2711e27ed4b41d9e82a26b6893cac5fd58cb90d886b4ee4 |
|
MD5 | fcacb5b00cbd8a8b5aa01a2d8b3274fc |
|
BLAKE2b-256 | b5139094b32e3c32daa9f334edc3cdf1ede962e17e18b4e75eb077fc8dc21d3c |