openlp-core team mailing list archive

[Tim Bentley <tim.bentley@xxxxxxxxx>]

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.