gloo/sqlite

SQLite column types for use with gloo/migration.

Build columns with sqlite.column(name, type) then pass them to the migration DSL. Autoincrement is achieved by applying primary_key to an Integer column — SQLite’s rowid mechanism handles the rest.

Passing a SqColumnType to gloo/pg.column (or vice versa) is a compile error because the types are distinct.

Types

SqColumnType

</>

pub type SqColumnType {
  Integer
  Text
  Real
  Blob
}

Constructors

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

Values

column

</>

pub fn column(name: String, t: SqColumnType) -> migration.Column

Create a SQLite-typed column. Compile error if you pass a gloo/pg.PgColumnType — they are different types.

default

</>

pub fn default(
  col: migration.Column,
  expr: String,
) -> migration.Column

not_null

</>

pub fn not_null(col: migration.Column) -> migration.Column

primary_key

</>

pub fn primary_key(col: migration.Column) -> migration.Column

type_sql

</>

pub fn type_sql(t: SqColumnType) -> String

Render a SQLite column type to its DDL SQL string.

unique

</>

pub fn unique(col: migration.Column) -> migration.Column