vendredi 13 mars 2015

how to filter result of sqlite query

I am performing sample database app using sqlite.swift framework excuting select query and store result in data variable when type any character or text in search bar display data in tableview written filtering code in filterContentForSearchText method but when i run app searching not work



class DetailViewController: UIViewController , UITableViewDataSource , UITableViewDelegate {
var db : Database!
var name = Expression<String>("ZCATEGORY")
var user : Query!
var stmt : Query!
var data1 : Array<Row>!
var data : Array<Row>!
@IBOutlet var table: UITableView!
var serchcontroller : UISearchController!
override func viewDidLoad() {
super.viewDidLoad()
createdb()
// code for adding search bar
serchcontroller = UISearchController(searchResultsController: nil)
serchcontroller.searchBar.sizeToFit()
table.tableHeaderView = serchcontroller.searchBar
definesPresentationContext = true
}

internal func createdb()
{
let path = NSBundle.mainBundle().pathForResource("db", ofType: "sqlite")
db = Database(path, readonly: true)
user = db["ZFOOD"]
stmt = user.select(name)
data = Array(stmt)
println(stmt)

}
func filterContentForSearchText(searchText: String)
{
data1 = data.filter{ $0.get(self.name).rangeOfString(searchText, options: nil, range: nil, locale: nil)

self.data2 = Array(self.data1)
println(searchText)
return false
}

Aucun commentaire:

Enregistrer un commentaire