Struct CreateDatabaseStatement 

pub struct CreateDatabaseStatement { /* private fields */ }

Available on crate feature database and non-WebAssembly only.

CREATE DATABASE statement builder

This struct provides a fluent API for constructing CREATE DATABASE queries. It supports both PostgreSQL and MySQL database creation options.

Examples

use reinhardt_query::prelude::*;

// CREATE DATABASE mydb
let query = Query::create_database()
    .name("mydb");

// CREATE DATABASE IF NOT EXISTS mydb
let query = Query::create_database()
    .name("mydb")
    .if_not_exists();

// CREATE DATABASE mydb OWNER alice (PostgreSQL)
let query = Query::create_database()
    .name("mydb")
    .owner("alice");

// CREATE DATABASE mydb TEMPLATE template0 ENCODING 'UTF8' (PostgreSQL)
let query = Query::create_database()
    .name("mydb")
    .template("template0")
    .encoding("UTF8");

// CREATE DATABASE mydb CHARACTER SET utf8mb4 (MySQL)
let query = Query::create_database()
    .name("mydb")
    .character_set("utf8mb4");

Implementations

impl CreateDatabaseStatement

pub fn new() -> CreateDatabaseStatement

Create a new CREATE DATABASE statement

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database();

pub fn take(&mut self) -> CreateDatabaseStatement

Take the ownership of data in the current CreateDatabaseStatement

pub fn name<N>(&mut self, name: N) -> &mut CreateDatabaseStatement

where N: IntoIden,

Set the database name

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb");

pub fn if_not_exists(&mut self) -> &mut CreateDatabaseStatement

Add IF NOT EXISTS clause

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .if_not_exists();

pub fn owner<O>(&mut self, owner: O) -> &mut CreateDatabaseStatement

where O: IntoIden,

Set OWNER (PostgreSQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .owner("alice");

pub fn template<T>(&mut self, template: T) -> &mut CreateDatabaseStatement

where T: IntoIden,

Set TEMPLATE database (PostgreSQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .template("template0");

pub fn encoding<S>(&mut self, encoding: S) -> &mut CreateDatabaseStatement

where S: Into<String>,

Set ENCODING (PostgreSQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .encoding("UTF8");

pub fn lc_collate<S>(&mut self, lc_collate: S) -> &mut CreateDatabaseStatement

where S: Into<String>,

Set LC_COLLATE (PostgreSQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .lc_collate("en_US.UTF-8");

pub fn lc_ctype<S>(&mut self, lc_ctype: S) -> &mut CreateDatabaseStatement

where S: Into<String>,

Set LC_CTYPE (PostgreSQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .lc_ctype("en_US.UTF-8");

pub fn character_set<S>(&mut self, charset: S) -> &mut CreateDatabaseStatement

where S: Into<String>,

Set CHARACTER SET (MySQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .character_set("utf8mb4");

pub fn collate<S>(&mut self, collate: S) -> &mut CreateDatabaseStatement

where S: Into<String>,

Set COLLATE (MySQL/PostgreSQL)

Examples

use reinhardt_query::prelude::*;

let query = Query::create_database()
    .name("mydb")
    .collate("utf8mb4_unicode_ci");

Trait Implementations

impl Clone for CreateDatabaseStatement

fn clone(&self) -> CreateDatabaseStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateDatabaseStatement

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

Formats the value using the given formatter.

impl Default for CreateDatabaseStatement

fn default() -> CreateDatabaseStatement

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateDatabaseStatement

fn build_any( &self, query_builder: &(dyn QueryBuilderTrait + 'static), ) -> (String, Values)

Build SQL statement for a database backend and collect query parameters

fn to_string<T>(&self, query_builder: T) -> String

where T: QueryBuilderTrait,

Build SQL statement for a database backend and return SQL string with values inlined as SQL literals.

fn build<T>(&self, query_builder: T) -> (String, Values)

where T: QueryBuilderTrait,

Build SQL statement with parameter collection

impl QueryStatementWriter for CreateDatabaseStatement