aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* • improved behavior while closing a document windowBibiko2009-09-041-4/+23
| | | | | | | - 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
* • implementation of a new history controllerBibiko2009-09-041-15/+20
| | | | | | | | | | | | | - 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 :)
* • renamed SPQueryConsole to SPQueryController since it controls not only ↵Bibiko2009-09-031-20/+20
| | | | | | 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-031-26/+39
| | | | | | | | • 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
* • 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-031-16/+31
| | | | | | • 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
* • 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-021-170/+335
| | | | | | | | | | | | | | - 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
* - Remove an NSLog I accidentally left in (and another found via a search)rowanbeentje2009-09-011-1/+0
| | | | | - Improve SQL parser streaming improvements for significant speedups and some very important bugfixes
* - Re-enable the fine-grained query logging preferencesrowanbeentje2009-08-311-4/+21
| | | | | | | - 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
* Update Localizable.strings by running genstrings and remove use of multiple ↵stuconnolly2009-08-281-2/+2
| | | | comments for a single string.
* • some tiny fixes to Open/Save SPF file proceduresBibiko2009-08-251-31/+61
|
* • outsourced Save SPF accessory xibBibiko2009-08-251-32/+30
| | | | | | | | | • updated save SPF accessory xib due to SPF structure changes NOTES: - The view in DBView.xib will be deleted after stuart02's commit. - Still after clicking at the encrypt text field a warning will be shown in the Console: NSSecureTextFieldCell detected a field editor that is not a NSTextView subclass... WHY?
* • 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