Struct AlterFunctionStatement 

pub struct AlterFunctionStatement { /* private fields */ }

ALTER FUNCTION statement builder

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

Examples

use reinhardt_query::prelude::*;

// ALTER FUNCTION my_func RENAME TO new_func
let query = Query::alter_function()
    .name("my_func")
    .rename_to("new_func");

// ALTER FUNCTION my_func OWNER TO new_owner
let query = Query::alter_function()
    .name("my_func")
    .owner_to("new_owner");

Implementations

impl AlterFunctionStatement

pub fn new() -> Self

Create a new ALTER FUNCTION statement

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_function();

pub fn take(&mut self) -> Self

Take the ownership of data in the current AlterFunctionStatement

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::alter_function()
    .name("my_func");

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

Add a function parameter (for identifying which overloaded function to alter)

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_function()
    .name("my_func")
    .add_parameter("a", "integer")
    .rename_to("new_func");

pub fn rename_to<N: IntoIden>(&mut self, new_name: N) -> &mut Self

RENAME TO new_name

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_function()
    .name("my_func")
    .rename_to("new_func");

pub fn owner_to<N: IntoIden>(&mut self, new_owner: N) -> &mut Self

OWNER TO new_owner

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_function()
    .name("my_func")
    .owner_to("new_owner");

pub fn set_schema<N: IntoIden>(&mut self, new_schema: N) -> &mut Self

SET SCHEMA new_schema

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_function()
    .name("my_func")
    .set_schema("new_schema");

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

Set behavior (IMMUTABLE/STABLE/VOLATILE)

Examples

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

let query = Query::alter_function()
    .name("my_func")
    .set_behavior(FunctionBehavior::Immutable);

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

Set security (DEFINER/INVOKER)

Examples

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

let query = Query::alter_function()
    .name("my_func")
    .set_security(FunctionSecurity::Definer);

Trait Implementations

impl Clone for AlterFunctionStatement

fn clone(&self) -> AlterFunctionStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for AlterFunctionStatement

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

Formats the value using the given formatter.

impl Default for AlterFunctionStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for AlterFunctionStatement

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 AlterFunctionStatement