Struct AlterSequenceStatement 

pub struct AlterSequenceStatement { /* private fields */ }

ALTER SEQUENCE statement builder

This struct provides a fluent API for constructing ALTER SEQUENCE queries.

Examples

use reinhardt_query::prelude::*;

// ALTER SEQUENCE my_seq RESTART
let query = Query::alter_sequence()
    .name("my_seq")
    .restart(None);

// ALTER SEQUENCE my_seq RESTART WITH 100
let query = Query::alter_sequence()
    .name("my_seq")
    .restart(Some(100));

// ALTER SEQUENCE my_seq INCREMENT BY 5 MINVALUE 1 MAXVALUE 1000
let query = Query::alter_sequence()
    .name("my_seq")
    .increment_by(5)
    .min_value(1)
    .max_value(1000);

// ALTER SEQUENCE my_seq OWNED BY my_table.id
let query = Query::alter_sequence()
    .name("my_seq")
    .owned_by_column("my_table", "id");

Implementations

impl AlterSequenceStatement

pub fn new() -> Self

Create a new ALTER SEQUENCE statement

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence();

pub fn take(&mut self) -> Self

Take the ownership of data in the current AlterSequenceStatement

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

where N: IntoIden,

Set the sequence name

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq");

pub fn restart(&mut self, value: Option<i64>) -> &mut Self

Add RESTART option

Use None for RESTART (without value) or Some(value) for RESTART WITH value.

Examples

use reinhardt_query::prelude::*;

// RESTART
let query = Query::alter_sequence()
    .name("my_seq")
    .restart(None);

// RESTART WITH 100
let query = Query::alter_sequence()
    .name("my_seq")
    .restart(Some(100));

pub fn increment_by(&mut self, increment: i64) -> &mut Self

Add INCREMENT BY option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .increment_by(5);

pub fn min_value(&mut self, value: i64) -> &mut Self

Add MINVALUE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .min_value(1);

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

Add NO MINVALUE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .no_min_value();

pub fn max_value(&mut self, value: i64) -> &mut Self

Add MAXVALUE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .max_value(1000);

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

Add NO MAXVALUE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .no_max_value();

pub fn cache(&mut self, value: i64) -> &mut Self

Add CACHE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .cache(20);

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

Add CYCLE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .cycle();

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

Add NO CYCLE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .no_cycle();

pub fn owned_by_column<T: IntoIden, C: IntoIden>( &mut self, table: T, column: C, ) -> &mut Self

Add OWNED BY table.column option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .owned_by_column("my_table", "id");

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

Add OWNED BY NONE option

Examples

use reinhardt_query::prelude::*;

let query = Query::alter_sequence()
    .name("my_seq")
    .owned_by_none();

Trait Implementations

impl Clone for AlterSequenceStatement

fn clone(&self) -> AlterSequenceStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for AlterSequenceStatement

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

Formats the value using the given formatter.

impl Default for AlterSequenceStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for AlterSequenceStatement

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 AlterSequenceStatement