Struct OptimizeTableStatement 

pub struct OptimizeTableStatement { /* private fields */ }

OPTIMIZE TABLE statement builder

This struct provides a fluent API for constructing OPTIMIZE TABLE queries. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data.

MySQL-only: Other backends will panic with a helpful error message.

Examples

use reinhardt_query::prelude::*;

// OPTIMIZE TABLE users
let query = Query::optimize_table()
    .table("users");

// OPTIMIZE NO_WRITE_TO_BINLOG TABLE users, posts
let query = Query::optimize_table()
    .table("users")
    .table("posts")
    .no_write_to_binlog();

// OPTIMIZE LOCAL TABLE users
let query = Query::optimize_table()
    .table("users")
    .local();

Implementations

impl OptimizeTableStatement

pub fn new() -> Self

Create a new OPTIMIZE TABLE statement

Examples

use reinhardt_query::prelude::*;

let query = Query::optimize_table();

pub fn take(&mut self) -> Self

Take the ownership of data in the current OptimizeTableStatement

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

where T: IntoIden,

Add a table to optimize

Examples

use reinhardt_query::prelude::*;

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

pub fn no_write_to_binlog(&mut self) -> &mut Self

Set NO_WRITE_TO_BINLOG option

Suppresses binary logging for this operation (same as LOCAL).

Examples

use reinhardt_query::prelude::*;

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

pub fn local(&mut self) -> &mut Self

Set LOCAL option

Suppresses binary logging for this operation (same as NO_WRITE_TO_BINLOG).

Examples

use reinhardt_query::prelude::*;

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

pub fn options(&mut self, opt: OptimizeTableOption) -> &mut Self

Set options from OptimizeTableOption

Examples

use reinhardt_query::prelude::*;
use reinhardt_query::types::OptimizeTableOption;

let opt = OptimizeTableOption::new().no_write_to_binlog(true);
let query = Query::optimize_table()
    .table("users")
    .options(opt);

Trait Implementations

impl Clone for OptimizeTableStatement

fn clone(&self) -> OptimizeTableStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for OptimizeTableStatement

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

Formats the value using the given formatter.

impl Default for OptimizeTableStatement

fn default() -> OptimizeTableStatement

Returns the “default value” for a type.

impl QueryStatementBuilder for OptimizeTableStatement

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

Build SQL statement for a database backend and collect query parameters

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

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

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

Build SQL statement with parameter collection

impl QueryStatementWriter for OptimizeTableStatement