Skip to main content

uqa_sql/schema/
dependencies.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Traverse stored expressions and recognize their column dependencies.
8
9mod walk;
10
11const SUBQUERY_DEPENDENCY_ERROR: &str =
12    "schema expression contains a subquery whose dependencies cannot be rewritten safely";
13
14pub fn walk_schema_expr_mut(
15    expression: &mut crate::ast::Expr,
16    visit: &mut impl FnMut(&mut crate::ast::Expr) -> Result<(), String>,
17) -> Result<(), String> {
18    walk::walk_mut(expression, visit, &mut || SUBQUERY_DEPENDENCY_ERROR.into())
19}
20
21/// Observe the same stored-expression children without copying syntax. Each callback and the subquery diagnostic use the invoking request.
22pub fn walk_schema_expr_with_control(
23    expression: &crate::ast::Expr,
24    control: &uqa_core::memory::ProductionControl<'_>,
25    visit: &mut impl FnMut(&crate::ast::Expr) -> Result<(), crate::SQLError>,
26) -> Result<(), crate::SQLError> {
27    walk::walk(
28        expression,
29        &mut |node| {
30            control.check()?;
31            visit(node)
32        },
33        &mut || match control.copy_text(SUBQUERY_DEPENDENCY_ERROR) {
34            Ok(message) => crate::SQLError::Internal(message.into_parts().0),
35            Err(error) => error.into(),
36        },
37    )
38}
39
40pub fn schema_expr_references_column(expression: &crate::ast::Expr, column: &str) -> bool {
41    references_column(expression, column, true)
42}
43
44/// Attribute dependencies survive column renames but disappear with the selected column. A whole-row value depends on its relation and continues to read that relation's current fields after a column is dropped.
45pub fn schema_expr_depends_on_column(expression: &crate::ast::Expr, column: &str) -> bool {
46    references_column(expression, column, false)
47}
48
49fn references_column(expression: &crate::ast::Expr, column: &str, reads_whole_row: bool) -> bool {
50    let mut expression = expression.clone();
51    let mut referenced = false;
52    let result = walk_schema_expr_mut(&mut expression, &mut |node| {
53        referenced |= match node {
54            crate::ast::Expr::Star | crate::ast::Expr::QualifiedStar(_) => reads_whole_row,
55            crate::ast::Expr::Column(name)
56            | crate::ast::Expr::QualifiedColumn { column: name, .. } => name == column,
57            _ => false,
58        };
59        Ok(())
60    });
61    result.is_err() || referenced
62}
63
64pub mod oid_alias;
65pub mod regclass;
66pub mod registration;
67pub mod rewrites;