Struct DropUserStatement 

pub struct DropUserStatement {
    pub user_names: Vec<String>,
    pub if_exists: bool,
}

DROP USER statement builder

This struct provides a fluent API for building DROP USER statements.

PostgreSQL

PostgreSQL DROP USER is an alias for DROP ROLE.

MySQL

MySQL DROP USER supports:

• IF EXISTS clause
• User@host specification
• Multiple users

Examples

Drop a single user:

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .user("app_user");

Drop multiple users (MySQL):

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .users(vec!["user1@localhost".to_string(), "user2@localhost".to_string()])
    .if_exists(true);

Fields

user_names: Vec<String>

User names (with optional @host for MySQL)

if_exists: bool

IF EXISTS clause

Implementations

impl DropUserStatement

pub fn new() -> Self

Create a new DROP USER statement

Examples

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new();

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

Add a single user to drop

Examples

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .user("app_user");

MySQL with host:

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .user("app_user@localhost");

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

Set all users to drop at once

Examples

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .users(vec!["user1".to_string(), "user2".to_string()]);

pub fn if_exists(self, flag: bool) -> Self

Set IF EXISTS flag

Examples

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .user("app_user")
    .if_exists(true);

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

Validate the DROP USER statement

Validation Rules

1. At least one user must be specified

Examples

use reinhardt_query::dcl::DropUserStatement;

let stmt = DropUserStatement::new()
    .user("app_user");

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

use reinhardt_query::dcl::DropUserStatement;

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

Trait Implementations

impl Clone for DropUserStatement

fn clone(&self) -> DropUserStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DropUserStatement

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

Formats the value using the given formatter.

impl Default for DropUserStatement

fn default() -> DropUserStatement

Returns the “default value” for a type.