Test and debug Exposed upsert

sylux6 / WatanaBot

A discord bot written in Kotlin using JDA

GNU General Public License v3.0

0 stars 0 forks source link

Test and debug Exposed upsert #87

Closed sylux6 closed 4 years ago

sylux6 commented 4 years ago

Hmmm...

sylux6 commented 4 years ago

Set birthday then reuse command... tada it works. Something is wrong with UPSERT command again

sylux6 commented 4 years ago

This seems to happen when trying to marry a ship while user doesn't exist in users table. Somehow, it works with set birthday while it uses the same method...

Try to redefine unique index on tables with new columns in harmonica migration.

sylux6 commented 4 years ago

In the worst case, reimplement it without ON CONFLICT but with Exposed DSL

sylux6 commented 4 years ago

Another reason that must be the right answer: the database refactor and importing process messed up the row ids...

EDIT: yes