database

const GET_ALL_ARTISTS = "select id, name, default_genre FROM artists;"

const GET_ALL_LOCATIONS = `` /* 143-byte string literal not displayed */

const GET_ALL_SETS = "select sets.id, user_id, artists.id, artists.name, locations.id, locations.name, sets.date, sets.rating, sets.genre, sets.length, sets.notes " +
	"FROM sets INNER JOIN artists ON artists.id = sets.artist_id " +
	"INNER JOIN locations ON locations.id = sets.location_id;"

const GET_ALL_SETS_FOR_USER_FORMAT = "select sets.id, user_id, artists.id, artists.name, locations.id, locations.name, sets.date, sets.rating, sets.genre, sets.length, sets.notes " +
	"FROM sets INNER JOIN artists ON artists.id = sets.artist_id " +
	"INNER JOIN locations ON locations.id = sets.location_id " +
	"WHERE user_id=%d;"

const GET_ALL_USERS = `select id, username, email, IFNULL(first_name,""), IFNULL(last_name,""), role FROM users;`

const GET_ARTIST_DEFAULT_GENRE = `select default_genre FROM artists where name = ? or id = ?;`

const GET_LOCATION_TYPE = `select is_festival FROM locations where id = ?;`

const GET_SPECIFIC_ARTIST = "select id, name, default_genre FROM artists where id = ?;"

const GET_SPECIFIC_LOCATION = `` /* 156-byte string literal not displayed */

const GET_SPECIFIC_USER = `select id, username, email, IFNULL(first_name,""), IFNULL(last_name,""), role FROM users where id = ?;`

const INSERT_NEW_ARTIST = `insert into artists (name, default_genre) values(?,?);`

const INSERT_NEW_LOCATION = `insert into locations (name, description, city, state, country, is_festival, year) values(?,?,?,?,?,?,?);`

const INSERT_NEW_SET = `insert into sets (user_id, artist_id, location_id, date, rating, genre, length, notes) values(?,?,?,?,?,?,?,?);`

const IS_ARTIST_UNIQUE_QUERY = `select COUNT(*) FROM artists where name = ?`

const IS_LOCATION_UNIQUE_QUERY = `` /* 133-byte string literal not displayed */

const IS_LOCATION_UPDATE_UNIQUE = `select COUNT(*) FROM locations where id != ? AND (name = ? AND city = ? AND state = ? AND country = ? AND year = ?)`

const IS_SET_UNIQUE_QUERY = "select COUNT(*) FROM sets where user_id = ? and artist_id = ? and location_id = ? and date = ?"

const IS_USER_UPDATE_UNIQUE = `select COUNT(*) FROM users where id != ? AND (username = ? OR email = ?)`

const UPDATE_LOCATION = `update locations set name = ?, description = ?, city = ?, state = ?, country = ?, is_festival = ?, year = ? WHERE id = ?`

const UPDATE_USER = `update users set username = ?, email = ?, first_name = ?, last_name = ?, role = ? WHERE id = ?`