Struct CreateTableBuilder 

pub struct CreateTableBuilder<Name, Cols> { /* private fields */ }

Type-safe CREATE TABLE builder.

Uses the typestate pattern to ensure that:

• A table name must be set before building
• At least one column must be added before building

Example

use oxide_sql_core::migrations::{CreateTableBuilder, bigint, varchar, timestamp};

let op = CreateTableBuilder::new()
    .name("users")
    .column(bigint("id").primary_key().autoincrement().build())
    .column(varchar("username", 255).not_null().unique().build())
    .column(timestamp("created_at").not_null().default_expr("CURRENT_TIMESTAMP").build())
    .build();

assert_eq!(op.name, "users");
assert_eq!(op.columns.len(), 3);

Implementations

impl CreateTableBuilder<NoName, NoColumns>

pub fn new() -> Self

Creates a new CreateTableBuilder.

impl<Cols> CreateTableBuilder<NoName, Cols>

pub fn name(self, name: impl Into<String>) -> CreateTableBuilder<HasName, Cols>

Sets the table name.

impl<Name> CreateTableBuilder<Name, NoColumns>

pub fn column( self, column: ColumnDefinition, ) -> CreateTableBuilder<Name, HasColumns>

Adds the first column to the table.

impl<Name> CreateTableBuilder<Name, HasColumns>

pub fn column(self, column: ColumnDefinition) -> Self

Adds another column to the table.

impl<Name, Cols> CreateTableBuilder<Name, Cols>

pub fn if_not_exists(self) -> Self

Uses IF NOT EXISTS clause.

impl<Cols> CreateTableBuilder<HasName, Cols>

pub fn constraint(self, constraint: TableConstraint) -> Self

Adds a table-level constraint.

pub fn primary_key(self, columns: &[&str]) -> Self

Adds a composite primary key constraint.

pub fn primary_key_named( self, name: impl Into<String>, columns: &[&str], ) -> Self

Adds a named composite primary key constraint.

pub fn unique_constraint(self, columns: &[&str]) -> Self

Adds a unique constraint on multiple columns.

pub fn unique_constraint_named( self, name: impl Into<String>, columns: &[&str], ) -> Self

Adds a named unique constraint on multiple columns.

pub fn check_constraint(self, expression: impl Into<String>) -> Self

Adds a check constraint.

pub fn check_constraint_named( self, name: impl Into<String>, expression: impl Into<String>, ) -> Self

Adds a named check constraint.

impl CreateTableBuilder<HasName, HasColumns>

pub fn build(self) -> CreateTableOp

Builds the CreateTableOp.

Trait Implementations

impl<Name: Clone, Cols: Clone> Clone for CreateTableBuilder<Name, Cols>

fn clone(&self) -> CreateTableBuilder<Name, Cols>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<Name: Debug, Cols: Debug> Debug for CreateTableBuilder<Name, Cols>

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

Formats the value using the given formatter.

impl Default for CreateTableBuilder<NoName, NoColumns>

fn default() -> Self

Returns the “default value” for a type.