1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
use crate::api::{get_response_from_query, Response};
use crate::database::{Delete, Song, SongPost, SongPut};
use crate::AppState;
use actix_web::{delete, get, post, put, web, HttpResponse};
use serde::Deserialize;
/* Possible arguments ( /song?arg=value ) */
#[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 {
/* Avoid lifespan issues */
let default = String::default();
/* Handle individual result for search-by-id */
if get_args.id.is_some() {
let id: &str = get_args.id.as_ref().unwrap_or(&default);
let query_result: sqlx::Result<Option<Song>> =
app_state.database.select_song_by_id(id).await;
return match query_result {
Ok(song_list) => HttpResponse::Ok().json(song_list),
Err(e) => HttpResponse::Ok().body(format!("{}", e)),
};
}
/* Handle N results */
let query_result: 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 query_result {
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>,
request_data: web::Json<SongPost>,
) -> HttpResponse {
get_response_from_query(
app_state.database.create_song(request_data.into_inner()).await,
"POST".to_string(),
)
}
#[put("/song")]
pub async fn put_song(
app_state: web::Data<AppState>,
request_data: web::Json<SongPut>,
) -> HttpResponse {
get_response_from_query(
app_state.database.edit_song(request_data.into_inner()).await,
"PUT".to_owned(),
)
}
#[delete("/song")]
pub async fn delete_song(
app_state: web::Data<AppState>,
request_data: web::Json<Delete>,
) -> HttpResponse {
/* Check if ID is valid (return -1 if invalid) */
let id: i32 = request_data
.into_inner()
.id
.unwrap_or(String::default())
.parse::<i32>()
.unwrap_or(-1);
if id == -1 {
return HttpResponse::BadRequest().json(Response {
message: "Invalid id value, code not executed".to_owned(),
});
}
get_response_from_query(
app_state.database.delete_song(id).await,
"DELETE".to_owned(),
)
}
|
