diff options
| author | Michael Merickel <michael@merickel.org> | 2022-12-29 16:45:48 -0600 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-12-29 16:45:48 -0600 |
| commit | dc4e2e282d60a8387e60ac5fd2b1813b9df3535d (patch) | |
| tree | 8664fdc6dd332dd55c2a0fb11970c856fb900bd4 /docs | |
| parent | 13df6badcf97ad379dc88bb9773bdabc1520a71d (diff) | |
| parent | 4703e60eb7ddb870bf2cc69eaafd8e12fa966636 (diff) | |
| download | pyramid-dc4e2e282d60a8387e60ac5fd2b1813b9df3535d.tar.gz pyramid-dc4e2e282d60a8387e60ac5fd2b1813b9df3535d.tar.bz2 pyramid-dc4e2e282d60a8387e60ac5fd2b1813b9df3535d.zip | |
Merge branch 'master' into main
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/quick_tutorial/databases.rst | 30 | ||||
| -rw-r--r-- | docs/quick_tutorial/databases/development.ini | 6 |
2 files changed, 18 insertions, 18 deletions
diff --git a/docs/quick_tutorial/databases.rst b/docs/quick_tutorial/databases.rst index 968c7b6a4..5582e6101 100644 --- a/docs/quick_tutorial/databases.rst +++ b/docs/quick_tutorial/databases.rst @@ -13,8 +13,8 @@ Background Our Pyramid-based wiki application now needs database-backed storage of pages. This frequently means an SQL database. The Pyramid community strongly supports the :ref:`SQLAlchemy <sqla:index_toplevel>` project and its -:ref:`object-relational mapper (ORM) <sqla:orm_quickstart>` as a -convenient, Pythonic way to interface to databases. +:ref:`object-relational mapper (ORM) <sqla:orm_toplevel>` as a convenient, +Pythonic way to interface to databases. In this step we hook up SQLAlchemy to a SQLite database table, providing storage and retrieval for the wiki pages in the previous step. @@ -87,13 +87,13 @@ Steps $VENV/bin/initialize_tutorial_db development.ini - 2016-04-16 13:01:33,055 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1 - 2016-04-16 13:01:33,055 INFO [sqlalchemy.engine.base.Engine][MainThread] () - 2016-04-16 13:01:33,056 INFO [sqlalchemy.engine.base.Engine][MainThread] SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1 - 2016-04-16 13:01:33,056 INFO [sqlalchemy.engine.base.Engine][MainThread] () - 2016-04-16 13:01:33,057 INFO [sqlalchemy.engine.base.Engine][MainThread] PRAGMA table_info("wikipages") - 2016-04-16 13:01:33,057 INFO [sqlalchemy.engine.base.Engine][MainThread] () - 2016-04-16 13:01:33,058 INFO [sqlalchemy.engine.base.Engine][MainThread] + 2016-04-16 13:01:33,055 INFO [sqlalchemy.engine.Engine][MainThread] SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1 + 2016-04-16 13:01:33,055 INFO [sqlalchemy.engine.Engine][MainThread] () + 2016-04-16 13:01:33,056 INFO [sqlalchemy.engine.Engine][MainThread] SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1 + 2016-04-16 13:01:33,056 INFO [sqlalchemy.engine.Engine][MainThread] () + 2016-04-16 13:01:33,057 INFO [sqlalchemy.engine.Engine][MainThread] PRAGMA table_info("wikipages") + 2016-04-16 13:01:33,057 INFO [sqlalchemy.engine.Engine][MainThread] () + 2016-04-16 13:01:33,058 INFO [sqlalchemy.engine.Engine][MainThread] CREATE TABLE wikipages ( uid INTEGER NOT NULL, title TEXT, @@ -103,12 +103,12 @@ Steps ) - 2016-04-16 13:01:33,058 INFO [sqlalchemy.engine.base.Engine][MainThread] () - 2016-04-16 13:01:33,059 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT - 2016-04-16 13:01:33,062 INFO [sqlalchemy.engine.base.Engine][MainThread] BEGIN (implicit) - 2016-04-16 13:01:33,062 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO wikipages (title, body) VALUES (?, ?) - 2016-04-16 13:01:33,063 INFO [sqlalchemy.engine.base.Engine][MainThread] ('Root', '<p>Root</p>') - 2016-04-16 13:01:33,063 INFO [sqlalchemy.engine.base.Engine][MainThread] COMMIT + 2016-04-16 13:01:33,058 INFO [sqlalchemy.engine.Engine][MainThread] () + 2016-04-16 13:01:33,059 INFO [sqlalchemy.engine.Engine][MainThread] COMMIT + 2016-04-16 13:01:33,062 INFO [sqlalchemy.engine.Engine][MainThread] BEGIN (implicit) + 2016-04-16 13:01:33,062 INFO [sqlalchemy.engine.Engine][MainThread] INSERT INTO wikipages (title, body) VALUES (?, ?) + 2016-04-16 13:01:33,063 INFO [sqlalchemy.engine.Engine][MainThread] ('Root', '<p>Root</p>') + 2016-04-16 13:01:33,063 INFO [sqlalchemy.engine.Engine][MainThread] COMMIT #. With our data now driven by SQLAlchemy queries, we need to update our ``databases/tutorial/views.py``: diff --git a/docs/quick_tutorial/databases/development.ini b/docs/quick_tutorial/databases/development.ini index 270cf7b63..1c02a8ed2 100644 --- a/docs/quick_tutorial/databases/development.ini +++ b/docs/quick_tutorial/databases/development.ini @@ -14,7 +14,7 @@ listen = localhost:6543 # Begin logging configuration [loggers] -keys = root, tutorial, sqlalchemy.engine.base.Engine +keys = root, tutorial, sqlalchemy.engine.Engine [logger_tutorial] level = DEBUG @@ -31,10 +31,10 @@ keys = generic level = INFO handlers = console -[logger_sqlalchemy.engine.base.Engine] +[logger_sqlalchemy.engine.Engine] level = INFO handlers = -qualname = sqlalchemy.engine.base.Engine +qualname = sqlalchemy.engine.Engine [handler_console] class = StreamHandler |