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>

Remarks

A column name SQLite would not read bare - a keyword such as From, or a name that is not one word, such as created-at - is written between double quotes. A plain name, and a name the caller already quoted, is written as given.

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>

Remarks

Column names are quoted as the three-argument overload describes.