improve diagnostics when unique index constraint is violated

[jschilli]

No description provided.

[Ramblurr]

Is this issue related to this error?

version: 2.4.2
events.js:154
      throw er; // Unhandled 'error' event
      ^

Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: searchIndex.name, searchIndex.type, searchIndex.path
    at Error (native)

Is there a workaround?

[jschilli]

It's been a while since I looked at this.

My recollection is that you can turn on verbose output which should point some additional detail

add verbose: true to your options

Happy to help, but little context to go on here

[Ramblurr]

I worked around the issue for now by adding OR IGNORE to the insert statement. It looks like this mostly affects attributes and properties that have common names (e.g., name). This is ok as I mainly want the class documentation.