Enum ColumnType

#[non_exhaustive]
pub enum ColumnType {
    Char(Option<u32>),
    String(StringLen),
    Text,
    Blob,
    TinyInteger,
    SmallInteger,
    Integer,
    BigInteger,
    TinyUnsigned,
    SmallUnsigned,
    Unsigned,
    BigUnsigned,
    Float,
    Double,
    Decimal(Option<(u32, u32)>),
    DateTime,
    Timestamp,
    TimestampWithTimeZone,
    Time,
    Date,
    Year,
    Interval(Option<PgInterval>, Option<u32>),
    Binary(u32),
    VarBinary(StringLen),
    Bit(Option<u32>),
    VarBit(u32),
    Boolean,
    Money(Option<(u32, u32)>),
    Json,
    JsonBinary,
    Uuid,
    Custom(SeaRc<dyn Iden>),
    Enum {
        name: SeaRc<dyn Iden>,
        variants: Vec<SeaRc<dyn Iden>>,
    },
    Array(Arc<ColumnType>),
    Vector(Option<u32>),
    Cidr,
    Inet,
    MacAddr,
    LTree,
}

All column types

ColumnType	MySQL data type	PostgreSQL data type	SQLite data type
Char	char	char	char
String	varchar	varchar	varchar
Text	text	text	text
TinyInteger	tinyint	smallint	tinyint
SmallInteger	smallint	smallint	smallint
Integer	int	integer	integer
BigInteger	bigint	bigint	integer
TinyUnsigned	tinyint unsigned	smallint	tinyint
SmallUnsigned	smallint unsigned	smallint	smallint
Unsigned	int unsigned	integer	integer
BigUnsigned	bigint unsigned	bigint	integer
Float	float	real	float
Double	double	double precision	double
Decimal	decimal	decimal	real
DateTime	datetime	timestamp without time zone	datetime_text
Timestamp	timestamp	timestamp	timestamp_text
TimestampWithTimeZone	timestamp	timestamp with time zone	timestamp_with_timezone_text
Time	time	time	time_text
Date	date	date	date_text
Year	year	N/A	N/A
Interval	N/A	interval	N/A
Blob	blob	bytea	blob
Binary	binary	bytea	blob
VarBinary	varbinary	bytea	varbinary_blob
Bit	bit	bit	N/A
VarBit	bit	varbit	N/A
Boolean	bool	bool	boolean
Money	decimal	money	real_money
Json	json	json	json_text
JsonBinary	json	jsonb	jsonb_text
Uuid	binary(16)	uuid	uuid_text
Enum	ENUM(…)	ENUM_NAME	enum_text
Array	N/A	DATA_TYPE[]	N/A
Vector	N/A	vector	N/A
Cidr	N/A	cidr	N/A
Inet	N/A	inet	N/A
MacAddr	N/A	macaddr	N/A
LTree	N/A	ltree	N/A

Variants (Non-exhaustive)

Non-exhaustive enums could have additional variants added in future. Therefore, when matching against variants of non-exhaustive enums, an extra wildcard arm must be added to account for any future variants.

Char(Option<u32>)

String(StringLen)

Text

Blob

TinyInteger

SmallInteger

Integer

BigInteger

TinyUnsigned

SmallUnsigned

Unsigned

BigUnsigned

Float

Double

Decimal(Option<(u32, u32)>)

DateTime

Timestamp

TimestampWithTimeZone

Time

Date

Year

Interval(Option<PgInterval>, Option<u32>)

Binary(u32)

VarBinary(StringLen)

Bit(Option<u32>)

VarBit(u32)

Boolean

Money(Option<(u32, u32)>)

Json

JsonBinary

Uuid

Custom(SeaRc<dyn Iden>)

Enum

Fields

name: SeaRc<dyn Iden>

variants: Vec<SeaRc<dyn Iden>>

Array(Arc<ColumnType>)

Vector(Option<u32>)

Cidr

Inet

MacAddr

LTree

Implementations

impl ColumnType

pub fn custom<T>(ty: T) -> ColumnType

where T: Into<String>,

pub fn string(length: Option<u32>) -> ColumnType

pub fn var_binary(length: u32) -> ColumnType

Trait Implementations

impl Clone for ColumnType

fn clone(&self) -> ColumnType

Returns a copy of the value.

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

Performs copy-assignment from source.

impl ColumnTypeTrait for ColumnType

fn def(self) -> ColumnDef

Instantiate a new ColumnDef

fn get_enum_name(&self) -> Option<&SeaRc<dyn Iden>>

Get the name of the enum if this is a enum column

impl Debug for ColumnType

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

Formats the value using the given formatter.

impl PartialEq for ColumnType

fn eq(&self, other: &ColumnType) -> 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.