output

2012-12-10 21:45:44,898 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("artist")
2012-12-10 21:45:44,898 INFO sqlalchemy.engine.base.Engine ()
2012-12-10 21:45:44,898 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("album")
2012-12-10 21:45:44,898 INFO sqlalchemy.engine.base.Engine ()
2012-12-10 21:45:44,898 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("track")
2012-12-10 21:45:44,898 INFO sqlalchemy.engine.base.Engine ()
2012-12-10 21:45:44,900 INFO sqlalchemy.engine.base.Engine
CREATE TABLE artist (
	id INTEGER NOT NULL,
	name VARCHAR,
	PRIMARY KEY (id)
)


2012-12-10 21:45:44,900 INFO sqlalchemy.engine.base.Engine ()
2012-12-10 21:45:45,005 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-10 21:45:45,006 INFO sqlalchemy.engine.base.Engine
CREATE TABLE album (
	id INTEGER NOT NULL,
	title VARCHAR,
	artist INTEGER,
	year INTEGER,
	PRIMARY KEY (id),
	FOREIGN KEY(artist) REFERENCES artist (id)
)


2012-12-10 21:45:45,006 INFO sqlalchemy.engine.base.Engine ()
2012-12-10 21:45:45,112 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-10 21:45:45,112 INFO sqlalchemy.engine.base.Engine
CREATE TABLE track (
	id INTEGER NOT NULL,
	tracknumber INTEGER,
	discbumber INTEGER,
	title VARCHAR,
	source VARCHAR,
	album INTEGER,
	artist INTEGER,
	PRIMARY KEY (id),
	FOREIGN KEY(album) REFERENCES album (id),
	FOREIGN KEY(artist) REFERENCES artist (id)
)


2012-12-10 21:45:45,114 INFO sqlalchemy.engine.base.Engine ()
2012-12-10 21:45:45,224 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-10 21:45:45,246 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2012-12-10 21:45:45,246 INFO sqlalchemy.engine.base.Engine SELECT artist.id AS artist_id, artist.name AS artist_name
FROM artist
WHERE artist.name = ?
 LIMIT ? OFFSET ?
2012-12-10 21:45:45,246 INFO sqlalchemy.engine.base.Engine (u'Air', 1, 0)
2012-12-10 21:45:45,247 INFO sqlalchemy.engine.base.Engine INSERT INTO artist (name) VALUES (?)
2012-12-10 21:45:45,247 INFO sqlalchemy.engine.base.Engine (u'Air',)
2012-12-10 21:45:45,249 INFO sqlalchemy.engine.base.Engine COMMIT
2012-12-10 21:45:45,328 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2012-12-10 21:45:45,329 INFO sqlalchemy.engine.base.Engine SELECT album.id AS album_id, album.title AS album_title, album.artist AS album_artist, album.year AS album_year
FROM album
WHERE album.year = ? AND album.title = ?
 LIMIT ? OFFSET ?
2012-12-10 21:45:45,329 INFO sqlalchemy.engine.base.Engine (u'2004', u'Talkie Walkie', 1, 0)
2012-12-10 21:45:45,331 INFO sqlalchemy.engine.base.Engine INSERT INTO album (title, artist, year) VALUES (?, ?, ?)
2012-12-10 21:45:45,331 INFO sqlalchemy.engine.base.Engine (u'Talkie Walkie', <Artist Air>, u'2004')
2012-12-10 21:45:45,332 INFO sqlalchemy.engine.base.Engine ROLLBACK
Traceback (most recent call last):
  File "C:\__DEV\PROJECTS\PySideMedia\PySideMedia\musiclogic.py", line 93, in <module>
    for t in TrackIter('D:\\# MUSIC\\Air'):
  File "C:\__DEV\PROJECTS\PySideMedia\PySideMedia\musiclogic.py", line 42, in next
    album = self._saveAlbum(_album, artist)
  File "C:\__DEV\PROJECTS\PySideMedia\PySideMedia\musiclogic.py", line 77, in _saveAlbum
    self.db.session.commit()
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\session.py", line 703, in commit
    self.transaction.commit()
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\session.py", line 361, in commit
    self._prepare_impl()
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\session.py", line 340, in _prepare_impl
    self.session.flush()
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\session.py", line 1718, in flush
    self._flush(objects)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\session.py", line 1789, in _flush
    flush_context.execute()
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\unitofwork.py", line 331, in execute
    rec.execute(self)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\unitofwork.py", line 475, in execute
    uow
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\persistence.py", line 64, in save_obj
    table, insert)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\orm\persistence.py", line 558, in _emit_insert_statements
    execute(statement, params)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\engine\base.py", line 1449, in execute
    params)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\engine\base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\engine\base.py", line 1698, in _execute_context
    context)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\engine\base.py", line 1691, in _execute_context
    context)
  File "C:\__DEV\LANG\PYTHON\2.7\lib\site-packages\sqlalchemy-0.7.9-py2.7.egg\sqlalchemy\engine\default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.InterfaceError