aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* Incorrect pref key name.stuconnolly2009-11-011-1/+1
|
* Improve truncating of table names (by appending ...) using SPTableTextFieldCell.stuconnolly2009-11-012-0/+88
|
* - Fix a crash when opening .spfs caused by an autorelease - revert to ↵rowanbeentje2009-11-012-1/+10
| | | | | | | manual memory management instead of r1455 approach, but fix leaks - Fix an exception caused by closing .spf windows while "Connecting..." windows were open
* Enable the display of vertical grid lines in the table relations table view.stuconnolly2009-11-012-0/+15
|
* Faster loop approach.stuconnolly2009-11-011-4/+2
|
* When checking the existance of the ENGINES table within the ↵stuconnolly2009-11-011-2/+2
| | | | information_schema database, use its exact name case-wise, to avoid problems on case sensitive filesystems (i.e. linux).
* - Revert all threaded table loading in TableContent, albeit leaving task ↵rowanbeentje2009-10-302-50/+14
| | | | functionality in place. This addresses r447, and threading will be reimplemented at a per-task level in the near future.
* Got rid of a crash when using the User Manager and closing last Table ↵mltownsend2009-10-294-62/+53
| | | | Document. May be leaking now, not sure. Still needs some work.
* • as default add the UTF-8 BOM (byte order marker) \xEFBBBF to a MySQL ↵Bibiko2009-10-293-1/+7
| | | | | | | | | dump file - this should simplify the loading of such a file in other text editors - to avoid the writing of that BOM one can add to Sequel Pro's preference plist the boolean key “NoBOMforSQLdumpFile” and set it to YES Note: If it turns out that this BOM causes problems one could add a checkbox for it to the NSSavePanel for instance later on.
* • fixed issue: avoid executing of the last query of a set of queries in ↵Bibiko2009-10-291-3/+8
| | | | the Query Editor if the last query is empty or it is a "DELIMITER" statement to come up with the result of the last valid query or to avoid an unnecessary error message
* Before terminating the SSH tunnel task check that it's actually running to ↵stuconnolly2009-10-291-2/+7
| | | | accommodate tunnels that suddenly disappear.
* Replace hard coded occurrences of preference key DefaultFavorite with a ↵stuconnolly2009-10-294-8/+10
| | | | constant.
* Replace the multiple occurrences of hard coded toolbar identifiers for the ↵stuconnolly2009-10-285-62/+76
| | | | main toolbar with constants.
* Missing space when appending extra field info when creating a new field. ↵stuconnolly2009-10-271-0/+1
| | | | Fixes original problem reported in issue #445.
* 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-277-13/+119
| | | | | | | 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-263-106/+109
| | | | 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-233-77/+235
| | | | | | | | 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-213-40/+66
| | | | | - 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-211-1/+1
|
* Initial work on threaded task, with an implementation of Table Content view ↵rowanbeentje2009-10-2012-303/+700
| | | | | | | | | 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-203-19/+15
|
* Some UI tidying up.stuconnolly2009-10-191-2/+2
|
* 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-1732-352/+552
| | | | 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
* • 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-164-45/+117
| | | | | | | | | | | | - 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-162-0/+10
| | | | http://www.sequelpro.com/docs/Contact_the_developers.
* • 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
* • 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-141-0/+56
| | | | | | - 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.