aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • fixed and improved several issues for sorting the Custom Query result table:Bibiko2009-07-281-8/+59
| | | | | | - better ORDER BY detection - (try to) insert ORDER BY clause at the correct position (e.g. "SELECT * FROM A LIMIT 10 - ORDER clause has to be inserted before LIMIT) - preserve the sort order after editing a field
* Improve TablesList significantly:rowanbeentje2009-07-288-375/+813
| | | | | | | | - If there are twenty or more tables, show a table quicksearch/filter at the top of the list, and update the rest of the code to match. This addresses issue #178. - Select tables and views alphabetically by user's current locale (instead of default MySQL "A B C a b c") - When adding or duplicating tables, insert them at the correct point - Fix a number of minor display bugs caused by incorrect interaction with the tables list caches
* • Editing in Custom Query:Bibiko2009-07-262-29/+49
| | | | | - now fields are also identified via the database which the field belongs to in order to allow to select/join/etc. fields coming from different databases and to improve the unambiguity of the field origin - sped up editing check for fields with no table or database origin (then no "select count(*)" is needed)
* - Add keyboard shortcuts for Add and Delete buttons in Table Relations panerowanbeentje2009-07-261-0/+9
| | | | | | | | - Remove hidden, non-implemented menu in create table relation add dialog to improve tabbing through fields in the popup - Add cancel shortcut in the table relation add dialog - Prevent table relations table cells from being edited, as edit support isn't present yet - clean up tooltips to fix references to Indexes
* - Tweak table information panel to show scrollbars if it's resized to a ↵rowanbeentje2009-07-266-4/+44
| | | | | | | | position that would hide content - Store collapse state of table information panel in preferences - Apply a double fix for BWSplitView/NSSplitView+BWAnchoredButtonBar not informing delegates of resizes - correctly inform original BWSplitView delegates of resizes, and allow BWAnchoredButtonBar registered delegates to recieve the original split view resize notifications. This fixes database menu resizing in synch with splitview resizing for improved/consistent look and feel.
* - For custom query result columns which map to SQL fields, check the column ↵rowanbeentje2009-07-242-3/+60
| | | | | | | width memory to set column widths - Save custom query result columns back to the master column width store for columns witch map to SQL fields
* - Fix editing of results including decimalsrowanbeentje2009-07-231-5/+3
| | | | | - Enable custom query result editing
* To fix query logging not working, initialize delegateQueryLogging to YES ↵stuconnolly2009-07-231-0/+3
| | | | upon connection initialization as well as setting the value based on the user's preferences during initiateMySQLConnection in SPConnectionController. Also, initialize delegateResponseToWillQueryString when the connection's delegate is set and revert back to simply calling the delegate method willQueryString:connection: as opposed to using the selector cache as its currently not working. Might need to look into restoring this if we incur a big performance hit after this revision.
* Remove delegate calls asking for SP specific TableDocument ivars, replacing ↵stuconnolly2009-07-221-2/+20
| | | | them with more generic delegate methods.
* - Allow the reconnection dialogs to function correctly if anything other ↵rowanbeentje2009-07-221-3/+5
| | | | | | | than "Disconnect" is selected - Fix tunnel restarts
* Disable updating the number of rows in the selected table in the table data ↵stuconnolly2009-07-212-4/+4
| | | | cache within getNumberOfRows after the discovery of much larger issue.
* - Rename "TunnelPassphraseRequester" to "SequelProTunnelAssistant" for ↵rowanbeentje2009-07-213-4/+4
| | | | | | | clarity (sorry nightly testers) - Improve assistant copy from being in a script to resources copy phase
* - Clean up logic flow, moving column and row capture to within ↵rowanbeentje2009-07-211-6/+6
| | | | trackMouse:inRect:ofView:untilMouseUp: instead of hitTestForEvent:.
* - Improve the TextAndLinkCell (foreign key link arrows) to make the arrows ↵rowanbeentje2009-07-212-4/+68
| | | | behave like proper buttons, allowing clicking and dragging out to cancel the click, and highlight states
* - Fix a reproducible crash when exporting tables caused by a string being ↵rowanbeentje2009-07-211-3/+5
| | | | autoreleased; this addresses Issue #341
* Merge framework integration branch back to trunk. Summary of changes:stuconnolly2009-07-2151-2474/+373
| | | | | | | | | | | | | | | - Includes all custom code from subclasses CMMCPConnection and CMMCPResult, meaning they have subsequently been removed from the project. - All previous Sequel Pro specific code in the above subclasses has been removed in favour of the delegate (currently set to TableDocumet) informing the framework of such information. - All references to CMMCPConnection and CMMCPResult have subsequently been changed to MCPConnection and MCPResult. - Framework includes MySQL 5.1.36 client libraries and source headers. - Framework is now built as a 4-way (32/64 bit, i386/PPC arch) binary. - All import references to <MCPKit_bundled/MCPKit_bundled.h> have been changed to <MCPKit/MCPKit.h>. - New script 'build-mysql-client.sh' can be used to build the MySQL client libraries from the MySQL source. See the script's header for a list of available options or run it with no arguments to display it's usage. Note that there are still a few changes to be made to the framework with regard to removing Sequel Pro specific calls to the delegate. These however can be made later on as they have no effect on functionality and are merely design changes. Also, note that any future development done on the framework should be made to be as 'generic' as possible, with no Sequel Pro specific references. This should allow the framework to be integrated into another project without the need for SP specific code.
* • fixed bug for table sorter in Custom Query:Bibiko2009-07-211-0/+3
| | | | - remove all comments before changing/adding the ORDER clause (it can happen that the original ORDER clause was commented out and the table sorter wouldn't work)
* • fixed bug if the table sorting query in Custom Query gave an errorBibiko2009-07-212-12/+20
| | | | | | - SP tried to select the erroneous part in customQueryView which could lead to an range exception - now it shows a proper error message - it suppresses column highlighting and setting of the NSSortIndicator
* • bug fixed for the case that table status returns NULL for number of rows:Bibiko2009-07-211-1/+1
| | | | - object for key 'Rows' should be a NSString not a NSNumber
* 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-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
generated by cgit v1.2.3 (git 2.25.1) at 2024-12-05 00:53:51 +0000