aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableStructureDelegate.m
Commit message (Collapse)AuthorAgeFilesLines
* Merge further revisions back from trunk to the 1.0.x release branch, ↵rowanbeentje2013-04-281-2/+2
| | | | | | | | | | | | | | | | | | | | | | potentially comprising the last of 1.0.2: - r4066: Fix query status and error message title to not always suggest an error has occurred, addressing Issue #1670 - r4067: Fix validation of the "Add to Favorites" File menu item when editing past favorites; Fix the action of the "Add to Favorites" File menu item to correctly create the new favorite; These address Issue #1666 - r4068: Move the SPBeginWaitingAlertSheet function to a 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 - r4069: Fix newline warnings - r4070: Issue #1601: Fix menu items not being validated properly once a connection is established - r4071: Split the process list controller's table view data source and delegate methods into their own category - r4072: Fix process list kill query/connection actions not using the correct ID if the list was filtered - r4074: Correctly link the SSH name field, fixing issues editing and automatically filling in connection names on the SSH tab, addressing Issue #1686 - r4075: Specify the NULL status of fields when creating view placeholders on export, fixing problems with invalid timestamp NULL defaults, addressing Issue #1688 - r4076: Add a spotlight comment to allow easy location of Sequel Pro with other search terms than the name - r4077: Fix string type detection, addressing errors when converting string types to blob or binary fields (addressing Issue #1453) - r4078: Composite Foreign Keys will now show all columns in Relation view (workaround) - r4079: Changed a query (addressing issue #1687); Make some strings localizable - r4087: Fix another issue causing ALTER statements to error for binary column types being edited, further addressing Issue #1265 - r4088: Update version number to 1.0.2
* Merge further revisions from trunk back to the 1.0.x release branch:rowanbeentje2013-04-281-10/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - r4034: End editing for deleting content filter or query favourites, addressing exceptions and Issue #1648 - r4035: Apply schlabberdog's fix for log #3969, addressing Issue #1647 - r4036: Fix an error parsing SQL inside an unterminated delimiter statement causing an off-by-one error in positioning, addressing Issue #1643 - r4037: If date-type fields are cleared, and allow NULLs, save the cell value as NULL; this implements Issue #1638 - r4038: Alter the content filter manager and the query favourite manager to import items from a file into the Global group if the document is untitled, improving import UX and addressing Issue #1616 and Issue #1645. Also select and scroll to the newly imported items for clarity. - r4039: Fix crashes in the User Manager when fields don't validate but a save/cancel/tab switch is still triggered, addressing Issue #1627 - r4041: Tweak and improve the User Manager: Rework how data to populate the user manager is retrieved from the server, speeding up display of lots of users by a large factor; Fix support for schema permissions for the Anonymous user, and add support for '%' and '' hostnames (only showing if already set once), fixing Issue #1620; Highlight databases in the user manager that have permissions set for the selected user; Switch to using the centrally provided database list to reduce queries and remove the information_schema and performance_schema "databases"; Speed up a number of operations by tweaking the logic and queries used - r4042: Fix release builds after r4041; Update localizable strings - r4043: Set Sequel Pro to always run on Integrated Graphics on machines with both integrated and discrete, improving power consumption if nothing else is triggering the discrete GPU. This addresses Issue #1609 - r4044: Make the theme background apply to the query favourites editor - r4045: If the Custom Query editor view is active on window open, correctly set the focus in it, addressing Issue #1590 - r4046: Add support for querying the server default charset and collation; Move a bit of redundant code into a method - r4047: Restore tab bar label when cancelling a connection - r4048: Fix format string error in QueryKit - r4049: Alter the preferences favourite minimum version to avoid issues with previous runs of nightlies, which may partially address Issue #1588; Remove the old favourites key from the preferences now imports have succeeded - r4050: Allow Favorites import to read favorites from an old preferences .plist file, further addressing Issue #1588 - r4051: Change the string '=' and '!=' to be case- and collation-insensitive by default, using the Shift key (as documented in the tooltip) to trigger a BINARY exact match. This addresses Issue #1578 - r4052: When adding a database the servers default charset is now shown - r4053: Adjust keywords list to fix auto capitalisation of "ON" - r4054: Add a new SPMySQLEmptyResult class to SPMySQLFramework, returning it instead of nil if a query produces no result set. This allows per-result-set properties to be preserved, fixing issues where information like query execution time was lost - addressing Issue #1577 - r4056: Improve startup when loading from file, preventing overwrite of details read from a spf/spfs during startup. This addresses Issue #1619 - r4057: Correctly reset document state for setting it from file/when duplicating tab, further addressing Issue #1619 - r4058: Add a stub override to fix exceptions when code receiving a SPMySQLEmptyResult expects a SPMySQLStreamingResult/SPMySQLFastStreamingResult (Exception #3988) - r4060: Make some small tweaks to string BINARY handling: Correctly send the binary state/collation when reordering fields, addressing Issue #1265; Allow unticking of the binary box to save correctly, allowing conversion of fields to non-binary collations again - r4061: Fix errors when editing or moving columns on server vesions which do not support character sets/collations, addressing Issue #1629; Fix needless collation queries on those servers; Disable field enums and table encoding dropdown on those servers
* Default grayed out column encodings should use monospaced fonts if enabled.stuconnolly2012-08-131-31/+47
|
* - Fix table structure issues with default collations on non-default ↵rowanbeentje2012-08-051-2/+15
| | | | | | | | encodings, fixing a number of exceptions with various actions (Issue #1416) - Fix which item is selected after reordering columns in the structure view - Display enodings and collations which match the table settings in gray
* Change Sequel Pro's license from GPL (version 2) to MIT.stuconnolly2012-07-251-13/+20
|
* Fix the display of the encoding and collation of fields that don't support ↵stuconnolly2012-07-161-25/+23
| | | | them (introduced in r3708). This also fixes the issue of re-ordering non-string fields failing due to the encoding and collaction being included.
* Move the table structure's loading logic into it's own category.stuconnolly2012-07-041-0/+2
|
* More tidy up.stuconnolly2012-06-041-16/+19
|
* - 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
|
* - Fix a possible race condition exception when switching between tables ↵rowanbeentje2012-03-211-1/+1
| | | | when th structure view was active, the collation column was visible, and fields had custom collations
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-3/+4
| | | | | | | | | | | | 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-2/+2
|
* Rework linebreak handling in content and custom query result views, as ↵rowanbeentje2011-09-211-1/+1
| | | | | | | | | | | 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)
* When moving a field in the structure view, only use the default value if it ↵stuconnolly2011-08-091-34/+48
| | | | actually has one. Fixes issue #1140.
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-0/+2
|
* • improve BIT field type supportBibiko2011-05-051-1/+1
| | | | | | | | - caught some more exceptional cases - re-factored byte to bit conversion (really do not know why the old code wasn't working anymore); this should fix i1042 - disabled unisgned/zerofill check boxes in Structure for BIT - insert correct default BIT field default value if any after adding a new row -- this works for 5.5 but for MySQL 5.0.x it seems that providing a default value is a MySQL bug (further checks are needed)
* - Add the ability to double-click in empty areas of the main tableviews to ↵rowanbeentje2011-04-251-0/+1
| | | | add new rows/records
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-8/+0
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* 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-3/+13
| | | | UI code from functional code
* - Fix more compiler warningsrowanbeentje2011-03-151-1/+1
| | | | | - Tweak README
* Fix more compiler warnings.stuconnolly2011-03-141-2/+2
|
* Fix more compiler warnings.stuconnolly2011-03-041-1/+1
|
* fixed compiler warningssqlprodev2011-03-011-1/+5
|
* - Revert r3187, which only masked an underlying bug and caused double ↵rowanbeentje2011-02-111-1/+4
| | | | | | | | | columns in views - In SPTableStructureDelete, don't request the encoding if the table is reloading; this prevents multithreaded data fetches and race conditions causing Issue #974. - Alter SPTableData to use thread mutexes instead of a boolean to prevent threading issues, which also fixes Issue #974 in a different way. Alter race condition checks to block their threads instead of returning bogus information to prevent state issues. - Alter table loading to no longer load trigger information until required, speeding up use of other views and cleaning up the console log.
* - Rework the Add Index indexes menu and the auto_increment index required ↵rowanbeentje2011-01-041-1/+2
| | | | | | | | | | | | | 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 table structure logic for date/time fieldsBibiko2010-11-051-2/+5
| | | | - fixes issue 886
* 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
* • TableStructure sheet to ask for the to be used index of an ↵Bibiko2010-11-011-1/+13
| | | | | | auto_increment field now runs doc-modal not app-modal - the used strategy is to ask the user for an index whenever the user set the Extra field to 'auto_increment' and not as part of the 'addRowToDb' method
* • improved Structure editing logic to allow to choose auto_increment for ↵Bibiko2010-11-011-4/+23
| | | | | | Extra only if table has no auto_increment field set since MySQL allows only one auto column - the user has still the chance to type 'auto_increment' into the Extra manually
* Tidy up SPTableStructure including moving all the private field type ↵stuconnolly2010-10-281-7/+7
| | | | validation methods to their own class, SPTableFieldValidation.
* Add SPDefaultPasteboardDragType constant.stuconnolly2010-10-281-5/+5
|
* Split out all of SPTableStructure's delegate and datasource methods into ↵stuconnolly2010-10-261-0/+567
their own category.