step 1: Add following libraries.
1. libsqlite3.tbd
2. libsqlite3.0.tbd
step 2: Create Bridgeheader.h (Header) file.
step 3: Import sqlite3. Like,
#import <sqlite3.h>
1. libsqlite3.tbd
2. libsqlite3.0.tbd
step 2: Create Bridgeheader.h (Header) file.
step 3: Import sqlite3. Like,
#import <sqlite3.h>
step 4: Create database and table using "DB Browser For SQLite".
step 5: After create database and table, drag database_name.sqlite file and drop on your project.
step 6: Put the following code on Viewcontroller. Like,
var db : OpaquePointer? = nil
var arr_of_Users : NSMutableArray = NSMutableArray()
var arrData = NSMutableArray()
var query = String()
var temp = String()
internal let SQLITE_STATIC = unsafeBitCast(0, to: sqlite3_destructor_type.self)
internal let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
step 7: Create the copy_file function. Like,
func copy_file()
{
let file_manager = FileManager.default
let document_path = URL(fileURLWithPath: NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true)[0])
let destination_sqlite_url = document_path.appendingPathComponent("example_db.sqlite")
let source_sqlite_url = Bundle.main.url(forResource: "example_db", withExtension: "sqlite")
print("\(destination_sqlite_url.path)")
if !file_manager.fileExists(atPath: destination_sqlite_url.path)
{
do
{
try file_manager.copyItem(at: source_sqlite_url!, to: destination_sqlite_url)
print("copied..")
print(destination_sqlite_url.path)
}
catch let error as NSError
{
print("Enable to create database:\(error.debugDescription)")
}
}
if sqlite3_open(destination_sqlite_url.path, &db) != SQLITE_OK
{
print("Error open database..")
}
else
{
print("Success open database..")
}
}
step 8: Call this function on ViewDidLoad. Like,
override func viewDidLoad() {
super.viewDidLoad()
copy_file()
}
step 9: Create select query function(Get data from table). Like,
func get_data_from_table(_ querySQL : String) -> NSMutableArray {
var statement : OpaquePointer? = nil
if sqlite3_prepare_v2(db, querySQL, -1, &statement, nil) != SQLITE_OK
{
let error_msg = String(cString: sqlite3_errmsg(db))
print("Error prepaer select:\(error_msg)")
}
while sqlite3_step(statement) == SQLITE_ROW {
let name = sqlite3_column_text(statement, 0)
var name_str = String()
if name != nil
{
name_str = String(cString: name!)
print("Name is=\(name_str)")
}
else
{
print("Name is not found")
}
let dict_of_user : NSMutableDictionary = NSMutableDictionary()
dict_of_user.setObject(name_str, forKey: "name" as NSCopying)
arr_of_Users.add(dict_of_user)
}
print(arr_of_Users)
if sqlite3_finalize(statement) != SQLITE_OK
{
let err_msg = String(cString: sqlite3_errmsg(db))
print("Error finalized prepared statement\(err_msg)")
}
statement = nil
return arr_of_Users
}
step 10: Call this function on viewDidLoad. Like,
override func viewDidLoad() {
super.viewDidLoad()
copy_file()
arrData = get_data_from_table("select * from example_table")
print(arrData)
}
Note: I already put data on database, so I will get data from database.
step 11: Create delete function. Like,
func deleteData(_ queryStr : String) {
var deleteStatement: OpaquePointer? = nil
if sqlite3_prepare_v2(db, queryStr, -1, &deleteStatement, nil) == SQLITE_OK {
if sqlite3_step(deleteStatement) == SQLITE_DONE {
print("Successfully deleted row.")
} else {
print("Could not delete row.")
}
} else {
print("DELETE statement could not be prepared")
}
sqlite3_finalize(deleteStatement)
}
step 12: Create UITableView on viewcontroller. Give proper constraints on it.
step 13: Give UITableviewDatasource and UITableviewDelegate.
step 14: Put following code in NumberOfRowsInSection method. Like,
func tableView(_ tableView: UITableView, numberOfRowsInSection section: Int) -> Int {
return arrData.count
}
step 15: Put following code in cellForRowAtindexPath method. Like,
func tableView(_ tableView: UITableView, cellForRowAt indexPath: IndexPath) -> UITableViewCell {
let cell : custom_cell = tableView.dequeueReusableCell(withIdentifier: "custom_cell") as! custom_cell
cell.textLabel?.text = (arrData[indexPath.row] as! NSMutableDictionary).value(forKey: "name") as? String
return cell
}
step 16: Put following code in commiteditingStyle method. Like,
func tableView(_ tableView: UITableView, commit editingStyle: UITableViewCellEditingStyle, forRowAt indexPath: IndexPath) {
temp = (arrData[indexPath.row] as! NSMutableDictionary).value(forKey: "name")! as! String
print(temp)
if editingStyle == .delete
{
arrData.removeObject(at: indexPath.row)
tableView.deleteRows(at: [indexPath], with: .fade)
deleteData("delete from example_table where name = '\(temp)' ")
}
}
Note: This method is use to swipe delete cell from UITableview.
Thank you...
