Struct ProcedureCall 

pub struct ProcedureCall {
    pub name: String,
    pub schema: Option<String>,
    pub parameters: Vec<Parameter>,
    pub db_type: DatabaseType,
    pub is_function: bool,
}

Builder for stored procedure calls.

Fields

name: String

Procedure/function name.

schema: Option<String>

Schema name (optional).

parameters: Vec<Parameter>

Parameters.

db_type: DatabaseType

Database type for SQL generation.

is_function: bool

Whether this is a function call (vs procedure).

Implementations

impl ProcedureCall

pub fn new(name: impl Into<String>) -> Self

Create a new procedure call.

pub fn function(name: impl Into<String>) -> Self

Create a new function call.

pub fn schema(self, schema: impl Into<String>) -> Self

Set the schema name.

pub fn with_db_type(self, db_type: DatabaseType) -> Self

Set the database type.

pub fn param( self, name: impl Into<String>, value: impl Into<FilterValue>, ) -> Self

Add an input parameter.

pub fn in_param( self, name: impl Into<String>, value: impl Into<FilterValue>, ) -> Self

Add an input parameter (alias for param).

pub fn out_param(self, name: impl Into<String>) -> Self

Add an output parameter.

pub fn out_param_typed( self, name: impl Into<String>, type_hint: impl Into<String>, ) -> Self

Add an output parameter with type hint.

pub fn inout_param( self, name: impl Into<String>, value: impl Into<FilterValue>, ) -> Self

Add an input/output parameter.

pub fn add_parameter(self, param: Parameter) -> Self

Add a raw parameter.

pub fn qualified_name(&self) -> Cow<'_, str>

Get the fully qualified name.

pub fn has_outputs(&self) -> bool

Check if any parameters are OUT or INOUT.

pub fn input_values(&self) -> Vec<FilterValue>

Get input parameter values.

pub fn to_postgres_sql(&self) -> (String, Vec<FilterValue>)

Generate SQL for PostgreSQL.

pub fn to_mysql_sql(&self) -> (String, Vec<FilterValue>)

Generate SQL for MySQL.

pub fn to_mssql_sql(&self) -> (String, Vec<FilterValue>)

Generate SQL for MSSQL.

pub fn to_sqlite_sql(&self) -> QueryResult<(String, Vec<FilterValue>)>

Generate SQL for SQLite (only functions supported).

pub fn to_sql(&self) -> QueryResult<(String, Vec<FilterValue>)>

Generate SQL for the configured database type.

Trait Implementations

impl Clone for ProcedureCall

fn clone(&self) -> ProcedureCall

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ProcedureCall

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

Formats the value using the given formatter.