aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* Significantly improve export:rowanbeentje2009-09-142-186/+321
| | | | | | | | - Rework CSV export to stream data, significantly reducing memory consumption and so increasing speed and stability when exporting large tables. By default safe/fast streaming is used, but a checkbox is available to select "low memory mode" full streaming, allowing export of any size table in theory. This addresses Issue #224. - Rework XML export to stream data in the same way, also significantly reducing memory usage and providing the option of using low memory mode. - Make SQL, CSV and XML export progress bars update more smoothly - When exporting the current browse view or custom query result, show an indeterminate progress bar when copying large resultsets to avoid the app appearing to hang
* Forgot to assign the back/forward history menu item's tags resulting in ↵stuconnolly2009-09-123-4/+4
| | | | incorrect navigation and menu item validation.
* Add back/forward history menu items to the view menu with the assigned ↵stuconnolly2009-09-125-14/+67
| | | | shortcuts of cmd+[ and cmd+].
* • fixed bug for exporting tables as XML: now the very last row will be ↵Bibiko2009-09-112-4/+10
| | | | | | written to file [ this fixes issue 404 ] • FieldEditorSheet: if string cell content is "NULL" select the entire string for convenience
* • added to hard-coded encoding list the DESCRIPTION fieldBibiko2009-09-082-172/+176
| | | | | | | | | | | | • fixed issue while retrieving possible encodings/collations from information_schema - in many cases "SHOW TABLES IN information_schema LIKE 'character_sets'" returns NULL whereby "SELECT * FROM `information_schema`.`character_sets`" returns the correct list - change the test query to the latter syntax - if the retrieving of possible encodings fails return an array of the hard-coded list with dictionaries containing the keys for name AND description -- [this fix solves i400 due to the fact that the chosen encoding title from the popup list must be of the format: "description (name)"; otherwise the following regexp returns (null) because it's looking for the content of parentheses]
* • removed leaks in QueryFavoriteManagerBibiko2009-09-073-2/+26
| | | | • prepared QueryController for future steps
* - Ensure table viewport is correctly restored for navigation history/SPF ↵rowanbeentje2009-09-071-0/+5
| | | | usage following TableContent cleanups in r1183/r1204
* • Query Favorite ManagerBibiko2009-09-071-22/+51
| | | | | - disabled sorting by clicking at table headers - added drag&drop support of multiple selected items
* • after "Apply Changes" in a Query Favorite Manager update the Query ↵Bibiko2009-09-072-14/+25
| | | | | | Favorites of all opened documents to synchronize changes in global favorites • "Import Favorites" in the Query Favorite Manager adds the imported favorites after the last selected item, if no selected item is found it adds them
* • updated SPQueryFavoriteManager to mange document-based and global query ↵Bibiko2009-09-077-289/+270
| | | | | | | favorites • disabled "Select Active Query" in CMTextView if shown in the favorite manager • code cleaning and simplifications
* • improved behavior while closing a document windowBibiko2009-09-043-35/+73
| | | | | | | - if not connected close it without any checks - if an Untitled document contains stored query favorites - What should be done? - up to now it saves them to the global prefs • header in query favorites list keep visible while filtering • code cleaning
* • first steps to support global/document-based query favoritesBibiko2009-09-043-30/+54
| | | | - not yet fully implemented but workable
* • prepared Query Name Sheet for choosing the target of the to be saved ↵Bibiko2009-09-042-6/+14
| | | | query favorite (global or not)
* • the in r1313 introduced method [NSString stringWithCString:encoding:] ↵Bibiko2009-09-041-3/+8
| | | | | | must be a \0 terminated cString - fixed that and replaced the deprecated method [NSString stringWithCString:length] again
* • 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.
generated by cgit v1.2.3 (git 2.25.1) at 2024-10-31 17:36:50 +0000