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 SQLSpecificExpressible.collating() method.

let email: SQLCollatedExpression = Column("email").collating(.nocase)

// SELECT * FROM player WHERE email = 'arthur@example.com' COLLATE NOCASE
Player.filter(email == "arthur@example.com")

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

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

Show on GitHub