Logo ProcessCore

Table<'row> Type

Schema metadata for a single SQLite table or view, paired with the codec functions that translate between rows of type and the on-the-wire SqlRow / SqlParameters representations.

Instances are typically obtained from the Repository module rather than constructed directly. The repository's CRUD façades use Name, Columns and PrimaryKey to synthesise SQL, and use OfRow / ToParameters to marshal values across the ISqliteDriver boundary.

Constructors

Constructor Description

Table(Name, Columns, PrimaryKey, OfRow, ToParameters)

Full Usage: Table(Name, Columns, PrimaryKey, OfRow, ToParameters)

Parameters:
    Name : string
    Columns : string[]
    PrimaryKey : string[]
    OfRow : SqlRow -> 'row
    ToParameters : 'row -> SqlParameters

Returns: Table<'row>
Name : string
Columns : string[]
PrimaryKey : string[]
OfRow : SqlRow -> 'row
ToParameters : 'row -> SqlParameters
Returns: Table<'row>

Instance members

Instance member Description

this.Columns

Full Usage: this.Columns

Returns: string[]

Ordered column names.

Returns: string[]

this.Name

Full Usage: this.Name

Returns: string

SQL table or view name.

Returns: string

this.OfRow

Full Usage: this.OfRow

Returns: SqlRow -> 'row

Row decoder.

Returns: SqlRow -> 'row

this.PrimaryKey

Full Usage: this.PrimaryKey

Returns: string[]

Ordered primary-key column names.

Returns: string[]

this.ToParameters

Full Usage: this.ToParameters

Returns: 'row -> SqlParameters

Row encoder.

Returns: 'row -> SqlParameters

Static members

Static member Description

Table.create (Name, Columns, PrimaryKey, OfRow, ToParameters)

Full Usage: Table.create (Name, Columns, PrimaryKey, OfRow, ToParameters)

Parameters:
    Name : string
    Columns : string[]
    PrimaryKey : string[]
    OfRow : SqlRow -> 'row
    ToParameters : 'row -> SqlParameters

Returns: Table<'row>

Named-argument constructor exposed to JavaScript and Python callers.

Name : string
Columns : string[]
PrimaryKey : string[]
OfRow : SqlRow -> 'row
ToParameters : 'row -> SqlParameters
Returns: Table<'row>

Type something to start searching.