Extensions

The following extensions are available globally.

Array, Sequence, Set extensions

Array
See more
Declaration
Swift

extension Array


                    
                    
                    Sequence

Declaration

Swift

extension Sequence

extension Sequence where Element == SQLLiteral

extension Sequence where Element == SQLExpression

extension Sequence where Self.Iterator.Element: SQLExpressible

extension Sequence where Self.Iterator.Element == SQLExpressible

Set
See more
Declaration
Swift

extension Set
Database

See more


                    
                    
                    Optional

Swift’s Optional comes with built-in methods that allow to fetch cursors and arrays of optional DatabaseValueConvertible:

try Optional<String>.fetchCursor(db, sql: "SELECT name FROM ...", arguments:...) // Cursor of String?
try Optional<String>.fetchAll(db, sql: "SELECT name FROM ...", arguments:...)    // [String?]

let statement = try db.makeSelectStatement(sql: "SELECT name FROM ...")
try Optional<String>.fetchCursor(statement, arguments:...) // Cursor of String?
try Optional<String>.fetchAll(statement, arguments:...)    // [String?]

DatabaseValueConvertible is adopted by Bool, Int, String, etc.

Declaration

Swift

extension Optional where Wrapped: DatabaseValueConvertible

extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible


                    
                    
                    Collection

Declaration

Swift

extension Collection where Element == SQLLiteral

CGFloat
CGFloat adopts DatabaseValueConvertible
See more
Declaration
Swift

extension CGFloat: DatabaseValueConvertible
Data
Data is convertible to and from DatabaseValue.
See more
Declaration
Swift

extension Data: DatabaseValueConvertible, StatementColumnConvertible
NSDate
NSDate is stored in the database using the format “yyyy-MM-dd HH:mm:ss.SSS”, in the UTC time zone.
See more
Declaration
Swift

extension NSDate: DatabaseValueConvertible
Date
Date is stored in the database using the format “yyyy-MM-dd HH:mm:ss.SSS”, in the UTC time zone.
See more
Declaration
Swift

extension Date: DatabaseValueConvertible

extension Date: StatementColumnConvertible
NSData
NSData is convertible to and from DatabaseValue.
See more
Declaration
Swift

extension NSData: DatabaseValueConvertible
NSNull
NSNull adopts DatabaseValueConvertible
See more
Declaration
Swift

extension NSNull: DatabaseValueConvertible
NSNumber
NSNumber adopts DatabaseValueConvertible
See more
Declaration
Swift

extension NSNumber: DatabaseValueConvertible
NSString
NSString adopts DatabaseValueConvertible
See more
Declaration
Swift

extension NSString: DatabaseValueConvertible
NSURL
NSURL stores its absoluteString in the database.
See more
Declaration
Swift

extension NSURL: DatabaseValueConvertible
URL
URL stores its absoluteString in the database.
Declaration
Swift

extension URL: DatabaseValueConvertible
NSUUID
NSUUID adopts DatabaseValueConvertible
See more
Declaration
Swift

extension NSUUID: DatabaseValueConvertible


                    
                    
                    UUID

UUID adopts DatabaseValueConvertible

Declaration

Swift

extension UUID: DatabaseValueConvertible

extension UUID: StatementColumnConvertible

Value Types

Bool
Bool adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Bool: DatabaseValueConvertible, StatementColumnConvertible
Int
Int adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Int: DatabaseValueConvertible, StatementColumnConvertible
Int8
Int8 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Int8: DatabaseValueConvertible, StatementColumnConvertible
Int16
Int16 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Int16: DatabaseValueConvertible, StatementColumnConvertible
Int32
Int32 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Int32: DatabaseValueConvertible, StatementColumnConvertible
Int64
Int64 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Int64: DatabaseValueConvertible, StatementColumnConvertible
UInt
UInt adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension UInt: DatabaseValueConvertible, StatementColumnConvertible
UInt8
UInt8 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension UInt8: DatabaseValueConvertible, StatementColumnConvertible
UInt16
UInt16 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension UInt16: DatabaseValueConvertible, StatementColumnConvertible
UInt32
UInt32 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension UInt32: DatabaseValueConvertible, StatementColumnConvertible
UInt64
UInt64 adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension UInt64: DatabaseValueConvertible, StatementColumnConvertible
Double
Double adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Double: DatabaseValueConvertible, StatementColumnConvertible
Float
Float adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension Float: DatabaseValueConvertible, StatementColumnConvertible
String
String adopts DatabaseValueConvertible and StatementColumnConvertible.
See more
Declaration
Swift

extension String: DatabaseValueConvertible, StatementColumnConvertible
Column

See more
DatabaseQueue

See more
TableRequest

See more
TableRecord

See more

Inclusion Operators (BETWEEN, IN)


                    
                    
                    Range

Declaration

Swift

extension Range where Bound: SQLExpressible


                    
                    
                    ClosedRange

Declaration

Swift

extension ClosedRange where Bound: SQLExpressible


                    
                    
                    CountableRange

Declaration

Swift

extension CountableRange where Bound: SQLExpressible


                    
                    
                    CountableClosedRange

Declaration

Swift

extension CountableClosedRange where Bound: SQLExpressible