Struct AlterFunctionStatement 

pub struct AlterFunctionStatement { /* private fields */ }

Available on crate feature database and non-WebAssembly only.

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

Create a new ALTER FUNCTION statement

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_function();

pub fn take(&mut self) -> AlterFunctionStatement

Take the ownership of data in the current AlterFunctionStatement

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

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, T>( &mut self, name: N, param_type: T, ) -> &mut AlterFunctionStatement

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

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>(&mut self, new_name: N) -> &mut AlterFunctionStatement

where N: IntoIden,

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>(&mut self, new_owner: N) -> &mut AlterFunctionStatement

where N: IntoIden,

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>(&mut self, new_schema: N) -> &mut AlterFunctionStatement

where N: IntoIden,

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 AlterFunctionStatement

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 AlterFunctionStatement

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

Formats the value using the given formatter.

impl Default for AlterFunctionStatement

fn default() -> AlterFunctionStatement

Returns the “default value” for a type.

impl QueryStatementBuilder for AlterFunctionStatement

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 AlterFunctionStatement