SQLite error 19: UNIQUE constraint failed in Reminders example preview mode

[jcmourey]

Description

seedSampleData() is called from appDatabase() when in preview mode.
Also, in preview mode: seedSampleData is called from the Seed Data Toolbar button
This causes SQLite to fail from attempting to add duplicate data.

Checklist

• I have determined whether this bug is also reproducible in a vanilla SwiftUI project.
• I have determined whether this bug is also reproducible in a vanilla GRDB project.
• If possible, I've reproduced the issue using the main branch of this package.
• This issue hasn't been addressed in an existing GitHub issue or discussion.

Expected behavior

Not really a big deal, but since it is a demo project that should probably as clean as possible, seedSampleData should probably get called from one or the other place, not both.

Actual behavior

🟣 Reminders/RemindersLists.swift:146: Caught error: SQLite error 19: UNIQUE constraint failed: tags.title - while executing INSERT INTO "tags" ("title") VALUES (?), (?), (?), (?), (?), (?), (?)

Reproducing project

No response

SQLiteData version information

No response

Sharing version information

No response

GRDB version information

No response

Destination operating system

No response

Xcode version information

No response

Swift Compiler version information

[mbrandonw]

Hi @jcmourey, if you would like to fix this we would happily merge a PR. But we don't really consider this an issue so I am going to convert to a discussion.

One approach would be to explicitly invoke seedSampleData() in each preview and remove it from the appDatabase() function.