src/sql/section_upsert.sql


1
2
3
4
5
6
7
8
9
10

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
			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;