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
128
129
130
|
// 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},
unit::{Unit, UnitId},
unit_property::UnitPropertyId,
};
#[derive(Debug, Deserialize, Serialize)]
pub(crate) enum Operation {
RegisterUnit {
id: UnitId,
full_name_singular: String,
full_name_plural: String,
short_name: String,
unit_property: UnitPropertyId,
description: Option<String>,
},
}
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::RegisterUnit {
id,
full_name_singular,
full_name_plural,
short_name,
description,
unit_property,
} => {
query!(
"
INSERT INTO units (id, unit_property, full_name_singular, full_name_plural, short_name, description)
VALUES (?,?,?,?,?,?)
",
id, unit_property, full_name_singular, full_name_plural, short_name, description,
)
.execute(txn)
.await?;
}
}
Ok(())
}
async fn undo(self, txn: &mut sqlx::SqliteConnection) -> Result<(), undo::Error> {
match self {
Operation::RegisterUnit {
id,
full_name_singular,
full_name_plural,
short_name,
description,
unit_property,
} => {
query!(
"
DELETE FROM units
WHERE id = ? AND full_name_singular = ? AND full_name_plural = ? AND short_name = ? AND description = ? AND unit_property = ?;
",
id, full_name_singular, full_name_plural, short_name, description, unit_property
)
.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 Unit {
pub(crate) fn register(
full_name_singular: String,
full_name_plural: String,
short_name: String,
description: Option<String>,
unit_property: UnitPropertyId,
ops: &mut Operations<Operation>,
) -> Self {
let id = UnitId::from(Uuid::new_v4());
ops.push(Operation::RegisterUnit {
id,
full_name_singular: full_name_singular.clone(),
full_name_plural: full_name_plural.clone(),
short_name: short_name.clone(),
description: description.clone(),
unit_property,
});
Self {
id,
full_name_singular,
full_name_plural,
short_name,
description,
unit_property,
}
}
}
|
