use crate::routes::Song;
use crate::AppState;
use actix_web::{get, web, HttpResponse};
use serde::Deserialize;

#[derive(Deserialize)]
struct SongQueryOptions {
    id: Option<String>,
    name: Option<String>,
    artist: Option<String>,
    album: Option<String>,
}

#[get("/song")]
pub async fn song(
    app_state: web::Data<AppState>,
    get_args: web::Query<SongQueryOptions>,
) -> HttpResponse {
    let search_attempt: sqlx::Result<Vec<Song>>;

    match true {
        _ if check_if_exists(&get_args.id) => {
            search_attempt = sqlx::query_as!(
                Song,
                "SELECT song.name, song.lyrics, song.id,
                album.name as album_name, album.id as album_id,
                artist.name as artist_name, artist.id as artist_id
                FROM song
                INNER JOIN album ON song.album_id = album.id
                INNER JOIN artist ON album.artist_id = artist.id
                WHERE song.id=?",
                &get_args.id,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ if check_if_exists(&get_args.name) => {
            let new_name : String = format!("{}{}{}", "%", &get_args.name.clone().unwrap(), "%");
            search_attempt = sqlx::query_as!(
                Song,
                "SELECT song.name, song.lyrics, song.id,
                album.name as album_name, album.id as album_id,
                artist.name as artist_name, artist.id as artist_id
                FROM song
                INNER JOIN album ON song.album_id = album.id
                INNER JOIN artist ON album.artist_id = artist.id
                WHERE LOWER(song.name) LIKE LOWER(?)",
                new_name,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ if check_if_exists(&get_args.album) => {
            search_attempt = sqlx::query_as!(
                Song,
                "SELECT song.name, song.lyrics, song.id,
                album.name as album_name, album.id as album_id,
                artist.name as artist_name, artist.id as artist_id
                FROM song
                INNER JOIN album ON song.album_id = album.id
                INNER JOIN artist ON album.artist_id = artist.id
                WHERE song.album_id=?
                ",
                &get_args.album,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ if check_if_exists(&get_args.artist) => {
            search_attempt = sqlx::query_as!(
                Song,
                "SELECT song.name, song.lyrics, song.id,
                album.name as album_name, album.id as album_id,
                artist.name as artist_name, artist.id as artist_id
                FROM song
                INNER JOIN album ON song.album_id = album.id
                INNER JOIN artist ON album.artist_id = artist.id
                WHERE album.artist_id=?
                ",
                &get_args.artist,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ => {
            search_attempt = sqlx::query_as!(
                Song,
                "SELECT song.name, song.lyrics, song.id,
                album.name as album_name, album.id as album_id,
                artist.name as artist_name, artist.id as artist_id
                FROM song
                INNER JOIN album ON song.album_id = album.id
                INNER JOIN artist ON album.artist_id = artist.id
                ",
            )
            .fetch_all(&app_state.pool)
            .await;
        }
    };

    match search_attempt {
        Ok(song_list) => HttpResponse::Ok().json(song_list),
        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
    }
}

fn check_if_exists(value: &Option<String>) -> bool {
    match value {
        Some(_) => true,
        None => false,
    }
}