SQLCollection
public protocol SQLCollection
SQLCollection is the protocol for types that can be checked for inclusion.
-
Returns an SQL string that represents the collection.
When the arguments parameter is nil, any value must be written down as a literal in the returned SQL:
var arguments: StatementArguments? = nil let collection = SQLExpressionsArray([1,2,3]) collection.collectionSQL(&arguments) // "1,2,3"
When the arguments parameter is not nil, then values may be replaced by
?
or colon-prefixed tokens, and fed into arguments.var arguments = StatementArguments() let collection = SQLExpressionsArray([1,2,3]) collection.collectionSQL(&arguments) // "?,?,?" arguments // [1,2,3]
Declaration
Swift
func collectionSQL(_ arguments: inout StatementArguments?) -> String
-
contains(_:)
Default implementationReturns an expression that check whether the collection contains the expression.
Default Implementation
Returns a SQLExpressionContains which applies the
IN
SQL operator.Declaration
Swift
func contains(_ value: SQLExpressible) -> SQLExpression