| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
| |
- added the chance to mark a global value as SQL statement in the sheet to allow to use a calculated value like LENGTH(`foo`) or NOW() while inserting/replacing/updating
• added ^⌥⌘N short-cut Navigator (still hidden)
|
|
|
|
|
|
|
|
|
|
| |
- added 'sync' mode - the navigator follows the active window db/table selection if navigator has not multiple selected items
- added drag support of selected items
-- as comma separated and backtick quoted string for external apps
-- as array of schema paths for SP
• CMTextView
- added drop support for selected items coming from the Navigator
- insert them as comma list relative to current selected db/table
|
|
|
|
|
| |
- preserve selection; if generally possible check if selected item still exists if not select parent if still exists on so forth
- a reload should only occurs if structure was changed
|
|
|
|
|
|
|
|
| |
- made expand status persistent for current SP session
- added draft to display additional information about selected fields
- tried the minimize the jittering while resizing outline views (test)
Note: to test it simply unhide menu item in MainMenu.xib
|
|
|
|
| |
to make it even clearer to what it applies to. Related to issue #601.
|
| |
|
|
|
|
| |
clearly to what it applies to. Related to issue #601.
|
| |
|
|
|
|
| |
menu item)
|
|
|
|
| |
- to try see line 1134 in TableDocument.m)
|
|
|
|
| |
Interfaces/ for XIBs. This addresses the first point on issue #593.
|
|
|
|
|
| |
- set favorite table's next key view in ConnectionView to tab view (standard,socket,ssh) to allow to navigate via ⇥
- if password field of the current selected connection in the ConnectionView is empty set first responder to it since it's very likely that user wants to fill it; otherwise favorite table is first responder
|
| |
|
|
|
|
| |
multiple comments for the same string.
|
| |
|
|
|
|
|
| |
- regardless of focus it prints the table info sheet
- only if user selects something then the create syntax will be printed
|
|
|
|
| |
http://www.sequelpro.com/docs/Keyboard_Shortcuts.
|
| |
|
|
|
|
|
|
| |
SP_ASLIST_ALL_FIELDS since it's too long
• some GUI improvements for Query Fav Editor's "Insert placeholder"
|
|
|
|
| |
^1,2,3 doesn't close an already displayed completion list window (instead an 'h' will be inserted??)
|
|
|
|
| |
making the user manager KVO compliant for the sort descriptors array. Also, add a bunch of comments and general tidy up on SPUserManager.m.
|
|
|
|
|
| |
• 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
|
|
|
|
| |
• added "Filter Tables…" ^⌥⌘F" to main menu > Table which sets the focus to TablesList's search field if visible
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
the query favourites menu popup, change the 'Filter Content...' menu item's shortcut to control+cmd+F.
|
| |
|
| |
|
| |
|
|
|
|
| |
the content view and places the focus on the filter field.
|
|
|
|
|
|
|
|
|
|
|
| |
CompletionTokens.plist
• SPQueryController manages keyword and function completion lists now; this reduces the memory usage a bit and the list is easier to edit
• added pre-defined function argument snippets to CompletionTokens.plist (auto-generated from mysql's HELP)
• added Preference option for Editor whether a function completion should insert () and if found the function argument snippets automatically or not
- last ) will be linked as autopaired then
• changed behaviour for wrapping a selection into `"'() etc. - now it re-selects the original selection after wrapping and in addition last wrap character is now marked as autopair-linked
• improved logic for popping up the auto-completion list
|
|
|
|
|
|
| |
on/off, settable in Prefs and gear menu
- if inserted completion is marked as function it inserts snippet (${}1:) so far; function parameters as snippets follows soon
|
|
|
|
|
| |
- added to INSERT advanced option "Skip existing rows"
This option allows to insert only those source file rows which primary keys do not exist. It executes INSERT INTO … ON DUPLICATE KEY UPDATE `pri_key_name` = `pri_key_name`. This statement suppresses all warnings/errors regarding to duplicates pri keys etc. BUT it gives an error if an INSERT… statement of a remaining row was erroneous.
|
|
|
|
|
| |
- fixed some issues for displaying the default values for auto_increment and time_stamp
• added possibility to change the tab stop width in each CMTextView via Preference setting in Editor window
|
|
|
|
|
|
| |
- improved some validation logic
- added "Match Field" to source file field popup to be consistent if UPDATE is chosen
- the label "Advanced" is now clickable as well
|
|
|
|
|
|
|
|
|
|
|
| |
- removed Advanced sheet, instead resize the main sheet and display these settings in it
- added advanced options LOW/HIGH_PRIORITY
- improved logic for adv. settings, disabling UPDATE if target table has less than 2 fields, etc.
- fixed URL for displaying the source file name
- removed Help text since it's too large - should be go to the general help
• CMTextView
- fixed bug if ESC Completion is invoked if caret position is 0
• fixed document URL handling to come up with the correct icons etc.
|
|
|
|
| |
- further work on UPDATE (not yet activated)
|
|
|
|
| |
localised strings.
|
|
|
|
| |
submitting to a new online repository. Integrates the FeedbackReporter framework.
|
|
|
|
|
|
|
|
| |
than one selected item in the TablesList; if no error alert OK, if not or for CHECKSUM list the output in a table view
- while sheet is open showing the accessory table user can press ⌘C for copying it
- added missing NSLocalizeStrings
• fixed a tiny issue for $SP_SELECTED_TABLES
|
|
|
|
|
|
|
|
| |
- added snippet variable $SP_SELECTED_TABLES which inserts `table1`,`table2`, etc. (ONLY tables)
• improved "Check Table"
- now one can select more than one table to execute "CHECK TABLE table1,table2,… ; if all tables passed successfully alert OK, if not show the result as accessory table in the sheet
note: OPTIMIZE, REPAIR, FLUSH, CHECKSUM, ANALYZE follow
|
| |
|
|
|
|
|
|
|
|
|
|
| |
value (no sheet)
• "Delete all records" confirmation sheet shows a checkbox "Reset AUTO_INCREMENT after deletion" if PRI key is given for that table
• minimized table data querying for auto_inc
• optimized auto_inc change notification
• if user changes tabVIew to Table Info Pane update data in beforehand
• TRUNCATE query updates auto_inc value as well in TABLE INFORMATION
|
|
|
|
|
|
|
|
| |
Table Info Pane via Advanced popup button and sheet (not yet optimal GUI solution)
• SPAlertSheets
- ensure that this sheet becomes the keyWindow
|
|
|
|
|
|
| |
Structure Pane via right-click at the index tableView
- implementation in the Table Info follows soon
|
|
|
|
| |
- not yet active
|
|
|
|
|
| |
- added Advanced sheet for setting IGNORE, DELAYED, ON DUPLICATE KEY UPDATE '<string>' for INSERT/REPLACE INTO
• if during import CSV Import an error occurred show SP Console
|
|
|
|
|
|
| |
- specified first responder to avoid pressing ↩ twice before closing sheet
- ESC also closes that sheet
- fixed tab behaviour for keyboard navigation
|
|
|
|
| |
whether the leading <field> placeholder should be suppressed or not in order to be able to write a filter like "LENGTH($CURRENT_FIELD)>${}"
|