aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • 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
* • in Table Content the button status of "edit spreadsheet or sheet-like" ↵Bibiko2009-08-113-16/+73
| | | | | | | | | 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.
* • improved identification of the field origin for editing in Custom QueryBibiko2009-08-111-5/+33
| | | | | - first try to found a primary key for the to be edited field in the result set - fixed some backtick quotings
* Rework data loading in TableContent:rowanbeentje2009-08-113-491/+364
| | | | | | | | | - Data loading now only occurs in one place in the code. This improves consistency and fixes a number of actions which used to trigger a full table reload followed instantly by a filter when the action was performed - If "Reload data after..." prefs are unticked, no longer load the data (ie the preference now works) - Make table count text more consistent and useful - Fix a number of small position-saving type problems with filters and limits active. This fixes Issue #200. - Clean up and standardise the code dealing with data storage - only one data storage array is now used.
* • added to Custom Query table editing max text length validationBibiko2009-08-103-2/+18
| | | | | • SPFieldEditorController: - improved textViewDidChangeSelection: to eg saves to correct rendered glyph after inserting a non-base char + base char if this combination was typed as last glyph before pressing the OK button (otherwise foo¨ will be saved instead of fooü)
* • added to the FieldEditorSheet a max text length validationBibiko2009-08-103-6/+63
| | | | | | • added the max text length validation for the TableContent while editing in the FieldEditorSheet • reinvoked the validation of the max text length for TableContent editing while editing in a cell • fixed in TableContent: prevent the editing of data cells in gray if the cell displays the gray NULL value
* • added field name to Field Editor SheetBibiko2009-08-084-3/+11
| | | | | | - initial support (not yet finished) Note: maybe add information about field type, max length as attributed string
* When selecting a cell to edit that is either a blob or text field and hasn't ↵stuconnolly2009-08-081-28/+29
| | | | already had it's content loaded, only load the data for the selected cell and not the entire row. Fixes issue #288.
* Rename MainController to SPAppController.stuconnolly2009-08-085-13/+13
|
* - Fix SSH tunnel support for private/public keys following framework ↵rowanbeentje2009-08-083-6/+13
| | | | upgrade changes
* Rename print accessory XIB.stuconnolly2009-08-072-2/+2
|
* - Fix "Add to favorites" behaviour when the user has no favourites (This ↵rowanbeentje2009-08-072-21/+20
| | | | | | | addresses Issue #354) - Improve favorites saving including names with anonymous users
* Rename Keychain class.stuconnolly2009-08-0710-22/+22
|
* Source tidy up and missing SVN properties.stuconnolly2009-08-0713-35/+33
|
* - Fix a memory leak when filtering the server variablesstuconnolly2009-08-072-28/+38
| | | | | | - 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.
* Don't run the add relation sheet application modally and thus block the ↵stuconnolly2009-08-071-19/+14
| | | | entire main thread until it is dismissed. Note that is not only sheet that is being run using runModalForWindow, which is subsequently causing the same issue. Fixes issue #357.
* Small tidy up and improvements to new export controller.stuconnolly2009-08-061-48/+37
|
* New shortcuts:stuconnolly2009-08-061-4/+1
| | | | | | | - Shift+Cmd+A to add the current connection to your favourites if it doesn't already exist - Shift+Cmd+I to invoke importing - Shift+Cmd+S to display the create table syntax panel
* • enabled "Open" menu item to open SQL filesBibiko2009-08-063-53/+105
| | | | | - 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-063-2/+145
| | | | | - 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
* • corrected SVN propertiesBibiko2009-08-064-4/+4
|
* - Add history menus to the history back/forward buttons for faster ↵rowanbeentje2009-08-062-1/+87
| | | | navigation; click and hold buttons to view navigation menu
* • 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-055-5/+54
| | | | | | | 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 sortorder of tables in export multiple tables as CSV/XML accesory viewbamse162009-08-051-3/+15
|
* In addition to fn+return give the OK button in the content edit sheet the ↵stuconnolly2009-08-051-2/+3
| | | | key equivalent cmd+return. Implements #321.
* - Fix some small memory leaks when changing tablesrowanbeentje2009-08-044-10/+24
| | | | | - Fix the history navigation to correctly switch across databases without invalid history states
* • initial support for open/save connection files (*.spf)Bibiko2009-08-044-0/+176
| | | | | | | | | - 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 -
* (no commit message)Bibiko2009-08-041-0/+4
|
* • 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-042-0/+5
| | | | | - 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
* • some corrections for Custom Query completionBibiko2009-08-041-24/+14
| | | | | | - fixed issue if caret is inside `` for the narrow-down completion - fixed issue to add all 'Functions' for the "normal" completion - some minor code cleaning
* This shouldn't actually be negated as a return value of YES indicating that ↵stuconnolly2009-08-031-1/+1
| | | | NULLs are allowed is correct and we can color it if it also matches the user's NULL placeholder.
* • add Menu Item "Insert NULL value" SHIFT+CTRL+NBibiko2009-08-034-2/+37
| | | | | | | - it inserts the value set in the preferences • a NULL value will be displayed greyed in the Custom Query result • make usage of NSArrayObjectAtIndex() in TableContent for tableView:willDisplayCell - and negated the NULL checking for column (is NULL allowed)
* When blob/text fields are loaded on demand also color them light gray if ↵stuconnolly2009-08-031-1/+1
| | | | they are actually NULL.
* Use light gray rather than gray for displaying NULLs and blog/text fields ↵stuconnolly2009-08-031-2/+2
| | | | that aren't loaded.
* 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.
* Display the user specified NULL value placeholder in grey when displaying a ↵stuconnolly2009-08-031-26/+27
| | | | table's content. Fixes issue 337.#
* - Implement live filtering of the server variables table viewstuconnolly2009-08-032-76/+91
| | | | | | - Update the save variables button to save the current filtered variables if necessary - Remove old/unused NSSplitView code
* In the field editor sheet:stuconnolly2009-08-031-68/+87
| | | | | | - Make some of the QuickLook format menuitem name's uppercase. - Run both the save and open panels as sheets to prevent blocking the entire app.
* • button tooltip for "Show / Hide Table Information" toggles according to ↵Bibiko2009-08-022-0/+9
| | | | | | | its status • after editing a field in Custom Query table scroll to last selected row after data refreshing - (TODO: should be improved in near future)
* - Add a tooltip to the table information pane toggle buttonrowanbeentje2009-08-022-26/+41
| | | | | | | - 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
* Overhaul CSV import functionality:rowanbeentje2009-08-021-116/+244
| | | | | | | - When selecting CSVs SP will attempt to auto-detect the line endings to use - Throw an error if the CSV to be imported appears to have more than 512 columns, usually due to wrong line ending/quote/etc selection - Rewrite the CSV parser completely. New version correctly deals with CSV line terminators which are escaped or in enclosed content, correctly deals with quote strings which are the same as escape strings, and fixes a number of small edge cases. Performance on very long complex strings is slightly slower (~1.5 slower on long strings) but on large but simple tables is faster (~2.2x faster); memory usage is ~1.3x as high but all autoreleased. This addresses Issue #252.
* - Fix an errant NSLog in TableSourcerowanbeentje2009-08-017-95/+336
| | | | | | - 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-012-19/+34
| | | | search field can be resized. Addresses issue #339.
* The size of the import array only needs to be counted once.stuconnolly2009-07-311-5/+6
|
* • Favorite Preferences - Favorite name issues fixed:Bibiko2009-07-312-0/+83
| | | | | | | - Trap and control the 'name' field of the new added favorite. If the user pressed 'Add Favorite' the 'name' field is set to "New Favorite". If the user do not change the 'name' field or the user deletes the field content it will be set to user@host automatically. This also fixes the issue for empty names. - focus is set to 'Host' field after "Add Favorite" - focus is set to 'Name' field after "Duplicate Favorite"
* - Update the 'this table does not support relations' to be a little more ↵stuconnolly2009-07-301-1/+1
| | | | | | | 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-306-1/+338
| | | | toolbar item to navigate backwards and forwards. TBC!