aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • fixed: if SPTableData returns for dict: tableStatus key:Rows = NULL (as ↵Bibiko2009-07-201-0/+9
| | | | for information_schema for instance) then try to get the number of rows via "SELECT COUNT(*) FROM table" in order to be able to load the Content Tab
* Remove the dependency on information_schema for table encodings.stuconnolly2009-07-202-5/+23
|
* Include a hard coded list of encodings and collations in SPDatabaseData to ↵stuconnolly2009-07-203-11/+220
| | | | remove the depdendency on the information_schema database when its not available or accessible.
* - When selecting tables - eg from a foreign key link - fall back to a case ↵rowanbeentje2009-07-181-1/+10
| | | | insensitive match if a full match fails, as MySQL can return foreign key references as lowercase rather than actual case
* • added: AMIndeterminateProgressIndicatorCell for global spinning wheelBibiko2009-07-183-1/+248
| | | | | • added: spinning wheel background image • removed warning in TableContent (unused 'j')
* - Update WHERE string buildup - the code now uses equals comparisons rather ↵rowanbeentje2009-07-181-22/+3
| | | | than LIKE, so the quote methods were incorrect. We now use standard escaping without additional LIKE preparation. This resolves Issue #338
* Add the ability to navigate between tables via foreign key relationships, ↵rowanbeentje2009-07-187-56/+401
| | | | | | | | | addressing the first part of #209: - For the first column linked by each foreign key, display a link arrow within the table cell - When clicking on the link arrow, select the reference table and set the table filters to select the clicked value - Also uses the table cell subclass to allow the entire cell to be editable, not just the contained text (addresses #250)
* • finial preparation to make Custom Query's result table editableBibiko2009-07-171-17/+36
| | | | | | | - added editing of blob data - (editing not yet enabled) TODO: progress bar while checking if field is editable and writing large blob data
* • changed in Custom Query:Bibiko2009-07-172-85/+52
| | | | | - make usage of SPFieldEditor for displaying result data field (incl. blob data) - set to non-editable yet
* • Field Editor Sheet classBibiko2009-07-173-4/+27
| | | | | | - added the feature to set "isEditable"; according to "isEditable" GUI elements will be hidden or renamed - if no blob data reduce the minimal sheet size since no segment or quicklook control is needed
* • fixed: caching of QuickLook preview in Field Editor sheet is suppressed ↵Bibiko2009-07-172-17/+28
| | | | by alternating the temporary file name
* • fixed inField Editor Sheet:Bibiko2009-07-171-2/+6
| | | | - if textView was changed update hexView (if demanded) according to the correct data type
* • applied the new class SPFieldEditorController to TableContentBibiko2009-07-174-575/+83
| | | | • deleted in DBVview.xib Field Editor Sheet (out-sourced)
* • some further progress on outsourcing the Field Editor sheet for Content ↵Bibiko2009-07-163-191/+237
| | | | and Custom Query Tab
* • some further work on outsourcing the Field Editor sheet for Content and ↵Bibiko2009-07-162-44/+55
| | | | Custom Query Tab
* • fixed minor issues for "Comment Line/Selection" in Custom QueryBibiko2009-07-161-6/+11
| | | | - esp. for (un)commenting a selection if it ends with a \n
* (no commit message)Bibiko2009-07-162-0/+10
|
* • fixed: Custom Query's gear menu item "Comment Line" will change its ↵Bibiko2009-07-161-0/+3
| | | | title to "Comment Selection" if a selection is given
* • rewrote ⌘/ "comment line" completelyBibiko2009-07-162-28/+106
| | | | | | | | | | | - ⌘/ (un)comment current line only if no selection is given (by using "-- ") -- caret jumps to the next line to (un)comment lines quickly -- # sign will be recognized for uncommenting as well as if the entire line is wrapped into /* */ - ⌘/ (un)comment current selection (by wrapping it into /* */) -- it (un)escapes present */ into *\/ automatically - ⌥⌘/ (un)comment the current query (by wrapping it into /* */) -- the GUI element will be found in the Gear Menu by pressing ⌥ • added shortcut ⌫ to Table Content's "Delete selected row(s)" tooltip
* Issue 240: Default connection not being set correctly, take 2. bamse162009-07-161-2/+8
| | | | | Thanks to Rowan for suggestion where to actually look.
* • Comment current Query/SelectionBibiko2009-07-153-9/+17
| | | | | | | - changed comment string to "-- " - fixed bug in uncomment - added gear menu item -- TODO: change menu item title according to selection/current query (coming soon)
* • initial support for ⌘/ in CustomQuery editor to (un)comment out the ↵Bibiko2009-07-153-1/+36
| | | | | | current query or selection by inserting "# " at the begin of each line - Note: not yet finished completely
* • a right-click at a row within a tableView will select that row before ↵Bibiko2009-07-153-1/+83
| | | | ordering out the contextual menu if not more than one row is selected
* • fixed dealloc of 'suggestions' in SPNarrowDownCompletionBibiko2009-07-152-22/+14
| | | | | • deleted (void)paste hook from CMTextView (not needed anymore) • decreased iteration cycles for 'normal' completion (ESC) by getting only the unique words from the current textView
* • narrow-down completion (F5)Bibiko2009-07-151-20/+10
| | | | | - added view icon for Views - improved some tiny code snippets
* - Update r1003 to also work with views (fixes Issue #335)rowanbeentje2009-07-151-1/+2
|
* - 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
|