Skip to main content

pyramid_basemodel - a thin, low level SQLAlchemy bindings to pyramid

Project description


pyramid_basemodel is a thin, low level package that provides an SQLAlchemy declarative Base and a thread local scoped Session that can be used by different packages whilst only needing to be bound to a db engine once.


You can use these as base classes for declarative model definitions, e.g.:

from pyramid_basemodel import Base, BaseMixin, Session, save

class MyModel(Base, BaseMixin):
    """Example model class."""

    def do_foo(cls):
        instance = Session.query(cls).first()

You can then bind these to the sqlalchemy.url in your paster .ini config by importing your model and this package, e.g.:

# for example in
import mymodel

def main(global_config, **settings):
    config = Configurator(settings=settings)
    return config.make_wsgi_app()

Or if this is all too much voodoo, you can just use the bind_engine function:

.. code-block:: python

from pyramid_basemodel import bind_engine from mypackage import mymodel

# assuming engine is a bound SQLAlchemy engine. bind_engine(engine)

Note that the Session is designed to be used in tandem with [pyramid_tm][]. If you don’t include pyramid_tm, you’ll need to take care of committing transactions yourself.


To run the tests use:

py.test -v --cov pyramid_basemodel tests/

[pyramid_basemodel]: [pyramid_simpleauth]: [pyramid_tm]:


Install pipenv and –dev dependencies first, Then run:

pipenv run tbump [NEW_VERSION]

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

pyramid_basemodel-0.6.1.tar.gz (17.6 kB view hashes)

Uploaded source

Built Distribution

pyramid_basemodel-0.6.1-py3-none-any.whl (15.0 kB view hashes)

Uploaded py3

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