- 2019-02-16 21:45:23,919 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
- 2019-02-16 21:45:23,919 INFO sqlalchemy.engine.base.Engine ()
- 2019-02-16 21:45:23,919 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
- 2019-02-16 21:45:23,919 INFO sqlalchemy.engine.base.Engine ()
- 2019-02-16 21:45:23,920 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("users")
- 2019-02-16 21:45:23,920 INFO sqlalchemy.engine.base.Engine ()
- 2019-02-16 21:45:23,921 INFO sqlalchemy.engine.base.Engine
- CREATE TABLE users (
- id INTEGER NOT NULL,
- name VARCHAR,
- fullname VARCHAR,
- nickname VARCHAR,
- PRIMARY KEY (id)
- )
- 2019-02-16 21:45:23,921 INFO sqlalchemy.engine.base.Engine ()
- 2019-02-16 21:45:23,922 INFO sqlalchemy.engine.base.Engine COMMIT
- 2019-02-16 21:45:23,924 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
- 2019-02-16 21:45:23,925 INFO sqlalchemy.engine.base.Engine INSERT INTO users (name, fullname, nickname) VALUES (?, ?, ?)
- 2019-02-16 21:45:23,925 INFO sqlalchemy.engine.base.Engine ('ed', 'Ed Jones', 'edsnickname')
- 2019-02-16 21:45:23,926 INFO sqlalchemy.engine.base.Engine INSERT INTO users (name, fullname, nickname) VALUES (?, ?, ?)
- 2019-02-16 21:45:23,926 INFO sqlalchemy.engine.base.Engine ('wendy', 'Wendy Williams', 'windy')
- 2019-02-16 21:45:23,926 INFO sqlalchemy.engine.base.Engine INSERT INTO users (name, fullname, nickname) VALUES (?, ?, ?)
- 2019-02-16 21:45:23,926 INFO sqlalchemy.engine.base.Engine ('mary', 'Mary Contrary', 'mary')
- 2019-02-16 21:45:23,927 INFO sqlalchemy.engine.base.Engine COMMIT
- 2019-02-16 21:45:23,929 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
- 2019-02-16 21:45:23,929 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.name AS users_name, users.fullname AS users_fullname, users.nickname AS users_nickname
- FROM users
- WHERE users.id <?
- 2019-02-16 21:45:23,929 INFO sqlalchemy.engine.base.Engine (2,)
- [<User(name='ed', fullname='Ed Jones', nickname='edsnickname')>]
- 2019-02-16 21:45:23,931 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.name AS users_name, users.fullname AS users_fullname, users.nickname AS users_nickname
- FROM users
- WHERE users.id <= ?
- 2019-02-16 21:45:23,931 INFO sqlalchemy.engine.base.Engine (5,)
- [<User(name='ed', fullname='Ed Jones', nickname='edsnickname')>, <User(name='wendy', fullname='Wendy Williams', nickname='windy')>, <User(name='mary', fullname='Mary Contrary', nickname='mary')>]
- 2019-02-16 21:45:23,932 INFO sqlalchemy.engine.base.Engine UPDATE users SET name=? WHERE users.id = ?
- 2019-02-16 21:45:23,932 INFO sqlalchemy.engine.base.Engine ('admin', 1)
- 2019-02-16 21:45:23,933 INFO sqlalchemy.engine.base.Engine INSERT INTO users (name, fullname, nickname) VALUES (?, ?, ?)
- 2019-02-16 21:45:23,933 INFO sqlalchemy.engine.base.Engine ('fred', 'Fred Flintstone', 'freddy')
- 2019-02-16 21:45:23,934 INFO sqlalchemy.engine.base.Engine UPDATE users SET name=? WHERE users.id = ?
- 2019-02-16 21:45:23,934 INFO sqlalchemy.engine.base.Engine ('test', 2)
- 2019-02-16 21:45:23,935 INFO sqlalchemy.engine.base.Engine SELECT users.id AS users_id, users.name AS users_name, users.fullname AS users_fullname, users.nickname AS users_nickname
- FROM users
- WHERE users.id <= ?
- 2019-02-16 21:45:23,935 INFO sqlalchemy.engine.base.Engine (5,)
- [<User(name='admin', fullname='Ed Jones', nickname='edsnickname')>, <User(name='test', fullname='Wendy Williams', nickname='windy')>, <User(name='mary', fullname='Mary Contrary', nickname='mary')>, <User(name='fred', fullname='Fred Flintstone', nickname='freddy')>]
由于我们设置 create_engine 中 echo 为 True, 因此在执行结果中包含了 SQLAlchemy 打印的 SQL 语句, 我们可以取消 crete_engine 中的 echo
来源: http://www.bubuko.com/infodetail-2961390.html