summaryrefslogtreecommitdiff
path: root/src/api
diff options
context:
space:
mode:
Diffstat (limited to 'src/api')
-rw-r--r--src/api/album.rs94
-rw-r--r--src/api/artist.rs90
-rw-r--r--src/api/search_results.rs55
-rw-r--r--src/api/song.rs96
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)),
+ }
+}
generated by cgit v1.2.3 (git 2.39.1) at 2025-01-23 06:48:47 +0000