Files
GRDB.swift/GRDB/QueryInterface/SQL/SQLOrdering.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
}
}
}