Extensions

The following extensions are available globally.

RangeReplaceableCollection, Sequence, Dictionary, Set extensions

RangeReplaceableCollection
See more
Declaration
Swift

extension RangeReplaceableCollection
Dictionary
See more
Declaration
Swift

extension Dictionary
Set
See more
Declaration
Swift

extension Set


                    
                    
                    Sequence

Declaration

Swift

extension Sequence

extension Sequence where Element == SQL

extension Sequence where Element: SQLSpecificExpressible

extension Sequence where Element == SQLSpecificExpressible

extension Sequence where Self.Iterator.Element: SQLExpressible

extension Sequence where Self.Iterator.Element == SQLExpressible

Database

See more

Cursors


                    
                    
                    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.makeStatement(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 & Hashable

extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible

extension Optional where Wrapped: DatabaseValueConvertible & StatementColumnConvertible & Hashable


                    
                    
                    Collection

Declaration

Swift

extension Collection where Element == SQL

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


                    
                    
                    Decimal

Decimal adopts DatabaseValueConvertible

Declaration

Swift

extension Decimal: DatabaseValueConvertible

extension Decimal: 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
TableRequest

See more
TableRecord

See more
ColumnExpression

See more

SQLExpressible

SQLExpressible

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