Struct Sequence 

pub struct Sequence {
    pub name: String,
    pub schema: Option<String>,
    pub start: i64,
    pub increment: i64,
    pub min_value: Option<i64>,
    pub max_value: Option<i64>,
    pub cycle: bool,
    pub cache: Option<i64>,
    pub owned_by: Option<OwnedBy>,
    pub comment: Option<String>,
}

A database sequence definition.

Fields

name: String

Sequence name.

schema: Option<String>

Schema name (optional).

start: i64

Starting value.

increment: i64

Increment value.

min_value: Option<i64>

Minimum value (None for no minimum).

max_value: Option<i64>

Maximum value (None for no maximum).

cycle: bool

Whether the sequence cycles when reaching max/min.

cache: Option<i64>

Number of values to cache (for performance).

owned_by: Option<OwnedBy>

Whether the sequence is owned by a column.

comment: Option<String>

Optional comment/description.

Implementations

impl Sequence

pub fn builder(name: impl Into<String>) -> SequenceBuilder

Create a new sequence builder.

pub fn qualified_name(&self) -> Cow<'_, str>

Get the fully qualified sequence name.

pub fn to_postgres_create_sql(&self) -> String

Generate PostgreSQL CREATE SEQUENCE SQL.

pub fn to_mssql_create_sql(&self) -> String

Generate MSSQL CREATE SEQUENCE SQL.

pub fn to_create_sql(&self, db_type: DatabaseType) -> QueryResult<String>

Generate CREATE SEQUENCE SQL for the specified database type.

pub fn to_drop_sql(&self, db_type: DatabaseType) -> QueryResult<String>

Generate DROP SEQUENCE SQL.

pub fn to_alter_sql(&self, db_type: DatabaseType) -> QueryResult<String>

Generate ALTER SEQUENCE SQL.

pub fn restart_sql( &self, value: i64, db_type: DatabaseType, ) -> QueryResult<String>

Generate SQL to restart the sequence at a specific value.

Trait Implementations

impl Clone for Sequence

fn clone(&self) -> Sequence

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Sequence

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Sequence

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for Sequence

fn eq(&self, other: &Sequence) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for Sequence

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for Sequence

impl StructuralPartialEq for Sequence