* Add fallback column queries support when PRAGMA table_info is not working
* Switch to check columnCount instead of rowsAffected
* Use SELECT * FROM pragma_table_info('%@')
Fallback to SELECT * FROM table where 0=1
Co-authored-by: Tanner Bennett <tannerbennett@me.com>
`SELECT rowid` returns rowids corresponding to rows in a different order than `SELECT *`. We will now order the rowids in ascending order to match the order of `SELECT *`.
Previously, the mismatched order would mean deleting a row in the UI might delete a different row.
Sqlite is often smart enough to not need quotes for identifiers, unless you want to use a keyword as a name. Then you need to quote it
https://www.sqlite.org/lang_keywords.html
- All database managers automatically open and close connections to the underlying database
- Allow getting last result and last rowid from FLEXSQLiteDatabaseManager
- Execute statements with arguments with FLEXSQLiteDatabaseManager
Replaces the following method calls with dot syntax:
- count, length, UTF8String, CGColor, contentOffset, firstObject, lastObject, allObjects, allKeys, allValues, subviews, scale, frame, bounds, bytes
Also replaces various UIKit and Foundation singleton method calls with dot syntax, such as UIApplication.sharedApplication. These are all `class` properties now and Xcode will autocomplete them.
Also fixes a couple warnings.
Chaoshuai Lü
Tanner Bennett
Hossam Ghareeb
Michael Gray
matrush
Les Melnychuk
Chaoshuai Lu
Iulian Onofrei
Tim Oliver