Method BuildSyncTriggerSql

Namespace

Qavren.Edge.Sqlite.Fts

Assembly

Qavren.Edge.Sqlite.dll

BuildSyncTriggerSql(string, string, IReadOnlyList<string>)

External-content tables need triggers; FTS5 does not observe the content table itself.

public static IReadOnlyList<string> BuildSyncTriggerSql(string ftsTable, string contentTable, IReadOnlyList<string> columns)

Parameters

ftsTable string

contentTable string

columns IReadOnlyList<string>

Returns

IReadOnlyList<string>

BuildSyncTriggerSql(string, string, IReadOnlyList<string>, string)

Sync triggers for an external-content table whose rowid alias is named contentRowId rather than rowid.

public static IReadOnlyList<string> BuildSyncTriggerSql(string ftsTable, string contentTable, IReadOnlyList<string> columns, string contentRowId)

Parameters

ftsTable string

contentTable string

columns IReadOnlyList<string>

contentRowId string

Returns

IReadOnlyList<string>