Class FtsTable

Namespace: Qavren.Edge.Sqlite.Fts

Assembly: Qavren.Edge.Sqlite.dll

Emits FTS5 DDL and sync-trigger SQL a consumer could have written by hand.

public static class FtsTable

Inheritance: object

FtsTable

Inherited Members: object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

BuildCreateSql(string, IReadOnlyList<string>, FtsTokenizer, FtsTableOptions): Options-taking overload. options is required and non-nullable so this never becomes ambiguous with the string? contentTable overload above.

BuildCreateSql(string, IReadOnlyList<string>, FtsTokenizer, string?): Builds the CREATE VIRTUAL TABLE ... USING fts5(...) statement for the given columns.

BuildSyncTriggerSql(string, string, IReadOnlyList<string>): External-content tables need triggers; FTS5 does not observe the content table itself.

BuildSyncTriggerSql(string, string, IReadOnlyList<string>, string): Sync triggers for an external-content table whose rowid alias is named contentRowId rather than rowid.

CreateAsync(SqliteConnection, string, IReadOnlyList<string>, FtsTokenizer, FtsTableOptions, CancellationToken): Options-taking overload; see BuildCreateSql(string, IReadOnlyList<string>, FtsTokenizer, FtsTableOptions).

CreateAsync(SqliteConnection, string, IReadOnlyList<string>, FtsTokenizer, string?, CancellationToken): Builds the table's DDL with BuildCreateSql(string, IReadOnlyList<string>, FtsTokenizer, string?) and executes it on connection.

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

Edit this page