aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* • added $SP_ASLIST_ALL_FIELDS_FROM_SELECTED_TABLE as pre-defined snippet listBibiko2010-03-097-78/+438
| | | | | • 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-093-28/+277
| | | | | | | | | | | | | 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-096-2/+342
| | | | • 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
* - Update feedbackreporter framework to better cope with exception backtrace ↵rowanbeentje2010-03-091-0/+0
| | | | generation errors. This should address http://log.sequelpro.com/view/35
* - Update MySQL client libraries to 5.1.44, incorporating all changes since ↵rowanbeentje2010-03-094-10/+10
| | | | | | | previous 5.1.36 - Update MySQL client build script for snow leopard compatibility, and to build the client libraries as a three-way binary (x86/ppc/x86_64) in keeping with the rest of Sequel Pro
* • corrected function arg list for MATCHBibiko2010-03-081-1/+1
|
* • added possibility to define a snippet via ¦a¦b¦ – such a snippet ↵Bibiko2010-03-085-41/+106
| | | | | | | | 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-084-32/+332
| | | | - 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
* Until we can find a better way of doing this and to prevent a conflict with ↵stuconnolly2010-03-081-5/+7
| | | | the query favourites menu popup, change the 'Filter Content...' menu item's shortcut to control+cmd+F.
* 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.
* Tidy up the add/remove schema privileges buttons.stuconnolly2010-03-081-55/+50
|
* Fix user manager splitview maximum and minimum sizes.stuconnolly2010-03-083-17/+33
|
* Various user manager improvements including a new outline view contextual menu.stuconnolly2010-03-084-149/+285
|
* 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-086-50/+168
| | | | 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-0812-1030/+1367
| | | | | | | | | | | 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
* Rework MCPConnection for greater thread safety:rowanbeentje2010-03-082-61/+87
| | | | | | | | - The delegate is now triggered for connectionLost: on the main thread, as this action will probably trigger a GUI update; this addresses http://log.sequelpro.com/view/10 . - Connection proxy disconnects are now triggered on the main thread - Connection checks are now made via a pthread'd ping in a loop, removing the reliance on SIGALRM which may hop thread execution back to the main thread when called on another thread. The new approach is cleaner but does rely on a loop with a sleep. This will hopefully improve the disconnect/retry/reconnect crashes.
* - 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-0710-50/+556
| | | | | | 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-074-2/+6
| | | | 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-063-14/+117
| | | | | - 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-067-64/+304
| | | | | - 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-0621-37/+49
| | | | | | | | - 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-052-50/+71
| | | | | | - 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-057-910/+1221
| | | | | | | | | | | - 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-035-72/+188
| | | | - further work on UPDATE (not yet activated)
* Localise SPExtendedTableInfo.m and remove use of multiple comments for ↵stuconnolly2010-03-034-32/+33
| | | | localised strings.
* - Addition and enabling of crash reporting and exception reporting, ↵rowanbeentje2010-03-0317-2/+141
| | | | 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-265-123/+389
| | | | | | | | 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-257-144/+1007
| | | | | | | | - 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
* • fixed GUI resize behaviour of the auto_inc value input fieldBibiko2010-02-231-1/+1
|
* • Reset AUTO_INCREMENT in Table Info Pane uses inline entering of the new ↵Bibiko2010-02-239-44/+487
| | | | | | | | | | 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-227-81/+435
| | | | | | | | 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-224-15/+53
| | | | | | Structure Pane via right-click at the index tableView - implementation in the Table Info follows soon