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
105
106
107
108
109
110
111
112
|
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>,
artist: Option<String>,
album: 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 song.name, song.lyrics, song.id,
album.name as album_name, album.id as album_id,
artist.name as artist_name, artist.id as artist_id
FROM song
INNER JOIN album ON song.album_id = album.id
INNER JOIN artist ON album.artist_id = artist.id
WHERE song.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!(
Song,
"SELECT song.name, song.lyrics, song.id,
album.name as album_name, album.id as album_id,
artist.name as artist_name, artist.id as artist_id
FROM song
INNER JOIN album ON song.album_id = album.id
INNER JOIN artist ON album.artist_id = artist.id
WHERE LOWER(song.name) LIKE LOWER(?)",
new_name,
)
.fetch_all(&app_state.pool)
.await;
}
_ if check_if_exists(&get_args.album) => {
search_attempt = sqlx::query_as!(
Song,
"SELECT song.name, song.lyrics, song.id,
album.name as album_name, album.id as album_id,
artist.name as artist_name, artist.id as artist_id
FROM song
INNER JOIN album ON song.album_id = album.id
INNER JOIN artist ON album.artist_id = artist.id
WHERE song.album_id=?
",
&get_args.album,
)
.fetch_all(&app_state.pool)
.await;
}
_ if check_if_exists(&get_args.artist) => {
search_attempt = sqlx::query_as!(
Song,
"SELECT song.name, song.lyrics, song.id,
album.name as album_name, album.id as album_id,
artist.name as artist_name, artist.id as artist_id
FROM song
INNER JOIN album ON song.album_id = album.id
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!(
Song,
"SELECT song.name, song.lyrics, song.id,
album.name as album_name, album.id as album_id,
artist.name as artist_name, artist.id as artist_id
FROM song
INNER JOIN album ON song.album_id = album.id
INNER JOIN artist ON album.artist_id = artist.id
",
)
.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,
}
}
|
