Skip to content

Instantly share code, notes, and snippets.

@dhoss
Created September 23, 2016 18:11
Show Gist options
  • Save dhoss/acf0d7e83e0e27e01402f0d6a5f469a9 to your computer and use it in GitHub Desktop.
Save dhoss/acf0d7e83e0e27e01402f0d6a5f469a9 to your computer and use it in GitHub Desktop.
sqlalchemy transaction crap
sqlalchemy.engine.base.Engine: INFO: select version()
sqlalchemy.engine.base.Engine: INFO: {}
sqlalchemy.engine.base.Engine: INFO: select current_schema()
sqlalchemy.engine.base.Engine: INFO: {}
sqlalchemy.engine.base.Engine: INFO: SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
sqlalchemy.engine.base.Engine: INFO: {}
sqlalchemy.engine.base.Engine: INFO: SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
sqlalchemy.engine.base.Engine: INFO: {}
sqlalchemy.engine.base.Engine: INFO: show standard_conforming_strings
sqlalchemy.engine.base.Engine: INFO: {}
sqlalchemy.engine.base.Engine: INFO: BEGIN (implicit)
sqlalchemy.engine.base.Engine: INFO: select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=%(schema)s and relname=%(name)s
sqlalchemy.engine.base.Engine: INFO: {'name': u'post', 'schema': u'blog'}
sqlalchemy.engine.base.Engine: INFO: INSERT INTO blog.post (title, body, author, created_on, updated_on) VALUES (%(title)s, %(body)s, %(author)s, %(created_on)s, %(updated_on)s) RETURNING blog.post.id
sqlalchemy.engine.base.Engine: INFO: {'body': 'test body', 'updated_on': datetime.datetime(2016, 9, 23, 18, 11, 22, 509447, tzinfo=<UTC>), 'created_on': datetime.datetime(2016, 9, 23, 18, 11, 22, 509418, tzinfo=<UTC>), 'title': 'test', 'author': 1}
sqlalchemy.engine.base.Engine: INFO: SAVEPOINT sa_savepoint_1
sqlalchemy.engine.base.Engine: INFO: {}
sqlalchemy.engine.base.Engine: INFO: SELECT blog.post.id AS blog_post_id, blog.post.title AS blog_post_title, blog.post.body AS blog_post_body, blog.post.author AS blog_post_author, blog.post.created_on AS blog_post_created_on, blog.post.updated_on AS blog_post_updated_on, blog.post.published_on AS blog_post_published_on
FROM blog.post
sqlalchemy.engine.base.Engine: INFO: {}
.sqlalchemy.engine.base.Engine: INFO: ROLLBACK
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment