aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableContent.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.
* Fix remaining 10.6/7 build warnings.stuconnolly2013-02-171-34/+33
|
* Fix more wanrings by creating a protocol that delegates of the copy table ↵stuconnolly2013-02-161-1/+2
| | | | should conform to.
* Changing SP_REFACTOR macro to SP_CODAsqlprodev2013-02-141-46/+46
|
* Fix warnings due to not conforming to 10.6 protocols.stuconnolly2013-01-241-4/+1
|
* - Fix a problem where the row count for InnoDB would not be displayed as an ↵rowanbeentje2013-01-211-1/+0
| | | | | | | | 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
* - Disable connection muxing on OS X versions lower than 10.7, to speed up ↵rowanbeentje2012-12-171-1/+1
| | | | | | | connections, improving Issue #1457 - Fix a warning left over from changes in r3931
* - Rearrange some menu shortcuts: ⌘F is now used on the Content tab to set ↵rowanbeentje2012-12-171-1/+1
| | | | the focus to the Filter Content tab bar. ⇧⌘F is used to show the advanced content filter table. This allows ^⌘F to be used for the standard OS X fullscreen window command, addressing Issue #1513.
* - Allow table content pagination to preserve the current filter type, ↵rowanbeentje2012-11-211-0/+1
| | | | 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)
* * Please note this revision will re-prompt for access to all KeyChain ↵rowanbeentje2012-11-181-0/+1
| | | | | | | | | | passwords * - Change the bundle identifier from com.google.code.sequel-pro to com.sequelpro.SequelPro - Change the code signing process to use a new identity and requirement, to add Developer ID support on 10.7+ but to also maintain functionality on 10.5+ - Add a preference migration routine to copy the old application defaults to the new bundle identifier's defaults - Re-order the default keys to alphabetical to more easily locate values
* Move table content filter logic to it's own file.stuconnolly2012-08-151-4/+0
|
* - Alter table content Advanced Table Filter query preview area to use ↵rowanbeentje2012-08-011-1/+1
| | | | | | | 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-4/+8
| | | | | | | | 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)
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-31/+37
|
* - Rework SPTableData PRIMARY KEY and UNIQUE KEY parsing to use SPSQLParser ↵rowanbeentje2012-03-221-3/+3
| | | | | | | | | | 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
* - When exporting a query result or filtered table view make sure we're ↵stuconnolly2012-03-201-61/+75
| | | | | | | | 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-8/+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
* - Cleanup: improve compatibility with 10.7 SDK to reduce compiler warningsrowanbeentje2012-02-081-3/+3
|
* - 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
* Tidy up.stuconnolly2011-08-271-0/+1
|
* - Review changes made in r3376 and revert a number of regressionsrowanbeentje2011-08-141-3/+2
|
* Tidy up.stuconnolly2011-08-131-4/+2
|
* merged latest SP_REFACTOR changessqlprodev2011-08-021-2/+3
|
* Fix for NULL values in CSV export (same as last commit, but this one ↵stuconnolly2011-07-241-2/+2
| | | | actually works).
* - 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-8/+41
|
* - Fix a number of warnings for DBView.xib by moving some 10.6-only code ↵rowanbeentje2011-05-081-3/+2
| | | | | | | 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-2/+16
| | | | UI code from functional code
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-071-2/+5
|
* - Fix more compiler warningsrowanbeentje2011-03-041-2/+2
|
* • fixed minor issue for filterTable approach in ContentBibiko2011-01-241-0/+2
| | | | - prepared some stuff for table state history
* • fixed several issues for validation and other stuff while editing of ↵Bibiko2011-01-111-1/+1
| | | | MySQL data tables if user re-ordered columns
* - When saving rows in the table content view, only include those fields ↵rowanbeentje2010-12-131-1/+1
| | | | | | | | which have altered values in the UPDATE query, improving speed and reducing the chance of issues when copying queries or altering rapidly changing tables. This addresses Issue #527; thanks to Tobias Mollstam for contributing a patch which prompted this update. - Rename SPTableContent's "addRowToDB" to "saveRowToTable" for clarity, and clean up the code for speed and clarity - Correctly save numeric fields as NULL if the value is blanked
* • 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
* • sequelpro url scheme supportBibiko2010-11-221-1/+2
| | | | | | | • added commands: SelectDocumentView, ReloadContentTableWithWHEREClause • fixed typos • tried to queue incoming commands
* • Custom and Content table in-cell editingBibiko2010-10-301-0/+6
| | | | - a possible given selection done inside the edited cell will be passed to the field editor sheet for convenience since one often forgets that the field editor sheet mode is active
* • convert the Field Editor Sheet into a document-modal sheet, i.e. now the ↵Bibiko2010-10-291-1/+3
| | | | | | | | 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-1/+0
|
* • some further work on Filter TableBibiko2010-10-011-0/+1
|
* • some very minor code, commenting, and tiny speed improvement stuffBibiko2010-09-301-0/+3
|
* • Filter TableBibiko2010-09-291-1/+1
| | | | | - minor GUI improvements - try to fix issue 1654
* • Filter Table - Set Default OperatorBibiko2010-09-291-1/+5
| | | | - added the chance to define the unmarked default operator
* • Filter TableBibiko2010-09-291-3/+3
| | | | | | | - added "Search while Typing" - added some keyboard short-cuts - fixed some minor issues - Filter Table is now a normal NSWindow
* • enabled Filter Table approach (Content View > ⌘F) for testingBibiko2010-09-281-1/+2
|
* • some progress on the filter table approachBibiko2010-09-281-1/+14
|
* • some progress on the filter table approachBibiko2010-09-271-1/+1
|
* • initial sketch approach to allow to write complex WHERE clauses by ↵Bibiko2010-09-271-2/+16
| | | | | | using a table approach - not yet activated
* - Fix incomplete argument logic when deleting multiple rows without indexes ↵rowanbeentje2010-09-051-0/+1
| | | | | | | | (now rolled into argumentForRow: for centralised logic), addressing Issue #791 - Update table row count at bottom of window when deleting rows in the content view - Update localisable strings