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