schema

const (
	InsertDbQ    = "INSERT INTO dbs(id, name) VALUES (?, ?) ON CONFLICT DO NOTHING;"
	InsertTableQ = "INSERT INTO tables(id, name) VALUES (?, ?) ON CONFLICT DO NOTHING;"
	InsertTypeQ  = "INSERT INTO types(id, name) VALUES (?, ?) ON CONFLICT DO NOTHING;"
	InsertUrlQ   = "INSERT INTO urls(id, url) VALUES (?, ?) ON CONFLICT DO NOTHING;"
	InsertNoteQ  = "INSERT INTO notes(id, note) VALUES (?, ?) ON CONFLICT DO NOTHING;"

	InsertColumnQ = "INSERT INTO columns(id, table_id, name) VALUES (?, ?, ?) " +
		"ON CONFLICT DO NOTHING;"

	InsertVersionQ = "INSERT INTO versions(id, db_id, version, is_current, version_order) " +
		"VALUES (?, ?, ?, ?, ?) ON CONFLICT DO UPDATE SET" +
		" is_current = coalesce(excluded.is_current, is_current)" +
		" , version_order = coalesce(excluded.version_order, version_order);"
	InsertLicenseQ = "INSERT INTO licenses(id, license, attribution, url_id) " +
		"VALUES (?, ?, ?, ?) ON CONFLICT DO NOTHING;" // ?
	InsertColumnVersionQ = "INSERT INTO column_versions(" +
		"id, column_id, version_id, type_id, nullable, url_id, note_id, note_license_id" +
		") VALUES (?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT(id) DO UPDATE SET" +
		" type_id = coalesce(excluded.type_id, type_id)" +
		" , url_id = coalesce(excluded.url_id, url_id)" +
		" , note_id = coalesce(excluded.note_id, note_id)" +
		" , note_license_id = coalesce(excluded.note_license_id, note_license_id);"
)