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>,
}

#[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 name, lyrics FROM song WHERE id=?",
                &get_args.id,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ if check_if_exists(&get_args.name) => {
            search_attempt = sqlx::query_as!(
                Song,
                "SELECT name, lyrics FROM song WHERE LOWER(name) LIKE '%' + LOWER(?) + '%'",
                &get_args.name,
            )
            .fetch_all(&app_state.pool)
            .await;
        }
        _ => {
            search_attempt = sqlx::query_as!(Song, "SELECT name, lyrics FROM song",)
                .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,
    }
}