2007-11-07 14:42:12,666 INFO sqlalchemy.engine.base.Engine.0x..54 select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and lower(relname)=%(name)s
2007-11-07 14:42:12,668 INFO sqlalchemy.engine.base.Engine.0x..54 {'name': 'referer'}
2007-11-07 14:42:12,681 INFO sqlalchemy.engine.base.Engine.0x..54 select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and lower(relname)=%(name)s
2007-11-07 14:42:12,683 INFO sqlalchemy.engine.base.Engine.0x..54 {'name': 'test'}
2007-11-07 14:42:12,689 INFO sqlalchemy.engine.base.Engine.0x..54
DROP TABLE referer
2007-11-07 14:42:12,691 INFO sqlalchemy.engine.base.Engine.0x..54 {}
2007-11-07 14:42:12,705 INFO sqlalchemy.engine.base.Engine.0x..54 COMMIT
2007-11-07 14:42:12,716 INFO sqlalchemy.engine.base.Engine.0x..54
DROP TABLE test
2007-11-07 14:42:12,718 INFO sqlalchemy.engine.base.Engine.0x..54 {}
2007-11-07 14:42:12,728 INFO sqlalchemy.engine.base.Engine.0x..54 COMMIT
2007-11-07 14:42:12,738 INFO sqlalchemy.engine.base.Engine.0x..54 select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and lower(relname)=%(name)s
2007-11-07 14:42:12,740 INFO sqlalchemy.engine.base.Engine.0x..54 {'name': 'test'}
2007-11-07 14:42:12,747 INFO sqlalchemy.engine.base.Engine.0x..54 select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and lower(relname)=%(name)s
2007-11-07 14:42:12,748 INFO sqlalchemy.engine.base.Engine.0x..54 {'name': 'referer'}
2007-11-07 14:42:12,755 INFO sqlalchemy.engine.base.Engine.0x..54
CREATE TABLE test (
id SERIAL NOT NULL,
data TEXT,
PRIMARY KEY (id)
)
2007-11-07 14:42:12,756 INFO sqlalchemy.engine.base.Engine.0x..54 {}
2007-11-07 14:42:12,798 INFO sqlalchemy.engine.base.Engine.0x..54 COMMIT
2007-11-07 14:42:12,803 INFO sqlalchemy.engine.base.Engine.0x..54
CREATE TABLE referer (
id SERIAL NOT NULL,
fk INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(fk) REFERENCES test (id)
)
2007-11-07 14:42:12,805 INFO sqlalchemy.engine.base.Engine.0x..54 {}
2007-11-07 14:42:12,832 INFO sqlalchemy.engine.base.Engine.0x..54 COMMIT
2007-11-07 14:42:12,838 INFO sqlalchemy.engine.base.Engine.0x..54 INSERT INTO test (data) VALUES (%(data)s)
2007-11-07 14:42:12,840 INFO sqlalchemy.engine.base.Engine.0x..54 [{'data': 1}, {'data': 2}, {'data': 3}, {'data': 4}, {'data': 5}, {'data': 6}, {'data': 7}, {'data': 8}, {'data': 9}, {'data': 10}, {'data': 11}, {'data': 12}, {'data': 13}, {'data': 14}, {'data': 15}, {'data': 30}, {'data': 44}, {'data': 55}]
2007-11-07 14:42:12,861 INFO sqlalchemy.engine.base.Engine.0x..54 COMMIT
2007-11-07 14:42:12,868 INFO sqlalchemy.engine.base.Engine.0x..54 select nextval('"referer_id_seq"')
2007-11-07 14:42:12,869 INFO sqlalchemy.engine.base.Engine.0x..54 None
2007-11-07 14:42:12,873 INFO sqlalchemy.engine.base.Engine.0x..54 INSERT INTO referer (id, fk) VALUES (%(id)s, %(fk)s)
2007-11-07 14:42:12,875 INFO sqlalchemy.engine.base.Engine.0x..54 {'fk': 2, 'id': 1L}
2007-11-07 14:42:12,880 INFO sqlalchemy.engine.base.Engine.0x..54 COMMIT
2007-11-07 14:42:12,914 INFO sqlalchemy.engine.base.Engine.0x..54 SELECT "testView".id AS "testView_id", "testView".data AS "testView_data"
FROM (SELECT test.id AS id, test.data AS data
FROM test
WHERE test.id IN (%(test_id)s, %(test_id_1)s, %(test_id_2)s, %(test_id_3)s, %(test_id_4)s, %(test_id_5)s, %(test_id_6)s, %(test_id_7)s, %(test_id_8)s, %(test_id_9)s, %(test_id_10)s)) AS "testView"
WHERE "testView".id = %(param_1)s ORDER BY "testView".id
2007-11-07 14:42:12,915 INFO sqlalchemy.engine.base.Engine.0x..54 {'test_id_3': 5, 'test_id_10': 45, 'param_1': 2, 'test_id_8': 30, 'test_id_9': 44, 'test_id_1': 3, 'test_id_2': 4, 'test_id': 2, 'test_id_4': 8, 'test_id_5': 10, 'test_id_6': 11, 'test_id_7': 13}
<__main__.Test object at 0xb7c8ba4c>
2007-11-07 14:42:12,930 INFO sqlalchemy.engine.base.Engine.0x..54 SELECT referer.id AS referer_id, referer.fk AS referer_fk
FROM referer
WHERE referer.id = %(param_1)s ORDER BY referer.id
2007-11-07 14:42:12,931 INFO sqlalchemy.engine.base.Engine.0x..54 {'param_1': 1}
2 <__main__.Test object at 0xb7c8ba4c>