uqa-sql 0.4.0

PostgreSQL-compatible SQL compiler built on libpg_query
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
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

//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

//! Names and independent catalog identities from a borrowed relation declaration.

use super::ConstraintLocation;
use crate::ast::{ColumnDef, ForeignKey, TableCheck, TableConstraintSet, TableKeyConstraint};

#[derive(Clone, Copy)]
pub struct NamedConstraint<'a> {
    pub name: &'a str,
    pub object_id: Option<[u8; 16]>,
    pub location: ConstraintLocation,
}

#[cfg(test)]
mod tests;

#[derive(Clone, Copy)]
pub struct ConstraintNames<'a> {
    pub columns: &'a [ColumnDef],
    pub checks: &'a [TableCheck],
    pub foreign_keys: &'a [ForeignKey],
    pub keys: &'a [TableKeyConstraint],
}

impl<'a> ConstraintNames<'a> {
    pub fn from_definition(columns: &'a [ColumnDef], constraints: &'a TableConstraintSet) -> Self {
        Self {
            columns,
            checks: &constraints.checks,
            foreign_keys: &constraints.foreign_keys,
            keys: &constraints.key_constraints,
        }
    }

    pub fn entries(self) -> impl Iterator<Item = NamedConstraint<'a>> {
        let not_null = self
            .columns
            .iter()
            .enumerate()
            .filter_map(|(position, column)| {
                column.not_null.then_some(())?;
                Some(NamedConstraint {
                    name: column.not_null_name.as_deref()?,
                    object_id: column.not_null_identity.map(|id| id.object_id),
                    location: ConstraintLocation::NotNull(position),
                })
            });
        let column_checks = self
            .columns
            .iter()
            .enumerate()
            .filter_map(|(position, column)| {
                column.check.as_ref()?;
                Some(NamedConstraint {
                    name: column.check_name.as_deref()?,
                    object_id: column.check_object_id,
                    location: ConstraintLocation::ColumnCheck(position),
                })
            });
        let column_foreign_keys =
            self.columns
                .iter()
                .enumerate()
                .filter_map(|(position, column)| {
                    let key = column.references.as_ref()?;
                    Some(NamedConstraint {
                        name: key.name.as_deref()?,
                        object_id: key.catalog_identity.map(|id| id.object_id),
                        location: ConstraintLocation::ColumnForeignKey(position),
                    })
                });
        let checks = self
            .checks
            .iter()
            .enumerate()
            .filter_map(|(position, check)| {
                Some(NamedConstraint {
                    name: check.name.as_deref()?,
                    object_id: check.object_id,
                    location: ConstraintLocation::TableCheck(position),
                })
            });
        let foreign_keys = self
            .foreign_keys
            .iter()
            .enumerate()
            .filter_map(|(position, key)| {
                Some(NamedConstraint {
                    name: key.name.as_deref()?,
                    object_id: key.catalog_identity.map(|id| id.object_id),
                    location: ConstraintLocation::TableForeignKey(position),
                })
            });
        let keys = self.keys.iter().enumerate().filter_map(|(position, key)| {
            Some(NamedConstraint {
                name: key.name.as_deref()?,
                object_id: key.catalog_identity.map(|id| id.object_id),
                location: ConstraintLocation::Key(position),
            })
        });
        not_null
            .chain(column_checks)
            .chain(column_foreign_keys)
            .chain(checks)
            .chain(foreign_keys)
            .chain(keys)
    }
}