Struct CreateFunctionStatement 

pub struct CreateFunctionStatement { /* private fields */ }

CREATE FUNCTION statement builder

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

Examples

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

// CREATE FUNCTION my_func() RETURNS integer LANGUAGE SQL AS 'SELECT 1'
let query = Query::create_function()
    .name("my_func")
    .returns("integer")
    .language(FunctionLanguage::Sql)
    .body("SELECT 1");

// CREATE OR REPLACE FUNCTION my_func(a integer) RETURNS integer
// LANGUAGE PLPGSQL IMMUTABLE AS 'BEGIN RETURN a + 1; END;'
let query = Query::create_function()
    .name("my_func")
    .or_replace()
    .add_parameter("a", "integer")
    .returns("integer")
    .language(FunctionLanguage::PlPgSql)
    .behavior(FunctionBehavior::Immutable)
    .body("BEGIN RETURN a + 1; END;");

Implementations

impl CreateFunctionStatement

pub fn new() -> Self

Create a new CREATE FUNCTION statement

Examples

use reinhardt_query::prelude::*;

let query = Query::create_function();

pub fn take(&mut self) -> Self

Take the ownership of data in the current CreateFunctionStatement

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

where N: IntoIden,

Set the function name

Examples

use reinhardt_query::prelude::*;

let query = Query::create_function()
    .name("my_func");

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

Add OR REPLACE clause

Examples

use reinhardt_query::prelude::*;

let query = Query::create_function()
    .name("my_func")
    .or_replace();

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

Add a function parameter

Examples

use reinhardt_query::prelude::*;

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

pub fn returns<T: Into<String>>(&mut self, returns: T) -> &mut Self

Set RETURNS type

Examples

use reinhardt_query::prelude::*;

let query = Query::create_function()
    .name("my_func")
    .returns("integer");

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_function()
    .name("my_func")
    .language(FunctionLanguage::PlPgSql);

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

Set function behavior (IMMUTABLE/STABLE/VOLATILE)

Examples

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

let query = Query::create_function()
    .name("my_func")
    .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_function()
    .name("my_func")
    .security(FunctionSecurity::Definer);

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

Set function body (AS clause)

Security Warning

The function body is embedded directly into the CREATE FUNCTION statement and will be stored in the database. DO NOT pass user input directly to this method, as it could lead to arbitrary code execution.

Only use with trusted, validated code.

Examples

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

// ✅ SAFE: Static code
let query = Query::create_function()
    .name("my_func")
    .returns("integer")
    .language(FunctionLanguage::Sql)
    .body("SELECT 1");

// ❌ UNSAFE: User input
// let query = Query::create_function()
//     .name("user_func")
//     .body(&user_code);

Trait Implementations

impl Clone for CreateFunctionStatement

fn clone(&self) -> CreateFunctionStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateFunctionStatement

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

Formats the value using the given formatter.

impl Default for CreateFunctionStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateFunctionStatement

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 CreateFunctionStatement