sqlite library
Classes
- FtsInside
- FtsNear
- FtsOutside
- FtsPhrase
- FtsQuery
- FtsSide
- FullId
- IndexColumn
- KeyId
- PagedResult
- PagedResultIterator
- PartialIndex
- Query
- RowId
- Scheme
- SchemeElement
- SchemeMigrationPlan
- SearchColumn
- SearchIndex
- SearchIndexUpdater
- SqlCase
- SqlExpression
- SqlFunction
- SqlId
- SqlIdentifier
- SQLite
- SQLiteQuery
- SqlJsonExtract
- SqlJsonJson
- SqlJsonQuote
- SqlLiteral
- SqlParameter
- SqlSearch
- SqlTable
- SqlValues
- Transaction
- VirtualColumn
Constants
- columnKeyId → const String
- columnKind → const String
- columnRank → const String
- columnRowId → const String
- columnValue → const String
- extraTokenChars → const String
- ftsTermJoiner → const String
- keyDefinition → const String
- queryDefaultLimit → const int
- schemeInitialRevision → const int
- tableMapping → const String
- tableScheme → const String
Properties
- reFtsSpaces → RegExp
-
final
- reFtsTermToken → RegExp
-
final
- reFtsTextToken → RegExp
-
final
Functions
-
escapeSingleQuotes(
String string) → String -
ftsString(
String string) → String -
ftsTerm(
String string) → String -
ftsText(
String string) → String -
ftsWords(
String string) → Iterable< String> -
queryOrdering(
SqlX expression, QuerySorting sorting) → QueryOrdering -
queryRow(
FullId id, QueryRowOrdered ordered, QueryRowColumns columns) → QueryRow -
queryRowGetPosition(
QueryRow row) → QueryRowPosition -
quoteWithDoubleQuotes(
String string) → String -
quoteWithSingleQuotes(
String string) → String -
searchRowToParameters(
SearchRow row) → Map< String, Object> -
sqlIdentifier(
String name) → String -
sqlLiteral(
Object? value) → String -
unquoteDoubleQuotes(
String string) → String
Typedefs
- DatabaseUpgrader = void Function(int storedRevision, int actualRevision, SQLite sqlite)
- FtsI = FtsInside
- FtsN = FtsNear
- FtsO = FtsOutside
- FtsP = FtsPhrase
- FtsQ = FtsQuery
-
FullIdIterable
= Iterable<
FullId> - FullIdWithValue = ({FullId id, Object value})
-
IndexColumns
= List<
IndexColumn> - Kind = Object
-
KindList
= List<
Kind> -
PartialIndexes
= List<
PartialIndex> - QueryId = int
- QueryOrdering = ({SqlX expression, QuerySorting sorting})
-
QueryParameters
= Map<
String, Object> - QueryRow = ({QueryRowColumns columns, FullId id, QueryRowOrdered ordered})
-
QueryRowColumns
= List<
Object?> -
QueryRowOrdered
= List<
Object> - QueryRowPosition = ({FullId id, QueryRowOrdered ordered})
-
QueryRows
= List<
QueryRow> -
SearchColumns
= List<
SearchColumn> -
SearchIndexes
= List<
SearchIndex> -
SearchRow
= Map<
String, Object> - SearchRowGetter = SearchRow Function(Object)
-
SearchRowGetters
= Map<
Kind, SearchRowGetter> -
SearchRowsUpdaters
= IList<
({SearchIndexUpdater indexUpdater, SearchRowGetter rowGetter})> - SqlC = SqlCase
- SqlF = SqlFunction
- SqlI = SqlIdentifier
-
SqlIdList
= List<
SqlId> - SqlJQ = SqlJsonQuote
- SqlJT = SqlJsonJson
- SqlJX = SqlJsonExtract
- SqlL = SqlLiteral
- SqlP = SqlParameter
- SqlS = SqlSearch
- SqlT = SqlTable
- SqlV = SqlValues
- SqlX = SqlExpression
-
VirtualColumns
= List<
VirtualColumn>