pyramid_basemodel
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.
Usage
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."""
@classmethod
def do_foo(cls):
instance = Session.query(cls).first()
save(instance)
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 yourapp.__init__.py
import mymodel
def main(global_config, **settings):
config = Configurator(settings=settings)
config.include('pyramid_basemodel')
config.include('pyramid_tm')
return config.make_wsgi_app()
Or if this is all too much voodoo, you can just use the bind_engine function::
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.
Tests
To run the tests use:
py.test -v --cov pyramid_basemodel tests/
2.5k Dec 31, 2022
3.9k Jan 9, 2023
5 Dec 11, 2022
10 Aug 13, 2022
394 Jan 7, 2023
139 Dec 30, 2022
19 Nov 3, 2022
0 Aug 3, 2021
6 Apr 7, 2022
3 Nov 30, 2021
12 Dec 4, 2022
2.2k Dec 28, 2022
1.3k Jan 1, 2023
3.7k Dec 30, 2022
73 Dec 3, 2021
95 Nov 28, 2022
62 Oct 10, 2022
121 Oct 15, 2021