Logo ProcessCore

ProcessCore.SQL Namespace

Type/Module Description

Annotation

CRUD façade for the annotation table.

AnnotationOrphanRow

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

AnnotationOrphans

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

AnnotationRow

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

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 AnnotationRow 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 ProcessRow.

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 AnnotationRow 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 ProcessRow 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 samples, 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 RecipeRow can take, optionally pinned to a default AnnotationRow.

ISqliteDriver

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

Process

CRUD façade for the process table.

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 SampleRow or DataRow to a ProcessRow 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 AnnotationRow to a ProcessRow as a parameter value.

ProcessRow

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

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 AnnotationRow to a RecipeRow.

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 RecipeRow.

Recipe

CRUD façade for the recipe table.

RecipeRow

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

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.

Sample

CRUD façade for the sample table.

SampleAdditionalProperty

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

SampleAdditionalPropertyRow

Row of the sample_additional_property association table — attaches an ordered AnnotationRow to a SampleRow.

SampleRow

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

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.