aboutsummaryrefslogtreecommitdiffstats
path: root/Source/TableDocument.m
Commit message (Collapse)AuthorAgeFilesLines
* • 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
* Overhaul the connection screen:rowanbeentje2009-07-061-705/+202
| | | | | | | | | - 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
* • fixes for Create Syntax HUD window:Bibiko2009-06-261-1/+1
| | | | | | | - added minimum size to avoid overlapping context and header - now keyboard, mouse events are working for scrolling - bound font to CustomQueryEditorFont • removed tiny double code in TableDocument
* - Printing of backgrounds is now correctly separated from the WebKit ↵rowanbeentje2009-06-251-0/+1
| | | | preferences, and no longer links SP to Safari
* - Revert r844, making background printing draw from the print accessory ↵rowanbeentje2009-06-251-3/+0
| | | | view again. Improve by setting background printing to on by default, read on startup.
* - Modified titlebar display of SSH statusavenjamin2009-06-241-4/+17
|
* • fixed several problems for alerting an error sheet inside of a ↵Bibiko2009-06-231-1/+18
| | | | didEndSelector: of an other sheet
* - Add BWToolkit Framework to allow for better control over some UI elementsavenjamin2009-06-231-49/+49
| | | | | | | - Add TABLE INFORMATION toggle button - shows/hides pane - Used new UI elements in Copy Table Syntax HUD window - Misc other changes - NOTE: more splitview changes to be made
* - Allow connections via SSH tunnels to reattempt using the specified host ↵rowanbeentje2009-06-211-9/+45
| | | | | | | | | if 127.0.0.1 was retried automatically. - Store the SSH debug logs and allow viewing on connection error - Clean up CMMCPConnections on connection failure - Fix connection keepalive instantiation
* • added to TableContent.m:Bibiko2009-06-191-1/+1
| | | | | | | | - (NSArray * )currentDataResult -- like currentResult but returns "BLOB" for blob data and a base64 encoded string for images à la <IMG SRC="data:image/auto;base64,"> - (NSString * ) base64EncodingOfData:(NSData * )data withLineLength:(unsigned int)lineLength -- it returns a base64 encoded string of data • changed: currentDataResult is now called for printing from the Table Content Browser
* • added to SPArrayAdditions.h: NSArrayObjectAtIndex() inline functionBibiko2009-06-181-2/+3
| | | | | | | | | - id o = NSArrayObjectAtIndex(anArray, index) :== id o = [anArray objectAtIndex:index] - this speed up it ~3µs per call - replaced that inline function for such calls within loops to speed up them • used IMP function pointers for keepAlive calls within queryString: • set -O3 (Fastest) compiler option • allow in preference pane "Tables" to set the Limit up to 50000
* • some tiny improvements to speed up queryString:Bibiko2009-06-181-1/+7
| | | | | | | | | - cache the function pointer for delegate willPerformQuery: - if Console Log window is NOT visible suppress reloadData and scrolling to last line (this speeds it up remarkably); if user opens the Console log window it will be synchronized - timeIntervall for execution time will be divide by CLOCKS_PER_SEC in [NSString stringForTimeInterval] - removed for utf8 enc in cString the return UTF8String (no significant difference) • now execution time shows only the time for mysql_real_query