aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • the replacing of the deprecated stringWithCString:length: method in ↵Bibiko2009-09-041-1/+2
| | | | r1313 leads to the issue that no password can be read from the keychain; reverted to r1212 in order to keep SP workable until a fix is found
* • implementation of a new history controllerBibiko2009-09-045-139/+219
| | | | | | | | | | | | | - each history is doc-based even if you have opened not only one instance of the same spf file - for each SPF file identified by its file URL SP remembers each history item regardless from which doc instance it comes from internally ( to make sure that after closing the last instance of a doc all executed queries are saved in that file - if the user wants to change that s/he has to save that file under a different name ) - the history list for each Untitled doc will be initialized by the items stored in the global SP's prefs - the history list for each SPF doc will be initialized by the items stored in the SPF file unless an instance of the same file is already open - then the new instance inherits the history list from the opened one(s) - all history items executed in any Untitled docs will be added to SP's prefs - in other words SP's global prefs plist is the historyrepository for each new Untitled doc - if the user saves an untitled doc or rename an opened SPF file the _current_ history list for that doc will be saved to the chosen file unless an other doc instance is still open - all history lists are saved automatically if SP quits or the user closes a doc window Note: This should be tested for any logical pitfalls - each desired logic can be implemented :)
* Table row should be a signed integer not unsigned, fixes duplicate method ↵stuconnolly2009-09-031-1/+1
| | | | definition warning.
* Replace deprecated stringWithCString:length: and update Console.xib after ↵stuconnolly2009-09-032-1/+6
| | | | SPQueryConsole rename.
* • fixed (hopefully) : While adding all procedures and functions do check ↵Bibiko2009-09-031-1/+3
| | | | for mysql errors - if information_schema is not accessible for some reasons omit adding procedures and functions silently
* • renamed SPQueryConsole to SPQueryController since it controls not only ↵Bibiko2009-09-034-119/+119
| | | | | | the query console but also query favorites and history application-wide - accessible via: [SPQueryController sharedQueryController]
* • fixed document registering with its query favorites and historyBibiko2009-09-034-44/+82
| | | | | | | | • added and applied removeRegisteredDocumentWithURL to remove a registered document from the app-wide query fav/history controller • saveDocumentWithFilePath now returns the success status after saving - if saving fails for some reasons SP suggests to save that doc under a new name • fixed issues for "Save" an Untitled doc • improved error handling
* • commented out a not yet fully implemented feature in SPQueryConsole in ↵Bibiko2009-09-031-13/+13
| | | | | | order to be able to open files from Finder correctly Note: I tested it with 21 spf files (different connections, encrypt state, auto connect state, non-readable spf files etc) selected in Finder ⇢ ⌘O ⇢ all of them were handled correctly
* • fixed bug Save (the correct file path will be calculated)Bibiko2009-09-031-4/+6
| | | | • fixed bug for Save As (suggested name is now Unicode-safe )
* • fixed issue if a SPF file contains non-valid URL character like space, etc.Bibiko2009-09-034-18/+110
| | | | | | • each new connection which is non-SPF file-based gets the document name "Untitled x" • prepared SPQueryConsole to manage all query favorite and history data application-wide • minor code fixes and renaming issues
* - Fix exception/hang when an error occurs when deleting a table or tablesrowanbeentje2009-09-031-20/+36
| | | | | | - Improve error messages encountered when deleting multiple tables, asking whether to stop or continue; also now shows all errors, not just the last (if it showed any!) - Fix various exceptions caused by the table list attempting to redraw while the underlying data is being changed
* - Replaces uses of the deprecated selectRow:byExtendingSelection: with ↵rowanbeentje2009-09-025-13/+13
| | | | selectRowIndexes:byExtendingSelection:
* • forgot to remove a NSLog Bibiko2009-09-021-1/+1
|
* • added "Recent Open" menu item to Main Menu > FileBibiko2009-09-021-1/+7
|
* • simplified and unified the issue to set the title of a tableWindowBibiko2009-09-025-197/+388
| | | | | | | | | | | | | | - everything will be configured in [TableDocument displayName] - to update the title call [TableDocument setTitle:[TableDocument displayName]] - this removes dozens of lines • first steps to support more the document-based approach ( a document is nothing else than a connection with view properties and preferences ) - renamed/added/changed in Main Menu items into "New", "Open", "Save", and "Save As" - if user opened a spf file -> fileURL will be set - "Save" will save the current connection/view data according to the "Save As" setting - ie if one saved a doc with do not "Remember window state" - "Save" won't save the window state; to enable this hit "Save As" [this works for encrypted file data as well] - if the current doc was opened from file and the user closes it or quits the entire app all connection/document-based preferences (up to now query favs and history) will be updated silently [not yet implemented fully in CustomQuery] [works for encrypted file as well] • delete saveSPFAccessory view from DBView since it was outsourced • fixed some issues for the NSSecureTextField in the Save accessory panel (but still a warning appears)
* - Improve on r1242, improving window cascading (especially for maximised ↵rowanbeentje2009-09-021-6/+20
| | | | windows) and addressing Issue #383
* - Use long longs instead of ints when looking at table sizes, free space, ↵rowanbeentje2009-09-014-10/+32
| | | | | | | | and row counts for display, fixing overflow issues (this addresses Issue #394) - Tweak the byte size formatter to also show TBs for very large numbers - Improve row count and auto increment value formatting by using a number formatter (enhancements for Issue #394)
* • fixes for Query Favorite Manager:Bibiko2009-09-013-2/+26
| | | | | | - 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)
* • query favorite managerBibiko2009-09-013-75/+413
| | | | | | | | - 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
* - Remove an NSLog I accidentally left in (and another found via a search)rowanbeentje2009-09-013-20/+10
| | | | | - Improve SQL parser streaming improvements for significant speedups and some very important bugfixes
* - Re-enable the fine-grained query logging preferencesrowanbeentje2009-08-314-5/+55
| | | | | | | - Add defaults for fine-grained logging preferences - Add a method to TableDocument to allow setting the query mode, and use the query mode to control logging - Set import/export and custom query to set the appropriate query modes
* Refactor CSV/SQL import structure slightly, and rewrite SQL import:rowanbeentje2009-08-314-302/+457
| | | | | | | - SQL import now reads and processes files in full streaming mode, running queries as they are encountered - Memory usage during import is significantly reduced, and should stay within a few megabytes; the significant memory use remaining is for query logging - The progress bar more accurately represents progress and is shown at once (this addresses Issue #320)
* More data export work.stuconnolly2009-08-298-20/+297
|
* Implement the core CSV export process in the new CSV exporter class.stuconnolly2009-08-296-7/+345
|
* Add the first classes of the new export architecture. See the description at ↵stuconnolly2009-08-295-5/+205
| | | | the top of SPExporter.h for more information.
* • due to new minimum size of the connection pane rearranged help buttonBibiko2009-08-282-17/+22
|
* • improved Query Favorite ManagerBibiko2009-08-283-26/+137
| | | | | | | | | | | | - 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?
* Give the connection view's split view maximum and minimum sizes.stuconnolly2009-08-281-2/+15
|
* Update Localizable.strings by running genstrings and remove use of multiple ↵stuconnolly2009-08-284-7/+7
| | | | comments for a single string.
* If the SSH tunnel is unable to bind to the local port because there is ↵stuconnolly2009-08-283-13/+40
| | | | already an existing tunnel, give the user the option of using a standard connection to localhost on the port that is in use in order to use the existing tunnel. Fixes issue #371.
* • moved "Replace Editor Content" (Favorites/History) settings from popup ↵Bibiko2009-08-281-22/+55
| | | | | | | | lists to gear menu since these are settings • revert the actual behaviour for "Save ... to Favorite" to "Save All to Favorite" since this was the default behaviour in previous releases - to restrict what should be save as favorite press ⌘ to toggle "Save All to Favorite" into "Save current query/selection to Favorite" • while choosing a favorite or history item each modifier key ⇧,^,⌥, or ⌘ inverts the current setting for "Replace Editor Content"
* • simplified code for inserting the seach fieldes (fav/hisotry) - now set ↵Bibiko2009-08-281-30/+1
| | | | | | in DBView • added keyboard short-cut ⌥⌘F and ⌥⌘H for open Favorites and History (for testing)
* • Custom Query:Bibiko2009-08-282-14/+74
| | | | | | | - added to History list "Replace Editor Content" (stored in the prefs) and a search field - "Save ... to Favorites" menu title changes according to selection in the textView Problem: How can we allow if the user hits RETURN in a search field (fav/history) to select the next menu item if any and to change the first responder to popup button menu list?
* • tiny improvements for loading SQL files and syntax highlightingBibiko2009-08-283-9/+17
|
* Fixed keyDown editing of SPTableView and CMCopyTablemltownsend2009-08-282-3/+18
|
* When creating a new relation, the ON UPDATE and ON DELETE drop downs should ↵stuconnolly2009-08-271-5/+11
| | | | only contain valid MySQL options. Fixes issue #388.
* • fixed bug while uppercasing keywordsBibiko2009-08-271-6/+13
| | | | - inserting a char within an already marked keyword doesn't end up in inserting a uppercase char if resulting word won't be a new keyword
* When editing blob/text fields and the LoadBlobsAsNeeded option is enabled, ↵stuconnolly2009-08-272-19/+18
| | | | load a blob/text's field content even if we are still editing the row. This prevents the placeholder value '(not loaded)' being displayed, giving the impression that it is the field's value. Fixes issue #385.
* • SPFieldEditorSheetBibiko2009-08-273-3/+5
| | | | | | - ESC and ENTER will close a non-editable sheet * SPTooltip - first check if tooltip should be closed and then forward the current event (this fixes an issue if a tooltip is shown while a modal window appears which could block the closing of the tooltip
* • improvement for hitting RETURN or ENTER to invoke the row edit modeBibiko2009-08-272-13/+20
| | | | | | - fixed that the table is selectable again - hitting ENTER/RETURN are enabled only for TableContent and ask the delegate's tableView:shouldEditTableColumn: method for validation (by doing so a RETURN/ENTER is the same event as a double-click into a table cell for column 0 if table is in non-editing mode)
* Fix for not editing in CMCopyTable when hitting enter or return which is ↵mltownsend2009-08-261-0/+5
| | | | used in CustomQuery
* Fix favorite length when favorite name is under 32 charsmltownsend2009-08-261-1/+1
|
* • fixed bug for remembering the Query Editor font after restart and new ↵Bibiko2009-08-261-2/+4
| | | | | | | doc resp. - delegate textViewDidChangeTypingAttributes: should only save the textView font if it is not (null) which occurs while awaking from nib - removed a setFont: command since the editor's font is already bound to the pref's setting
* • added to "Query Favorite" popup menu:Bibiko2009-08-262-8/+35
| | | | | | - "Replace Editor Content" check box menu item; if checked the chosen query will replace the editor's content if not it will insert it (setting will be saved in the prefs) - Search Text Field to filter the list of names (by using a regular expressions) - added a tooltip to each menu item displaying the query behind the name
* • fixed/improved several things for the SPQueryFavoriteManager:Bibiko2009-08-262-17/+56
| | | | | | | | - allow favorites with the same name (it's the user's responsibility) - fixed removing of all menu items (beginning from the end) - "Save Query to Favorites" will save the selected text, or if no selection the CURRENT query, or if no current query can be detected the entire textView string (since the tooltip says '...or save the current query...) - ensure after editing the favorites ALL changes will be saved first before closing the sheet
* • bug fixed for providing an auto-generated name for favorites after redesignBibiko2009-08-261-1/+2
| | | | - not every favorite query is longer than 32 characters thus check length in beforehand to avoid raising an exception which causes that SP doesn't start
* Remove unused methods.stuconnolly2009-08-262-68/+0
|
* Completely redesigned query favorite manager, including:stuconnolly2009-08-265-274/+636
| | | | | | | | | | | - 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.
* Alter CustomQuery to use StreamingResult to download and process result sets:rowanbeentje2009-08-262-54/+59
| | | | | | | - Significantly improve memory usage - Minor speedup (1.1x faster?) to overall query/display times - Improvements to MCPStreamingResult and MCPConnection to accurately report affected row count
* Made it so that SPTableView and SPOutlineView will respond to enter or ↵mltownsend2009-08-254-3/+104
| | | | return being hit when a row is selected and go into edit mode.