aboutsummaryrefslogtreecommitdiffstats
path: root/Interfaces
Commit message (Collapse)AuthorAgeFilesLines
* • preparation for GUI support to manage user-defined content filtersBibiko2009-09-291-0/+2774
|
* • rewrote the content filter logic:Bibiko2009-09-281-40/+50
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - all default filters come from "ContentFilters.plist" which can be localized main structure: <plist> <dict> <key>number</key> <array/> <key>string</key> <array/> <key>date</key> <array/> </dict> </plist> filter item structure: [ ${} is a place holder for an argument ] <dict> <key>MenuLabel</key> <string>BETWEEN</string> <key>Tooltip> <string>a tooltip</string> <key>NumberOfArguments</key> <integer>2</integer> <key>ConjunctionLabels</key> <array> <string>AND</string> </array> <key>Clause</key> <string>BETWEEN '${}' AND '${}'</string> </dict> - if NumberOfArguments == 0 then start filtering automatically - now one can save his/her own filters in SP's preferences.plist (GUI follows soon) - fixed issue for filters requiring two arguments that pressing RETURN if one is in the second argument input field invokes "Filter" - added string operators: "IS EMPTY" and "IS NOT EMPTY" - fixed issue that now one is able to look for eg \n in string fields
* • re-enabled field editor's QuickLook for 10.6Bibiko2009-09-251-359/+98
| | | | | | | | | - This is up to now a kind of a 'hack' since SP will be compiled against SDK10.5 but if SP runs on 10.6 it'll use code from a 10.6 framework. - Under 10.6 full screen mode is available and QL does run in its own run loop ie now it's non-modal - Changed the way of removing temp files; now all files will be deleted while closing the sheet to fix issues if the user double-click at the QL item and the called app was too slow - this ended up in getting the message 'File not found' - Changed default container extension for images since 'pict' isn't support under 64bit 10.6; now SP makes usage of 'icns' • outsourced QuickLook types (show as pull down menu) to SP's preference plist. (up to now only 'power users' can change that type list via a Property List editor) • enhanced the caching behaviour of the sheet editor in terms of triggering a refresh if the text content was changed (this fixes the issue that it could happen that binary data were interpreted as text data)
* • changed short-cuts for table history to ^⌥⇠/⇢ to avoid ↵Bibiko2009-09-241-2/+2
| | | | interfering with cocoa short-cuts
* Rename (currently unused) help folder.stuconnolly2009-09-2321-0/+0
|
* Change the size of the checkboxes in the structure view to resolve the ↵stuconnolly2009-09-231-219/+139
| | | | strange blurriness on Snow Leopard.
* Change the back/forward in history menu item shortcuts to command + arrows ↵stuconnolly2009-09-141-3/+3
| | | | as the current shortcuts are already in use by the query editor for indentation.
* Significantly improve export:rowanbeentje2009-09-141-1558/+2469
| | | | | | | | - 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-121-0/+1
| | | | incorrect navigation and menu item validation.
* Add back/forward history menu items to the view menu with the assigned ↵stuconnolly2009-09-121-26/+90
| | | | shortcuts of cmd+[ and cmd+].
* File menu separator.stuconnolly2009-09-111-176/+949
|
* • Query Favorite ManagerBibiko2009-09-071-30/+45
| | | | | - disabled sorting by clicking at table headers - added drag&drop support of multiple selected items
* • updated SPQueryFavoriteManager to mange document-based and global query ↵Bibiko2009-09-071-35/+129
| | | | | | | 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-041-62/+12
| | | | | | | - 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-041-3/+86
| | | | - not yet fully implemented but workable
* • prepared Query Name Sheet for choosing the target of the to be saved ↵Bibiko2009-09-041-17/+77
| | | | query favorite (global or not)
* Replace deprecated stringWithCString:length: and update Console.xib after ↵stuconnolly2009-09-031-68/+784
| | | | SPQueryConsole rename.
* • added "Recent Open" menu item to Main Menu > FileBibiko2009-09-021-2/+67
|
* • next polish up of the QueryFavoriteManager GUIBibiko2009-09-021-562/+565
|
* • simplified and unified the issue to set the title of a tableWindowBibiko2009-09-023-356/+345
| | | | | | | | | | | | | | - 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)
* • recreated "Secure Text Input Sheet" which was deleted accidentallyBibiko2009-09-021-3/+543
|
* • fixes for Query Favorite Manager:Bibiko2009-09-011-7/+62
| | | | | | - 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-011-253/+214
| | | | | | | | - 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
* - Re-enable the fine-grained query logging preferencesrowanbeentje2009-08-311-191/+144
| | | | | | | - 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
* Forgot the project file and the export XIB.stuconnolly2009-08-291-27/+538
|
* • due to new minimum size of the connection pane rearranged help buttonBibiko2009-08-281-30/+132
|
* • improved Query Favorite ManagerBibiko2009-08-281-16/+269
| | | | | | | | | | | | - 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?
* Update Localizable.strings by running genstrings and remove use of multiple ↵stuconnolly2009-08-281-0/+0
| | | | comments for a single string.
* • set maximum to 50000 for the Preference setting "Limit result to:"Bibiko2009-08-281-44/+8
|
* If the SSH tunnel is unable to bind to the local port because there is ↵stuconnolly2009-08-281-3/+10
| | | | 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-126/+151
| | | | | | | | 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-15/+70
| | | | | | in DBView • added keyboard short-cut ⌥⌘F and ⌥⌘H for open Favorites and History (for testing)
* • Custom Query:Bibiko2009-08-281-52/+400
| | | | | | | - 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?
* When creating a new relation, the ON UPDATE and ON DELETE drop downs should ↵stuconnolly2009-08-271-159/+35
| | | | only contain valid MySQL options. Fixes issue #388.
* • SPFieldEditorSheetBibiko2009-08-271-7/+160
| | | | | | - 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
* • added to "Query Favorite" popup menu:Bibiko2009-08-261-16/+354
| | | | | | - "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
* Completely redesigned query favorite manager, including:stuconnolly2009-08-262-982/+2019
| | | | | | | | | | | - 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.
* Made it so that SPTableView and SPOutlineView will respond to enter or ↵mltownsend2009-08-251-98/+52
| | | | return being hit when a row is selected and go into edit mode.
* • outsourced Save SPF accessory xibBibiko2009-08-251-0/+875
| | | | | | | | | • 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?
* • finalized first approach to save/open SPF (⇧⌘S/⌘O)Bibiko2009-08-242-13/+336
| | | | | | | - 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-1/+15
| | | | | | | | | | - 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-1/+490
| | | | | | | | | | | - 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?
* • outsourced SPEncodingPopupAccessoryBibiko2009-08-222-223/+50
| | | | | | - 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-0/+325
|
* Add support for the BETWEEN operator when filtering a table's content. ↵stuconnolly2009-08-211-13/+241
| | | | Implements issue #361. Note the sizing of the new controls still needs fine tuned.
* • activated "Save Query…" menu item (⌘S)Bibiko2009-08-201-5/+4
| | | | - saves the Custom Query editor content by using a selected encoding to a SQL file
* • Main Menu > FileBibiko2009-08-201-18/+55
| | | | | | | | - 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
* Place the field label on the editor sheet at the top to make it more obvious ↵stuconnolly2009-08-201-94/+27
| | | | (originally added by Hans-Jörg Bibiko). Fixes #360.
* - Change MCPStreamingResult to use a safer streaming mode by default - ↵rowanbeentje2009-08-201-22/+108
| | | | | | | download all results as fast as possible from the server, to avoid blocking, but do so in a background thread to allow results processing to start as soon as data is available. Many thanks to Hans-Jörg Bibiko for assistance with this. - Add an option to the SQL export dialog to allow selection of the full-streaming method, with a warning that it may block table UPDATES/INSERTS.
* - The add, rename and copy table sheets should not block the main thread ↵stuconnolly2009-08-181-24/+34
| | | | | | | | (part of issue #357). - Improve the consistency of destructive confirmation dialogs by making the remove field and index dialogs default button 'Cancel' with a key equivalent of return. - Disable the remove field button when the currently selected table only has one field, removing the need for the extra check (and subsequent dialog) when the user attempts to remove a field.