oxibase 0.4.9

Autonomous relational database management system with MVCC, time-travel queries, and full ACID compliance
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

// Copyright 2025 Oxibase Contributors
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

//! Stored procedures persistence
//!
//! This module provides storage for stored procedures in system tables.
//! Procedures are stored in the `system.procedures` system table and loaded
//! during database startup.

use serde::{Deserialize, Serialize};

/// System table name for stored procedures
pub const SYS_PROCEDURES: &str = "_sys_procedures";

/// SQL to create the procedures system table
pub const CREATE_PROCEDURES_SQL: &str = r#"
CREATE TABLE IF NOT EXISTS _sys_procedures (
    id INTEGER PRIMARY KEY AUTO_INCREMENT,
    schema TEXT,
    name TEXT NOT NULL,
    parameters JSON NOT NULL,
    language TEXT NOT NULL,
    code TEXT NOT NULL
);
"#;

/// Check if a table name is the procedures system table
pub fn is_procedures_table(_schema: &str, name: &str) -> bool {
    name.eq_ignore_ascii_case(SYS_PROCEDURES)
}

/// Parameter representation for stored procedures
#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct StoredProcedureParameter {
    pub mode: String, // We use String here to avoid depending on ast::ParameterMode directly for serialization if we want to decouple, but we can also use an enum
    pub name: String,
    pub data_type: String,
}

/// Stored procedure metadata for persistence
#[derive(Debug, Clone, Serialize, Deserialize)]
pub struct StoredProcedure {
    pub id: i64,
    pub schema: Option<String>,
    pub name: String,
    pub parameters: Vec<StoredProcedureParameter>,
    pub language: String,
    pub code: String,
}