aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCustomQuery.m
Commit message (Collapse)AuthorAgeFilesLines
* Cleaned up Format string is not a string literal (potentially insecure) errorsMarius Ursache2013-11-091-1/+1
|
* Allow opened SQL files to be saved back to the original file, addressing ↵rowanbeentje2013-09-081-4/+1
| | | | | | | | | Issue #1805: - Add new menu item for "Save Query", making the existing item "Save Query As" as an alternate - Track the opened SQL file and used encoding to be able to easily save the same file again - Standardise encoding detection to use the UniversalDetector framework and use that for opened SQL files where the encoding menu is not used
* Rework table content and custom query data loading and storage for speed ↵rowanbeentje2013-08-131-105/+84
| | | | | | | | | 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.
* - Fix all the Xcode 4.6.2 build warnings, and tweak warning settings to ↵rowanbeentje2013-05-211-13/+4
| | | | enable some more
* Issue #1717: Custom query export validation only needs to know the number of ↵stuconnolly2013-05-111-0/+10
| | | | rows of the current result, so don't return the actual result.
* - Move the SPBeginWaitingAlertSheet function to a ↵rowanbeentje2013-04-031-9/+13
| | | | beginWaitingAlertSheetWithTitle:... class method on a new SPAlertSheets class, allowing us to use invocation forwarding to ensure the entire function is executing on the main thread. This allows runloop processing to happen on the main thread, addressing Issue #1676
* - Fix query status and error message title to not always suggest an error ↵rowanbeentje2013-04-011-0/+5
| | | | has occurred, addressing Issue #1670
* - Alter the SPComboPopupButton to ignore clicks started in the left-hand ↵rowanbeentje2013-04-011-4/+3
| | | | | | | part of the button but ended in the right-hand part of the button - Change the button to use "Run All" instead of "Run All Queries" to avoid localisation issues
* Combine the "Run All" and "Run Current/Previous/Selection" buttons into a ↵rowanbeentje2013-03-311-65/+128
| | | | | | | | | | | | 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
* - If date-type fields are cleared, and allow NULLs, save the cell value as ↵rowanbeentje2013-03-061-1/+1
| | | | NULL; this implements Issue #1638
* Fix remaining 10.6/7 build warnings.stuconnolly2013-02-171-5/+5
|
* Fix more wanrings by creating a protocol that delegates of the copy table ↵stuconnolly2013-02-161-9/+11
| | | | should conform to.
* Changing SP_REFACTOR macro to SP_CODAsqlprodev2013-02-141-67/+67
|
* Changes required to merge Sequel Pro r4011 into Codasqlprodev2013-02-141-38/+46
|
* * Fixes #1568 (Enter key was linked to "Run All" while displayed as linked ↵dmoagx2013-02-011-1/+1
| | | | to "Run Current")
* Remove useless init and dealloc method comments and perform general tidy up.stuconnolly2013-01-221-3/+0
|
* Fix Issue #1527, weird display artifacts when reordering custom query ↵rowanbeentje2013-01-221-2/+2
| | | | | | | | results, in two different ways: - Preserve the existing scroll rectangle if reloading the view - Update the scroll rect on the main thread when not reloading the view
* Minor tidy up.stuconnolly2013-01-111-10/+7
|
* - Add names for most threads created by Sequel Pro for easier debugrowanbeentje2012-10-141-1/+2
|
* Improve connection handling and recovery in general, and specifically to ↵rowanbeentje2012-08-181-0/+6
| | | | | | | | | | | address Issue #877: - On servers with very short timeouts set the wait_timeout for the session as well as the interactive_timeout to prevent the connection from dropping frequently - Improve recovery from connection errors, correctly restoring the connection if appropriate and possible - Allow reconnections to occur recursively by altering the internal tracking mechanism - Fix some edge cases where the connection would remain locked incorrectly - Improve error messaging for the "MySQL Server has gone away" network case
* - Add linebreak display in the database processes list, preventing display ↵rowanbeentje2012-08-061-1/+1
| | | | | | | of truncated queries for clarity (Issue #1407) - If SHOW FULL PROCESSLIST isn't on, and the query appears to be truncated (length == 100), add a trailing ellipsis to suggest more content
* - Remove BWToolKit from the project, using ibtool to strip out plugin ↵rowanbeentje2012-08-031-4/+0
| | | | dependencies now that all BW custom elements have been removed; remove last references and build steps.
* - Replace the collapsible BWSplitView on the Query pane with a SPSplitView ↵rowanbeentje2012-07-261-50/+14
| | | | | | | | 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-14/+26
|
* Merged SP r3710 with Codasqlprodev2012-07-051-0/+1
|
* * Fixes some cases of bad localizabilitydmoagx2012-06-231-7/+14
| | | | * In Help viewer [HELP\nTOPIC] would not be recognized as link
* - Improve help search updates while typing, adding basic display for no ↵rowanbeentje2012-06-221-5/+11
| | | | | | | | results found and showing the table of contents if the field is cleared - Permit help searches for the operator "%" as a standalone string - Update localisable strings
* - Fix exceptions with certain kinds of help results, for example for most ↵rowanbeentje2012-06-211-31/+6
| | | | | | | mathematical operators - Add support for more help links
* - Ensure that help results are returned as strings to try and address ↵rowanbeentje2012-06-201-0/+5
| | | | issues with 4.1.x servers (Issue #1378)
* - Fix some text reselection logic when running all queries, which appears ↵rowanbeentje2012-05-311-34/+1
| | | | to be legacy code from r600 (!) when the queries were run in a non-threaded manner. This addresses Issue #1337.
* * Fixes the case of the curious @"es"'sdmoagx2012-05-171-4/+4
|
* - Fix a number of small memory leaksrowanbeentje2012-04-141-0/+3
|
* #ifdef'ing out references to frameworks that are not used in SP_REFACTOR buildssqlprodev2012-03-291-0/+2
|
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-3/+1
| | | | | | | fix nightly builds - Fix warnings
* tweaks to compile on Xcode 4 / 10.6 SDK for SP_REFACTORsqlprodev2012-03-271-2/+11
|
* - Fix exceptions caused when resizing custom query columns which don't map ↵rowanbeentje2012-03-241-3/+3
| | | | to underlying table columns on certain 5.0.x MySQL versions
* - When exporting a query result or filtered table view make sure we're ↵stuconnolly2012-03-201-7/+9
| | | | | | | | 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-65/+64
| | | | | | | | | | | | 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
* - Cleanup: improve compatibility with 10.7 SDK to reduce compiler warningsrowanbeentje2012-02-081-5/+5
|
* When exporting a query result as CSV ensure that we're allowing the exporter ↵stuconnolly2012-01-141-162/+202
| | | | 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.
* - Expicitly cast parameters before passing into NSString formatters ↵rowanbeentje2012-01-091-1/+1
| | | | assuming 64-bit lengths; this addresses exceptions and hangs viewing table contents on 32-bit machines, many thanks to stuart02 for identifying and tracking down this issue
* • fixed issue for line numbering view if associated textView is scrolled ↵Bibiko2012-01-051-1/+1
| | | | | | from origin {0,0}; now it's synchronized • minor speed ups for custom query editor
* - Update code to use NSStrings for NSTableColumn identifiers, as per 10.7 SDKrowanbeentje2011-10-171-38/+21
| | | | | - Update localizable strings
* - Rework table data saving to ensure that cells that should be edited via ↵rowanbeentje2011-10-051-146/+109
| | | | | | | 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
* - Fix editing of binary string values, a regression in r3428; addresses log ↵rowanbeentje2011-09-221-0/+3
| | | | 2665
* Rework linebreak handling in content and custom query result views, as ↵rowanbeentje2011-09-211-19/+35
| | | | | | | | | | | triggered by Issue #1184: - Display table cells on a single line for preview purposes - Display gray pilcrow/reverse pilcrow placeholders instead of linebreaks - If a cell contains linebreaks, automatically trigger sheet editing mode - Handle newly displayed linebreaks in column width detection - If using the up/down arrow keys in a field editor, allow them to select the previous/next line within an editor if appropriat (instead of always moving to the previous/next row)
* Tidy up console/query controller.stuconnolly2011-09-031-0/+1
|
* - Clean up undo manager handlingrowanbeentje2011-08-311-0/+7
| | | | | - Implement an undo manager per tab (strictly speaking, per connection 'document'), addressing Issue #1109.
* Rework editable row checks in views and custom query results:rowanbeentje2011-08-241-31/+21
| | | | | | | | - Only include columns from the same database, even if they share the same table name - If a primary key was found that can be checked, use all the columns specified in the primary key - Correctly escape and format values in primary key columns - Clean up logic and string generation
* merged latest SP_REFACTOR changessqlprodev2011-08-021-12/+0
|
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-30 05:55:15 +0000