aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • added $SP_ASLIST_ALL_FIELDS_FROM_SELECTED_TABLE as pre-defined snippet listBibiko2010-03-095-56/+190
| | | | | • 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
* • fixed bug in snippet list - now it inserts the chosen item correctly ↵Bibiko2010-03-092-25/+78
| | | | | | | | | | | | | 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
* • improved tooltip behaviour of SPNarrowDownCompletion's tableViewBibiko2010-03-095-0/+81
| | | | • added "Filter Tables…" ^⌥⌘F" to main menu > Table which sets the focus to TablesList's search field if visible
* • fixed some minor GUI issues for SPNarrowDownCompletion windowBibiko2010-03-093-9/+28
| | | | - added oneColumn mode for dict and list view to decrease the window's width
* • added possibility to define a snippet via ¦a¦b¦ – such a snippet ↵Bibiko2010-03-082-4/+43
| | | | | | | | 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
* • Select Content Filter ^⌘FBibiko2010-03-082-3/+18
| | | | | - select first textfield for 1 or 2 argument(s); if no argument field is selectable select compareField - ensure the focus setting by calling "makeContentFilterHaveFocus" via performSelector:afterDelay
* • Favorite Query Editor Bibiko2010-03-082-0/+10
| | | | - 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
* When cancelling a table sort operation remember to end the threaded task to ↵stuconnolly2010-03-081-0/+1
| | | | ensure the bezel and spinner are removed from view. Fixes issue #570.
* Fix user manager splitview maximum and minimum sizes.stuconnolly2010-03-082-3/+10
|
* Various user manager improvements including a new outline view contextual menu.stuconnolly2010-03-083-15/+14
|
* Remove semi-colons from user manager queries as they're not needed.stuconnolly2010-03-081-5/+5
|
* Add a new 'Filter Content...' menu item to the 'Table' menu that switches to ↵stuconnolly2010-03-085-41/+68
| | | | the content view and places the focus on the filter field.
* • auto-completionBibiko2010-03-081-1/+1
| | | | - make sure it will only be invoked if there're pending changes to the text buffer -this fixes issue that auto-completion was invoke by eg Run All
* • outsourced keyword completion and function completion lists to ↵Bibiko2010-03-088-1025/+161
| | | | | | | | | | | 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
* - Move history popup construction to the main thread, fixing crashes ↵rowanbeentje2010-03-082-2/+12
| | | | probably caused by non-thread-safe menu interaction. This addresses http://log.sequelpro.com/view/19
* - Fix an exception when table source edit errors occur and the user ↵rowanbeentje2010-03-071-1/+1
| | | | requests changes be discarded; this addresses http://log.sequelpro.com/view/16
* - Fix exception on duplication of table source rows that haven't been saved ↵rowanbeentje2010-03-072-4/+8
| | | | | | | yet; this addresses http://log.sequelpro.com/view/23 - Clean up fix in r1859
* - When editing favourites from the connection screen, fix an exception when ↵rowanbeentje2010-03-071-1/+1
| | | | no selection is active. This addresses http://log.sequelpro.com/view/14
* • function completionBibiko2010-03-071-2/+7
| | | | | - do not insert () after a function if inserted string ends with ) - no snippet insertion for () - only locate the caret inside ()
* - Add a check for valid columns - this addresses ↵rowanbeentje2010-03-071-0/+1
| | | | http://log.sequelpro.com/view/25
* • added to CustomQuery's CMTextView the option to set auto-completion ↵Bibiko2010-03-077-20/+75
| | | | | | 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
* Add a hidden preference to display or hide the MySQL server version in the ↵stuconnolly2010-03-073-2/+4
| | | | window title.
* • set CMTextView temporarily to editable:YES if the tab stops width is ↵Bibiko2010-03-061-0/+6
| | | | changed to avoid exceptions
* • CSV Import Field MapperBibiko2010-03-062-7/+40
| | | | | - 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.
* Fix warning introduced in r1850 by making SPAppController conform to the ↵stuconnolly2010-03-062-2/+3
| | | | FeebackReporter's FRFeedbackReporterDelegate protocol.
* • CSV Import Field MapperBibiko2010-03-065-38/+63
| | | | | - 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
* Improve Feedback reporter privacy and functionality:rowanbeentje2010-03-062-0/+29
| | | | | | | | - Update to a development version of the feedback reporter, which improves logging and allows functionality like exception reporting from non-main threads (together with many other improvements). - Use the new preference privacy delegate methods to remove query history and favorite settings, together with other hostname/user path type settings, to anonymise the preferences submitted - Limit the console log submitted to 10k - Move the framework into the Frameworks folder
* • CSV Import Field MapperBibiko2010-03-052-1/+34
| | | | - implemented "Insert remaining rows" for import method UPDATE; if the UPDATE statement does't affect any row and this row via INSERT INTO…
* • CSV Import Field MapperBibiko2010-03-051-6/+15
| | | | | | - 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
* • CSV Import Field MapperBibiko2010-03-056-76/+236
| | | | | | | | | | | - 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.
* • CSV Import Field MapperBibiko2010-03-043-33/+152
| | | | | | | - added UPDATE method which allows to configure an import statement à la: UPDATE t1 SET col1=foo1, col2=foo2 WHERE col3=baz1 AND col4=baz2 - Insert remaining rows (which are not matched) isn't implemented yet - note: further tests are needed to ensure it works as expected
* - Fix an exception/crash when content edit errors occur and the user ↵rowanbeentje2010-03-031-2/+2
| | | | requests changs be discarded
* • CSV Import Field MapperBibiko2010-03-034-3/+46
| | | | - further work on UPDATE (not yet activated)
* Localise SPExtendedTableInfo.m and remove use of multiple comments for ↵stuconnolly2010-03-033-32/+33
| | | | localised strings.
* - Addition and enabling of crash reporting and exception reporting, ↵rowanbeentje2010-03-031-0/+9
| | | | submitting to a new online repository. Integrates the FeedbackReporter framework.
* • CSV Field MapperBibiko2010-03-023-13/+28
| | | | | | - REPLACE as import method is only enabled if target table has a primary key or at least one field which is set to unique - if user set a field to "Ignore Field" display as "import value" the field's default value greyed - some minor code cosmetics
* In the extended table information view, hide rather than disable the 'reset ↵stuconnolly2010-03-011-2/+2
| | | | auto increment' button when no auto increment field is present.
* • REPAIR, OPTIMIZE, ANALYZE, FLUSH, CHECKSUM now can be applied to more ↵Bibiko2010-02-264-89/+301
| | | | | | | | 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
* • Query Favorites:Bibiko2010-02-256-17/+146
| | | | | | | | - 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
* • Reset AUTO_INCREMENT in Table Info Pane uses inline entering of the new ↵Bibiko2010-02-238-11/+71
| | | | | | | | | | 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
* Fix Issue #574 (foreign key links not working after first use):rowanbeentje2010-02-235-18/+43
| | | | | | - Move foreign key reference loading into it's own task and set state modification markers to allow it to override the table state history - Rename modifyingHistoryState to modifyingState now the usge has broadened slightly
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-226-26/+79
| | | | | | | | Table Info Pane via Advanced popup button and sheet (not yet optimal GUI solution) • SPAlertSheets - ensure that this sheet becomes the keyWindow
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-223-4/+21
| | | | | | Structure Pane via right-click at the index tableView - implementation in the Table Info follows soon
* • initial work to give the chance to reset the table's AUTO_INCREMENT valueBibiko2010-02-223-0/+49
| | | | - not yet active
* • this commit should fix the displaying the correct read file size and the ↵Bibiko2010-02-211-6/+6
| | | | | | | file size while importing very large CSV/SQL - replaced deprecated method fileAttributesAtPath:traverseLink: by attributesOfItemAtPath:error: - fix for i549
* • CSV Import Field MapperBibiko2010-02-215-10/+138
| | | | | - 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
* • fixed keyboard behaviour of "Create Sytax Sheet"Bibiko2010-02-201-0/+3
| | | | | | - specified first responder to avoid pressing ↩ twice before closing sheet - ESC also closes that sheet - fixed tab behaviour for keyboard navigation
* • applied new SPTableData keys "PRIMARY" and "UNIQUE" information to the ↵Bibiko2010-02-201-10/+12
| | | | | | mapping table - set tokenField to noWrap
* • added to method informationForTable: Bibiko2010-02-201-12/+37
| | | | | | - the root dict key "primarykeyfield" = <field name> - the key "isprimarykey" for corresponding table field - the key "unique" = 1 if corresponding table field has a UNIQUE KEY
* • removed initial transition of insertion NSNull into table's dataSource ↵Bibiko2010-02-192-11/+8
| | | | from last commit r1824 since that part should be moved maybe into SPTableTextFieldCell
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-08 11:49:58 +0000