src/sql/section_upsert.sql


1
2
3
4
5
6
7
8
9

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
			,beats_per_bar=excluded.beats_per_bar
			,bar_count=excluded.bar_count
			,is_deleted=0
			,modification_dt=unixepoch('now')
		WHERE song_uuid=excluded.uuid AND sequence=excluded.sequence;