Struct CreateProcedureStatement 

pub struct CreateProcedureStatement { /* private fields */ }

CREATE PROCEDURE statement builder

This struct provides a fluent API for constructing CREATE PROCEDURE queries.

Examples

use reinhardt_query::prelude::*;
use reinhardt_query::types::function::{FunctionLanguage, FunctionBehavior};

// CREATE PROCEDURE my_proc() LANGUAGE SQL AS 'SELECT 1'
let query = Query::create_procedure()
    .name("my_proc")
    .language(FunctionLanguage::Sql)
    .body("SELECT 1");

// CREATE OR REPLACE PROCEDURE my_proc(a integer)
// LANGUAGE PLPGSQL IMMUTABLE AS 'BEGIN INSERT INTO log VALUES (a); END;'
let query = Query::create_procedure()
    .name("my_proc")
    .or_replace()
    .add_parameter("a", "integer")
    .language(FunctionLanguage::PlPgSql)
    .behavior(FunctionBehavior::Immutable)
    .body("BEGIN INSERT INTO log VALUES (a); END;");

Implementations

impl CreateProcedureStatement

pub fn new() -> Self

Create a new CREATE PROCEDURE statement

Examples

use reinhardt_query::prelude::*;

let query = Query::create_procedure();

pub fn take(&mut self) -> Self

Take the ownership of data in the current CreateProcedureStatement

pub fn name<N>(&mut self, name: N) -> &mut Self

where N: IntoIden,

Set the procedure name

Examples

use reinhardt_query::prelude::*;

let query = Query::create_procedure()
    .name("my_proc");

pub fn or_replace(&mut self) -> &mut Self

Add OR REPLACE clause

Examples

use reinhardt_query::prelude::*;

let query = Query::create_procedure()
    .name("my_proc")
    .or_replace();

pub fn add_parameter<N: IntoIden, T: Into<String>>( &mut self, name: N, param_type: T, ) -> &mut Self

Add a procedure parameter

Examples

use reinhardt_query::prelude::*;

let query = Query::create_procedure()
    .name("my_proc")
    .add_parameter("param1", "integer")
    .add_parameter("param2", "text");

pub fn language(&mut self, language: FunctionLanguage) -> &mut Self

Set LANGUAGE

Examples

use reinhardt_query::prelude::*;
use reinhardt_query::types::function::FunctionLanguage;

let query = Query::create_procedure()
    .name("my_proc")
    .language(FunctionLanguage::PlPgSql);

pub fn behavior(&mut self, behavior: FunctionBehavior) -> &mut Self

Set procedure behavior (IMMUTABLE/STABLE/VOLATILE)

Examples

use reinhardt_query::prelude::*;
use reinhardt_query::types::function::FunctionBehavior;

let query = Query::create_procedure()
    .name("my_proc")
    .behavior(FunctionBehavior::Immutable);

pub fn security(&mut self, security: FunctionSecurity) -> &mut Self

Set security context (DEFINER/INVOKER)

Examples

use reinhardt_query::prelude::*;
use reinhardt_query::types::function::FunctionSecurity;

let query = Query::create_procedure()
    .name("my_proc")
    .security(FunctionSecurity::Definer);

pub fn body<B: Into<String>>(&mut self, body: B) -> &mut Self

Set procedure body (AS clause)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_procedure()
    .name("my_proc")
    .body("SELECT 1");

Trait Implementations

impl Clone for CreateProcedureStatement

fn clone(&self) -> CreateProcedureStatement

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for CreateProcedureStatement

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for CreateProcedureStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateProcedureStatement

fn build_any(&self, query_builder: &dyn QueryBuilderTrait) -> (String, Values)

Build SQL statement for a database backend and collect query parameters

fn to_string<T: QueryBuilderTrait>(&self, query_builder: T) -> String

Build SQL statement for a database backend and return SQL string with values inlined as SQL literals.

fn build<T: QueryBuilderTrait>(&self, query_builder: T) -> (String, Values)

Build SQL statement with parameter collection

impl QueryStatementWriter for CreateProcedureStatement