aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* Improvements to reporting the correct row count for tables. See issue #141.stuconnolly2009-07-213-10/+20
|
* • 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-185-1/+258
| | | | | • 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-1811-56/+419
| | | | | | | | | 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)
* • fixed: FieldEditorSheet remembers the last sheet size for 'normal' text ↵Bibiko2009-07-181-3/+1
| | | | fields and blob data field variably
* Update copyright year.stuconnolly2009-07-181-2/+1
|
* • 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-173-86/+57
| | | | | - make usage of SPFieldEditor for displaying result data field (incl. blob data) - set to non-editable yet
* • Field Editor Sheet classBibiko2009-07-174-9/+66
| | | | | | - 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
* Remove old SSH tunnel password prompt script.stuconnolly2009-07-172-16/+0
|
* • 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-176-1828/+121
| | | | • deleted in DBVview.xib Field Editor Sheet (out-sourced)
* • some further progress on outsourcing the Field Editor sheet for Content ↵Bibiko2009-07-165-238/+449
| | | | and Custom Query Tab
* • some further work on outsourcing the Field Editor sheet for Content and ↵Bibiko2009-07-164-44/+1348
| | | | 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-163-2/+63
|
* • changed keyboard shortcut for "Choose Database" from ⇧⌘T to ⇧⌘D ↵Bibiko2009-07-161-3/+15
| | | | (⇧⌘T is reserved for Show/Hide Toolbar)
* • fixed: "Custom Query's Gear Menu item "Comment Current Query" is ↵Bibiko2009-07-161-14/+13
| | | | disabled if SP awakes from NIB
* • 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-163-46/+165
| | | | | | | | | | | - ⌘/ (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.
* - Tweak connection view positioning: relayout views to allow centering ↵rowanbeentje2009-07-151-1022/+1043
| | | | within window without edge sticking, increase spacing and alter boundary spacing for better and more consistent appearance
* • Comment current Query/SelectionBibiko2009-07-154-24/+199
| | | | | | | - 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-155-23/+124
| | | | ordering out the contextual menu if not more than one row is selected
* • fixed: suppress cursor appearance change (for resizing a BWSplitView) by ↵Bibiko2009-07-151-0/+1
| | | | setting invalidateCursorRectsForView after the end of an animation
* • 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-153-20/+14
| | | | | - 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-1515-85/+128
| | | | | | | | | | 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
* • unified ⌥⌘A in tooltipsBibiko2009-07-141-12/+52
| | | | • added tooltips for "Add new table" and "Refresh table list"
* • fixed size problem for SSH tab view for SP's minimum window sizeBibiko2009-07-141-58/+76
| | | | | • added tooltip and short-cut (⌥⌘A) to "Add to Favorites" • added tooltip and short-cut (⌥⌘E) to Edit button
* • fixed issue for Connection NIB: TABview jumped downwards while resizingBibiko2009-07-141-4/+6
|
* - Add a "Frequency" menu to automatic updates prefpane, allowing users to ↵rowanbeentje2009-07-131-36/+228
| | | | choose hourly, daily, or weekly automatic checks
* 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