pgrx_sql_entity_graph/postgres_ord/
entity.rsuse crate::pgrx_sql::PgrxSql;
use crate::to_sql::entity::ToSqlConfigEntity;
use crate::to_sql::ToSql;
use crate::{SqlGraphEntity, SqlGraphIdentifier};
#[derive(Debug, Clone, Hash, PartialEq, Eq, Ord, PartialOrd)]
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 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 {
fn to_sql(&self, _context: &PgrxSql) -> eyre::Result<String> {
let PostgresOrdEntity { name, full_path, file, line, .. } = self;
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});\
",
cmp_fn_name = self.cmp_fn_name(),
);
Ok(sql)
}
}