Struct SetRoleStatement 

pub struct SetRoleStatement {
    pub target: Option<RoleTarget>,
}

SET ROLE statement builder

This struct provides a fluent API for building SET ROLE statements.

PostgreSQL

PostgreSQL SET ROLE changes the current role for the session. Supports:

• Named role: SET ROLE role_name
• Reset: SET ROLE NONE

MySQL

MySQL SET ROLE activates roles for the session. Supports:

• Named role: SET ROLE role_name
• None: SET ROLE NONE
• All: SET ROLE ALL
• All except: SET ROLE ALL EXCEPT role_list
• Default: SET ROLE DEFAULT

Examples

Set to a specific role:

use reinhardt_query::dcl::{SetRoleStatement, RoleTarget};

let stmt = SetRoleStatement::new()
    .role(RoleTarget::Named("admin".to_string()));

Deactivate all roles:

use reinhardt_query::dcl::{SetRoleStatement, RoleTarget};

let stmt = SetRoleStatement::new()
    .role(RoleTarget::None);

Activate all granted roles (MySQL):

use reinhardt_query::dcl::{SetRoleStatement, RoleTarget};

let stmt = SetRoleStatement::new()
    .role(RoleTarget::All);

Activate all except specific roles (MySQL):

use reinhardt_query::dcl::{SetRoleStatement, RoleTarget};

let stmt = SetRoleStatement::new()
    .role(RoleTarget::AllExcept(vec!["restricted".to_string()]));

Fields

target: Option<RoleTarget>

Role target

Implementations

impl SetRoleStatement

pub fn new() -> Self

Create a new SET ROLE statement

Examples

use reinhardt_query::dcl::SetRoleStatement;

let stmt = SetRoleStatement::new();

pub fn role(self, target: RoleTarget) -> Self

Set the role target

Examples

use reinhardt_query::dcl::{SetRoleStatement, RoleTarget};

let stmt = SetRoleStatement::new()
    .role(RoleTarget::Named("admin".to_string()));

pub fn validate(&self) -> Result<(), String>

Validate the SET ROLE statement

Validation Rules

1. Role target must be specified
2. For Named variant, role name cannot be empty
3. For AllExcept variant, exception list cannot be empty

Examples

use reinhardt_query::dcl::{SetRoleStatement, RoleTarget};

let stmt = SetRoleStatement::new()
    .role(RoleTarget::Named("admin".to_string()));

assert!(stmt.validate().is_ok());

use reinhardt_query::dcl::SetRoleStatement;

let stmt = SetRoleStatement::new();
assert!(stmt.validate().is_err());

Trait Implementations

impl Clone for SetRoleStatement

fn clone(&self) -> SetRoleStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SetRoleStatement

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

Formats the value using the given formatter.

impl Default for SetRoleStatement

fn default() -> SetRoleStatement

Returns the “default value” for a type.