Logo ProcessCore

ProcessCore.SQL Namespace

Type/Module Description

Data

CRUD façade for the data table.

DataAdditionalProperty

CRUD façade for the data_additional_property association table. Primary key: (data_id, position).

DataAdditionalPropertyRow

Row of the data_additional_property association table — attaches an ordered PropertyValueRow to a DataRow.

DataRow

Row of the data table — a digital data item identified by a path and optional selector, participating as input or output of a LabProcessRow.

Dataset

CRUD façade for the dataset table.

DatasetAdditionalProperty

CRUD façade for the dataset_additional_property association table. Primary key: (dataset_id, position).

DatasetAdditionalPropertyRow

Row of the dataset_additional_property association table — attaches an ordered PropertyValueRow to a dataset.

DatasetHasPart

CRUD façade for the dataset_has_part association table. Primary key: (dataset_id, position).

DatasetHasPartRow

Row of the dataset_has_part association table — links a parent dataset to one of its parts, which is either a child dataset or a data item, at a given ordered position.

DatasetProcess

CRUD façade for the dataset_process association table. Primary key: (dataset_id, position).

DatasetProcessRow

Row of the dataset_process association table — links a dataset to one of its LabProcessRow entries at a given ordered position.

DatasetRow

Row of the dataset table — a top-level container that aggregates parts (other datasets or data items), processes and additional properties.

DefinedTerm

CRUD façade for the defined_term table.

DefinedTermRow

Row of the defined_term table — a controlled-vocabulary term used as a typed identifier throughout the data model (e.g. as ontology references for materials, units and parameter names).

FormalParameter

CRUD façade for the formal_parameter table.

FormalParameterRow

Row of the formal_parameter table — the schema-side declaration of a parameter that a LabProtocolRow can take, optionally pinned to a default PropertyValueRow.

ISqliteDriver

Minimal driver contract implemented by runtime-specific SQLite adapters (ProcessCore.SQL.DotNet, ProcessCore.SQL.JavaScript, ProcessCore.SQL.Python).

LabProcess

CRUD façade for the lab_process table.

LabProcessRow

Row of the lab_process table — a single execution of a LabProtocolRow, connected to its inputs and outputs through ProcessIoRow and to its parameter values through ProcessParameterValueRow.

LabProtocol

CRUD façade for the lab_protocol table.

LabProtocolRow

Row of the lab_protocol table — a reusable protocol definition that can be executed by one or more LabProcessRow instances and parameterised through ProtocolParameterRow entries.

Material

CRUD façade for the material table.

MaterialAdditionalProperty

CRUD façade for the material_additional_property association table. Primary key: (material_id, position).

MaterialAdditionalPropertyRow

Row of the material_additional_property association table — attaches an ordered PropertyValueRow to a MaterialRow.

MaterialRow

Row of the material table — a tangible substance or sample that can act as input or output of a LabProcessRow.

ProcessEdgeRow

Row of the process_edges view — a denormalised pairing of one input and one output of the same lab process, used to traverse the data-flow graph without joining the I/O table to itself.

ProcessEdges

Read-only façade for the process_edges view, which exposes one row per (input, output) pair sharing a lab process. Useful for graph traversal of the data flow.

ProcessIo

CRUD façade for the process_io association table. Primary key: (process_id, direction, position).

ProcessIoDirection

Direction tag for a row in the process_io table.

ProcessIoRow

Row of the process_io association table — attaches a MaterialRow or DataRow to a LabProcessRow on either the input or output side at an ordered position.

ProcessParameterValue

CRUD façade for the process_parameter_value association table. Primary key: (process_id, position).

ProcessParameterValueRow

Row of the process_parameter_value association table — attaches an ordered PropertyValueRow to a LabProcessRow as a parameter value.

PropertyValue

CRUD façade for the property_value table.

PropertyValueOrphanRow

Row of the property_value_orphans view — the id of a PropertyValueRow that is not referenced by any owning entity. Useful for housekeeping and integrity checks.

PropertyValueOrphans

Read-only façade for the property_value_orphans view, which lists ids of PropertyValueRow entries no entity references. Useful for housekeeping.

PropertyValueRow

Row of the property_value table — a typed name/value pair, optionally with a unit and ontology references. Used as parameter value, additional property and default-value carrier.

ProtocolAdditionalProperty

CRUD façade for the protocol_additional_property association table. Primary key: (protocol_id, position).

ProtocolAdditionalPropertyRow

Row of the protocol_additional_property association table — attaches an ordered PropertyValueRow to a LabProtocolRow.

ProtocolParameter

CRUD façade for the protocol_parameter association table. Primary key: (protocol_id, position).

ProtocolParameterRow

Row of the protocol_parameter association table — attaches an ordered FormalParameterRow to a LabProtocolRow.

Repository

Static catalogue of Table{TRow} descriptors, one per persisted table in the data model.

RowCodecExtensions

Bidirectional codecs between row records and the on-the-wire SqlRow / SqlParameters representations consumed by ISqliteDriver.

SqlParameter

A single named parameter bound to an SqlValue, used to compose SqlParameters.

SqlParameters

An ordered collection of SqlParameter values bound to a single SQL command.

SqlRow (Module)

Helpers for extracting strongly-typed values from a SqlRow. All helpers raise with a fully qualified table.column reference when the lookup fails or the storage class is wrong.

SqlRow (Type)

A single result-set row, keyed by column name. Driver implementations populate this map from the underlying engine's row representation (ADO.NET reader, better-sqlite3 object, Python tuple, …).

SqlValue (Module)

Helpers for constructing SqlValue instances from primitive values and for extracting strongly-typed values back out, with descriptive errors when the underlying case does not match the expected SQLite storage class.

SqlValue (Type)

SQLite values supported by the shared, Fable-compatible API surface.

Table<'row>

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.

Type something to start searching.