Struct TruncateTableStatement 

pub struct TruncateTableStatement { /* private fields */ }

Available on crate feature database and non-WebAssembly only.

TRUNCATE TABLE statement builder

This struct provides a fluent API for constructing TRUNCATE TABLE queries.

Examples

use reinhardt_query::prelude::*;

let query = Query::truncate_table()
    .table("users")
    .restart_identity();

Implementations

impl TruncateTableStatement

pub fn new() -> TruncateTableStatement

Create a new TRUNCATE TABLE statement

pub fn take(&mut self) -> TruncateTableStatement

Take the ownership of data in the current TruncateTableStatement

pub fn table<T>(&mut self, tbl: T) -> &mut TruncateTableStatement

where T: IntoTableRef,

Set the table to truncate

Examples

use reinhardt_query::prelude::*;

let query = Query::truncate_table()
    .table("users");

pub fn tables<I, T>(&mut self, tbls: I) -> &mut TruncateTableStatement

where I: IntoIterator<Item = T>, T: IntoTableRef,

Set multiple tables to truncate

Note: MySQL does not support truncating multiple tables in a single statement.

Examples

use reinhardt_query::prelude::*;

let query = Query::truncate_table()
    .tables(vec!["users", "posts", "comments"]);

pub fn cascade(&mut self) -> &mut TruncateTableStatement

Add CASCADE clause

This option automatically truncates dependent tables. Supported by PostgreSQL only.

Examples

use reinhardt_query::prelude::*;

let query = Query::truncate_table()
    .table("users")
    .cascade();

pub fn restrict(&mut self) -> &mut TruncateTableStatement

Add RESTRICT clause

This option prevents truncating if there are dependent tables (default behavior). Supported by PostgreSQL only.

Examples

use reinhardt_query::prelude::*;

let query = Query::truncate_table()
    .table("users")
    .restrict();

pub fn restart_identity(&mut self) -> &mut TruncateTableStatement

Add RESTART IDENTITY clause

This option resets sequences associated with columns. Supported by PostgreSQL only.

Examples

use reinhardt_query::prelude::*;

let query = Query::truncate_table()
    .table("users")
    .restart_identity();

Trait Implementations

impl Clone for TruncateTableStatement

fn clone(&self) -> TruncateTableStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for TruncateTableStatement

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

Formats the value using the given formatter.

impl Default for TruncateTableStatement

fn default() -> TruncateTableStatement

Returns the “default value” for a type.

impl QueryStatementBuilder for TruncateTableStatement

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 TruncateTableStatement