aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - Make the DBView window the document window. This allows the document to ↵rowanbeentje2009-07-1514-83/+118
| | | | | | | | | | 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-145-86/+131
| | | | | | | - 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)
* - changed history and favorite selection to insert rather then overwrite ↵mtvee2009-07-141-12/+3
| | | | query editor buffer
* Rework data storage and retrieval in TableContent and CustomQuery backing ↵rowanbeentje2009-07-138-159/+171
| | | | | | | | | | | | arrays, and make some editable CustomQuery improvements: - Switch to using arrays for row storage rather than dictionaries. Use the data column index for table column identifiers. - This fixes Issue #316 and also allows sorting by all custom query result columns using a column index rather than the name - Offers significant speed and memory advantages: result building is now 2x-3x faster, memory used for results storage is 30-40% lower, and result access is slightly faster. (Note full 2x-3x speed results won't be seen - result fetching and mysql binary work isn't included in the timing) - No longer need to fetch the first column of data for tables containing only blob types - Correctly escape strings when editing CustomQuery results - Rewrite NSArrayObjectAtIndex to use the native CFArrayGetValueAtIndex rather than cached selectors - neater code and I think slightly faster
* • added levenshteinDistanceOfWord: to SPStringAdditionsBibiko2009-07-133-6/+75
| | | | | - will be used mainly for auto-matching column names while csv import • fixed bug for in/decreasing the font size by using the two-finger gesture on a trackpad if a textView has a selection
* Issue 333: Problems with single quotes in table name by escaping the single ↵bamse162009-07-111-1/+3
| | | | quotes in queries like SHOW TABLE STATUS LIKE 'I\'m';
* - Add support for the function "NOW()" to resolve Issue #300rowanbeentje2009-07-091-0/+3
|
* - Correctly display errors that occur when editing rows, and ensure the row ↵rowanbeentje2009-07-091-8/+5
| | | | isn't deselected to prevent accidental loss of entered data
* 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-093-2/+3
|
* - Fix connection controller errors with nil strings (bindings?), fixing ↵rowanbeentje2009-07-092-0/+40
| | | | | | | Issue #331 - Make the "optional" socket more optional: add a list of common socket file locations that are checked (instead of just /tmp/mysql.sock), including MAMP to address a common use case
* - Ensure that error IDs are available from CMMCPConnection after connection ↵rowanbeentje2009-07-083-8/+15
| | | | | | | or database selection problems - Detect connection errors due to "Access denied" problems and show a clearer, more appropriate error message
* - Tweak tabbing in TableSource.m to behave correctly following r991 (see ↵rowanbeentje2009-07-071-3/+1
| | | | Issue #323 for notes)
* - Alter the "Allow Null" column in the source view to use a checkbox ↵rowanbeentje2009-07-071-15/+13
| | | | | | | | instead of an autocompleting combo cell. This addresses Issue #323. - Make the appearance of all checkbox columns consistent and disable automatic resizing with table - Correctly flush the CREATE TABLE and status caches on table structure changes to ensure the Extended Info tab is kept up to date with column changes
* MyISAM tables report the exact number of rows in a table in the output of ↵stuconnolly2009-07-072-1/+5
| | | | SHOW TABLE STATUS so don't prefix the row count with '~'.
* - Fix placeholder exports of views containing enums, improving on r959rowanbeentje2009-07-071-1/+7
|
* - Update the import/export progress sheet title to reflect the current activityrowanbeentje2009-07-062-2/+26
| | | | | - Fix mutliple-table CSV and XML export when a view is selected - data for the view is now correctly exported
* - Fixes crashes in the CSV Field Mapping sheet caused by multiple threads ↵rowanbeentje2009-07-061-5/+7
| | | | | | | and autorelease pools (fixes Issue #326) - Reset the field mapping table list whenever it's about to be populated, fixing errors when performing imports into multi databases in the same session
* - Improve handling of the new favorites interface in preferences, ↵rowanbeentje2009-07-062-115/+97
| | | | simplifying the code and fixing one or two edge cases that caused disassociation (desynch) of keychain passwords from the favorite
* - Fix favorites text fields resizing in prefs windowrowanbeentje2009-07-061-1/+2
| | | | | - Correctly select Structure view after connection
* Fixed some memory leaksbamse162009-07-061-8/+12
|
* Overhaul the connection screen:rowanbeentje2009-07-066-794/+1337
| | | | | | | | | - 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
* small fix for add index sheet default behaviormtvee2009-07-021-1/+1
|
* Fix warnings caused by calls to validateMenuItem: being passed to NSObject ↵stuconnolly2009-07-023-3/+3
| | | | by returning YES by default.
* Restore the position of the buttons on the remove table and truncate table ↵stuconnolly2009-07-021-4/+16
| | | | confirmation dialogs, but change the cancel button to the have key equivalent of return.
* Add contextual menus to the table content and table relations views. ↵stuconnolly2009-07-022-0/+36
| | | | Completes the implementation of issue #139 as all views now have contextual menus.
* Add contextual menus to table structure and table index views. Part of issue ↵stuconnolly2009-07-021-0/+23
| | | | #139.
* When displaying the add new table sheet use SPDatabaseData to get the ↵stuconnolly2009-07-012-6/+6
| | | | available storage engines instead of the information_schema.engines table, which doesn't exist in versions other than MySQL 5.
* Fixed the last use connection when you're reordering your connectionsbamse162009-06-301-5/+9
| | | | | | Issue 240: Default connection not being set correctly
* - Correctly SQL export views with interdependencies on other views or ↵rowanbeentje2009-06-272-1/+79
| | | | tables, resolving Issue #313
* Improve custom query timing and display:rowanbeentje2009-06-275-17/+21
| | | | | | | - Amend timing using clock() to timing based on mach_absolute_time() (see revision comment on Google code) - Ensure the time returned is for the requested query and not subsequent helper queries - Use NSNumberFormatter to return a localised "< 0.1 ms" rather than the hardcoded Euro-style "< 0,1 ms"
* • 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
* • fixed issue for sorting the Custom Query table via clicking at the ↵Bibiko2009-06-261-2/+4
| | | | header if no ORDER BY statement was found in the original statement
* - Printing of backgrounds is now correctly separated from the WebKit ↵rowanbeentje2009-06-253-3/+18
| | | | preferences, and no longer links SP to Safari
* - Revert r844, making background printing draw from the print accessory ↵rowanbeentje2009-06-252-3/+1
| | | | view again. Improve by setting background printing to on by default, read on startup.
* • some work on SPFieldEditorBibiko2009-06-252-6/+172
|
* • added SPFieldEditor classBibiko2009-06-252-0/+419
| | | | - (not yet fully implemented)
* • trial to improve the Undo behaviour in the Custom Query editorBibiko2009-06-251-1/+3
|
* - Set an appropriate error message if the MySQL connection could not be ↵rowanbeentje2009-06-251-1/+5
| | | | established because the required tunnel isn't available. Resolves Issue #310.
* - Make changes to the table structure flush the appropriate table data cachesrowanbeentje2009-06-244-8/+34
| | | | | | - SPTableData's columnWithName: now updates caches as necessary to avoid issues - Mark the extended table info view (particularly the CREATE TABLE syntax) as requiring update following table structure changes
* - We have always allowed setting "on update CURRENT_TIMESTAMP" for ↵rowanbeentje2009-06-242-0/+17
| | | | timestamp columns - parse out this information, and now also show if it's set in the structure view. Fixes the setting not appearing to work.
* Change the remove relation confirmation dialog to a sheet as opposed to a ↵stuconnolly2009-06-241-34/+48
| | | | modal dialog.
* - Fix default values behaviour - previously, default values weren't being ↵rowanbeentje2009-06-241-15/+15
| | | | saved. They are now.
* • initial trial to make Custom Query's result table sortable by clicking ↵Bibiko2009-06-242-11/+58
| | | | at a column header
* Remove table column from relations table view as its redundant data.stuconnolly2009-06-241-1/+0
|
* • added separate Menu "Context Menu (Table List)" to DBView.xibBibiko2009-06-242-1/+62
| | | | | | - it's used for the contextual menu for the Table List • fixed: contextual menu in Table List
* - Fix some warnings for setTitlebarStatus methodavenjamin2009-06-241-0/+1
|
* - Modified titlebar display of SSH statusavenjamin2009-06-243-12/+41
|
* • Custom Query fixes:Bibiko2009-06-242-61/+69
| | | | | - preserve table width/order after editing - updated data source code to avoid having the data twice in the memory