SQLite
示例
要运行示例项目,首先克隆仓库,并在 Example 目录下运行 pod install
安装
SQLite 通过 CocoaPods 提供。要安装它,只需将以下行添加到您的 Podfile 中
pod 'SQLite'
使用
//Create or switch new database
SQLite.shared.databaseName = "NewDatabaseName"
//Get new pointer to current database
let databasePointer = SQLite.shared.getDB()
//Get current pointer to working database
let currentDatabasePointer = SQLite.shared.db
//Get Current database name
let currentDatabaseName = SQLite.shared.databaseName
//Execute raw SQL Query
SQLite.shared.execute(query: "Your_Raw_SQL_Query")
//Execute and know executed successfully or error occured
let flag = SQLite.shared.execute(queryString: "Your_Raw_SQL_Query")
//Get rows with column name
SQLite.shared.getRowsWithCol(query: "Your_select_query")
//Insert a Row in Table
let entry : = ["Key1":Value1,"Key2":Value2]
let replaceExisting = true
SQLite.shared.insertTable(entry, TableName, replaceExisting)
//Update Row in Table
let entry : = ["Key1":Value1,"Key2":Value2]
let condition = "columnName = 'MyColumn'"
SQLite.shared.insertTable(entry, TableName, condition)
作者
Vivek Kumar, [email protected]
许可协议
SQLite可在MIT许可下使用。有关更多信息,请参阅LICENSE文件。