Chiel Suttorp
18 lines
564 B
SQL
18 lines
564 B
SQL
-- artists.sql
|
|
-- name: GetArtistByID :one
|
|
SELECT * FROM artists WHERE id = $1;
|
|
|
|
-- name: GetAllArtists :many
|
|
SELECT * FROM artists;
|
|
|
|
-- name: CreateArtist :one
|
|
INSERT INTO artists (id, name, genre, bio, artist_image_url) VALUES ($1, $2, $3, $4, $5) RETURNING id;
|
|
|
|
-- name: UpdateArtist :exec
|
|
UPDATE artists SET name = $2, genre = $3, bio = $4, artist_image_url = $5 WHERE id = $1;
|
|
|
|
-- name: DeleteArtist :exec
|
|
DELETE FROM artists WHERE id = $1;
|
|
|
|
-- name: SearchArtists :many
|
|
SELECT * FROM artists WHERE name ILIKE '%' || $1 || '%' OR genre ILIKE '%' || $1 || '%'; |