criterium 3.1.3

Lightweigt dynamic database queries for rusqlite.
Documentation 
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

// SPDX-FileCopyrightText: 2025 Slatian
//
// SPDX-License-Identifier: LGPL-3.0-only

//! This file contains an example schema for running unit tests on.
//! It is only included when running unit tests.

use crate::sql::Field;
use crate::sql::Table;

#[derive(Debug, Clone, PartialEq, Eq)]
pub enum ExampleTable {
	Link,
	File,
	TempKeyValueCache,
}

impl Table for ExampleTable {
	fn sql_safe_table_name(&self) -> &str {
		match self {
			Self::Link => "links",
			Self::File => "files",
			Self::TempKeyValueCache => "temp.key_value_cache",
		}
	}
}

#[allow(dead_code)]
#[derive(Debug, Clone, PartialEq, Eq)]
pub enum ExampleSchema {
	FileId,
	FileName,

	LinkId,
	LinkInFileId,
	LinkToUrl,

	TempKeyValueCacheKey,
	TempKeyValueCacheValue,
}

impl Field for ExampleSchema {
	type TableType = ExampleTable;

	fn sql_safe_field_name(&self) -> &str {
		match self {
			Self::FileId => "file_id",
			Self::FileName => "name",
			Self::LinkId => "link_id",
			Self::LinkInFileId => "in_file_id",
			Self::LinkToUrl => "to_url",
			Self::TempKeyValueCacheKey => "key",
			Self::TempKeyValueCacheValue => "value",
		}
	}

	fn table(&self) -> &Self::TableType {
		match self {
			Self::FileId => &ExampleTable::File,
			Self::FileName => &ExampleTable::File,
			Self::LinkId => &ExampleTable::Link,
			Self::LinkInFileId => &ExampleTable::Link,
			Self::LinkToUrl => &ExampleTable::Link,
			Self::TempKeyValueCacheKey => &ExampleTable::TempKeyValueCache,
			Self::TempKeyValueCacheValue => &ExampleTable::TempKeyValueCache,
		}
	}
}