aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - Improve stability when flipping between tables with the content view selectedrowanbeentje2009-11-042-12/+13
|
* - Add task support to all the main interface viewsrowanbeentje2009-11-0414-433/+666
| | | | | | | | - Improve task support on previously supported views - Use a threaded task load for all initial table loads - Support threaded task loads for table content loads, reloads, sorts, and filters - Improve upon previous threaded task loads by minimising view updates and supporting updates of the existing data arrays where valid
* • cleaned code for SPTableInfo.mBibiko2009-11-031-93/+86
| | | | • added NSLocalizedStrings
* Added comments to help with explaining some of the Core Data concepts.mltownsend2009-11-031-10/+31
|
* • added basic PROCEDURE and FUNCTION INFORMATION Bibiko2009-11-022-66/+143
| | | | • change "multiple tables" to "multiple selection" and header to "INFORMATION" if a multiple selection is given
* • Finish off implementation to set the default selection view mode. Issue #249avenjamin2009-11-021-4/+22
|
* • fixed: return correct SPTableTextFieldCell 's cellSize for tooltip ↵Bibiko2009-11-022-5/+19
| | | | expansion frame rect
* • Initial work to set the default view mode when connecting. Issue #249avenjamin2009-11-023-68/+132
| | | | • Organize constants into groups
* - Tweak connection locking to avoid occasional NSLock warnings when running ↵rowanbeentje2009-11-011-8/+13
| | | | | | | custom queries - Add error connection to query reselection to avoid exceptions when editing queries while running them
* 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)