Method CreateSyncTriggersAsync

Namespace

Qavren.Edge.Sqlite.Fts

Assembly

Qavren.Edge.Sqlite.dll

CreateSyncTriggersAsync(SqliteConnection, string, string, IReadOnlyList<string>, CancellationToken)

Builds the sync triggers with BuildSyncTriggerSql(string, string, IReadOnlyList<string>) and executes them on connection.

public static Task CreateSyncTriggersAsync(SqliteConnection connection, string ftsTable, string contentTable, IReadOnlyList<string> columns, CancellationToken cancellationToken = default)

Parameters

connection SqliteConnection

The open connection to create the triggers on.

ftsTable string

The FTS5 table to keep in sync.

contentTable string

The external-content table the triggers observe.

columns IReadOnlyList<string>

The columns mirrored from contentTable into ftsTable.

cancellationToken CancellationToken

Cancels each command.

Returns

Task