mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
79 lines
3.0 KiB
Swift
79 lines
3.0 KiB
Swift
// MARK: - SQLOrderingTerm
|
|
|
|
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
|
|
///
|
|
/// The protocol for all types that can be used as an SQL ordering term, as
|
|
/// described at https://www.sqlite.org/syntax/ordering-term.html
|
|
///
|
|
/// :nodoc:
|
|
public protocol SQLOrderingTerm {
|
|
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
|
|
///
|
|
/// The ordering term, reversed
|
|
var reversed: SQLOrderingTerm { get }
|
|
|
|
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
|
|
///
|
|
/// Returns an SQL string that represents the ordering term.
|
|
func orderingTermSQL(_ context: inout SQLGenerationContext) -> String
|
|
|
|
/// [**Experimental**](http://github.com/groue/GRDB.swift#what-are-experimental-features)
|
|
func qualifiedOrdering(with alias: TableAlias) -> SQLOrderingTerm
|
|
}
|
|
|
|
// MARK: - SQLOrdering
|
|
|
|
enum SQLOrdering: SQLOrderingTerm {
|
|
case asc(SQLExpression)
|
|
case desc(SQLExpression)
|
|
#if GRDBCUSTOMSQLITE
|
|
case ascNullsLast(SQLExpression)
|
|
case descNullsFirst(SQLExpression)
|
|
#endif
|
|
|
|
var reversed: SQLOrderingTerm {
|
|
switch self {
|
|
case .asc(let expression):
|
|
return SQLOrdering.desc(expression)
|
|
case .desc(let expression):
|
|
return SQLOrdering.asc(expression)
|
|
#if GRDBCUSTOMSQLITE
|
|
case .ascNullsLast(let expression):
|
|
return SQLOrdering.descNullsFirst(expression)
|
|
case .descNullsFirst(let expression):
|
|
return SQLOrdering.ascNullsLast(expression)
|
|
#endif
|
|
}
|
|
}
|
|
|
|
func orderingTermSQL(_ context: inout SQLGenerationContext) -> String {
|
|
switch self {
|
|
case .asc(let expression):
|
|
return expression.expressionSQL(&context, wrappedInParenthesis: false) + " ASC"
|
|
case .desc(let expression):
|
|
return expression.expressionSQL(&context, wrappedInParenthesis: false) + " DESC"
|
|
#if GRDBCUSTOMSQLITE
|
|
case .ascNullsLast(let expression):
|
|
return expression.expressionSQL(&context, wrappedInParenthesis: false) + " ASC NULLS LAST"
|
|
case .descNullsFirst(let expression):
|
|
return expression.expressionSQL(&context, wrappedInParenthesis: false) + " DESC NULLS FIRST"
|
|
#endif
|
|
}
|
|
}
|
|
|
|
func qualifiedOrdering(with alias: TableAlias) -> SQLOrderingTerm {
|
|
switch self {
|
|
case .asc(let expression):
|
|
return SQLOrdering.asc(expression.qualifiedExpression(with: alias))
|
|
case .desc(let expression):
|
|
return SQLOrdering.desc(expression.qualifiedExpression(with: alias))
|
|
#if GRDBCUSTOMSQLITE
|
|
case .ascNullsLast(let expression):
|
|
return SQLOrdering.ascNullsLast(expression.qualifiedExpression(with: alias))
|
|
case .descNullsFirst(let expression):
|
|
return SQLOrdering.descNullsFirst(expression.qualifiedExpression(with: alias))
|
|
#endif
|
|
}
|
|
}
|
|
}
|