Struct CreateRoleStatement 

pub struct CreateRoleStatement {
    pub role_name: String,
    pub if_not_exists: bool,
    pub attributes: Vec<RoleAttribute>,
    pub options: Vec<UserOption>,
}

CREATE ROLE statement builder

This struct provides a fluent API for building CREATE ROLE statements. It supports both PostgreSQL attributes and MySQL options.

PostgreSQL

PostgreSQL CREATE ROLE accepts various attributes that control role privileges and settings. Use the `attribute()` method to add attributes.

MySQL

MySQL CREATE ROLE supports IF NOT EXISTS clause and user options. Use the `if_not_exists()` and `option()` methods.

Examples

Create a simple role:

use reinhardt_query::dcl::CreateRoleStatement;

let stmt = CreateRoleStatement::new()
    .role("developer");

Create a login role with password (PostgreSQL):

use reinhardt_query::dcl::{CreateRoleStatement, RoleAttribute};

let stmt = CreateRoleStatement::new()
    .role("app_user")
    .attribute(RoleAttribute::Login)
    .attribute(RoleAttribute::Password("password123".to_string()))
    .attribute(RoleAttribute::ConnectionLimit(5));

Create a role with IF NOT EXISTS (MySQL):

use reinhardt_query::dcl::{CreateRoleStatement, UserOption};

let stmt = CreateRoleStatement::new()
    .role("app_role")
    .if_not_exists(true)
    .option(UserOption::Comment("My application role".to_string()));

Fields

role_name: String

Role name

if_not_exists: bool

IF NOT EXISTS clause (MySQL only)

attributes: Vec<RoleAttribute>

PostgreSQL role attributes

options: Vec<UserOption>

MySQL user options

Implementations

impl CreateRoleStatement

pub fn new() -> Self

Create a new CREATE ROLE statement

Examples

use reinhardt_query::dcl::CreateRoleStatement;

let stmt = CreateRoleStatement::new();

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

Set the role name

Examples

use reinhardt_query::dcl::CreateRoleStatement;

let stmt = CreateRoleStatement::new()
    .role("developer");

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

Set IF NOT EXISTS flag (MySQL only)

Examples

use reinhardt_query::dcl::CreateRoleStatement;

let stmt = CreateRoleStatement::new()
    .role("app_role")
    .if_not_exists(true);

pub fn attribute(self, attr: RoleAttribute) -> Self

Add a single PostgreSQL role attribute

Examples

use reinhardt_query::dcl::{CreateRoleStatement, RoleAttribute};

let stmt = CreateRoleStatement::new()
    .role("app_user")
    .attribute(RoleAttribute::Login)
    .attribute(RoleAttribute::CreateDb);

pub fn attributes(self, attrs: Vec<RoleAttribute>) -> Self

Set all PostgreSQL role attributes at once

Examples

use reinhardt_query::dcl::{CreateRoleStatement, RoleAttribute};

let stmt = CreateRoleStatement::new()
    .role("app_user")
    .attributes(vec![
        RoleAttribute::Login,
        RoleAttribute::CreateDb,
        RoleAttribute::ConnectionLimit(10),
    ]);

pub fn option(self, opt: UserOption) -> Self

Add a single MySQL user option

Examples

use reinhardt_query::dcl::{CreateRoleStatement, UserOption};

let stmt = CreateRoleStatement::new()
    .role("app_role")
    .option(UserOption::Comment("Application role".to_string()));

pub fn options(self, opts: Vec<UserOption>) -> Self

Set all MySQL user options at once

Examples

use reinhardt_query::dcl::{CreateRoleStatement, UserOption};

let stmt = CreateRoleStatement::new()
    .role("app_role")
    .options(vec![
        UserOption::Comment("Application role".to_string()),
        UserOption::AccountLock,
    ]);

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

Validate the CREATE ROLE statement

Validation Rules

1. Role name cannot be empty

Examples

use reinhardt_query::dcl::CreateRoleStatement;

let stmt = CreateRoleStatement::new()
    .role("developer");

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

use reinhardt_query::dcl::CreateRoleStatement;

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

Trait Implementations

impl Clone for CreateRoleStatement

fn clone(&self) -> CreateRoleStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateRoleStatement

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

Formats the value using the given formatter.

impl Default for CreateRoleStatement

fn default() -> CreateRoleStatement

Returns the “default value” for a type.