Skip to content

Instantly share code, notes, and snippets.

@dianaclarke

dianaclarke/gist:25cf1262e5dd28883c661ad7830644a4 Secret

Created March 16, 2017 14:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dianaclarke/25cf1262e5dd28883c661ad7830644a4 to your computer and use it in GitHub Desktop.
Save dianaclarke/25cf1262e5dd28883c661ad7830644a4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
2017-03-16 10:03:26,953 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2017-03-16 10:03:26,953 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,954 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2017-03-16 10:03:26,954 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,955 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("baby")
2017-03-16 10:03:26,955 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,956 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("person")
2017-03-16 10:03:26,956 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,956 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("baby")
2017-03-16 10:03:26,956 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,957 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("person")
2017-03-16 10:03:26,957 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,958 INFO sqlalchemy.engine.base.Engine
CREATE TABLE person (
id INTEGER NOT NULL,
_name VARCHAR,
PRIMARY KEY (id)
)
2017-03-16 10:03:26,958 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,958 INFO sqlalchemy.engine.base.Engine COMMIT
2017-03-16 10:03:26,959 INFO sqlalchemy.engine.base.Engine
CREATE TABLE baby (
id INTEGER NOT NULL,
nickname VARCHAR,
PRIMARY KEY (id),
FOREIGN KEY(id) REFERENCES person (id)
)
2017-03-16 10:03:26,959 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,959 INFO sqlalchemy.engine.base.Engine COMMIT
2017-03-16 10:03:26,960 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2017-03-16 10:03:26,961 INFO sqlalchemy.engine.base.Engine INSERT INTO person (_name) VALUES (?)
2017-03-16 10:03:26,961 INFO sqlalchemy.engine.base.Engine ('DIANA',)
2017-03-16 10:03:26,962 INFO sqlalchemy.engine.base.Engine COMMIT
2017-03-16 10:03:26,962 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2017-03-16 10:03:26,963 INFO sqlalchemy.engine.base.Engine INSERT INTO person (_name) VALUES (?)
2017-03-16 10:03:26,963 INFO sqlalchemy.engine.base.Engine ('GWEN',)
2017-03-16 10:03:26,963 INFO sqlalchemy.engine.base.Engine INSERT INTO baby (id, nickname) VALUES (?, ?)
2017-03-16 10:03:26,963 INFO sqlalchemy.engine.base.Engine (2, 'bean')
2017-03-16 10:03:26,964 INFO sqlalchemy.engine.base.Engine COMMIT
2017-03-16 10:03:26,965 INFO sqlalchemy.engine.base.Engine SELECT person.id AS person_id, person._name AS person__name
FROM person
2017-03-16 10:03:26,965 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,966 DEBUG sqlalchemy.engine.base.Engine Col ('person_id', 'person__name')
2017-03-16 10:03:26,966 DEBUG sqlalchemy.engine.base.Engine Row (1, u'DIANA')
2017-03-16 10:03:26,966 DEBUG sqlalchemy.engine.base.Engine Row (2, u'GWEN')
------sql: DIANA DIANA
------sql: GWEN GWEN
2017-03-16 10:03:26,967 INFO sqlalchemy.engine.base.Engine SELECT baby.id AS baby_id, person.id AS person_id, person._name AS person__name, baby.nickname AS baby_nickname
FROM person JOIN baby ON person.id = baby.id
2017-03-16 10:03:26,967 INFO sqlalchemy.engine.base.Engine ()
2017-03-16 10:03:26,967 DEBUG sqlalchemy.engine.base.Engine Col ('baby_id', 'person_id', 'person__name', 'baby_nickname')
2017-03-16 10:03:26,968 DEBUG sqlalchemy.engine.base.Engine Row (2, 2, u'GWEN', u'bean')
------sql: GWEN GWEN bean
------python: Mike Mike
------python: JULIAN JULIAN
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment