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
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
// rocie - An enterprise grocery management system
//
// Copyright (C) 2026 Benedikt Peetz <benedikt.peetz@b-peetz.de>
// SPDX-License-Identifier: GPL-3.0-or-later
//
// This file is part of Rocie.
//
// You should have received a copy of the License along with this program.
// If not, see <https://www.gnu.org/licenses/gpl-3.0.txt>.
use serde::{Deserialize, Serialize};
use sqlx::query;
use uuid::Uuid;
use crate::storage::sql::{
insert::{Operations, Transactionable},
user::{PasswordHash, User, UserId},
};
#[derive(Debug, Deserialize, Serialize)]
pub(crate) enum Operation {
RegisterUser {
id: UserId,
name: String,
description: Option<String>,
password_hash: PasswordHash,
},
}
impl Transactionable for Operation {
type ApplyError = apply::Error;
type UndoError = undo::Error;
async fn apply(self, txn: &mut sqlx::SqliteConnection) -> Result<(), apply::Error> {
match self {
Operation::RegisterUser {
id,
name,
description,
password_hash,
} => {
let password_hash = password_hash.to_string();
query!(
"
INSERT INTO users (id, name, password_hash, description)
VALUES (?,?,?,?)
",
id,
name,
password_hash,
description,
)
.execute(txn)
.await?;
}
}
Ok(())
}
async fn undo(self, txn: &mut sqlx::SqliteConnection) -> Result<(), undo::Error> {
match self {
Operation::RegisterUser {
id,
name,
description,
password_hash,
} => {
let password_hash = password_hash.to_string();
query!(
"
DELETE FROM users
WHERE id = ? AND name = ? AND description = ? AND password_hash = ?;
",
id,
name,
description,
password_hash,
)
.execute(txn)
.await?;
}
}
Ok(())
}
}
pub(crate) mod undo {
#[derive(thiserror::Error, Debug)]
pub(crate) enum Error {
#[error("Failed to execute undo sql statments: {0}")]
SqlError(#[from] sqlx::Error),
}
}
pub(crate) mod apply {
#[derive(thiserror::Error, Debug)]
pub(crate) enum Error {
#[error("Failed to execute apply sql statments: {0}")]
SqlError(#[from] sqlx::Error),
}
}
impl User {
pub(crate) fn register(
name: String,
password_hash: PasswordHash,
description: Option<String>,
ops: &mut Operations<Operation>,
) -> Self {
let id = UserId::from(Uuid::new_v4());
ops.push(Operation::RegisterUser {
id,
name: name.clone(),
description: description.clone(),
password_hash: password_hash.clone(),
});
Self {
id,
name,
description,
password_hash,
}
}
}
|
