aboutsummaryrefslogtreecommitdiffstats
path: root/Interfaces/English.lproj/DBView.xib
Commit message (Collapse)AuthorAgeFilesLines
* • 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
* Change the size of the checkboxes in the structure view to resolve the ↵stuconnolly2009-09-231-219/+139
| | | | strange blurriness on Snow Leopard.
* 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
* • 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)
* • simplified and unified the issue to set the title of a tableWindowBibiko2009-09-021-305/+2
| | | | | | | | | | | | | | - 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
|
* • 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.
* • 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-261-982/+265
| | | | | | | | | | | - 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.
* • finalized first approach to save/open SPF (⇧⌘S/⌘O)Bibiko2009-08-241-12/+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.
* • 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-221-220/+7
| | | | | | - added SPEncodingPopupAccessory class and nib - it returns an accessory view containing a popup menu with predefined encodings - removed that view from DBView
* 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.
* - 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.
* - Rework TableContent row count fetching, loading it in the correct ↵rowanbeentje2009-08-131-17/+36
| | | | | | | | locations, and correcting the logic for fetching the count of rows so that the query is not used where not necessary. - Update the Table Info pane and tab with a new row count if one is known - this addresses Issue #141 - This reverts r1090, and so needs to be discussed with stuart02 - the rest of the row logic changes may have fixed the 'larger issue' described there?
* • in Table Content the button status of "edit spreadsheet or sheet-like" ↵Bibiko2009-08-111-32/+33
| | | | | | | | | will be saved in the Prefs • font settings in the Field Editor Sheet will be saved in the Prefs • improved max text length checking while using other InputManager (eg Japanese etc.) - still a bit under construction Note: each Beep() wil be replaced by a tooltip soon.
* - Fix a memory leak when filtering the server variablesstuconnolly2009-08-071-7/+63
| | | | | | - Fix a memory leak in MCPResult.m's stringFromCString: - Display the number of server variables being display when a filter is being applied
* - Fixed dimensions of Content Tableavenjamin2009-08-071-206/+127
| | | | - Added Copy, Copy with Column Names, Copy as SQL Insert to Content Table contextual menu.
* • added encoding popup list as accessory view for Open spf or sql filesBibiko2009-08-061-10/+217
| | | | | - 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
* • changed keyboard navigationBibiko2009-08-041-13/+197
| | | | | - 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
* - Implement live filtering of the server variables table viewstuconnolly2009-08-031-10/+134
| | | | | | - 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-16/+8
| | | | | | | - 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-18/+24
| | | | | | - 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
* Put the table content filter in a split view so the field name drop down and ↵stuconnolly2009-08-011-293/+374
| | | | search field can be resized. Addresses issue #339.
* Update the properties of the record count textfield on the CSV mapping ↵stuconnolly2009-07-311-10/+21
| | | | import sheet so it correctly resizes and truncates as appropriate.
* - Update the 'this table does not support relations' to be a little more ↵stuconnolly2009-07-301-26/+24
| | | | | | | informative. - Increase the size of the table selection NSPopupButton on the CSV import field mapping panel.
* - Add an initial barebones version of the history controller, with a basic ↵rowanbeentje2009-07-301-27/+164
| | | | toolbar item to navigate backwards and forwards. TBC!
* - Added Splitview delegate method to hide the drag handle on the Table Info ↵avenjamin2009-07-291-5/+13
| | | | pane and Filter view.
* Improve TablesList significantly:rowanbeentje2009-07-281-282/+490
| | | | | | | | - 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
* - Add keyboard shortcuts for Add and Delete buttons in Table Relations panerowanbeentje2009-07-261-160/+81
| | | | | | | | - Remove hidden, non-implemented menu in create table relation add dialog to improve tabbing through fields in the popup - Add cancel shortcut in the table relation add dialog - Prevent table relations table cells from being edited, as edit support isn't present yet - clean up tooltips to fix references to Indexes
* - Tweak table information panel to show scrollbars if it's resized to a ↵rowanbeentje2009-07-261-22/+74
| | | | | | | | 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.
* - For custom query result columns which map to SQL fields, check the column ↵rowanbeentje2009-07-241-184/+45
| | | | | | | width memory to set column widths - Save custom query result columns back to the master column width store for columns witch map to SQL fields
* • applied the new class SPFieldEditorController to TableContentBibiko2009-07-171-1248/+5
| | | | • deleted in DBVview.xib Field Editor Sheet (out-sourced)
* • changed keyboard shortcut for "Choose Database" from ⇧⌘T to ⇧⌘D ↵Bibiko2009-07-161-3/+15
| | | | (⇧⌘T is reserved for Show/Hide Toolbar)
* • fixed: "Custom Query's Gear Menu item "Comment Current Query" is ↵Bibiko2009-07-161-14/+13
| | | | disabled if SP awakes from NIB
* • rewrote ⌘/ "comment line" completelyBibiko2009-07-161-18/+59
| | | | | | | | | | | - ⌘/ (un)comment current line only if no selection is given (by using "-- ") -- caret jumps to the next line to (un)comment lines quickly -- # sign will be recognized for uncommenting as well as if the entire line is wrapped into /* */ - ⌘/ (un)comment current selection (by wrapping it into /* */) -- it (un)escapes present */ into *\/ automatically - ⌥⌘/ (un)comment the current query (by wrapping it into /* */) -- the GUI element will be found in the Gear Menu by pressing ⌥ • added shortcut ⌫ to Table Content's "Delete selected row(s)" tooltip
* • Comment current Query/SelectionBibiko2009-07-151-15/+182
| | | | | | | - changed comment string to "-- " - fixed bug in uncomment - added gear menu item -- TODO: change menu item title according to selection/current query (coming soon)
* • a right-click at a row within a tableView will select that row before ↵Bibiko2009-07-151-22/+35
| | | | ordering out the contextual menu if not more than one row is selected
* - Make the DBView window the document window. This allows the document to ↵rowanbeentje2009-07-151-2/+10
| | | | | | | | | | 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
* • unified ⌥⌘A in tooltipsBibiko2009-07-141-12/+52
| | | | • added tooltips for "Add new table" and "Refresh table list"
* - Alter the "Allow Null" column in the source view to use a checkbox ↵rowanbeentje2009-07-071-191/+98
| | | | | | | | instead of an autocompleting combo cell. This addresses Issue #323. - Make the appearance of all checkbox columns consistent and disable automatic resizing with table - Correctly flush the CREATE TABLE and status caches on table structure changes to ensure the Extended Info tab is kept up to date with column changes
* - Update the import/export progress sheet title to reflect the current activityrowanbeentje2009-07-061-21/+46
| | | | | - Fix mutliple-table CSV and XML export when a view is selected - data for the view is now correctly exported
* Overhaul the connection screen:rowanbeentje2009-07-061-2533/+35
| | | | | | | | | - Replace the connection sheet with a new connection view - Provide a tab-based selection system for Standard, Socket, and SSH connections, and show only the necessary fields. This resolves Issue #50. - Detect when "localhost" is used in error and alert the user (also to address Issue #50) - Update favorite editing to match connection view - Move connection methods to a new connection controller and tidy up TableDocument
* Add contextual menus to the table content and table relations views. ↵stuconnolly2009-07-021-9/+136
| | | | Completes the implementation of issue #139 as all views now have contextual menus.