Struct CreateSequenceStatement 

pub struct CreateSequenceStatement { /* private fields */ }

CREATE SEQUENCE statement builder

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

Examples

use reinhardt_query::prelude::*;

// CREATE SEQUENCE my_seq
let query = Query::create_sequence()
    .name("my_seq");

// CREATE SEQUENCE IF NOT EXISTS my_seq INCREMENT BY 5
let query = Query::create_sequence()
    .name("my_seq")
    .if_not_exists()
    .increment(5);

// CREATE SEQUENCE my_seq START WITH 100 MINVALUE 1 MAXVALUE 1000
let query = Query::create_sequence()
    .name("my_seq")
    .start(100)
    .min_value(Some(1))
    .max_value(Some(1000));

Implementations

impl CreateSequenceStatement

pub fn new() -> Self

Create a new CREATE SEQUENCE statement

Examples

use reinhardt_query::prelude::*;

let query = Query::create_sequence();

pub fn take(&mut self) -> Self

Take the ownership of data in the current CreateSequenceStatement

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::create_sequence()
    .name("my_seq");

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

Add IF NOT EXISTS clause

Examples

use reinhardt_query::prelude::*;

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

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

Set INCREMENT BY value

Examples

use reinhardt_query::prelude::*;

let query = Query::create_sequence()
    .name("my_seq")
    .increment(5);

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

Set MINVALUE

Use None for NO MINVALUE, or Some(value) for specific minimum.

Examples

use reinhardt_query::prelude::*;

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

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

Set MAXVALUE

Use None for NO MAXVALUE, or Some(value) for specific maximum.

Examples

use reinhardt_query::prelude::*;

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

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

Set START WITH value

Examples

use reinhardt_query::prelude::*;

let query = Query::create_sequence()
    .name("my_seq")
    .start(100);

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

Set CACHE value

Examples

use reinhardt_query::prelude::*;

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

pub fn cycle(&mut self, cycle: bool) -> &mut Self

Set CYCLE or NO CYCLE

Examples

use reinhardt_query::prelude::*;

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

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

Set OWNED BY table.column

Examples

use reinhardt_query::prelude::*;

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

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

Set OWNED BY NONE

Examples

use reinhardt_query::prelude::*;

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

Trait Implementations

impl Clone for CreateSequenceStatement

fn clone(&self) -> CreateSequenceStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CreateSequenceStatement

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

Formats the value using the given formatter.

impl Default for CreateSequenceStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for CreateSequenceStatement

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 CreateSequenceStatement