aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPIndexesController.m
Commit message (Collapse)AuthorAgeFilesLines
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-12/+19
|
* Move the table structure's loading logic into it's own category.stuconnolly2012-07-041-1/+3
|
* Fix memory leaks.stuconnolly2012-05-021-1/+5
|
* When opening the add index sheet make sure we're using the correct table ↵stuconnolly2012-04-301-7/+14
| | | | reload call, so the correct validation is done. Fixes issue #1292.
* Add index sheet improvements:stuconnolly2012-04-301-25/+58
| | | | | | - FULLTEXT index type should only be available for MyISAM tables - Index prefix lengths are ignored when specified for FULLTEXT indexes so don't require one (fixes issue #1306)
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-4/+0
| | | | | | | fix nightly builds - Fix warnings
* tweaks to compile on Xcode 4 / 10.6 SDK for SP_REFACTORsqlprodev2012-03-271-0/+4
|
* - Rework SPTableData PRIMARY KEY and UNIQUE KEY parsing to use SPSQLParser ↵rowanbeentje2012-03-221-16/+1
| | | | | | | | | | 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
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-7/+7
| | | | | | | | | | | | 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
* Improve index addition, especially where key sizes are required:rowanbeentje2012-01-111-3/+28
| | | | | | | - Fix exceptions caused by the sizes column formatter requiring a NSNumber - When displaying the indexes view ensure the sizes column is hidden by default, as the advanced view is closed - unless a field with a required size has been selected - If a field with a required size has been selected, don't hide the sizes column when collapsing the advanaced view
* - Prevent export and indexes controller awakeFromNib: routines from being ↵rowanbeentje2011-08-251-0/+10
| | | | | | | run multiple times - Fix crashes and exceptions when using "Use monospaced fonts" or "Display vertical grid lines" preferences after closing at least one window
* Fixes for issue #1098:stuconnolly2011-07-041-3/+4
| | | | | | - Fix logic for enabling/disabling the index storage type popup button when changing the index type. - Add a number formatter to the index length field.
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-2/+53
|
* - Add the ability to double-click in empty areas of the main tableviews to ↵rowanbeentje2011-04-251-0/+8
| | | | add new rows/records
* Make some minor changes after reviewing r3271:rowanbeentje2011-04-141-3/+3
| | | | | | - Fix a few encoding issues - Recode a few [NSApp keyWindow] uses back to [SPDatabaseDocument parentWindow] following discussion; possibly for later refactoring into use of an error method
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-9/+19
| | | | UI code from functional code
* - Fix more compiler warningsrowanbeentje2011-03-151-8/+9
| | | | | - Tweak README
* fixed compiler warningssqlprodev2011-03-011-0/+4
|
* - Fix errors creating indexes, addressing Issue #946rowanbeentje2011-01-111-8/+8
| | | | | | - Move index type query part before the column list to fix advanced use errors - Correct spelling of -_removeIndexUsingDetails:
* - Rework the Add Index indexes menu and the auto_increment index required ↵rowanbeentje2011-01-041-14/+43
| | | | | | | | | | | | | menu to use tag-based values when generating queries, allowing localisation of menu contents without using those localised values in queries. This addresses I$ - Remove the ability to specify a FULLTEXT auto_increment index, as I believe this isn't possible. - Prevent sheet reuse from specifying invalid storage types for PRIMARY KEYs - Fix exceptions when adding indexes to a table where every field is already indexed - Fix initialField/indexedFieldNames check to improve on r3061 - Fix toggling advanced index view after closing the sheet with the view open - Update localisable strings
* • fixed by mistake setting of initialField to nil instead of ↵Bibiko2011-01-031-1/+1
| | | | | | initialFiledNames if initialField is not nil - this should fix i933
* Protect against potentially over-releasing.stuconnolly2010-12-281-1/+1
|
* When opening the add index sheet, the initial suggested field should be one ↵stuconnolly2010-12-271-1/+23
| | | | that is not already indexed. This completes the implementation of issue #928.
* When adding a new index, exclude fields that have already been added from ↵stuconnolly2010-12-261-2/+6
| | | | the drop down list. Part of issue #928.
* When adding a new index, as well as checking for an existing primary key ↵stuconnolly2010-12-251-4/+18
| | | | also check for a composite primary key. Part of issue #928.
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-2/+2
| | | | | | | | | | | central functionality out of SPTablesList: - Centralise control over table loading, moving it away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Centralise control over the main tab view, moving control away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Simplify and clean up view loading logic - Improve thread safety - Update localisable strings
* Update indexes controller constants.stuconnolly2010-10-191-5/+5
|
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* Fix a bug when adding a PRIMARY KEY index, introduced in r2742. Fixes issue ↵stuconnolly2010-10-121-2/+2
| | | | #863.
* Add support for adding SPATIAL indexes on MyISAM tables. Also, update ↵stuconnolly2010-10-081-6/+18
| | | | Localizable.strings.
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-1/+2
| | | | | | | | | | | | | - Add a new ServerSupport class, for which an instance is created upon each new connection and is then subsequently accessible via SPDatabaseDocument. - Replace the majority of manual version checking with calls to properties in the above new class. - Improve the user manager's compatibility with MySQL 3 and 4 servers. Fixes issue #811 Other changes include: - Disable the encoding popup button when adding a new table or database to servers running pre MySQL 4.1 as it only contains one option, 'Default'. - Fix various potential memory leaks discovered during static analysis. - General tidy up and comments.
* Add support in the new index sheet for specifying an index's key block size ↵stuconnolly2010-09-221-8/+29
| | | | (in the advanced view) which was added in MySQL 5.1.10.
* • fixed in [_addIndexUsingDetails:]: do not release supportsLength and ↵Bibiko2010-09-201-187/+208
| | | | | | | | | | | requiresLength since they are still in use • fixed: if new field was added store the the underlying NSDictionary not only the field name • fixed in [addIndex:]: init indexedFields with a mutable copy - this fixes all issue for "mutating method sent to immutable object" of SPIndexController like i1609 • fixed "Add" Button validation • fixed display of "Size" column validation • code cosmetics
* Add index sheet:stuconnolly2010-09-181-7/+7
| | | | | | | | - Fix an exception caused when cancelling adding an index with the advanced options view open. - Move 'Cancel and 'Add' buttons to be inline with index type and name controls. Both found/suggested by Rowan.
* - When opening the add new sheet, ensure that the remove button is disabled ↵stuconnolly2010-09-171-0/+10
| | | | | | | when there is only one indexed field. - When cancelling adding a new index reset the indexed columns.
* - Fix a UI validation bug when adding an additional indexed field with a ↵stuconnolly2010-09-171-2/+4
| | | | | | | | | length specified and the advanced view open. - Fix an exception when adding the same indexed field when creating a new index. Both found by Max. Thanks Max!
* New add index sheet, which includes:stuconnolly2010-09-171-143/+445
| | | | | | | | | - The ability to easily index multiple columns - The ability to specify the storage type (HASH or BTREE) that should be used when available and permitted - The ability to specify a length prefix when indexing a specific column (required on TEXT columns) Requires lots of testing.
* • TableStructureBibiko2010-09-091-103/+103
| | | | | | | - changed: field information are retrieved via [SPTableData columns]; mainly to get all infos like comment, encoding, and collation - added the chance to edit encoding, collation, and comment for each field Note: This is work is progress - not yet optimized but fully workable. Due to GUI I simply added these three columns - improvements will follow
* Remove an attempt to obtain a bool value from a var that is already one ↵stuconnolly2010-09-011-1/+1
| | | | resulting in a crash when attempting to remove an index. Fixes log: http://spbug.com/l/1007.
* Fix various potential memory leaks and general warnings as a result of ↵stuconnolly2010-08-191-1/+0
| | | | static analysis.
* Fix call to showErrorSheetWith: which should be made against ↵stuconnolly2010-06-251-2/+2
| | | | SPTableStructure. Fixes logs http://spbug.com/875, http://spbug.com/876 and http://spbug.com/910.
* Revert a change made in r2320 that required an explicit name when adding new ↵stuconnolly2010-06-151-26/+6
| | | | index.
* • several fixes for index table in Structure viewBibiko2010-06-151-0/+18
| | | | | | | - fixed binding for removeIndexButton - moved indexTable's tableViewSelectionDidChange: delegate to SPIndexController to fix enabling/disabling of the removeIndexButton - fixed issue to blank the index table for multiple selected tables
* Split the management of a table's indexes (adding and removing) to its own ↵stuconnolly2010-06-141-0/+524
controller and XIB in preparation for the UI redesign.