aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCustomQuery.h
Commit message (Collapse)AuthorAgeFilesLines
* Rework table content and custom query data loading and storage for speed ↵rowanbeentje2013-08-131-2/+3
| | | | | | | | | increases and lower memory usage: - Add a new SPMySQLStreamingResultStore class to SPMySQL.framework. This class acts as both a result set and a data store for the accompanying data, storing the row information in a custom format in a custom malloc zone. - Amend SPDataStorage to wrap the new class, so original result information is stored in the one location in the custom format. Any edited information is handled by SPDataStorage for clean separation - Rework table content and custom query data data stores to use the new class. This significantly speeds up data loading, resulting in faster data loads if they weren't previously network constrained, or lower CPU usage otherwise. The memory usage is also lowered, with the memory overhead for many small cells being enormously reduced.
* Issue #1717: Custom query export validation only needs to know the number of ↵stuconnolly2013-05-111-24/+22
| | | | rows of the current result, so don't return the actual result.
* - Fix query status and error message title to not always suggest an error ↵rowanbeentje2013-04-011-0/+1
| | | | has occurred, addressing Issue #1670
* Combine the "Run All" and "Run Current/Previous/Selection" buttons into a ↵rowanbeentje2013-03-311-6/+18
| | | | | | | | | | | | single button with dropdown menu with ability to change the default action: - Create a new SPComboPopupButton class; this subclasses NSPopupButton to retain the ability to show the popup menu, but only when the right-hand side of the button is pressed, allowing the rest of the button to perform the click action - Combine the previous two "Run" buttons on the Custom Query view into a new SPComboPopupButton - Move the Run menu items from the gear menu into the Run button popup menu so they can be discovered more easily (and the shortcuts seen more easily) - Add a menu item to switch the button's default action, which also swaps all associated shortcuts - Clean up associated logic This implements Issue #1569
* Fix more wanrings by creating a protocol that delegates of the copy table ↵stuconnolly2013-02-161-2/+3
| | | | should conform to.
* Changing SP_REFACTOR macro to SP_CODAsqlprodev2013-02-141-28/+28
|
* Changes required to merge Sequel Pro r4011 into Codasqlprodev2013-02-141-0/+10
|
* Fix warnings due to not conforming to 10.6 protocols.stuconnolly2013-01-241-4/+1
|
* Tidy up custom query header.stuconnolly2013-01-231-23/+20
|
* - Replace the collapsible BWSplitView on the Query pane with a SPSplitView ↵rowanbeentje2012-07-261-17/+3
| | | | | | | | configured from code - Replace the other NSSplitView on the Query pane with an equivalent SPSplitView to allow easier constraint management - Fix SPSplitView collapsible subview resizing to only amend the collapsible subview's autoresizing mask along the axis of the split view, leaving the other axis untouched to avoid problems with subviews not correctly picking up window resize changes when they were collapsed
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-18/+34
|
* Merged SP r3710 with Codasqlprodev2012-07-051-0/+1
|
* - Fix some text reselection logic when running all queries, which appears ↵rowanbeentje2012-05-311-3/+0
| | | | to be legacy code from r600 (!) when the queries were run in a non-threaded manner. This addresses Issue #1337.
* - When exporting a query result or filtered table view make sure we're ↵stuconnolly2012-03-201-1/+1
| | | | | | | | including the entire content of BLOBs, not just what we display. Fixes issue #1124. - Move SPTableContent's table view datasource and delegate methods to separate categories in order to reduce it's size.
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-7/+6
| | | | | | | | | | | | exceptions as database structure retrieval is currently missing! Further work on SPMySQLFramework integration: - Improve SPMySQL framework build settings including correct ppc builds and a Distribution configuration for the build distributions to match - Add new convenience querying and result methods to the framework - Amend Sequel Pro source to use the new SPMySQL.framework methods everywhere, replacing MCPKit methods where they differ and improving some functions - Remove MCPKit from the source - Fix a number of warnings on Release-style builds
* When exporting a query result as CSV ensure that we're allowing the exporter ↵stuconnolly2012-01-141-0/+1
| | | | decide how to deal with NULLs rather than passing them already converted to the user's placeholder prefernce which results in them being quoted. Fixes issue #1281. Also, general tidy up.
* - Update code to use NSStrings for NSTableColumn identifiers, as per 10.7 SDKrowanbeentje2011-10-171-1/+1
| | | | | - Update localizable strings
* - Rework table data saving to ensure that cells that should be edited via ↵rowanbeentje2011-10-051-0/+1
| | | | | | | the edit sheet aren't then overwritten by the cell value, potentially causing data truncation in 10.5. This addresses Issue 1196. - Consolidate field editing in sheet logic
* - Review changes made in r3376 and revert a number of regressionsrowanbeentje2011-08-141-3/+2
|
* merged latest SP_REFACTOR changessqlprodev2011-08-021-2/+3
|
* - Rework a number of protocol defintions when refactoring to fix IB ↵rowanbeentje2011-06-211-3/+2
| | | | compilation warnings
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-2/+11
|
* - Fix a number of warnings for DBView.xib by moving some 10.6-only code ↵rowanbeentje2011-05-081-4/+3
| | | | | | | from a #ifndef SP_REFACTOR/#else/#endif to just a #ifdef SP_REFACTOR/<protocol declaration>/#endif, and remarking a few items as IBOutlets - Update localisable strings
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-2/+0
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-0/+22
| | | | UI code from functional code
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-071-0/+1
|
* - Fix more compiler warningsrowanbeentje2011-03-041-1/+4
|
* • fixed issue to highlight the correct current query after undoing, i.e. ↵Bibiko2011-01-141-0/+3
| | | | | | | do not using the cache • added SP_SELECTED_TEXT_RANGE shell variable for Bundle support of scope Input Text • added 'insertText', 'setText', 'setSelectedTextRange' JavaScript functions to window.system bridge
* • fixed several issues for validation and other stuff while editing of ↵Bibiko2011-01-111-1/+1
| | | | MySQL data tables if user re-ordered columns
* • Bundle command supportBibiko2010-12-071-0/+1
| | | | | - fixed issue for commands without assigning a key equivalent - output table meta data about type, type grouping, length, auto_inc, PRI key etc. for Data Table scope commands and sequelpro url scheme command ExecuteQuery
* - Show and hide the custom query info area based on whether custom query ↵rowanbeentje2010-12-041-0/+2
| | | | | | | | | | errors occurred, starting off hidden - Add "errors"/"no errors" prefix to the custom query status area - Add an import cancelled line to the import error list when stopping imports after errors - Fix custom query error highlighting by scrolling to the error - Update localisable strings
* • started to implement auto-completion for aliasesBibiko2010-11-041-1/+1
| | | | | - first sketch should work for 90% of all cases - fine-tuning will follow soon - this follows issue 880
* • convert the Field Editor Sheet into a document-modal sheet, i.e. now the ↵Bibiko2010-10-291-1/+5
| | | | | | | | sheet doesn't block the entire app - fixed various layout issues - fixed some tiny memory leaks • fixed tiny memory leak in MCPStreamingResult
* Tidy up.stuconnolly2010-10-191-2/+0
|
* • further improvements for in cell editing in CustomQuery tablesBibiko2010-08-271-2/+3
| | | | | | | | - simplified code - reduced number of queries for edit status - WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well • for TableContent fixed tooltip display - note: improvements as for CustomQuery follow soon
* • removed onMainThread for [Content/CustomTable makeFirstResponder] to ↵Bibiko2010-08-261-0/+5
| | | | | | | | | avoid the trampoline exceptions • unified error message while cell editing • in Custom Query table cell editing errors are displayed as tooltips and added these message if edit event comes from the keyboard • fixed: check edit status in Content Tables only for views to avoid unnecessary queries • used [SPCustomQuery fieldEditStatusForRow:andColumn:] consequently to simplify code
* • outsourced control:textView:doCommandBySelector: stuff to SPCopyTable ↵Bibiko2010-08-241-3/+4
| | | | | | | | | | since we need that for Content and Custom Query table; only class specific stuff like ESC trapping will handled in the actual class • enabled in cell editing for Custom Query tables - also added spreadsheet button to Custom Query status bar • fixed ESC trapping: F5 can be used for completion • simplified [SPCopyTable keyDown:] for trapping ENTER/RETURN key • some code cosmetics
* • added context menu for Copy, Copy with Header, Copy as SQL Insert to ↵Bibiko2010-08-241-1/+1
| | | | Custom Query table
* • added SPBeginWaitingAlertSheet() routine which offers the chance to ↵Bibiko2010-08-191-0/+1
| | | | | | display an alert sheet which waits for the change in the didEndSelector method of a passed class NSInteger variable • applied the SPBeginWaitingAlertSheet routine to Pref > Editor's check for unsaved color themes and in SPCustomQuery's sheet about Stop/Continue/Run All if a query failed after executing "Run All"
* Rename CMCopyTable to SPCopyTable.stuconnolly2010-08-191-2/+2
|
* - Apply column autosizing improvements to custom query loadingrowanbeentje2010-08-161-0/+9
| | | | | | | | - Move Table Content progress tracking onto the main thread's load timer - Improve thread safety when autosizing - Improve autosize to not contrain wide columns as much in tables where all columns can be shown, or if the column is double-clicked to size. (This completes work on Issue #271 and Issue #272)
* Rename CustomQuery as SPCustomQuery.stuconnolly2010-07-061-0/+236
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-10 06:00:28 +0000