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
use crate::sql_entity_graph::pgx_sql::PgxSql;
use crate::sql_entity_graph::to_sql::entity::ToSqlConfigEntity;
use crate::sql_entity_graph::to_sql::ToSql;
use crate::sql_entity_graph::{SqlGraphEntity, SqlGraphIdentifier};
use std::cmp::Ordering;
#[derive(Debug, Clone, Hash, PartialEq, Eq)]
pub struct PostgresOrdEntity {
pub name: &'static str,
pub file: &'static str,
pub line: u32,
pub full_path: &'static str,
pub module_path: &'static str,
pub id: core::any::TypeId,
pub to_sql_config: ToSqlConfigEntity,
}
impl PostgresOrdEntity {
pub(crate) fn cmp_fn_name(&self) -> String {
format!("{}_cmp", self.name.to_lowercase())
}
pub(crate) fn lt_fn_name(&self) -> String {
format!("{}_lt", self.name.to_lowercase())
}
pub(crate) fn le_fn_name(&self) -> String {
format!("{}_le", self.name.to_lowercase())
}
pub(crate) fn eq_fn_name(&self) -> String {
format!("{}_eq", self.name.to_lowercase())
}
pub(crate) fn gt_fn_name(&self) -> String {
format!("{}_gt", self.name.to_lowercase())
}
pub(crate) fn ge_fn_name(&self) -> String {
format!("{}_ge", self.name.to_lowercase())
}
}
impl Ord for PostgresOrdEntity {
fn cmp(&self, other: &Self) -> Ordering {
self.file.cmp(other.file).then_with(|| self.file.cmp(other.file))
}
}
impl PartialOrd for PostgresOrdEntity {
fn partial_cmp(&self, other: &Self) -> Option<Ordering> {
Some(self.cmp(other))
}
}
impl From<PostgresOrdEntity> for SqlGraphEntity {
fn from(val: PostgresOrdEntity) -> Self {
SqlGraphEntity::Ord(val)
}
}
impl SqlGraphIdentifier for PostgresOrdEntity {
fn dot_identifier(&self) -> String {
format!("ord {}", self.full_path)
}
fn rust_identifier(&self) -> String {
self.full_path.to_string()
}
fn file(&self) -> Option<&'static str> {
Some(self.file)
}
fn line(&self) -> Option<u32> {
Some(self.line)
}
}
impl ToSql for PostgresOrdEntity {
#[tracing::instrument(level = "debug", err, skip(self, _context), fields(identifier = %self.rust_identifier()))]
fn to_sql(&self, _context: &PgxSql) -> eyre::Result<String> {
let sql = format!("\n\
-- {file}:{line}\n\
-- {full_path}\n\
CREATE OPERATOR FAMILY {name}_btree_ops USING btree;\n\
CREATE OPERATOR CLASS {name}_btree_ops DEFAULT FOR TYPE {name} USING btree FAMILY {name}_btree_ops AS\n\
\tOPERATOR 1 <,\n\
\tOPERATOR 2 <=,\n\
\tOPERATOR 3 =,\n\
\tOPERATOR 4 >=,\n\
\tOPERATOR 5 >,\n\
\tFUNCTION 1 {cmp_fn_name}({name}, {name});\
",
name = self.name,
full_path = self.full_path,
file = self.file,
line = self.line,
cmp_fn_name = self.cmp_fn_name(),
);
tracing::trace!(%sql);
Ok(sql)
}
}