Struct SetDefaultRoleStatement 

pub struct SetDefaultRoleStatement {
    pub role_spec: Option<DefaultRoleSpec>,
    pub user_names: Vec<String>,
}

SET DEFAULT ROLE statement builder (MySQL only)

This struct provides a fluent API for building SET DEFAULT ROLE statements. This is a MySQL-specific feature.

MySQL

MySQL SET DEFAULT ROLE sets which roles are activated by default when users connect. Supports:

• Specific roles: SET DEFAULT ROLE role1, role2 TO user
• All roles: SET DEFAULT ROLE ALL TO user
• No roles: SET DEFAULT ROLE NONE TO user

Examples

Set specific default roles:

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::RoleList(vec!["app_role".to_string()]))
    .user("app_user@localhost");

Set all roles as default:

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::All)
    .users(vec!["user1@localhost".to_string(), "user2@localhost".to_string()]);

Clear default roles:

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::None)
    .user("app_user@localhost");

Fields

role_spec: Option<DefaultRoleSpec>

Role specification (ALL, NONE, or specific roles)

user_names: Vec<String>

Target users (with optional @host)

Implementations

impl SetDefaultRoleStatement

pub fn new() -> Self

Create a new SET DEFAULT ROLE statement

Examples

use reinhardt_query::dcl::SetDefaultRoleStatement;

let stmt = SetDefaultRoleStatement::new();

pub fn roles(self, spec: DefaultRoleSpec) -> Self

Set the role specification

Examples

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::RoleList(vec!["app_role".to_string()]));

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

Add a single target user

Examples

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::All)
    .user("app_user@localhost");

pub fn users(self, names: Vec<String>) -> Self

Set all target users at once

Examples

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::All)
    .users(vec!["user1@localhost".to_string(), "user2@localhost".to_string()]);

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

Validate the SET DEFAULT ROLE statement

Validation Rules

1. Role specification must be set
2. At least one user must be specified
3. For RoleList variant, role list cannot be empty

Examples

use reinhardt_query::dcl::{SetDefaultRoleStatement, DefaultRoleSpec};

let stmt = SetDefaultRoleStatement::new()
    .roles(DefaultRoleSpec::All)
    .user("app_user@localhost");

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

use reinhardt_query::dcl::SetDefaultRoleStatement;

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

Trait Implementations

impl Clone for SetDefaultRoleStatement

fn clone(&self) -> SetDefaultRoleStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SetDefaultRoleStatement

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

Formats the value using the given formatter.

impl Default for SetDefaultRoleStatement

fn default() -> SetDefaultRoleStatement

Returns the “default value” for a type.