aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* Add support for printing a table's create syntax with syntax highlighting.stuconnolly2010-03-131-6/+21
|
* Add support for printing the table triggers view as well some HTML ↵stuconnolly2010-03-134-13/+89
| | | | generation performance improvements.
* • fixed printing of Extended Table Info if Create Table Syntax view has focusBibiko2010-03-132-1/+11
| | | | | - regardless of focus it prints the table info sheet - only if user selects something then the create syntax will be printed
* Lots more printing support enhancements, including:stuconnolly2010-03-138-87/+191
| | | | | | | | | - The ability to print the extended table information view using a new template. - The inclusion of NULL values diaplyed as the user's NULL value placeholder when printing a table's sturcture and indexes. - If enabled in the user's preferences, the inclusion of vertical gridlines in the table views. - Dynamic calculation of page margins based on the paper size of the selected printer as opposed to using hard coded values. - Lots of other little style enhancements.
* Rework the running of custom queries, improving thread safety by splitting ↵rowanbeentje2010-03-122-114/+149
| | | | out table drawing and status/error drawing onto their own methods. This should address http://log.sequelpro.com/view/28 , http://log.sequelpro.com/view/45 and http://log.sequelpro.com/view/48
* Various printing support enhancements, including:stuconnolly2010-03-1211-201/+401
| | | | | | | | | - Splitting out all printing methods to SPPrintController which is category of TableDocument. - The ability to print table relations. - If present the inclusion of table indexes when printing a table's source. - If the user has use monospaced fonts enables, then the print out's tabular data will be in a monospaced font. - Lots of other style enhancements, including page headings and sections headings.
* • append () after completion of a stored procedureBibiko2010-03-111-2/+2
|
* - Improve SPTextAndLinkCell by not following links when the starting click ↵rowanbeentje2010-03-111-0/+3
| | | | was outside the link cell. Thanks to Brian Dunagan for this improvement ( http://www.bdunagan.com/2010/02/25/create-itunes-link-arrows/ )
* Include the current table name in printing support. Fixes issue #501.stuconnolly2010-03-101-27/+34
|
* Fix the enabling/disabling of the 'Table' menu items as a result of adding ↵stuconnolly2010-03-101-50/+52
| | | | the 'Filter Tables...' item. Note, that should ideally be moved to the menu item validation method to prevent future problems.
* Add a 'Keyboard Shortcuts' menu item to the 'Help' menu which opens the page ↵stuconnolly2010-03-104-0/+11
| | | | http://www.sequelpro.com/docs/Keyboard_Shortcuts.
* • auto-completionBibiko2010-03-101-0/+7
| | | | | - suppress completion window if only one item is found and the typed word is equal to it (case-insensitively) - fixed memory leak
* - Ensure endTask is called on the main thread, fixing various thread-safety ↵rowanbeentje2010-03-101-0/+6
| | | | issues including http://log.sequelpro.com/view/40 and http://log.sequelpro.com/view/21
* - Fix the "Import" button for the "Do you really want to load a [large] SQL ↵rowanbeentje2010-03-101-0/+1
| | | | file" dialog if no imports have been performed in the session
* - If using an untitled connection (eg non-spf), default to saving queries ↵rowanbeentje2010-03-101-0/+2
| | | | to the global favourites list
* • forgot to shorten SP_ASLIST_ALL_FIELDS in CustomQuery as wellBibiko2010-03-091-1/+1
|
* • shortened SP_ASLIST_ALL_FIELDS_FROM_SELECTED_TABLE to ↵Bibiko2010-03-091-1/+1
| | | | | | SP_ASLIST_ALL_FIELDS since it's too long • some GUI improvements for Query Fav Editor's "Insert placeholder"
* • for auto-completion suppress the caret moving inside `foo`|Bibiko2010-03-091-1/+1
|
* Fix an exception in the user manager caused by sorting the users list by ↵stuconnolly2010-03-092-59/+125
| | | | 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 $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