Method BuildStateSql

Namespace

Qavren.Edge.Ingestion

Assembly

Qavren.Edge.Ingestion.dll

BuildStateSql(string)

The three state tables and their indexes, as a statement list — the same shape EdgeVectorSchema.BuildCreateSql() returns.

All three are WITHOUT ROWID, including the two whose key is a single column (plan adjustment 19): the row lives in the key's b-tree rather than a rowid table plus a separate unique index, which is the right shape for tables read by primary key, never scanned by rowid, and holding twenty rows and two rows. The consequence is that every row must supply its primary key and there is no AUTOINCREMENT — both already true.

public static IReadOnlyList<string> BuildStateSql(string tablePrefix)

Parameters

tablePrefix string

IngestionOptions.StateTablePrefix. Quoted into an identifier position, so AddIngestion validates it against ^[A-Za-z_][A-Za-z0-9_]*$ first.

Returns

IReadOnlyList<string>

The statements, in apply order.