aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* • re-factored the SPF file structureBibiko2009-08-251-225/+321
| | | | | | | | - now it's an open format XML plist file with either encrypted <data> key or plain text <data> dict - (if option "Save Passords") the passwords will be readable if no encryption! - queries can be saved as plain text; whereby SP will compress the text chunk if length > 50k automatically NOTE: Basically it's working but the Save SPF file accessory is now a bit out of sync - waiting for stuart02
* • finalized first approach to save/open SPF (⇧⌘S/⌘O)Bibiko2009-08-241-55/+109
| | | | | | | - ask for encryption password in a sheet - fixed retrieving password Note: further tests are needed esp. for slow connections, connections via SSH and all combination of saving passwords Y/N, encrypt passwords Y/N.
* • further improvements for open/save spf filesBibiko2009-08-241-27/+119
| | | | | | | | | | - added encryption code routine - if encrypted ask for password • added to SPDataAdditions dataEn/DecryptedWithPassword: • tiny fixes for cascading new doc windows - never decrease win size less than minSize - large win width detection now gets rid of all connected monitors • updated credits.rtf
* • add accessory view for Save ConnectionBibiko2009-08-231-0/+37
| | | | | | | | | | | - options: -- Include session data (selected table, queries, status, etc.) -- Save passwords + Encrypt SPF file with password for safety reasons Note: SP gives this warning in the Console: NSSecureTextFieldCell detected a field editor (_NSSavePanelTextView) that is not a NSTextView subclass designed to work with the cell. Ignoring... Why?
* • further improvements to open/save spf filesBibiko2009-08-231-36/+86
| | | | | - rearrange invoking procedure for spf data if SP asks for passwords • fine-tuned and fixed table history for BETWEEN operator
* • further improvements to restore a SP session from spf fileBibiko2009-08-231-3/+74
|
* • moved NSOpenPanel stuff from TableDocument to SPAppControler to simplify ↵Bibiko2009-08-221-117/+1
| | | | | | | | and unify it • fixed: avoid opening of more than NSOpenPanel windows • if conncetionController is active do not allow a NSOpenPanel • minor code cleaning
* • outsourced SPEncodingPopupAccessoryBibiko2009-08-221-80/+7
| | | | | | - added SPEncodingPopupAccessory class and nib - it returns an accessory view containing a popup menu with predefined encodings - removed that view from DBView
* • further improvements for open/save SQL/SPF filesBibiko2009-08-221-22/+35
|
* • an attempt to improve the cascading of new connection windows for large ↵Bibiko2009-08-211-0/+17
| | | | windows
* • further work for open/save connection files (spf)Bibiko2009-08-211-8/+35
| | | | | • added to NSDataAdditions the methods 'compress' and 'decompress' • added libz.dylib to xcode project
* • first preparations to save the current connection window as SPF fileBibiko2009-08-211-1/+69
| | | | • added to TableContent's method filterSettings the dict key 'filterComparisonTag' in order to be able to rely on menu item tags instead on the title strings
* • activated "Save Query…" menu item (⌘S)Bibiko2009-08-201-7/+37
| | | | - saves the Custom Query editor content by using a selected encoding to a SQL file
* • Main Menu > FileBibiko2009-08-201-3/+22
| | | | | | | | - renamed "Open" into "Open…" plus tooltip - added "Save Query…" (enabled if a query is in the editor and rename 'Query' to 'Queries' dynamically) [still hidden] - added "Save Connection…" [still hidden] • added method numberOfQueries to CustomQuery • 'Save Query…" and "Save Connection…" are bound to the same connector distinguished via their tags
* - Merge in r1191 from SP0.9.6 branch, fixing a crasher for blank passwords ↵rowanbeentje2009-08-111-3/+6
| | | | | | | by checking a keychain item is present before trying to load it - Also make keychain checks more robust when supplying nil values as some of the parameters
* Fix problem with opening and reopening connectionsmltownsend2009-08-111-5/+0
|
* Fix some MainMenu references by index.mltownsend2009-08-111-3/+12
|
* User Manager featuremltownsend2009-08-111-1/+22
|
* • after connecting to a server set focus to table list filter field if ↵Bibiko2009-08-111-0/+7
| | | | visible otherwise set focus to Table List view for selecting a table quickly
* Rename MainController to SPAppController.stuconnolly2009-08-081-2/+2
|
* Rename print accessory XIB.stuconnolly2009-08-071-1/+1
|
* - Fix "Add to favorites" behaviour when the user has no favourites (This ↵rowanbeentje2009-08-071-2/+2
| | | | | | | addresses Issue #354) - Improve favorites saving including names with anonymous users
* Rename Keychain class.stuconnolly2009-08-071-1/+1
|
* - Fix a memory leak when filtering the server variablesstuconnolly2009-08-071-27/+37
| | | | | | - Fix a memory leak in MCPResult.m's stringFromCString: - Display the number of server variables being display when a filter is being applied
* Make the cancel button on the delete database dialog have the key equivalent ↵stuconnolly2009-08-071-0/+6
| | | | of return to be same as remove/truncate table.
* • enabled "Open" menu item to open SQL filesBibiko2009-08-061-46/+99
| | | | | - lastSqlFileEncoding will be stored in the Preference.plist - to open SPF files not yet supported
* • added encoding popup list as accessory view for Open spf or sql filesBibiko2009-08-061-2/+133
| | | | | - renamed menu item to Open - if sql file is selected encoding popup list is enabled otherwise not since spf will be encoded in UTF-8
* • fixed: release query string which would be inserted into the Custom ↵Bibiko2009-08-051-0/+1
| | | | Query editor after opening a SQL file if the user does not connect to a server
* • open a SQL file via Finder or Terminal (open *.sql if SP is the default ↵Bibiko2009-08-051-0/+28
| | | | | | | app for sql files) will insert the file content into the Custom Query editor of the current active doc - this action starts SP and asks for a connection if it is not running - same for drag&drop a SQL file onto SP's dock icon
* - Fix some small memory leaks when changing tablesrowanbeentje2009-08-041-3/+10
| | | | | - Fix the history navigation to correctly switch across databases without invalid history states
* • initial support for open/save connection files (*.spf)Bibiko2009-08-041-0/+53
| | | | | | | | | - Open/Save menu items are hidden • initial support for drag&drop files *.spf and *.sql to SP's icon or double-click at *.sql or *.spf files in Finder - SP starts if not already running - sql files will be executed in the Custom Query if at least one connection is open - spf files not yet supported -
* • fixed bug for focus setting after database choiceBibiko2009-08-041-2/+7
| | | | - it sets the focus to table list filter field only if it's visible, otherwise it sets the focus to the Table List view directly
* • changed keyboard navigationBibiko2009-08-041-0/+3
| | | | | - set focus to Table List filter field after selecting a database - TAB key in Table List filter field sets focus to Table List for selection/navigation
* Don't release the server variables array as it's simply a weak reference ↵stuconnolly2009-08-031-7/+9
| | | | when filtering is not taking place, fixes a crash. Also, if the panel is opened and the search field contains a value that was previously filter using, perform the filtering using this value before the sheet is displayed.
* - Implement live filtering of the server variables table viewstuconnolly2009-08-031-75/+88
| | | | | | - Update the save variables button to save the current filtered variables if necessary - Remove old/unused NSSplitView code
* - Add a tooltip to the table information pane toggle buttonrowanbeentje2009-08-021-26/+34
| | | | | | | - Change the "[Show/Hide] Console" button in the toolbar to a "Console" button, which shows or brings the console window to the front - Update the default toolbar state to reflect recent additions - Reset everyone's toolbars to ensure that normal users will have the new icons available and visible
* - Fix an errant NSLog in TableSourcerowanbeentje2009-08-011-2/+5
| | | | | | - Improve and make consistent state saving in TableContent; now saves filters and scroll position mor reliably on refresh/edit, and supports remembering and restoring which rows were selected - Significantly improve table history - only create entries for tables switches or filters, only remember 50 items, and save view/filters/scroll position/selections in table content view
* - Add an initial barebones version of the history controller, with a basic ↵rowanbeentje2009-07-301-1/+17
| | | | toolbar item to navigate backwards and forwards. TBC!
* - When getting splitview sizes to resize database menu, correctly use the ↵rowanbeentje2009-07-281-1/+1
| | | | | | | subview size directly instead of the contents of the scrollview (which incorrectly doesn't measure presence of the scrollbar) - Remove the connection view entirely once a window has connected, fixing resize events following document splitview resize
* Improve TablesList significantly:rowanbeentje2009-07-281-1/+0
| | | | | | | | - If there are twenty or more tables, show a table quicksearch/filter at the top of the list, and update the rest of the code to match. This addresses issue #178. - Select tables and views alphabetically by user's current locale (instead of default MySQL "A B C a b c") - When adding or duplicating tables, insert them at the correct point - Fix a number of minor display bugs caused by incorrect interaction with the tables list caches
* - Tweak table information panel to show scrollbars if it's resized to a ↵rowanbeentje2009-07-261-2/+1
| | | | | | | | position that would hide content - Store collapse state of table information panel in preferences - Apply a double fix for BWSplitView/NSSplitView+BWAnchoredButtonBar not informing delegates of resizes - correctly inform original BWSplitView delegates of resizes, and allow BWAnchoredButtonBar registered delegates to recieve the original split view resize notifications. This fixes database menu resizing in synch with splitview resizing for improved/consistent look and feel.
* Remove delegate calls asking for SP specific TableDocument ivars, replacing ↵stuconnolly2009-07-221-2/+20
| | | | them with more generic delegate methods.
* - Allow the reconnection dialogs to function correctly if anything other ↵rowanbeentje2009-07-221-3/+5
| | | | | | | than "Disconnect" is selected - Fix tunnel restarts
* Merge framework integration branch back to trunk. Summary of changes:stuconnolly2009-07-211-26/+84
| | | | | | | | | | | | | | | - Includes all custom code from subclasses CMMCPConnection and CMMCPResult, meaning they have subsequently been removed from the project. - All previous Sequel Pro specific code in the above subclasses has been removed in favour of the delegate (currently set to TableDocumet) informing the framework of such information. - All references to CMMCPConnection and CMMCPResult have subsequently been changed to MCPConnection and MCPResult. - Framework includes MySQL 5.1.36 client libraries and source headers. - Framework is now built as a 4-way (32/64 bit, i386/PPC arch) binary. - All import references to <MCPKit_bundled/MCPKit_bundled.h> have been changed to <MCPKit/MCPKit.h>. - New script 'build-mysql-client.sh' can be used to build the MySQL client libraries from the MySQL source. See the script's header for a list of available options or run it with no arguments to display it's usage. Note that there are still a few changes to be made to the framework with regard to removing Sequel Pro specific calls to the delegate. These however can be made later on as they have no effect on functionality and are merely design changes. Also, note that any future development done on the framework should be made to be as 'generic' as possible, with no Sequel Pro specific references. This should allow the framework to be integrated into another project without the need for SP specific code.
* - Make the DBView window the document window. This allows the document to ↵rowanbeentje2009-07-151-34/+61
| | | | | | | | | | be closed when the window is closed, freeing the document's memory - Update a number of dealloc methods to include more retained memory, and to avoid releasing non-retained memory - Remove notification observers and delegates where appropriate to avoid issues after document closing - Fix a couple of memory leaks - Support window cascading for all windows past the first, using the first window as the autosave window
* • fix for completion in CustomQuery editorBibiko2009-07-141-8/+24
| | | | | | | - now the gathering of suggestions does not query the MySQL connection, instead it uses the TableList/TableDocument tableView data as a kind of cache - this approach should improve the speed for slow server connections TODO: auto-update for TableList and Database List resp. (it could happen that an other user changed the name of a table/db meanwhile)
* Fix to clear compilation errors. 2 variables theUser and theHost weren't ↵avenjamin2009-07-091-2/+2
| | | | declared as pointers.
* - Add a number of additional nil checks as protection against further ↵rowanbeentje2009-07-091-6/+10
| | | | recurrences of Issue #331
* - Commit the second part of r995 (oops), addressing database selection issuesrowanbeentje2009-07-091-1/+1
|
* - Fix favorites text fields resizing in prefs windowrowanbeentje2009-07-061-1/+2
| | | | | - Correctly select Structure view after connection
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-20 12:37:55 +0000