SQLType enum

SQL column types with their SQL string representation

Inheritance

• Object
• Enum
• SQLType

Available extensions

• EnumName

Values

integer → const SQLType

const SQLType('INTEGER', 'integer')

bigint → const SQLType

const SQLType('BIGINT', 'bigint')

smallint → const SQLType

const SQLType('SMALLINT', 'smallint')

serial → const SQLType

const SQLType('SERIAL', 'serial')

bigserial → const SQLType

const SQLType('BIGSERIAL', 'bigserial')

text → const SQLType

const SQLType('TEXT', 'text')

varchar → const SQLType

const SQLType('VARCHAR', 'varchar')

char → const SQLType

const SQLType('CHAR', 'char')

real → const SQLType

const SQLType('REAL', 'real')

doublePrecision → const SQLType

const SQLType('DOUBLE PRECISION', 'double_precision')

numeric → const SQLType

const SQLType('NUMERIC', 'numeric')

decimal → const SQLType

const SQLType('DECIMAL', 'decimal')

boolean → const SQLType

const SQLType('BOOLEAN', 'boolean')

timestamp → const SQLType

const SQLType('TIMESTAMP', 'timestamp')

timestamptz → const SQLType

const SQLType('TIMESTAMPTZ', 'timestamptz')

date → const SQLType

const SQLType('DATE', 'date')

time → const SQLType

const SQLType('TIME', 'time')

timetz → const SQLType

const SQLType('TIMETZ', 'timetz')

interval → const SQLType

const SQLType('INTERVAL', 'interval')

bytea → const SQLType

const SQLType('BYTEA', 'bytea')

blob → const SQLType

const SQLType('BLOB', 'blob')

json → const SQLType

const SQLType('JSON', 'json')

jsonb → const SQLType

const SQLType('JSONB', 'jsonb')

uuid → const SQLType

const SQLType('UUID', 'uuid')

Properties

hashCode → int

The hash code for this object.

no setter, inherited

index → int

A numeric identifier for the enumerated value.

no setter, inherited

name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

sqlType → String

final

sqlTypeName → String

final

Methods

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Static Methods

convertTypeForDatabase(String sqlType, DatabaseType dbType) → String

Convert a SQL type string based on database type JSON and JSONB are only supported in PostgreSQL, convert to TEXT for SQLite

fromName(String name) → SQLType

toSql(String name) → String

toSqlForDatabase(String name, DatabaseType dbType) → String

Convert SQL type based on database type JSON and JSONB are only supported in PostgreSQL, convert to TEXT for SQLite

Constants

values → const List<SQLType>

A constant List of the values in this enum, in order of their declaration.