Query

public class Query

A database query. A Query instance can be constructed by calling one of the select class methods.

  • A Parameters object used for setting values to the query parameters defined in the query. All parameters defined in the query must be given values before running the query, or the query will fail.

    Declaration

    Swift

    public var parameters: Parameters

  • Create a SELECT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement. @param results The array of the SelectResult object for specifying the returned values. @return A Select object.

    Declaration

    Swift

    public static func select(_ results: SelectResult...) -> Select

  • Create a SELECT DISTINCT statement instance that you can use further (e.g. calling the from() function) to construct the complete query statement. @param results The array of the SelectResult object for specifying the returned values. @return A Select distinct object.

    Declaration

    Swift

    public static func selectDistinct(_ results: SelectResult...) -> Select

  • Runs the query. The returning an enumerator that returns result rows one at a time. You can run the query any number of times, and you can even have multiple enumerators active at once. The results come from a snapshot of the database taken at the moment -run: is called, so they will not reflect any changes made to the database afterwards. @return A QueryIterator object.

    Declaration

    Swift

    public func run() throws -> QueryIterator

  • Returns a string describing the implementation of the compiled query. This is intended to be read by a developer for purposes of optimizing the query, especially to add database indexes. It’s not machine-readable and its format may change.

    As currently implemented, the result is two or more lines separated by newline characters:
* The first line is the SQLite SELECT statement.
* The subsequent lines are the output of SQLite's "EXPLAIN QUERY PLAN" command applied to that
  statement; for help interpreting this, see https://www.sqlite.org/eqp.html . The most
  important thing to know is that if you see "SCAN TABLE", it means that SQLite is doing a
  slow linear scan of the documents instead of using an index.
@param outError If an error occurs, it will be stored here if this parameter is non-NULL.
@return a string describing the implementation of the compiled query.

    Declaration

    Swift

    public func explain() throws -> String

  • Returns a live query based on the current query. @return a live query object.

    Declaration

    Swift

    public func toLive() -> LiveQuery