aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableStructure.m
Commit message (Collapse)AuthorAgeFilesLines
* Address Issue #984:rowanbeentje2011-03-211-2/+13
| | | | | | | - Fix potential reload loop when setTableDetails: deselects the table row, after the fields have been emptied but before any edits have been committed - Fix reload action not checking whether items need saving before comparisons occur - Save incomplete edits back to the table before processing changes to avoid changes requiring additional queries
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-081-26/+29
|
* fixed compiler warningssqlprodev2011-03-011-2/+0
|
* fixed compiler warningssqlprodev2011-03-011-1/+0
|
* - When resetting AUTO_INCREMENT for a table, always use the selected table ↵rowanbeentje2011-01-111-7/+1
| | | | name sourced from SPTablesList rather than a SPTableStructure cached value, which may not have been updated. This addresses Issue #945.
* - Rework the Add Index indexes menu and the auto_increment index required ↵rowanbeentje2011-01-041-2/+12
| | | | | | | | | | | | | 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
* - Don't specify DEFAULT '' when saving TEXT, BLOB or geometry field types; ↵rowanbeentje2010-12-081-2/+3
| | | | this avoids errors in strict mode
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-7/+7
| | | | | | | | | | | 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-56/+51
| | | | | | 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-2/+18
| | | | | | 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-169/+116
| | | | validation methods to their own class, SPTableFieldValidation.
* Add SPDefaultPasteboardDragType constant.stuconnolly2010-10-281-9/+5
|
* Split out all of SPTableStructure's delegate and datasource methods into ↵stuconnolly2010-10-261-530/+2
| | | | their own category.
* • improved the TableStructure handling of GEOMETRY fields and their ↵Bibiko2010-10-251-3/+3
| | | | validations against non-valid WKT notations - return NULL if no header
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-3/+0
| | | | | | | | - Prepare for the implementation of PDF and HTML export by hiding the export options box for export types that don't need it. - Fix some spacing issues on the export dialog. - Create a new SPCategoryAdditions header that is included in the apps precompiled header, making all additions available to all classes. - Update strings files.
* When adding or editing a field and the option to make it the primary key is ↵stuconnolly2010-10-201-30/+47
| | | | selected, also make the field unsigned if not already. Implemented issue #703.
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* • implemented for TableStructure's source table the possibility to ↵Bibiko2010-10-151-0/+57
| | | | | | hide/unhide the columns: Key, encoding, collation, comment by adding a gear menu 'View Columns'; the hide status will be saved inside the Pref key: 'NSTableView Hidden Columns SPTableStructureSource' - this implements the feature request issue 868
* • display SPA in the Key column if a field has a spatial keyBibiko2010-10-091-1/+4
| | | | Question: Is it possible to assign an index to a geometry field other than SPATIAL?
* • added spatial field types to field list suggestionsBibiko2010-10-081-3/+26
| | | | • adjusted gui validation for geometry field types
* • fixed issue836 by avoiding the fact that while selecting a new table ↵Bibiko2010-09-221-15/+18
| | | | | | | | the CREATE SYNTAX will be parsed twice under certain circumstances which led to this issue - introduced a isWorking mechanism to SPTableData; while SPTableData is updating its cache (ie the CREATE SYNTAX is being parsed) each request for values will return nil or an empty array; the caller is responsible to decide what to do • various commenting stuff • various speed improvements
* • TableStructureBibiko2010-09-211-25/+126
| | | | | | - started general cell editing validation due to currently set type and other parameters to help user while setting up/changing fields (must be tested) - set BINARY checked if collation ends with _bin since string fields stores that information in that way for convenience - added TINYTEXT as type suggestion
* Update Localizable.strings and resolve the use of multiple comments for the ↵stuconnolly2010-09-211-1/+0
| | | | same string.
* - Remove a number of invalid [NSTableView makeFirstResponder] calls that ↵rowanbeentje2010-09-181-3/+3
| | | | | | | had crept into the source, replacing with the correct [NSWindow makeFirstResponder:NSTableView]. This fixes a number of exceptions. - Update localisable strings.
* New add index sheet, which includes:stuconnolly2010-09-171-0/+3
| | | | | | | | | - 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.
* - Consolidate structure and content row editing cancellation code into a ↵rowanbeentje2010-09-161-24/+23
| | | | | | | | | | single function in each class - Tweak NSTableView subclasses to catch presses of the Escape key and ask the class to abort row editing. This makes Esc key behaviour much more consistent, and allows cancelling/reverting edits made via the mouse (eg checkboxes, dropdowns, enums), or after the cell editing has finished but the row is still selected. - Remove debug - Update localisable strings
* • fixed issue for showing the optimized field type; it can return NULL; if ↵Bibiko2010-09-131-2/+2
| | | | so display nothing found message
* • added to Structure source table's context menu item: "Show optimized ↵Bibiko2010-09-121-0/+49
| | | | field type" which will come up with a suggested field type calculated by PROCEDURE ANALYSE(0,8192)
* • SPTableStructureBibiko2010-09-101-1/+1
| | | | - fixed bug for renaming a field name (issue 808)
* • TableStructureBibiko2010-09-101-4/+4
| | | | - fixed monoSpacedFont for index table refresh and setting
* • TableStructureBibiko2010-09-101-160/+113
| | | | | | | | - added basic field type and argument validations like unsigned should not be used for string types, etc. - added field types DEC, FIXED, NUMERIC for validation - simplified addRowToDb code to avoid double-coding - after removing a field preserve the focus on the source table for keyboard navigation - minor code improvements
* • TableStructureBibiko2010-09-101-85/+189
| | | | | | | - added support for field types SERIAL and BOOL(EAN) - added extra setting and support for SERIAL DEFAULT VALUE - fixed several string comparisons based on user input, ie trim it and compare it upper or lower cased resp. - if adding or changing of a field fails display the SQL statement which caused the error in the error sheet for better debugging
* • TableStructureBibiko2010-09-101-17/+89
| | | | | | - moved field type suggestions for combobox as data source to SPTableStructure - applied type combobox lowercased completion while typing - improved DEFAULT handling for any numeric, date, time fields if DEFAULT was set to an empty string '' - if so skip it to avoid unnecessary error messages
* • for Structure editing: try to save a row being edited _before_ the row ↵Bibiko2010-09-091-0/+7
| | | | selection will change - mainly if user changes something via mouse event on comboboxes or popupbuttons; if saving fails suppress the new row selection
* • Structure editingBibiko2010-09-091-46/+73
| | | | | | | - fixed issue while drag&drop an auto_inc field > ignore DEFAULT - fixed several keyboard navigation issues - further code improvements - fixed encoding editing
* • StructureBibiko2010-09-091-0/+8
| | | | - reset collation if encoding was changed
* • [SPDatabase getDatabaseCollationsForEncoding:] now uses a cache to ↵Bibiko2010-09-091-2/+19
| | | | | | | | reduce the querying of info_schema - this fixes the querying of each reloadData in [SPTableStructure objectValueFor:] • autoreleased mutableCopy in [SPTableStructure loadTable] • fixed drag&drop query in SPTableStructure to copy charset and collation as well
* • TableStructureBibiko2010-09-091-342/+377
| | | | | | | - 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
* • overall replacement of:Bibiko2010-08-201-12/+12
| | | | | | | | | [aString appendString:[NSString stringWithFormat:]] by [aString appendFormat:] since it's much more faster • first look at loop where several [aStr appendString:] occur to try to combine them into one appendString or appendFormat since the allocation of memory takes really time Note: I tested all my changes but we should test it further to be sure that I didn't a mistake!
* Tweak structure view index collapsing:rowanbeentje2010-07-171-2/+19
| | | | | | | - Make the minimum index view size a little smaller - Add a button to reveal the indexes subview when it is collapsed. This button is hidden when te index view is not collapsed. This addresses Issue #746
* When reordering a timestamp field ensure the query is correctly constructed ↵stuconnolly2010-07-021-5/+10
| | | | when it allows NULL values. Fixes issue #753. Also, improve the error message displayed when a field cannot be moved.
* • several fixes for index table in Structure viewBibiko2010-06-151-6/+4
| | | | | | | - 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-429/+137
| | | | controller and XIB in preparation for the UI redesign.
* - Alter the behaviour of the return key in structure view, making it ↵rowanbeentje2010-06-121-6/+16
| | | | consistent with the Content view and triggering a row save
* - Fix incorrect non-reset after structure editing which results in an ↵rowanbeentje2010-06-091-2/+10
| | | | unchanged row, resulting in subsequent editing errors and exceptions in addRowToDb
* - Ensure start/end query notifications are sent on the main thread to avoid ↵rowanbeentje2010-06-011-4/+4
| | | | | | | the interface being updated from the wrong thread on listeners - Add a "Support Files" folder to MCPKit, containing NSNotificationAdditions to support main thread notifications from within MCPKit
* Rename TableDocument to SPDatabaseDocument.stuconnolly2010-05-281-2/+2
|
* Rename TableSource to SPTableStructure.stuconnolly2010-05-271-0/+1921