create

Types

Column

pub type Column {
  Column(
    name: String,
    type_: ColumnType,
    is_primary: Bool,
    is_nullable: Bool,
    is_unique: Bool,
    default: Option(dynamic.Dynamic),
    references: Option(Reference),
  )
}

Constructors

Column(
  name: String,
  type_: ColumnType,
  is_primary: Bool,
  is_nullable: Bool,
  is_unique: Bool,
  default: Option(dynamic.Dynamic),
  references: Option(Reference),
)

ColumnType

</>

pub type ColumnType {
  Int
  String
  Bool
  ForeignKey
  Serial
}

Constructors

```
Int
```
```
String
```
```
Bool
```
```
ForeignKey
```
```
Serial
```

DbType

</>

pub type DbType {
  Integer
  Text
  Real
  Blob
}

Constructors

```
Integer
```
```
Text
```
```
Real
```
```
Blob
```

Reference

</>

pub type Reference {
  Reference(
    table: Table,
    column: String,
    on_delete: Option(String),
    on_update: Option(String),
  )
}

Constructors

Reference(
  table: Table,
  column: String,
  on_delete: Option(String),
  on_update: Option(String),
)

Table

</>

pub type Table {
  Table(name: String, columns: List(Column))
}

Constructors

Table(name: String, columns: List(Column))

Functions

dbtype_to_string

</>

pub fn dbtype_to_string(dbtype: ColumnType) -> String

default

</>

pub fn default(col: Column, value: a) -> Column

define_table

</>

pub fn define_table(name: String, columns: List(Column)) -> Table

foreign_key

</>

pub fn foreign_key(
  col: Column,
  references_table: Table,
  references_column: String,
) -> Column

format_column_sql

</>

pub fn format_column_sql(column: Column) -> String

int

</>

pub fn int(name: String) -> Column

nullable

</>

pub fn nullable(col: Column) -> Column

primary

</>

pub fn primary(col: Column) -> Column

serial

</>

pub fn serial(name: String) -> Column

text

</>

pub fn text(name: String) -> Column

unique

</>

pub fn unique(col: Column) -> Column