aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableContent.m
Commit message (Collapse)AuthorAgeFilesLines
* - Ensure the table row counts are correctly updated when reloading tables - ↵rowanbeentje2013-08-221-0/+2
| | | | this should address Issue #1789 and Issue #1788, and possibly Issue #1787
* Rework table content and custom query data loading and storage for speed ↵rowanbeentje2013-08-131-84/+55
| | | | | | | | | 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-3/+2
| | | | enable some more
* * Composite Foreign Keys will now show all columns in Relation view (workaround)dmoagx2013-04-211-1/+1
|
* - If date-type fields are cleared, and allow NULLs, save the cell value as ↵rowanbeentje2013-03-061-2/+2
| | | | NULL; this implements Issue #1638
* - Fix escaping of backlsashes in non-LIKE clauses, addressing string ↵rowanbeentje2013-02-281-12/+21
| | | | matching with the = and RegExp operators - addresses Issue #1563
* Fix remaining 10.6/7 build warnings.stuconnolly2013-02-171-5/+0
|
* Fix more wanrings by creating a protocol that delegates of the copy table ↵stuconnolly2013-02-161-8/+0
| | | | should conform to.
* Changing SP_REFACTOR macro to SP_CODAsqlprodev2013-02-141-115/+115
|
* Changes required to merge Sequel Pro r4011 into Codasqlprodev2013-02-141-2/+9
|
* Remove useless init and dealloc method comments and perform general tidy up.stuconnolly2013-01-221-13/+5
|
* - Fix a problem where the row count for InnoDB would not be displayed as an ↵rowanbeentje2013-01-211-45/+16
| | | | | | | | accurate value, whatever the Preferences setting, if the Content table was not selected - Clean up code slightly - Remove an unneccessary query being used for the table information view, speeding up display slightly
* Make some improvements to the Table Content Filter, particularly for text ↵rowanbeentje2012-12-231-1/+1
| | | | | | | | | fields: - Rename all "IS" entries to "=", to make the intended purpose clearer, and switch the underlying command to use "= BINARY" instead of "LIKE", producing an exact match instead of replicating LIKE functionality. Move LIKE p to just below the = options. This addresses Issue #1441. - Add entries for "matches RegExp" and "does not match RegExp", implementing Issue #1508. - When adding custom filters, add them by default to the Global group if the favourite isn't an on-disk document, addressing filter loss between sessions; this addresses Issue #1381
* - Allow table content pagination to preserve the current filter type, ↵rowanbeentje2012-11-211-5/+14
| | | | including URL schemes and advanced table-based filters, addressing Issue #1492. (The filter code in question probably needs refactoring to allow it to be simplified in future, but does currently function)
* - Fix exceptions when using the content filter table clear buttonrowanbeentje2012-11-201-1/+1
|
* - Improve use of the table content filter, no longer removing focus from it ↵rowanbeentje2012-11-201-5/+14
| | | | when a filter is triggered by deleting the contents (Issue #1496)
* - When a table content sort is cancelled because a row save operation ↵rowanbeentje2012-11-201-2/+5
| | | | fails, end the task to prevent the window from ending up in a non-responsive state. This addresses Issue #1499.
* - Add names for most threads created by Sequel Pro for easier debugrowanbeentje2012-10-141-3/+4
|
* - Improve filter clearing logic, addressing Issue #1438 (pagination ↵rowanbeentje2012-08-231-11/+9
| | | | controls no longer functioning correctly)
* - Alter table content endEditingFor calls to not be made if the undo ↵rowanbeentje2012-08-211-14/+32
| | | | | | | manager is undoing or redoing, avoiding potential text processing loops when undoing in the search filter field (Issue #996) - If the table is unfiltered, and the table filter field is cleared (eg when typing/changing) don't reload the table
* Move table content filter logic to it's own file.stuconnolly2012-08-151-208/+29
|
* Filter window should observe use table view gridlines preference.stuconnolly2012-08-141-10/+23
|
* - Add linebreak display in the database processes list, preventing display ↵rowanbeentje2012-08-061-0/+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
* - Alter table content Advanced Table Filter query preview area to use ↵rowanbeentje2012-08-011-2/+2
| | | | | | | standard textview backgrounds, getting rid of the surrounding border box. This fixes issues with dark colour schemes. - Fix Advanced Table Filter column sizing to be uniform
* - Remove the last BWToolKit view items from the main nib (DBView) by ↵rowanbeentje2012-07-291-10/+15
| | | | | | | | redesigning the advanced Content Filter window - Tweak SPTextView to support translucent views, or views which are set not to draw their background - Fix Lion compatibility for advanced content filter default operator (Issue #1255)
* * Restore filter window functionalitydmoagx2012-07-251-1/+1
|
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-16/+23
|
* - Fix use of the pagination jump-to-page functions, addressing Issue #1376rowanbeentje2012-06-201-3/+5
|
* * Fixes the case of the curious @"es"'sdmoagx2012-05-171-3/+3
|
* - Manually allocate memory for table selection restoration processing ↵rowanbeentje2012-05-131-3/+7
| | | | instead of relying on the stack; this should address exceptions on background threads when loading tables
* - Alter table filtering to reset pagination when filters are entered; ↵rowanbeentje2012-05-081-4/+9
| | | | pagination should still be correctly preserved in all other cases
* - Manually handle some SPFileHandle memory management to significantly ↵rowanbeentje2012-04-121-0/+3
| | | | | | | improve memory usage during large exports, particularly improving memory which appeared to never be reclaimed - Fix some minor memory leaks throughout the application
* #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/+9
|
* - Fix an exception when attempting to preserve the selection in a table ↵rowanbeentje2012-03-241-3/+12
| | | | | | | | with a primary key with multiple columns of which the first of which is a blob or binary type - Clean up NSNull comparisons and add comments - Clear the selection when filtering a table, allowing reselection to look a little more consistent
* - Rework SPTableData PRIMARY KEY and UNIQUE KEY parsing to use SPSQLParser ↵rowanbeentje2012-03-221-19/+141
| | | | | | | | | | instead of regexes - Support multiple primary keys in the SPTableData parse - If possible, use primary keys to preserve table content selection instead of row indexes - Improve SPTableData primary keys method to use cached value instead of using another query - Preserve selection when filtering tables if appropriate
* Update error message.stuconnolly2012-03-201-1/+1
|
* - When exporting a query result or filtered table view make sure we're ↵stuconnolly2012-03-201-897/+122
| | | | | | | | 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.
* - When cancelling a sort on the table content view, don't display an error ↵rowanbeentje2012-03-201-1/+1
| | | | message
* - When refreshing the table content view, preserve column widths for ↵rowanbeentje2012-03-201-0/+12
| | | | columns which keep the same name, fixing flickering when refreshing (addresses issue #1279)
* - Add a base64Encoding method for convenience when the result should be all ↵rowanbeentje2012-03-181-2/+2
| | | | on one line, and use it in SPTableContent
* - Remove the GPL-licensed Colloquy-sourced NSNotificationAdditions category ↵rowanbeentje2012-03-171-24/+1
| | | | from the project, and replace with an MIT-licensed TCMPortMapper sources NSNotificationCenterThreadingAdditions category. This should fix method clashes in the SP_REFACTOR project, so remove behavioural/namespacing switches.
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-85/+76
| | | | | | | | | | | | 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-10/+10
|
* - Expicitly cast parameters before passing into NSString formatters ↵rowanbeentje2012-01-091-2/+2
| | | | 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
* - Fix two incorrect initialisations; thanks to sqlprodev for spotting theserowanbeentje2011-10-201-1/+1
|
* - Update code to use NSStrings for NSTableColumn identifiers, as per 10.7 SDKrowanbeentje2011-10-171-38/+28
| | | | | - Update localizable strings
* - Rework table data saving to ensure that cells that should be edited via ↵rowanbeentje2011-10-051-178/+146
| | | | | | | 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