Review: Needs Fixing
Just changed a song from old style to new style authors and go this.
Traceback (most recent call last):
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 856,
in _execute_context
context)
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/default.py", line
323, in do_executemany
cursor.executemany(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: authors_songs.author_id,
authors_songs.song_id
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/home/tim/Projects/openlp/author-types/openlp/plugins/songs/forms/editsongform.py",
line 872, in accept
self.save_song()
File
"/home/tim/Projects/openlp/author-types/openlp/plugins/songs/forms/editsongform.py",
line 930, in save_song
clean_song(self.manager, self.song)
File
"/home/tim/Projects/openlp/author-types/openlp/plugins/songs/lib/__init__.py",
line 393, in clean_song
if not song.authors and not song.authors_songs: # Need to check both
relations
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/attributes.py", line
316, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/attributes.py", line
613, in get
value = self.callable_(state, passive)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/strategies.py", line
524, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/strategies.py", line
585, in _emit_lazyload
result = q.all()
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/query.py", line 2249,
in all
return list(self)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/query.py", line 2360,
in __iter__
self.session._autoflush()
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/session.py", line 1139,
in _autoflush
self.flush()
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/session.py", line 1824,
in flush
self._flush(objects)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/session.py", line 1942,
in _flush
transaction.rollback(_capture_exception=True)
File "/usr/lib/python3.3/site-packages/sqlalchemy/util/langhelpers.py", line
60, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 184,
in reraise
raise value
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/session.py", line 1906,
in _flush
flush_context.execute()
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/unitofwork.py", line
372, in execute
rec.execute(self)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/unitofwork.py", line
525, in execute
uow
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/persistence.py", line
64, in save_obj
table, insert)
File "/usr/lib/python3.3/site-packages/sqlalchemy/orm/persistence.py", line
541, in _emit_insert_statements
execute(statement, multiparams)
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 662,
in execute
params)
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 761,
in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 874,
in _execute_context
context)
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 1024,
in _handle_dbapi_exception
exc_info
File "/usr/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 188,
in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=exc_value)
File "/usr/lib/python3.3/site-packages/sqlalchemy/util/compat.py", line 183,
in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/base.py", line 856,
in _execute_context
context)
File "/usr/lib/python3.3/site-packages/sqlalchemy/engine/default.py", line
323, in do_executemany
cursor.executemany(statement, parameters)
sqlalchemy.exc.IntegrityError: (IntegrityError) UNIQUE constraint failed:
authors_songs.author_id, authors_songs.song_id 'INSERT INTO authors_songs
(author_id, song_id, author_type) VALUES (?, ?, ?)' ((17, 664, 'words'), (127,
664, 'words'))
--
https://code.launchpad.net/~sam92/openlp/author-types/+merge/213857
Your team OpenLP Core is subscribed to branch lp:openlp.
_______________________________________________
Mailing list: https://launchpad.net/~openlp-core
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openlp-core
More help : https://help.launchpad.net/ListHelp
