Protocol
SQLQueryFetcher
Common definitions for
SQLQueryBuilders which support retrieving result rows.protocol SQLQueryFetcher : SQLQueryBuilder
Mentioned in
Topics
Getting Rows
run(_:)Run the query specified by the builder, calling the provided handler closure with each output row, if any, as it is received.run(decoding:_:)Using a default-configuredSQLRowDecoder, call the provided handler closure with the result of decoding each output row, if any, as a given type.run(decoding:prefix:keyDecodingStrategy:userInfo:_:)Configure a newSQLRowDecoderas specified, use it to to decode each output row, if any, as a given type, and call the provided handler closure with each decoding result.run(decoding:with:_:)Using the givenSQLRowDecoder, call the provided handler closure with the result of decoding each output row, if any, as a given type.
Getting All Rows
all(decoding:with:)Using the givenSQLRowDecoder, returns the output rows, if any, decoded as a given type.all(decoding:)Using a default-configuredSQLRowDecoder, returns all output rows, if any, decoded as a given type.all(decoding:prefix:keyDecodingStrategy:userInfo:)Configure a newSQLRowDecoderas specified and use it to decode and return the output rows, if any, as a given type.all(decoding:with:)Using the givenSQLRowDecoder, returns the output rows, if any, decoded as a given type.all(decodingColumn:as:)Returns the named column from each output row, if any, decoded as a given type.
Getting One Row
first()Returns the first output row, if any.first(decoding:)Using a default-configuredSQLRowDecoder, returns the first output row, if any, decoded as a given type.first(decoding:prefix:keyDecodingStrategy:userInfo:)Configure a newSQLRowDecoderas specified and use it to decode and return the first output row, if any, as a given type.first(decoding:with:)Using the givenSQLRowDecoder, returns the first output row, if any, decoded as a given type.first(decodingColumn:as:)Returns the named column from the first output row, if any, decoded as a given type.
Legacy `EventLoopFuture` Interfaces
run(_:)Run the query specified by the builder, calling the provided handler closure with each output row, if any, as it is received.run(decoding:_:)Using a default-configuredSQLRowDecoder, call the provided handler closure with the result of decoding each output row, if any, as a given type.run(decoding:prefix:keyDecodingStrategy:userInfo:_:)Configure a newSQLRowDecoderas specified, use it to to decode each output row, if any, as a given type, and call the provided handler closure with each decoding result.run(decoding:with:_:)Using the givenSQLRowDecoder, call the provided handler closure with the result of decoding each output row, if any, as a given type.all()Returns all output rows, if any.all(decoding:)Using a default-configuredSQLRowDecoder, returns all output rows, if any, decoded as a given type.all(decoding:prefix:keyDecodingStrategy:userInfo:)Configure a newSQLRowDecoderas specified and use it to decode and return the output rows, if any, as a given type.all(decoding:with:)Using the givenSQLRowDecoder, returns the output rows, if any, decoded as a given type.all(decodingColumn:as:)Returns the named column from each output row, if any, decoded as a given type.first()Returns the first output row, if any.first(decoding:)Using a default-configuredSQLRowDecoder, returns the first output row, if any, decoded as a given type.first(decoding:prefix:keyDecodingStrategy:userInfo:)Configure a newSQLRowDecoderas specified and use it to decode and return the first output row, if any, as a given type.first(decoding:with:)Using the givenSQLRowDecoder, returns the first output row, if any, decoded as a given type.first(decodingColumn:as:)Returns the named column from the first output row, if any, decoded as a given type.
Instance Methods
all()Returns all output rows, if any.all(decoding:)Using a default-configuredSQLRowDecoder, returns all output rows, if any, decoded as a given type.all(decoding:prefix:keyDecodingStrategy:userInfo:)Configure a newSQLRowDecoderas specified and use it to decode and return the output rows, if any, as a given type.all(decoding:with:)Using the givenSQLRowDecoder, returns the output rows, if any, decoded as a given type.all(decodingColumn:as:)Returns the named column from each output row, if any, decoded as a given type.first()Returns the first output row, if any.first(decoding:)Using a default-configuredSQLRowDecoder, returns the first output row, if any, decoded as a given type.first(decoding:prefix:keyDecodingStrategy:userInfo:)Configure a newSQLRowDecoderas specified and use it to decode and return the first output row, if any, as a given type.first(decoding:with:)Using the givenSQLRowDecoder, returns the first output row, if any, decoded as a given type.first(decodingColumn:as:)Returns the named column from the first output row, if any, decoded as a given type.run(_:)Run the query specified by the builder, calling the provided handler closure with each output row, if any, as it is received.run(decoding:_:)Using a default-configuredSQLRowDecoder, call the provided handler closure with the result of decoding each output row, if any, as a given type.run(decoding:prefix:keyDecodingStrategy:userInfo:_:)Configure a newSQLRowDecoderas specified, use it to to decode each output row, if any, as a given type, and call the provided handler closure with each decoding result.run(decoding:with:_:)Using the givenSQLRowDecoder, call the provided handler closure with the result of decoding each output row, if any, as a given type.
Relationships
Inherits From
Conforming Types
See Also
Builder Protocols
SQLAliasedColumnListBuilderCommon definitions for query builders which permit specifying aliased column names.SQLColumnUpdateBuilderCommon definitions for query builders which support assigning values to columns.SQLJoinBuilderCommon definitions for any query builder which permits specifying joins.SQLPartialResultBuilderCommon definitions for any query builder which permits specifying range and ordering behaviors.SQLPredicateBuilderCommon definitions for any query builder which permits specifying a primary predicate.SQLQueryBuilderBase definitions for builders which set up queries and execute them against a given database.SQLReturningBuilderCommon definitions for any query builder which can return values from data-mutating queries.SQLSecondaryPredicateBuilderCommon definitions for any query builder which permits specifying a secondary predicate.SQLSubqueryClauseBuilderA builder which can construct - but not execute - a completeSELECTquery. Useful for building CTEs,CREATE TABLE ... SELECTclauses, etc., not to mention actualSELECTqueries.SQLUnqualifiedColumnListBuilderCommon definitions for query builders which permit or require specifying a list of unqualified column names.