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
113
|
use crate::db::Device;
use crate::error::Error;
use axum::extract::State;
use axum::Json;
use mac_address::MacAddress;
use serde::{Deserialize, Serialize};
use serde_json::{json, Value};
use sqlx::types::ipnetwork::IpNetwork;
use std::{sync::Arc, str::FromStr};
use tracing::{debug, info};
pub async fn get(
State(state): State<Arc<crate::AppState>>,
Json(payload): Json<GetDevicePayload>,
) -> Result<Json<Value>, Error> {
info!("get device {}", payload.id);
let device = sqlx::query_as!(
Device,
r#"
SELECT id, mac, broadcast_addr, ip, times
FROM devices
WHERE id = $1;
"#,
payload.id
)
.fetch_one(&state.db)
.await?;
debug!("got device {:?}", device);
Ok(Json(json!(device)))
}
#[derive(Deserialize)]
pub struct GetDevicePayload {
id: String,
}
pub async fn put(
State(state): State<Arc<crate::AppState>>,
Json(payload): Json<PutDevicePayload>,
) -> Result<Json<Value>, Error> {
info!(
"add device {} ({}, {}, {})",
payload.id, payload.mac, payload.broadcast_addr, payload.ip
);
let ip = IpNetwork::from_str(&payload.ip)?;
let mac = MacAddress::from_str(&payload.mac)?;
sqlx::query!(
r#"
INSERT INTO devices (id, mac, broadcast_addr, ip)
VALUES ($1, $2, $3, $4);
"#,
payload.id,
mac,
payload.broadcast_addr,
ip
)
.execute(&state.db)
.await?;
Ok(Json(json!(PutDeviceResponse { success: true })))
}
#[derive(Deserialize)]
pub struct PutDevicePayload {
id: String,
mac: String,
broadcast_addr: String,
ip: String,
}
#[derive(Serialize)]
pub struct PutDeviceResponse {
success: bool,
}
pub async fn post(
State(state): State<Arc<crate::AppState>>,
Json(payload): Json<PostDevicePayload>,
) -> Result<Json<Value>, Error> {
info!(
"edit device {} ({}, {}, {})",
payload.id, payload.mac, payload.broadcast_addr, payload.ip
);
let ip = IpNetwork::from_str(&payload.ip)?;
let mac = MacAddress::from_str(&payload.mac)?;
let device = sqlx::query_as!(
Device,
r#"
UPDATE devices
SET mac = $1, broadcast_addr = $2, ip = $3 WHERE id = $4
RETURNING id, mac, broadcast_addr, ip, times;
"#,
mac,
payload.broadcast_addr,
ip,
payload.id
)
.fetch_one(&state.db)
.await?;
Ok(Json(json!(device)))
}
#[derive(Deserialize)]
pub struct PostDevicePayload {
id: String,
mac: String,
broadcast_addr: String,
ip: String,
}
|
