Files
GRDB.swift/GRDB/QueryInterface/SQL/SQLCollection.swift

66 lines
2.2 KiB
Swift

// MARK: - SQLCollection
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
///
/// SQLCollection is the protocol for types that can be checked for inclusion.
///
/// :nodoc:
public protocol SQLCollection {
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
///
/// Returns an SQL string that represents the collection.
func collectionSQL(_ context: inout SQLGenerationContext) -> String
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
///
/// Returns an expression that check whether the collection contains
/// the expression.
func contains(_ value: SQLExpressible) -> SQLExpression
}
// MARK: Default Implementations
/// :nodoc:
extension SQLCollection {
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
///
/// Returns a SQLExpressionContains which applies the `IN` SQL operator.
public func contains(_ value: SQLExpressible) -> SQLExpression {
SQLExpressionContains(value, self)
}
}
// MARK: - SQLExpressionsArray
/// SQLExpressionsArray wraps an array of expressions
///
/// SQLExpressionsArray([1, 2, 3])
struct SQLExpressionsArray: SQLCollection {
let expressions: [SQLExpression]
init<S: Sequence>(_ expressions: S) where S.Iterator.Element: SQLExpressible {
self.expressions = expressions.map(\.sqlExpression)
}
func collectionSQL(_ context: inout SQLGenerationContext) -> String {
expressions
.map { $0.expressionSQL(&context, wrappedInParenthesis: false) }
.joined(separator: ", ")
}
func contains(_ value: SQLExpressible) -> SQLExpression {
guard let expression = expressions.first else {
// [].contains(Column("name")) => 0
return false.databaseValue
}
if expressions.count == 1 {
// ["foo"].contains(Column("name")) => name = 'foo'
return value == expression
}
// ["foo", "bar"].contains(Column("name")) => name IN ('foo', 'bar')
return SQLExpressionContains(value, self)
}
}