| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- r4034: End editing for deleting content filter or query favourites, addressing exceptions and Issue #1648
- r4035: Apply schlabberdog's fix for log #3969, addressing Issue #1647
- r4036: Fix an error parsing SQL inside an unterminated delimiter statement causing an off-by-one error in positioning, addressing Issue #1643
- r4037: If date-type fields are cleared, and allow NULLs, save the cell value as NULL; this implements Issue #1638
- r4038: Alter the content filter manager and the query favourite manager to import items from a file into the Global group if the document is untitled, improving import UX and addressing Issue #1616 and Issue #1645. Also select and scroll to the newly imported items for clarity.
- r4039: Fix crashes in the User Manager when fields don't validate but a save/cancel/tab switch is still triggered, addressing Issue #1627
- r4041: Tweak and improve the User Manager: Rework how data to populate the user manager is retrieved from the server, speeding up display of lots of users by a large factor; Fix support for schema permissions for the Anonymous user, and add support for '%' and '' hostnames (only showing if already set once), fixing Issue #1620; Highlight databases in the user manager that have permissions set for the selected user; Switch to using the centrally provided database list to reduce queries and remove the information_schema and performance_schema "databases"; Speed up a number of operations by tweaking the logic and queries used
- r4042: Fix release builds after r4041; Update localizable strings
- r4043: Set Sequel Pro to always run on Integrated Graphics on machines with both integrated and discrete, improving power consumption if nothing else is triggering the discrete GPU. This addresses Issue #1609
- r4044: Make the theme background apply to the query favourites editor
- r4045: If the Custom Query editor view is active on window open, correctly set the focus in it, addressing Issue #1590
- r4046: Add support for querying the server default charset and collation; Move a bit of redundant code into a method
- r4047: Restore tab bar label when cancelling a connection
- r4048: Fix format string error in QueryKit
- r4049: Alter the preferences favourite minimum version to avoid issues with previous runs of nightlies, which may partially address Issue #1588; Remove the old favourites key from the preferences now imports have succeeded
- r4050: Allow Favorites import to read favorites from an old preferences .plist file, further addressing Issue #1588
- r4051: Change the string '=' and '!=' to be case- and collation-insensitive by default, using the Shift key (as documented in the tooltip) to trigger a BINARY exact match. This addresses Issue #1578
- r4052: When adding a database the servers default charset is now shown
- r4053: Adjust keywords list to fix auto capitalisation of "ON"
- r4054: Add a new SPMySQLEmptyResult class to SPMySQLFramework, returning it instead of nil if a query produces no result set. This allows per-result-set properties to be preserved, fixing issues where information like query execution time was lost - addressing Issue #1577
- r4056: Improve startup when loading from file, preventing overwrite of details read from a spf/spfs during startup. This addresses Issue #1619
- r4057: Correctly reset document state for setting it from file/when duplicating tab, further addressing Issue #1619
- r4058: Add a stub override to fix exceptions when code receiving a SPMySQLEmptyResult expects a SPMySQLStreamingResult/SPMySQLFastStreamingResult (Exception #3988)
- r4060: Make some small tweaks to string BINARY handling: Correctly send the binary state/collation when reordering fields, addressing Issue #1265; Allow unticking of the binary box to save correctly, allowing conversion of fields to non-binary collations again
- r4061: Fix errors when editing or moving columns on server vesions which do not support character sets/collations, addressing Issue #1629; Fix needless collation queries on those servers; Disable field enums and table encoding dropdown on those servers
|
| |
|
|
| |
dependencies now that all BW custom elements have been removed; remove last references and build steps.
|
| |
|
|
| |
UserManagerView, replacing with SPSplitViews and standard equivalents
|
| |
|
|
|
|
|
| |
- Use menu item tag to insert the snippet, instread of using part of the tooltip; this is safer when localising values
- When inserting query placeholders, automatically wrap all the values if not already within a placeholder. This addresses Issue #1313.
- When inserting query placeholders, automatically use the lowest unused completion index instead of a fixed value
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| | |
|
| |
|
|
|
|
| |
SP_ASLIST_ALL_FIELDS since it's too long
• some GUI improvements for Query Fav Editor's "Insert placeholder"
|
| |
|
|
|
| |
• added Show Completion List submenu to the Custom Query Editor gear menu with the items all dbs ^1, all tables ^2, all fields ^3
• if dbStructure is available show these pre-defined completion lists with all info like the completion it does, otherwise fall back to plain style
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
after narrow-down the list
• added chance to invoke the snippet list in fuzzy search mode by the template ¦¦a¦b¦¦
• added new snippet placeholders:
¦$SP_ASLIST_ALL_TABLES¦ displays a list of all tables incl. views from the current db
¦$SP_ASLIST_ALL_DATABASES¦ displays a list of all dbs from the current connection
This makes it possible to write eg a query fav:
USE ¦¦$SP_ASLIST_ALL_DATABASES¦¦;
to search via fuzzy mode for a db and to use it
|
| |
|
|
|
|
|
|
| |
will be shown as completion list with the items “a” and “b”
• set auto-completion default Pref setting to true
• fixed some auto-completion issues like do not insert common prefix automatically and some others
• applied ¦a¦b¦ template to CompletionTokens.plist and some tiny corrections and improvements
|
| |
|
|
| |
- added the possibility to insert defined placeholder via a popup button similar to Content Filter Editor to give an hint to user what's possible
|
| | |
|
| |
|
|
|
|
|
|
|
| |
tab trigger; eg if tab trigger is set to "sel" sel⇥ will insert the first query which has the defined the tab trigger
• preparations to insert programmable query favorites
- eg "SELECT ${*} FROM ${Table}"
-- after insertion "SELECT * FROM Table" the '*' is highlighted to change, press ⇥ to select the next snippet 'Table'; ⇧⇥ selects the previous snippet; the snippet selection follows the user input
- Note: not yet active
|
| | |
|
| |
|
|
|
|
|
|
| |
don't include linebreaks, and reset it to run over upgraded arrays
- Also prevent the query fvorites interface from accepting newlines in titles - together, this addresses Issue #496
- Enable the query favorite editor vertical scrollbar when editing long queries
|
| |
|
|
| |
editor and query favorites editor as you can't do it in IB.
|
| | |
|
| | |
|
| |
|
|
|
| |
- disabled sorting by clicking at table headers
- added drag&drop support of multiple selected items
|
| |
|
|
|
|
|
| |
favorites
• disabled "Select Active Query" in CMTextView if shown in the favorite manager
• code cleaning and simplifications
|
| | |
|
| |
|
|
|
|
| |
- renamed "Save" button to "Apply Changes" to make it clear what will be done by clicking at it
- suppress context menu and selection while right-clicking at a header
- while in cell editing ESC will abort the editing (not close the sheet)
|
| |
|
|
|
|
|
|
| |
- first step to allow to manage global favs (stored in the prefs) and connection-based (not yet implemented - will be stored in ApplicationSupport/SequelPro)
- fav table is now a grouped table à la Table List
- second column in fav table will be used soon ;)
- now the sheet has two buttons "Save" and "Cancel" in order to be able to dismiss changes
- enabled table view inline editing of query names
|
| |
|
|
|
|
|
|
|
|
|
|
| |
- tableView is now a SPTableView for right-click selects item first
- corrected tooltips for all buttons and menu items
- added short-cut ⌘D for duplicate, ⌫ for remove, and ⌥⎋ for gear menu (which could be the standard for all gear menus?)
- remove selected favorite(s) asks the user first
- added chance to select and remove more than one favorite
- added chance to export selected favorites as SPF file
The file structure (format 'query favorites') goes conform with the SPF 'connection' format.
To be discussed: Should we add a separate Import Favorites menu or should we do that via the general "Open…" menu item since the SPF format tells SP what to do with that file?
|
|
|
- The ability to name query favorites
- The ability to edit query favorites using the same editor in the cutom query view
- The ability to save your query favorites to a file
Note that any already saved query favorites will be upgraded to accommodate the new format, that is including a name associated with the query. The default name is the first 32 chars of the query with '...' appended.
Also, added menu item validation to the 'Save Query to Favorites' menu item.
|
