SQLFetchedResultsCotroller可以让使用SQLite建立表格更加容易。对于那些喜欢SQL的灵活性，又不想放弃可以轻松建立表格的CoreData'sNSFetchedResultsCotroller的开发者，可以试试这个类。
作者注：这个脚本正在开发中，还不能保证总是正确的显示列表。
override fuc viewDidLoad() { super.viewDidLoad() var request = SQLFetchRequest() request.table = "Test as t" //Not tested with > 1 table request.fields = ["id","title", "(SELECT AVG(id) FROM Test WHERE title=t.title) as idAvg"] request.predicate = "id % 10 = 0 AND title != 'SomeStrig'" request.sortDescriptors = [(key:"title", isASC:true)] request.groupBy = "title" request.havig = "cout(*) > 3" fetchCotroller = SQLFetchedResultsCotroller(request: request, pathToDatabase: DatabaseSetup.getDatabasePath()) let preview = fetchCotroller!.previewSQL() pritl("--SQL Preview: \(preview.SQL) \--Parameters: \(preview.Parameters)") }
评论