prepare for apiHEADmaster

4 files changed, 335 insertions, 0 deletions

diff --git a/src/api/album.rs b/src/api/album.rs
new file mode 100644
index 0000000..d9d0d52
--- /dev/null
+++ b/src/api/album.rs
@@ -0,0 +1,94 @@
+use crate::database::{Album, AlbumPost, AlbumPut, Delete};
+use crate::AppState;
+use actix_web::{delete, get, post, put, web, HttpResponse};
+use serde::Deserialize;
+
+#[derive(Deserialize)]
+struct AlbumQueryOptions {
+    id: Option<String>,
+    name: Option<String>,
+    artist: Option<String>,
+}
+
+#[get("/album")]
+pub async fn get_album(
+    app_state: web::Data<AppState>,
+    get_args: web::Query<AlbumQueryOptions>,
+) -> HttpResponse {
+    let default = String::from("");
+
+    if get_args.id.is_some() {
+        let id: &str = get_args.id.as_ref().unwrap_or(&default);
+        let search_attempt: sqlx::Result<Option<Album>> =
+            app_state.database.select_album_by_id(id).await;
+
+        return match search_attempt {
+            Ok(song_list) => HttpResponse::Ok().json(song_list),
+            Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+        };
+    }
+    let search_attempt: sqlx::Result<Vec<Album>, sqlx::Error> = match true {
+        _ if get_args.name.is_some() => {
+            let name: &str = &get_args.name.as_ref().unwrap_or(&default);
+            app_state.database.select_albums_by_name(name).await
+        }
+        _ if get_args.artist.is_some() => {
+            let artist: &str = &get_args.artist.as_ref().unwrap_or(&default);
+            app_state.database.select_albums_by_artist(artist).await
+        }
+        _ => app_state.database.select_albums().await,
+    };
+
+    match search_attempt {
+        Ok(album_list) => HttpResponse::Ok().json(album_list),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[post("/album")]
+pub async fn post_album(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<AlbumPost>,
+) -> HttpResponse {
+    match app_state
+        .database
+        .create_album(post_data.into_inner())
+        .await
+    {
+        Ok(_) => HttpResponse::Ok().body("Post succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[put("/album")]
+pub async fn put_album(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<AlbumPut>,
+) -> HttpResponse {
+    match app_state.database.edit_album(post_data.into_inner()).await {
+        Ok(_) => HttpResponse::Ok().body("Put succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[delete("/album")]
+pub async fn delete_album(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<Delete>,
+) -> HttpResponse {
+    let id: i32 = post_data
+        .into_inner()
+        .id
+        .unwrap_or(String::default())
+        .parse::<i32>()
+        .unwrap_or(-1);
+
+    if id == -1 {
+        return HttpResponse::Ok().body("Invalid id value, code not executed\n");
+    }
+
+    match app_state.database.delete_album(id).await {
+        Ok(_) => HttpResponse::Ok().body("Deletion succeeded\n".to_owned()),
+        Err(e) => HttpResponse::Ok().body(format!("There was an issue in the request:\n{}", e)),
+    }
+}
diff --git a/src/api/artist.rs b/src/api/artist.rs
new file mode 100644
index 0000000..81ae773
--- /dev/null
+++ b/src/api/artist.rs
@@ -0,0 +1,90 @@
+use crate::database::{Artist, ArtistPost, ArtistPut, Delete};
+use crate::AppState;
+use actix_web::{delete, get, post, put, web, HttpResponse};
+use serde::Deserialize;
+
+#[derive(Deserialize)]
+struct ArtistQueryOptions {
+    id: Option<String>,
+    name: Option<String>,
+}
+
+#[get("/artist")]
+pub async fn get_artist(
+    app_state: web::Data<AppState>,
+    get_args: web::Query<ArtistQueryOptions>,
+) -> HttpResponse {
+    let default = String::from("");
+
+    if get_args.id.is_some() {
+        let id: &str = get_args.id.as_ref().unwrap_or(&default);
+        let search_attempt: sqlx::Result<Option<Artist>> =
+            app_state.database.select_artist_by_id(id).await;
+
+        return match search_attempt {
+            Ok(song_list) => HttpResponse::Ok().json(song_list),
+            Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+        };
+    }
+
+    let search_attempt: sqlx::Result<Vec<Artist>, sqlx::Error> = match true {
+        _ if get_args.name.is_some() => {
+            let name: &str = &get_args.name.as_ref().unwrap_or(&default);
+            app_state.database.select_artists_by_name(name).await
+        }
+        _ => app_state.database.select_artists().await,
+    };
+
+    match search_attempt {
+        Ok(artist_list) => HttpResponse::Ok().json(artist_list),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[post("/artist")]
+pub async fn post_artist(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<ArtistPost>,
+) -> HttpResponse {
+    match app_state
+        .database
+        .create_artist(post_data.into_inner())
+        .await
+    {
+        Ok(_) => HttpResponse::Ok().body("Post succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[put("/artist")]
+pub async fn put_artist(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<ArtistPut>,
+) -> HttpResponse {
+    match app_state.database.edit_artist(post_data.into_inner()).await {
+        Ok(_) => HttpResponse::Ok().body("Put succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[delete("/artist")]
+pub async fn delete_artist(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<Delete>,
+) -> HttpResponse {
+    let id: i32 = post_data
+        .into_inner()
+        .id
+        .unwrap_or(String::default())
+        .parse::<i32>()
+        .unwrap_or(-1);
+
+    if id == -1 {
+        return HttpResponse::Ok().body("Invalid id value, code not executed\n");
+    }
+
+    match app_state.database.delete_artist(id).await {
+        Ok(_) => HttpResponse::Ok().body("Deletion succeeded\n\n"),
+        Err(e) => HttpResponse::Ok().body(format!("There was an issue in the request:\n{}", e)),
+    }
+}
diff --git a/src/api/search_results.rs b/src/api/search_results.rs
new file mode 100644
index 0000000..6456ff9
--- /dev/null
+++ b/src/api/search_results.rs
@@ -0,0 +1,55 @@
+use crate::database::{Album, Artist, Song};
+use crate::AppState;
+use actix_web::{get, web, HttpResponse};
+use serde::Deserialize;
+
+#[derive(Deserialize)]
+struct SearchQueryOptions {
+    id: Option<String>,
+    name: Option<String>,
+}
+
+#[get("/search-results")]
+pub async fn search_results(
+    app_state: web::Data<AppState>,
+    get_args: web::Query<SearchQueryOptions>,
+) -> HttpResponse {
+    let default: String = String::from("");
+
+    if get_args.id.is_some() {
+        let id: &str = get_args.id.as_ref().unwrap_or(&default);
+        let search_attempt: (
+            sqlx::Result<Option<Artist>, sqlx::Error>,
+            sqlx::Result<Option<Album>, sqlx::Error>,
+            sqlx::Result<Option<Song>, sqlx::Error>,
+        ) = { app_state.database.search_results_by_id(id).await };
+
+        return HttpResponse::Ok().json((
+            search_attempt.0.unwrap_or(None),
+            search_attempt.1.unwrap_or(None),
+            search_attempt.2.unwrap_or(None),
+        ));
+    };
+
+    let search_attempt: (
+        sqlx::Result<Vec<Artist>, sqlx::Error>,
+        sqlx::Result<Vec<Album>, sqlx::Error>,
+        sqlx::Result<Vec<Song>, sqlx::Error>,
+    ) = match true {
+        _ if get_args.name.is_some() => {
+            app_state
+                .database
+                .search_results_by_name(&get_args.name.clone().unwrap())
+                .await
+        }
+        _ => app_state.database.search_results().await, // Err(sqlx::Error::RowNotFound),
+                                                        // Err(sqlx::Error::RowNotFound),
+                                                        // Err(sqlx::Error::RowNotFound),
+    };
+
+    return HttpResponse::Ok().json((
+        search_attempt.0.unwrap_or(Vec::new()),
+        search_attempt.1.unwrap_or(Vec::new()),
+        search_attempt.2.unwrap_or(Vec::new()),
+    ));
+}
diff --git a/src/api/song.rs b/src/api/song.rs
new file mode 100644
index 0000000..850c759
--- /dev/null
+++ b/src/api/song.rs
@@ -0,0 +1,96 @@
+use crate::database::{Delete, Song, SongPost, SongPut};
+use crate::AppState;
+use actix_web::{delete, get, post, put, 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 get_song(
+    app_state: web::Data<AppState>,
+    get_args: web::Query<SongQueryOptions>,
+) -> HttpResponse {
+    let default = String::from("");
+
+    if get_args.id.is_some() {
+        let id: &str = get_args.id.as_ref().unwrap_or(&default);
+        let search_attempt: sqlx::Result<Option<Song>> =
+            app_state.database.select_song_by_id(id).await;
+
+        return match search_attempt {
+            Ok(song_list) => HttpResponse::Ok().json(song_list),
+            Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+        };
+    }
+
+    let search_attempt: sqlx::Result<Vec<Song>> = match true {
+        _ if get_args.name.is_some() => {
+            let name: &str = get_args.name.as_ref().unwrap_or(&default);
+            app_state.database.select_songs_by_name(name).await
+        }
+        _ if get_args.album.is_some() => {
+            let album: &str = get_args.album.as_ref().unwrap_or(&default);
+            app_state.database.select_songs_by_album(album).await
+        }
+        _ if get_args.artist.is_some() => {
+            let artist: &str = get_args.artist.as_ref().unwrap_or(&default);
+            app_state.database.select_songs_by_artist(artist).await
+        }
+        _ => app_state.database.select_songs().await,
+    };
+
+    match search_attempt {
+        Ok(song_list) => HttpResponse::Ok().json(song_list),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[post("/song")]
+pub async fn post_song(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<SongPost>,
+) -> HttpResponse {
+    match app_state.database.create_song(post_data.into_inner()).await {
+        Ok(_) => HttpResponse::Ok().body("Post succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[put("/song")]
+pub async fn put_song(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<SongPut>,
+) -> HttpResponse {
+    match app_state.database.edit_song(post_data.into_inner()).await {
+        Ok(_) => HttpResponse::Ok().body("Put succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("{}", e)),
+    }
+}
+
+#[delete("/song")]
+pub async fn delete_song(
+    app_state: web::Data<AppState>,
+    post_data: web::Json<Delete>,
+) -> HttpResponse {
+    let id: i32 = post_data
+        .into_inner()
+        .id
+        .unwrap_or(String::default())
+        .parse::<i32>()
+        .unwrap_or(-1);
+
+    if id == -1 {
+        return HttpResponse::Ok().body("Invalid id value, code not executed\n");
+    }
+
+    match app_state.database.delete_song(id).await {
+        Ok(_) => HttpResponse::Ok().body("Deletion succeeded\n"),
+        Err(e) => HttpResponse::Ok().body(format!("There was an issue in the request:\n{}", e)),
+    }
+}