Add additional logging configs necessary for db script output and update tests.py to fix the 'At least one scoped session' warning
| | |
| | | .. code-block:: bash |
| | | |
| | | $ $VENV/bin/initialize_tutorial_db development.ini |
| | | 2013-09-06 15:54:08,050 INFO [sqlalchemy.engine.base.Engine][MainThread] PRAGMA table_info("wikipages") |
| | | 2013-09-06 15:54:08,050 INFO [sqlalchemy.engine.base.Engine][MainThread] () |
| | | 2013-09-06 15:54:08,051 INFO [sqlalchemy.engine.base.Engine][MainThread] |
| | | 2015-06-01 11:22:52,650 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1 |
| | | 2015-06-01 11:22:52,650 INFO [sqlalchemy.engine.base.Engine][MainThread] () |
| | | 2015-06-01 11:22:52,651 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1 |
| | | 2015-06-01 11:22:52,651 INFO [sqlalchemy.engine.base.Engine][MainThread] () |
| | | 2015-06-01 11:22:52,652 INFO [sqlalchemy.engine.base.Engine][MainThread] PRAGMA table_info("wikipages") |
| | | 2015-06-01 11:22:52,652 INFO [sqlalchemy.engine.base.Engine][MainThread] () |
| | | 2015-06-01 11:22:52,653 INFO [sqlalchemy.engine.base.Engine][MainThread] |
| | | CREATE TABLE wikipages ( |
| | | uid INTEGER NOT NULL, |
| | | title TEXT, |
| | | body TEXT, |
| | | PRIMARY KEY (uid), |
| | | UNIQUE (title) |
| | | uid INTEGER NOT NULL, |
| | | title TEXT, |
| | | body TEXT, |
| | | PRIMARY KEY (uid), |
| | | UNIQUE (title) |
| | | ) |
| | | |
| | | |
| | | 2015-06-01 11:22:52,653 INFO [sqlalchemy.engine.base.Engine][MainThread] () |
| | | 2015-06-01 11:22:52,655 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT |
| | | 2015-06-01 11:22:52,658 INFO [sqlalchemy.engine.base.Engine][MainThread] BEGIN (implicit) |
| | | 2015-06-01 11:22:52,659 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO wikipages (title, body) VALUES (?, ?) |
| | | 2015-06-01 11:22:52,659 INFO [sqlalchemy.engine.base.Engine][MainThread] ('Root', '<p>Root</p>') |
| | | 2015-06-01 11:22:52,659 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT |
| | | |
| | | #. With our data now driven by SQLAlchemy queries, we need to update |
| | | our ``databases/tutorial/views.py``: |
| | | |
| | |
| | | use = egg:pyramid#wsgiref |
| | | host = 0.0.0.0 |
| | | port = 6543 |
| | | |
| | | # Begin logging configuration |
| | | |
| | | [loggers] |
| | | keys = root, tutorial, sqlalchemy.engine.base.Engine |
| | | |
| | | [logger_tutorial] |
| | | level = DEBUG |
| | | handlers = |
| | | qualname = tutorial |
| | | |
| | | [handlers] |
| | | keys = console |
| | | |
| | | [formatters] |
| | | keys = generic |
| | | |
| | | [logger_root] |
| | | level = INFO |
| | | handlers = console |
| | | |
| | | [logger_sqlalchemy.engine.base.Engine] |
| | | level = INFO |
| | | handlers = |
| | | qualname = sqlalchemy.engine.base.Engine |
| | | |
| | | [handler_console] |
| | | class = StreamHandler |
| | | args = (sys.stderr,) |
| | | level = NOTSET |
| | | formatter = generic |
| | | |
| | | [formatter_generic] |
| | | format = %(asctime)s %(levelname)-5.5s [%(name)s][%(threadName)s] %(message)s |
| | | |
| | | # End logging configuration |
| | |
| | | |
| | | class WikiFunctionalTests(unittest.TestCase): |
| | | def setUp(self): |
| | | self.session = _initTestingDB() |
| | | self.config = testing.setUp() |
| | | from pyramid.paster import get_app |
| | | app = get_app('development.ini') |
| | |
| | | self.testapp = TestApp(app) |
| | | |
| | | def tearDown(self): |
| | | self.session.remove() |
| | | from .models import DBSession |
| | | DBSession.remove() |
| | | testing.tearDown() |
| | | |
| | | def test_it(self): |