Gohan
2/1/2012 - 4:06 PM

sqlalchemy test

sqlalchemy test

ipython.log
content_copyfile_download
In [8]: %edit main.py
Editing... done. Executing edited code...
2012-02-02 00:04:48,288 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("members")
2012-02-02 00:04:48,288 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,291 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("cast_types")
2012-02-02 00:04:48,291 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,296 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("persons")
2012-02-02 00:04:48,296 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,297 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("movies")
2012-02-02 00:04:48,297 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,297 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("cast_entries")
2012-02-02 00:04:48,297 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,297 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("reviews")
2012-02-02 00:04:48,297 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,298 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE members (
	id INTEGER NOT NULL, 
	username VARCHAR, 
	PRIMARY KEY (id)
)


2012-02-02 00:04:48,298 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,300 INFO sqlalchemy.engine.base.Engine COMMIT
2012-02-02 00:04:48,300 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE cast_types (
	id INTEGER NOT NULL, 
	typename VARCHAR, 
	PRIMARY KEY (id)
)


2012-02-02 00:04:48,300 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,302 INFO sqlalchemy.engine.base.Engine COMMIT
2012-02-02 00:04:48,303 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE persons (
	id INTEGER NOT NULL, 
	name VARCHAR, 
	PRIMARY KEY (id)
)


2012-02-02 00:04:48,303 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,305 INFO sqlalchemy.engine.base.Engine COMMIT
2012-02-02 00:04:48,306 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE movies (
	id INTEGER NOT NULL, 
	title VARCHAR, 
	PRIMARY KEY (id)
)


2012-02-02 00:04:48,306 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,308 INFO sqlalchemy.engine.base.Engine COMMIT
2012-02-02 00:04:48,309 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE cast_entries (
	id INTEGER NOT NULL, 
	cast_type INTEGER, 
	person_id INTEGER, 
	movie_id INTEGER, 
	PRIMARY KEY (id), 
	FOREIGN KEY(cast_type) REFERENCES cast_types (id), 
	FOREIGN KEY(person_id) REFERENCES persons (id), 
	FOREIGN KEY(movie_id) REFERENCES movies (id)
)


2012-02-02 00:04:48,309 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,311 INFO sqlalchemy.engine.base.Engine COMMIT
2012-02-02 00:04:48,312 INFO sqlalchemy.engine.base.Engine 
CREATE TABLE reviews (
	id INTEGER NOT NULL, 
	title VARCHAR, 
	member_id INTEGER, 
	movie_id INTEGER, 
	PRIMARY KEY (id), 
	FOREIGN KEY(member_id) REFERENCES members (id), 
	FOREIGN KEY(movie_id) REFERENCES movies (id)
)


2012-02-02 00:04:48,312 INFO sqlalchemy.engine.base.Engine ()
2012-02-02 00:04:48,315 INFO sqlalchemy.engine.base.Engine COMMIT
2012-02-02 00:04:48,330 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2012-02-02 00:04:48,331 INFO sqlalchemy.engine.base.Engine INSERT INTO members (username) VALUES (?)
2012-02-02 00:04:48,331 INFO sqlalchemy.engine.base.Engine ('cppgohan',)
2012-02-02 00:04:48,332 INFO sqlalchemy.engine.base.Engine INSERT INTO cast_types (typename) VALUES (?)
2012-02-02 00:04:48,332 INFO sqlalchemy.engine.base.Engine ('director',)
2012-02-02 00:04:48,333 INFO sqlalchemy.engine.base.Engine INSERT INTO cast_types (typename) VALUES (?)
2012-02-02 00:04:48,333 INFO sqlalchemy.engine.base.Engine ('actor',)
2012-02-02 00:04:48,334 INFO sqlalchemy.engine.base.Engine INSERT INTO movies (title) VALUES (?)
2012-02-02 00:04:48,334 INFO sqlalchemy.engine.base.Engine ('movie001',)
2012-02-02 00:04:48,335 INFO sqlalchemy.engine.base.Engine INSERT INTO persons (name) VALUES (?)
2012-02-02 00:04:48,336 INFO sqlalchemy.engine.base.Engine ('actor1',)
2012-02-02 00:04:48,336 INFO sqlalchemy.engine.base.Engine INSERT INTO persons (name) VALUES (?)
2012-02-02 00:04:48,336 INFO sqlalchemy.engine.base.Engine ('d2',)
2012-02-02 00:04:48,338 INFO sqlalchemy.engine.base.Engine INSERT INTO reviews (title, member_id, movie_id) VALUES (?, ?, ?)
2012-02-02 00:04:48,338 INFO sqlalchemy.engine.base.Engine ("cppgohan's movie001 review1", 1, 1)
2012-02-02 00:04:48,339 INFO sqlalchemy.engine.base.Engine INSERT INTO cast_entries (cast_type, person_id, movie_id) VALUES (?, ?, ?)
2012-02-02 00:04:48,339 INFO sqlalchemy.engine.base.Engine (1, 1, 1)
2012-02-02 00:04:48,340 INFO sqlalchemy.engine.base.Engine INSERT INTO cast_entries (cast_type, person_id, movie_id) VALUES (?, ?, ?)
2012-02-02 00:04:48,340 INFO sqlalchemy.engine.base.Engine (2, 2, 1)
2012-02-02 00:04:48,341 INFO sqlalchemy.engine.base.Engine COMMIT