Hi Jonathan, sure can, here it is below. I think maybe this has something
to do with the fact that we are creating a new engine and dropping the
schema on each pass maybe? Because it seems to *only* happen when we run
about 75 tests in a row.
Thanks for looking!
class FunctionalTestSuite(unittest.TestCase):
"""
base class for functional test suite with db seeding"
"""
# derived class needs to set this to the package of the app under test
# IE app_module = examp.app
app_package = None
# derived class needs to put settings in here
settings = {
'sqlalchemy.url': None
}
def __init__(self, *args, **kwargs):
super(FunctionalTestSuite, self).__init__(*args, **kwargs)
@classmethod
def setUpClass(cls):
"class level setUp creates tables"
configure_mappers()
# separate session factory for our test runner
cls.engine = engine_from_config(cls.settings, prefix='sqlalchemy.')
cls.session_factory = sessionmaker(bind=cls.engine)
@classmethod
def init_db(cls):
"initialize the database and create sessions, normally called
from setUp"
# drop and recreate tables once per test
# NB: this has to be done differently for postgres because
it's a constraint nazi
if 'postgres' in cls.settings['sqlalchemy.url']:
cls.engine.execute("drop owned by semaphore")
cls.engine.execute("create schema if not exists public")
else:
Base.metadata.drop_all(bind=cls.engine)
Base.metadata.create_all(bind=cls.engine)
def init_sessions(self):
"init seed and confirm sessions, normally called from setUp"
# create sessions for seeding and separate for confirming
self.seed_dbs = self.session_factory()
self.confirm_dbs = self.session_factory()
def init_app(self):
"init test wsgi app, normally called from setUp"
self.app = self.app_package.main({}, **self.settings)
self.testapp = webtest.TestApp(self.app)
def setUp(self):
# for tests where we want fresh db on *every* test, we use this
self.init_db()
self.init_sessions()
self.init_app()
def tearDown(self):
self.seed_dbs.close()
self.confirm_dbs.close()
On Wed, Sep 7, 2016 at 8:37 PM, Jonathan Vanasco <[email protected]> wrote:
> can you share the test harness?
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
