mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
117 lines
4.3 KiB
Swift
117 lines
4.3 KiB
Swift
/// SQLCollatedExpression taints an expression so that every derived expression
|
|
/// is eventually evaluated using an SQLite collation.
|
|
///
|
|
/// You create one by calling the `collating()` method:
|
|
///
|
|
/// let email = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player WHERE email = 'arthur@example.com' COLLATE NOCASE
|
|
/// Player.filter(email == "arthur@example.com")
|
|
public struct SQLCollatedExpression: SQLOrderingTerm {
|
|
/// The tainted expression
|
|
public let expression: SQLExpression
|
|
|
|
/// The name of the collation
|
|
public let collationName: Database.CollationName
|
|
|
|
/// Returns an ordering suitable for QueryInterfaceRequest.order()
|
|
///
|
|
/// let email: SQLCollatedExpression = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player ORDER BY email COLLATE NOCASE ASC
|
|
/// Player.order(email.asc)
|
|
///
|
|
/// See https://github.com/groue/GRDB.swift/#the-query-interface
|
|
public var asc: SQLOrderingTerm {
|
|
SQLOrdering.asc(sqlExpression)
|
|
}
|
|
|
|
/// Returns an ordering suitable for QueryInterfaceRequest.order()
|
|
///
|
|
/// let email: SQLCollatedExpression = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player ORDER BY email COLLATE NOCASE DESC
|
|
/// Player.order(email.desc)
|
|
///
|
|
/// See https://github.com/groue/GRDB.swift/#the-query-interface
|
|
public var desc: SQLOrderingTerm {
|
|
SQLOrdering.desc(sqlExpression)
|
|
}
|
|
|
|
#if GRDBCUSTOMSQLITE
|
|
/// Returns an ordering suitable for QueryInterfaceRequest.order()
|
|
///
|
|
/// let email: SQLCollatedExpression = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player ORDER BY email COLLATE NOCASE ASC NULLS LAST
|
|
/// Player.order(email.ascNullsLast)
|
|
///
|
|
/// See https://github.com/groue/GRDB.swift/#the-query-interface
|
|
public var ascNullsLast: SQLOrderingTerm {
|
|
SQLOrdering.ascNullsLast(sqlExpression)
|
|
}
|
|
|
|
/// Returns an ordering suitable for QueryInterfaceRequest.order()
|
|
///
|
|
/// let email: SQLCollatedExpression = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player ORDER BY email COLLATE NOCASE DESC NULLS FIRST
|
|
/// Player.order(email.descNullsFirst)
|
|
///
|
|
/// See https://github.com/groue/GRDB.swift/#the-query-interface
|
|
public var descNullsFirst: SQLOrderingTerm {
|
|
SQLOrdering.descNullsFirst(sqlExpression)
|
|
}
|
|
#elseif !GRDBCIPHER
|
|
/// Returns an ordering suitable for QueryInterfaceRequest.order()
|
|
///
|
|
/// let email: SQLCollatedExpression = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player ORDER BY email COLLATE NOCASE ASC NULLS LAST
|
|
/// Player.order(email.ascNullsLast)
|
|
///
|
|
/// See https://github.com/groue/GRDB.swift/#the-query-interface
|
|
@available(OSX 10.16, iOS 14, tvOS 14, watchOS 7, *)
|
|
public var ascNullsLast: SQLOrderingTerm {
|
|
SQLOrdering.ascNullsLast(sqlExpression)
|
|
}
|
|
|
|
/// Returns an ordering suitable for QueryInterfaceRequest.order()
|
|
///
|
|
/// let email: SQLCollatedExpression = Column("email").collating(.nocase)
|
|
///
|
|
/// // SELECT * FROM player ORDER BY email COLLATE NOCASE DESC NULLS FIRST
|
|
/// Player.order(email.descNullsFirst)
|
|
///
|
|
/// See https://github.com/groue/GRDB.swift/#the-query-interface
|
|
@available(OSX 10.16, iOS 14, tvOS 14, watchOS 7, *)
|
|
public var descNullsFirst: SQLOrderingTerm {
|
|
SQLOrdering.descNullsFirst(sqlExpression)
|
|
}
|
|
#endif
|
|
|
|
init(_ expression: SQLExpression, collationName: Database.CollationName) {
|
|
self.expression = expression
|
|
self.collationName = collationName
|
|
}
|
|
|
|
var sqlExpression: SQLExpression {
|
|
SQLExpressionCollate(expression, collationName: collationName)
|
|
}
|
|
|
|
// MARK: SQLOrderingTerm
|
|
|
|
/// :nodoc:
|
|
public func _orderingTermSQL(_ context: SQLGenerationContext) throws -> String {
|
|
try sqlExpression._orderingTermSQL(context)
|
|
}
|
|
|
|
/// :nodoc:
|
|
public func _qualifiedOrdering(with alias: TableAlias) -> SQLOrderingTerm {
|
|
SQLCollatedExpression(expression._qualifiedExpression(with: alias), collationName: collationName)
|
|
}
|
|
|
|
/// :nodoc:
|
|
public var _reversed: SQLOrderingTerm { desc }
|
|
}
|