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

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

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

    match true {
        _ if check_if_exists(&get_args.id) => {
            search_attempt = sqlx::query_as!(
                Album,
                "SELECT album.name, album.id,
                artist.name as artist_name, artist.id as artist_id
                FROM album
                INNER JOIN artist ON album.artist_id = artist.id
                WHERE album.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!(
                Album,
                "SELECT album.name, album.id,
                artist.name as artist_name, artist.id as artist_id
                FROM album
                INNER JOIN artist ON album.artist_id = artist.id
                WHERE LOWER(album.name) LIKE LOWER(?)",
                new_name,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ if check_if_exists(&get_args.artist) => {
            search_attempt = sqlx::query_as!(
                Album,
                "SELECT album.name, album.id,
                artist.name as artist_name, artist.id as artist_id
                FROM album
                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!(
                Album,
                "SELECT album.name, album.id,
                artist.name as artist_name, artist.id as artist_id
                FROM album
                INNER JOIN artist ON album.artist_id = artist.id
                ",
            )
            .fetch_all(&app_state.pool)
            .await;
        }
    };

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

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