Struct AlterDatabaseStatement

Source

pub struct AlterDatabaseStatement { /* private fields */ }

Expand description

ALTER DATABASE statement builder

This struct provides a fluent API for constructing ALTER DATABASE queries. It supports standard PostgreSQL operations and CockroachDB-specific multi-region configuration.

§Examples

use reinhardt_query::prelude::*;

// ALTER DATABASE mydb RENAME TO newdb
let query = Query::alter_database()
    .name("mydb")
    .rename_to("newdb");

// ALTER DATABASE mydb ADD REGION "us-east-1" (CockroachDB)
let query = Query::alter_database()
    .name("mydb")
    .add_region("us-east-1");

// ALTER DATABASE mydb PRIMARY REGION "us-east-1" (CockroachDB)
let query = Query::alter_database()
    .name("mydb")
    .set_primary_region("us-east-1");

Implementations§

Source §

impl AlterDatabaseStatement

Source

pub fn new() -> Self

Create a new ALTER DATABASE statement

§Examples

use reinhardt_query::prelude::*;

let query = Query::alter_database();

Source

pub fn take(&mut self) -> Self

Take the ownership of data in the current AlterDatabaseStatement

Source

pub fn name<N>(&mut self, name: N) -> &mut Self
where N: IntoIden,

Set the database name

§Examples

use reinhardt_query::prelude::*;

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

Source

pub fn rename_to<N>(&mut self, new_name: N) -> &mut Self
where N: IntoIden,

Rename the database to a new name

§Examples

use reinhardt_query::prelude::*;

let query = Query::alter_database()
    .name("old_db")
    .rename_to("new_db");

Source

pub fn owner_to<O>(&mut self, new_owner: O) -> &mut Self
where O: IntoIden,

Change the owner of the database

§Examples

use reinhardt_query::prelude::*;

let query = Query::alter_database()
    .name("mydb")
    .owner_to("new_owner");

Source

pub fn add_region<S>(&mut self, region: S) -> &mut Self
where S: Into<String>,

Add a region to the database (CockroachDB-specific)

§Examples

use reinhardt_query::prelude::*;

let query = Query::alter_database()
    .name("mydb")
    .add_region("us-east-1");

Source

pub fn drop_region<S>(&mut self, region: S) -> &mut Self
where S: Into<String>,

Drop a region from the database (CockroachDB-specific)

§Examples

use reinhardt_query::prelude::*;

let query = Query::alter_database()
    .name("mydb")
    .drop_region("us-west-1");

Source

pub fn set_primary_region<S>(&mut self, region: S) -> &mut Self
where S: Into<String>,

Set the primary region for the database (CockroachDB-specific)

§Examples

use reinhardt_query::prelude::*;

let query = Query::alter_database()
    .name("mydb")
    .set_primary_region("us-east-1");

Source

pub fn configure_zone(&mut self, zone: ZoneConfig) -> &mut Self

Configure zone settings for the database (CockroachDB-specific)

§Examples

use reinhardt_query::prelude::*;
use reinhardt_query::types::ZoneConfig;

let zone = ZoneConfig::new()
    .num_replicas(3)
    .add_constraint("+region=us-east-1");

let query = Query::alter_database()
    .name("mydb")
    .configure_zone(zone);