SQLCollatedExpression

public struct SQLCollatedExpression

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")

Show on GitHub

expression
The tainted expression
Declaration
Swift

public let expression: SQLExpression
Show on GitHub
collationName
The name of the collation
Declaration
Swift

public let collationName: Database.CollationName
Show on GitHub

asc

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

Declaration

Swift

public var asc: SQLOrderingTerm { get }

Show on GitHub


                    
                    
                    desc

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

Declaration

Swift

public var desc: SQLOrderingTerm { get }

Show on GitHub


                    
                    
                    ascNullsLast

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


                    
                    
                    descNullsFirst

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


                    
                    
                    ascNullsLast

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

Declaration

Swift

@available(macOS 11.0, iOS 14, tvOS 14, watchOS 7, *)
public var ascNullsLast: SQLOrderingTerm { get }

Show on GitHub


                    
                    
                    descNullsFirst

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

Declaration

Swift

@available(macOS 11.0, iOS 14, tvOS 14, watchOS 7, *)
public var descNullsFirst: SQLOrderingTerm { get }

Show on GitHub