diff options
Diffstat (limited to 'src/sql/section_upsert.sql')
| -rw-r--r-- | src/sql/section_upsert.sql | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/src/sql/section_upsert.sql b/src/sql/section_upsert.sql index 4ca1025..659d66a 100644 --- a/src/sql/section_upsert.sql +++ b/src/sql/section_upsert.sql @@ -1,10 +1,9 @@ -INSERT INTO [at_section] (uuid,section_type,sequence,beats_per_bar,bar_count) - VALUES('%s','%s','%s','%s','%s') - ON CONFLICT(uuid) DO UPDATE SET +INSERT INTO [at_section] (uuid,sequence,section_type,beats_per_bar,bar_count) + VALUES('%s','%i','%u','%u','%u') + ON CONFLICT(song_uuid,sequence) DO UPDATE SET section_type=excluded.section_type - ,sequence=excluded.sequence ,beats_per_bar=excluded.beats_per_bar ,bar_count=excluded.bar_count ,is_deleted=0 ,modification_dt=unixepoch('now') - WHERE uuid=excluded.uuid; + WHERE song_uuid=excluded.uuid AND sequence=excluded.sequence; |