Struct CreateProcedureStatement 

pub struct CreateProcedureStatement { /* private fields */ }

Available on crate feature database and non-WebAssembly only.

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() -> CreateProcedureStatement

Create a new CREATE PROCEDURE statement

Examples

use reinhardt_query::prelude::*;

let query = Query::create_procedure();

pub fn take(&mut self) -> CreateProcedureStatement

Take the ownership of data in the current CreateProcedureStatement

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

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 CreateProcedureStatement

Add OR REPLACE clause

Examples

use reinhardt_query::prelude::*;

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

pub fn add_parameter<N, T>( &mut self, name: N, param_type: T, ) -> &mut CreateProcedureStatement

where N: IntoIden, T: Into<String>,

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 CreateProcedureStatement

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 CreateProcedureStatement

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 CreateProcedureStatement

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>(&mut self, body: B) -> &mut CreateProcedureStatement

where B: Into<String>,

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<(), Error>

Formats the value using the given formatter.

impl Default for CreateProcedureStatement

fn default() -> CreateProcedureStatement

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateProcedureStatement

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

Build SQL statement for a database backend and collect query parameters

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

where T: QueryBuilderTrait,

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

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

where T: QueryBuilderTrait,

Build SQL statement with parameter collection

impl QueryStatementWriter for CreateProcedureStatement