src/sql/setlist_song_upsert.sql


1
2
3
4
5
6

INSERT INTO [at_setlist_song] (setlist_uuid,song_uuid)
	VALUES('%s','%s')
		ON CONFLICT(setlist_uuid,song_uuid) DO UPDATE SET
			is_deleted=0
			,modification_dt=unixepoch('now')
		WHERE setlist_uuid=excluded.setlist_uuid AND song_uuid=excluded.song_uuid;