Swift 之 SQLite.swift的使用

Swift 之 SQLite.swift的使用

GitHub地址 SQLite.swift

SQLite.swift使用Swift 编写的一款SQLite工具，封装了各种sql操作，避免了纯sql语句的开发

安装

1. Carthage

github "stephencelis/SQLite.swift" ~> 0.12.0

2. CocoaPods安装

pod 'SQLite.swift', '~> 0.12.0'

3. Swift Package Manager

dependencies: [
    .package(url: "https://github.com/stephencelis/SQLite.swift.git", from: "0.12.0")
]

使用

1. 首先第一步创建连接SQLite的对象 这一步就相当于创建了数据库，但是数据库中并没有表

//sqlPath是你数据库文件的地址，如..../demo.sqlite
let db = try? Connection.init(sqlPath)

2. 创建数据库的表

 let  id = Expression<Int64>.init("uId")
 let  name = Expression<String>.init("userName")
 do{
   
     let table = Table.init(tableName)
     try db?.run(table.create(temporary: false, ifNotExists: true,            withoutRowid: false, block: {
    (builder) in
     //设置主键和自增
       bulider.column(id,primaryKey: .autoincrement)
       bulider.column(name)
     }))
 }catch(let error){
   
 }

3. 向数据库中增加数据

@discardableResult func insert (table:Table?,setters:[Setter]) -> Bool{
   
        guard let tab = table else {
   
            return false
        }
        do {
   
            try db?.run(tab.insert(setters))
            return true
        } catch let error {
   
            debugPrint(error.localizedDescription)
            return false
        }
    }
   /// 

4. 查询数据

 func select(table:Table?,select: [Expressible] = [],filter: Expression<Bool>? = nil, order: [Expressible] = [], limit: Int? = nil, offset: Int? = nil) -> [Row]? {
   
        guard var queryTable = table else {
   
            return nil
        }
        do {
   
            if select.count != 0{
   
                queryTable = queryTable.select(select).order(order)
            }else{
   
                queryTable = queryTable.order(order)