1use crate::Engine;
9use uqa_execution::schema::view_creation::{
10 self,
11 context::{
12 MaterializedViewAccess, MaterializedViewWrite, ViewCreationCatalog, ViewCreationContext,
13 ViewCreationTransactions, ViewCreationWrite, ViewOwnerQuery, ViewPlanBinding,
14 ViewQueryOwners,
15 },
16};
17use uqa_sql::{
18 catalog::stored_view::StoredView, plan::QueryPlan, RowSchema, SQLError, SQLParam, SQLResult,
19};
20use uqa_storage::StorageBackendResult;
21
22impl Engine {
23 pub fn register_view(
24 &self,
25 name: &str,
26 body: uqa_sql::ast::SelectStmt,
27 ) -> Result<(), SQLError> {
28 view_creation::register_view(self, name, body)
29 }
30 fn view_creation_context(&self) -> ViewCreationContext<'_> {
31 ViewCreationContext {
32 catalog: self,
33 identities: self.catalog_identity_reservation_context(),
34 views: self,
35 locks: self,
36 namespace: self.relation_creation_context(),
37 names: self,
38 owners: self,
39 access: self,
40 bindings: self,
41 routines: self,
42 regroles: self,
43 aliases: self,
44 rewrite: self.view_rewrite_context(),
45 queries: self,
46 query_owners: self,
47 publication: self,
48 changes: self,
49 notices: &self.runtime.notices,
50 }
51 }
52}
53impl ViewCreationTransactions for Engine {
54 fn with_view_creation(&self, write: ViewCreationWrite<'_>) -> Result<(), SQLError> {
55 self.with_implicit_definition_transaction(|engine| write(&engine.view_creation_context()))
56 }
57 fn with_materialized_view_creation(
58 &self,
59 write: MaterializedViewWrite<'_>,
60 ) -> Result<Option<u64>, SQLError> {
61 self.with_implicit_definition_transaction(|engine| write(&engine.view_creation_context()))
62 }
63}
64impl ViewCreationCatalog for Engine {
65 fn synchronize(&self) -> StorageBackendResult<()> {
66 self.synchronize_catalog_registries()
67 }
68}
69impl ViewPlanBinding for Engine {
70 fn lock_relations(&self, plan: &QueryPlan) -> Result<(), SQLError> {
71 uqa_execution::query::locking::lock_query_relations(self.row_lock_context(), plan)
72 }
73 fn bind_relations(&self, plan: &mut QueryPlan) -> Result<bool, SQLError> {
74 self.bind_stored_query_relations(plan, "CREATE VIEW", true)
75 }
76 fn bind_routines(
77 &self,
78 plan: &mut QueryPlan,
79 params: &[SQLParam],
80 ) -> Result<RowSchema, SQLError> {
81 let scope = super::query_scope::new_for_catalog_binding(self);
82 uqa_execution::query::binding::bind_query_plan_routines_for_storage(
83 self, plan, params, &scope, None,
84 )
85 }
86 fn bind_type_identities(&self, plan: &mut QueryPlan) -> Result<(), SQLError> {
87 uqa_sql::binding::stored_types::bind_query_plan_type_identities(plan, &mut |name| {
88 uqa_sql::FunctionTypeResolver::resolve_type_name(self, name)
89 })
90 }
91 fn assign_input_collations(&self, plan: &mut QueryPlan) -> Result<(), SQLError> {
92 let scope = super::query_scope::new_for_catalog_binding(self);
93 uqa_execution::query::binding::assign_query_plan_input_collations(self, plan, &scope)
94 }
95}
96
97impl MaterializedViewAccess for Engine {
98 fn ensure_maintenance(&self, name: &str, view: &StoredView) -> Result<(), SQLError> {
99 uqa_sql::catalog::security::view_ownership::ensure_materialized_view_maintenance(
100 self.view_ownership_context(),
101 name,
102 view,
103 )
104 }
105}
106impl ViewQueryOwners for Engine {
107 fn with_owner(
108 &self,
109 owner: &uqa_sql::catalog::roles::RoleReference,
110 operation: ViewOwnerQuery<'_>,
111 ) -> Result<SQLResult, SQLError> {
112 self.with_current_user_context(owner, || operation(self))
113 }
114}
115
116impl Engine {
117 pub(crate) fn view_ownership_context(
118 &self,
119 ) -> uqa_sql::catalog::security::view_ownership::ViewOwnershipContext<'_> {
120 uqa_sql::catalog::security::view_ownership::ViewOwnershipContext {
121 session: self,
122 roles: self,
123 schemas: self,
124 }
125 }
126 pub(crate) fn ensure_view_owner(
127 &self,
128 name: &str,
129 view: &StoredView,
130 ) -> Result<String, SQLError> {
131 uqa_sql::catalog::security::view_ownership::ensure_view_owner(
132 self.view_ownership_context(),
133 name,
134 view,
135 )
136 }
137}
138impl uqa_sql::catalog::security::view_ownership::ViewOwnerSchemas for Engine {
139 fn schema_security(
140 &self,
141 schema: &str,
142 ) -> Option<uqa_sql::catalog::security::BoundSchemaSecurity> {
143 self.schema_security_for_privilege(schema)
144 }
145}
146
147impl uqa_execution::catalog::view::ViewIdentityAllocation for Engine {
148 fn allocate_identity(&self) -> StorageBackendResult<[u8; 16]> {
149 crate::new_view_object_id()
150 }
151}