* 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.
Added a new toolbar button to insert a new row. Tapping on the button will show an alert to write the values as a comma separated string which will be added in an INSERT statement to be executed.
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
Also add FLEXMutableListSection which wraps the collection content section in a way that makes displaying a simple list of content straightforward.
Adopt additions in appropriate view controllers.
- Typo
- Remove <FLEX/...> import syntax added by #353 which causes compilation errors when building FLEX as a part of a different target (as opposed to building it as its own target)
- Fix iOS 13 glitch
This Commit adds a Searchbar to Database Table Viewer Tables List.
For that it turns FLEXTableListViewController into a FLEXTableViewController sublcass, calls showSearchbar=YES and implements updateSearchResults
Object properties are strong by default, and primitive ones are assign by default. Verbosity is nice, but in this case it introduces unnecessary cognitive load.
Remove all usage of `strong` and `assign` property attributes
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.
Tanner Bennett
Tanner Bennett
matrushandTanner Bennett
Hossam GhareebandTanner Bennett
Chaoshuai LuandChaoshuai Lü
skytoupandChaoshuai Lü
Michael GrayandGitHub
Evan EmelgaandTanner Bennett
Les MelnychukandTanner Bennett
Dominik PichandChaoshuai Lü
Antoine CœurandTanner Bennett
Chengming LiaoandTanner Bennett
Chengming LiaoandTanner Bennett
zhaogyrainandTanner Bennett
Bharat Mediratta
Ryan OlsonandGitHub
Iulian Onofrei