Struct ColumnDef 

pub struct ColumnDef { /* private fields */ }

Available on crate feature database and non-WebAssembly only.

Column definition for CREATE TABLE

This struct represents a column definition, including its type, constraints, and default value.

Examples

use reinhardt_query::types::ddl::{ColumnDef, ColumnType};

// id INTEGER PRIMARY KEY AUTO_INCREMENT
let id_col = ColumnDef::new("id")
    .column_type(ColumnType::Integer)
    .primary_key(true)
    .auto_increment(true);

// name VARCHAR(100) NOT NULL
let name_col = ColumnDef::new("name")
    .column_type(ColumnType::String(Some(100)))
    .not_null(true);

Implementations

impl ColumnDef

pub fn new<T>(name: T) -> ColumnDef

where T: IntoIden,

Create a new column definition

pub fn column_type(self, column_type: ColumnType) -> ColumnDef

Set the column type

pub fn not_null(self, not_null: bool) -> ColumnDef

Set NOT NULL constraint

pub fn unique(self, unique: bool) -> ColumnDef

Set UNIQUE constraint

pub fn primary_key(self, primary_key: bool) -> ColumnDef

Set PRIMARY KEY constraint

pub fn auto_increment(self, auto_increment: bool) -> ColumnDef

Set AUTO_INCREMENT attribute

pub fn default(self, value: SimpleExpr) -> ColumnDef

Set DEFAULT value

pub fn check(self, expr: SimpleExpr) -> ColumnDef

Set CHECK constraint

pub fn comment<S>(self, comment: S) -> ColumnDef

where S: Into<String>,

Set column comment

pub fn integer(self) -> ColumnDef

Set column type to INTEGER

pub fn big_integer(self) -> ColumnDef

Set column type to BIGINT

pub fn small_integer(self) -> ColumnDef

Set column type to SMALLINT

pub fn tiny_integer(self) -> ColumnDef

Set column type to TINYINT

pub fn string(self) -> ColumnDef

Set column type to VARCHAR (no length limit)

pub fn string_len(self, len: u32) -> ColumnDef

Set column type to VARCHAR(len)

pub fn char(self) -> ColumnDef

Set column type to CHAR (no length limit)

pub fn char_len(self, len: u32) -> ColumnDef

Set column type to CHAR(len)

pub fn text(self) -> ColumnDef

Set column type to TEXT

pub fn boolean(self) -> ColumnDef

Set column type to BOOLEAN

pub fn float(self) -> ColumnDef

Set column type to FLOAT

pub fn double(self) -> ColumnDef

Set column type to DOUBLE

pub fn decimal(self, precision: u32, scale: u32) -> ColumnDef

Set column type to DECIMAL(precision, scale)

pub fn date(self) -> ColumnDef

Set column type to DATE

pub fn time(self) -> ColumnDef

Set column type to TIME

pub fn date_time(self) -> ColumnDef

Set column type to DATETIME

pub fn timestamp(self) -> ColumnDef

Set column type to TIMESTAMP

pub fn timestamp_with_time_zone(self) -> ColumnDef

Set column type to TIMESTAMPTZ

pub fn uuid(self) -> ColumnDef

Set column type to UUID

pub fn json(self) -> ColumnDef

Set column type to JSON

pub fn json_binary(self) -> ColumnDef

Set column type to JSONB

pub fn blob(self) -> ColumnDef

Set column type to BLOB

pub fn binary(self, len: u32) -> ColumnDef

Set column type to BINARY(len)

pub fn binary_len(self, len: u32) -> ColumnDef

Set column type to BINARY(len)

Alias for binary for reinhardt-query compatibility.

pub fn var_binary(self, len: u32) -> ColumnDef

Set column type to VARBINARY(len)

pub fn custom<S>(self, name: S) -> ColumnDef

where S: Into<String>,

Set column type to a custom type

pub fn array(self, element_type: ColumnType) -> ColumnDef

Set column type to ARRAY of given element type

Trait Implementations

impl Clone for ColumnDef

fn clone(&self) -> ColumnDef

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ColumnDef

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

Formats the value using the given formatter.