aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* Fix incorrectly named preference constant.stuconnolly2009-10-273-3/+3
|
* Change the order of the cancel/remove buttons on the remove field dialog.stuconnolly2009-10-271-3/+3
|
* - When performing threaded data loads, no longer disable the tables and ↵rowanbeentje2009-10-275-11/+49
| | | | instead prevent selection/editing/sorting in code; this prevents the tableviews from going grey during the load and minimises flicker and loss of focussed elements.
* - Set up TableSource to respond to task notifications to prepare for ↵rowanbeentje2009-10-278-51/+206
| | | | | | | threaded queries - Alter task notifications to pass the TableDocument as the notification object so that only the current window responds to the notification, allowing other windows to be fully used while a window is performing a task
* Don't run the add new database sheet modally, thus blocking the main thread. ↵stuconnolly2009-10-264-202/+169
| | | | Part of issue #357.
* Minor export work.stuconnolly2009-10-264-9/+18
|
* • improved error highlightingBibiko2009-10-242-7/+18
| | | | | - remember the start position of query/queries and calculate an offset for error highlighting (this fixes issue 442 mostly) - avoid highlighting of empty "near messages"
* - Apply new document task support to the Custom Query tab, and run all ↵rowanbeentje2009-10-234-117/+308
| | | | | | | | custom queries in a background thread with the task interface active. - Rework custom query result processing to allow display of results as they come in - Fix a memory leak
* Tidy up.stuconnolly2009-10-232-77/+65
|
* - Improve table and task redrawing during threaded table content loadsrowanbeentje2009-10-224-12/+25
| | | | | - Correctly update the table content count when duplicating a row, and cancelling the add. This addresses issue #440.
* - Display the user accounts manager as a sheetstuconnolly2009-10-214-556/+597
| | | | | - Tidy up a bunch of interface controls and bahaviour
* Other than the custom query item, disable all the main toolbar items when ↵stuconnolly2009-10-211-0/+5
| | | | something other than a table or view is currently selected.
* - Improve responsiveness/speed when loading table content by not forcing ↵rowanbeentje2009-10-212-2/+2
| | | | table redraw on new data, and increase the accuracy of the determinate progress as forced redraws are no longer an issue
* Interface labeling.stuconnolly2009-10-212-1/+1
|
* - Add support for createing fields of type BINARY and VARBINARY in the ↵stuconnolly2009-10-213-58/+76
| | | | | | | structure view. Fixes issue #223. - Fix for correctly displaying data within fields of type BINARY/VARBINARY. Fixes issue #348.
* Initial work on threaded task, with an implementation of Table Content view ↵rowanbeentje2009-10-2015-340/+2210
| | | | | | | | | data loading: - Removal of AMIndeterminateProgressIndicatorCell, and addition of a custom fork of YRKSpinningProgressIndicator which fixes bugs, adds threaded drawing, and adds a determinate mode. - Addition of a task system within TableDocument, triggering display of a large central progress indicator and stopping the window from being interacted with in any way that would cause a query while the task is running. - Add threaded TableContent content fetching, including use of the new task system and determinate progress bar; make fixes to improve threading stability and interaction.
* Attempt to fix connection problemmltownsend2009-10-204-33/+29
|
* Some UI tidying up.stuconnolly2009-10-193-361/+889
|
* Add constant for preference key 'AutoConnectToDefault' and replace ↵stuconnolly2009-10-173-2/+4
| | | | occurrences of it's use.
* - Update the row count a bit more intelligently when the table content is ↵rowanbeentje2009-10-171-0/+26
| | | | LMITed or FILTERed but the table content is increasing. This addresses Issue #421.
* Replace the use of hard coded preference keys with constants to prevent ↵stuconnolly2009-10-1733-352/+566
| | | | issues such as the one fixed in revision 1419. All future preference usage should be done so using these constants.
* • fixed NSString pointer reassignment in SPArrayAddition's method ↵Bibiko2009-10-162-4/+32
| | | | | | | 'componentsJoinedAndBacktickQuoted' • improved deletion of rows in tables which have no primary keys - check for duplicated rows first; if no duplicates are found use all columns as 'primary keys' and delete the rows via … WHERE (a='…' AND b='…') OR (a='…' AND b='…') OR …
* - Improve on r1423 by avoiding stringWithFormat: within the query ↵rowanbeentje2009-10-163-12/+26
| | | | | | | | construction loop, enormously reducing memory usage in big loops - Use 64k chunks instead of 256k chunks - seems to give *much* better performance, possibly due to MySQL parsing/cache sizes (?) - When restoring the query console to allow updates again after a loop, trigger a refresh of the view if the console is visible
* • if a table has more than one PRIMARY KEY delete the rows à la DELETE ↵Bibiko2009-10-161-5/+69
| | | | | | | FROM `table` WHERE (`prikey1`='…' AND `prikey2`='…') OR (`prikey1 `='…' AND `prikey2`='…'); - changed error messages slightly while deletion
* Highlight current query preference label change.stuconnolly2009-10-161-117/+767
|
* • fixed SPArrayAdditions method 'componentsJoinedByCommas' to use a ↵Bibiko2009-10-164-22/+111
| | | | | | | | | | | | | mutable string to avoid crashes if array has a very large number of items (malloc error due to reassigning a NSString pointer) • added to SPTableData method - (NSArray *) primaryKeyColumnNames - returns all column names which are set as PRIMARY KEYs - return nil if no PRIMARY KEY is set • improved the deletion of rows - if current table has only one PRIMARY KEY field delete all rows via DELETE FROM table WHERE pri_key IN (…) whereby the deletion query will be splitted into 256k chunks Note: line 1790ff It has to be implemented a workaround for tables with more than one PRIMARY KEY – maybe via DELETE FROM table WHERE ( (pri_key1='…' AND pri_key2='…') OR (… AND …) OR … ) splitted in 256k chunks as well
* • fixed three further typos for: objectForKey:@"NullValue"Bibiko2009-10-164-9/+11
| | | | • allow to enter the NULL value string even if the cell/field's maximal length is set to less then the actual NULL value string length (eg varchar(3) and NULL value string is @"NULL")
* nullValue preference key should be NullValue, which was preventing the ↵stuconnolly2009-10-161-6/+7
| | | | editing of NULL fields in the editor sheet.
* • fixed issue that tables without primary key and Pref is set to ↵Bibiko2009-10-161-8/+12
| | | | | | | | LoadBlobsAsNeeded are not editable • fixed issue if user tries to delete a row from a table without a primary key and Pref is set to LoadBlobsAsNeeded that a warning comes up and the table data keep unchanged • if an error occurred while deleting rows reload the table data automatically for safety reasons • fixed data cell class detection for returning argumentForRow: (typo after changing the internal logic)
* Significant User Management improvements:rowanbeentje2009-10-165-154/+1739
| | | | | | | | | | | | - When reading data from the server, correctly map values to the SPUser object values to prevent data loss - Ask server for priv support; disable unsupported privs in the interface, and only try to grant/revoke supported privs. Fixes errors saving users on MySQL < 6. - Make "check all" and "uncheck all" buttons functional - Add checkboxes for MySQL 6 privs as we already map the data for them - Fix double retain of priv mapping dictionary - Error dialogs stay on screen for longer than half a second - New hosts are now selected for editing when added This addresses some of the issues in Issue #349.
* Add a 'Provide Feedback' menu item to the help menu, which links to ↵stuconnolly2009-10-163-9/+69
| | | | http://www.sequelpro.com/docs/Contact_the_developers.
* Bring Localizable.strings up to date.stuconnolly2009-10-151-0/+0
|
* • fixed issue for closing the sheet for deleting/adding row(s) explicitly ↵Bibiko2009-10-151-13/+15
| | | | | | | | | | due to the fact that SP would crash if an error alert sheet follows • fixed NULL value detection in method 'argumentForRow' Notes: - isSPNotLoaded check has to be implemented in line 1658 - hide blob data "(not loaded)" can be applied for tables which have no primary keys - we have to check the code again here
* • added to SP's Dock menu "Open…" and "Open Recent" menu itemsBibiko2009-10-151-3/+95
|
* • fixed issue while copying a very large number queries from the Console ↵Bibiko2009-10-151-3/+7
| | | | | | Log window - make usage of a NSMutableString to speed it up and to avoid crashes
* • added the chance to set "allowConsoleUpdate"Bibiko2009-10-153-38/+58
| | | | | | | | - if set to YES the Console Log won't be updated after adding a new message even if the window is visible; this is useful if SP has to execute a large number of queries • first steps to increase the deletion of a large number of rows in the Content pane - removed deprecated 'selectedRowEnumerator' - set Console Log's 'allowConsoleUpdate' to NO if more than 10 rows should be deleted - instead of adding the successful deleted row indexes into a new array delete these indexes from the selectedRows NSIndexSet
* - Fix a problem preventing the end of large CSV files from being importedrowanbeentje2009-10-151-1/+1
|
* • SPF file: remember/restore 'connectionEncoding' and 'toolbar visibility'Bibiko2009-10-151-1/+11
|
* • added AppleScript support for "make new document"Bibiko2009-10-142-0/+14
| | | | • fixed validation of the main menu item "Print" - only enabled if one table is selected (otherwise it throws an exception)
* • cleaned and improved AppleScript supportBibiko2009-10-145-47/+89
| | | | | | - now 'activate' & 'quit' works due to that fact that if an app is scriptable the Dock's "Quit" command calls handleQuitScriptCommand: which has to be implemened - fixed issue that SPAppController has to be the delegate for NSApp to support AS - added support for AS à la: "get name of first document" or "close every window" etc.
* - Tweak query locking with MCPStreamingResults to fix certain operations ↵rowanbeentje2009-10-132-3/+21
| | | | releasing locks on different threads from which they were locked (which generates a console message)
* • changed Error Detail HUD window for the connection manager slightly:Bibiko2009-10-132-139/+187
| | | | | | | - suppress spell checking - set left alignment - set a minimum window size - set font size to 12pt (to make it easier to read)
* • cleaned the current Applescript support definitions slightlyBibiko2009-10-134-36/+21
| | | | | - removed unnecessary method 'handleQuitScriptCommand' from SPAppController - set main class to SPAppController
* • Sequel Pro now understands the AppleScript command 'quit' correctlyBibiko2009-10-134-9/+9
| | | | - this fixed issue 434
* • first steps to improve the general tooltip behaviour of ↵Bibiko2009-10-123-19/+60
| | | | | | 'ImageAndTextCell' class • simplified the tooltip of Preference's Favorite List
* • fixed truncating issue of Pref's Favorite List table viewBibiko2009-10-124-346/+463
| | | | | - now favorite name/host will be truncated correctly - added tooltip for truncated favorites
* - Preserve the "host" field for other connection types when socket ↵rowanbeentje2009-10-112-19/+33
| | | | connections are selected, synthesising "localhost" where necessary. This addresses Issue #384.
* - Make the custom query error text selectable - this addresses Issue #425rowanbeentje2009-10-101-31/+37
|
* - Allow link arrows for foreign key links to work when used on a column ↵rowanbeentje2009-10-101-12/+27
| | | | with a foreign key link within the same table - this improves compatibility for Issue #428.
* Remove the use of the logger in debugging the new export redesign as it's ↵stuconnolly2009-10-102-4/+0
| | | | creating the log file on every launch.