aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - Before performing an export (except from a dot export), refresh the table ↵stuconnolly2010-09-191-46/+106
| | | | | | | list to accommodate cases where additional tables have been added to the database by external applications. If so inform the user of this, giving them the choice of whether or not to continue with the export. - Update Localizable.strings
* - Prevent the table content from being filtered or pages through if a row ↵rowanbeentje2010-09-181-0/+2
| | | | is currently being edited and can't been saved cleanly. Addresses at least http://spbug.com/l/735 .
* - Remove a number of invalid [NSTableView makeFirstResponder] calls that ↵rowanbeentje2010-09-185-12/+12
| | | | | | | had crept into the source, replacing with the correct [NSWindow makeFirstResponder:NSTableView]. This fixes a number of exceptions. - Update localisable strings.
* 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!
* * Fixes minor label length issues and one unlocalized stringdmoagx2010-09-171-3/+5
|
* New add index sheet, which includes:stuconnolly2010-09-176-148/+492
| | | | | | | | | - 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.
* • only some minor code cosmeticsBibiko2010-09-173-412/+413
|
* • added comments conforming to the new SP doc generatorBibiko2010-09-162-35/+166
|
* • BIT Field Sheet Editor now can handle NULL valuesBibiko2010-09-164-4/+75
| | | | • Field Editor Sheet field name label also displays NOT NULL if set
* • finished and enabled the new BIT field editor sheetBibiko2010-09-161-51/+141
|
* - Consolidate structure and content row editing cancellation code into a ↵rowanbeentje2010-09-165-80/+73
| | | | | | | | | | 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
* • further progress on the BIT field sheet editorBibiko2010-09-152-23/+82
|
* • Custom Query EditorBibiko2010-09-151-49/+67
| | | | | - Shift Left now also considers leading SPACES (issue 822) - changed approach for Shift Right/Left of a selection: instead to iterate through all lines do a simple find&replace which is much more faster (4x) and additionally it improves the undo behaviour
* • added validation for BIT fields while in-cell-editing; only 1 or 0 are ↵Bibiko2010-09-152-12/+27
| | | | | | allowed to type in • enabled max length and BIT field validation for CustomQuery
* More work on tab creation target and actionavenjamin2010-09-151-3/+3
|
* Add ability to double click the empty area of the tab bar to create a new tab.avenjamin2010-09-151-0/+1
| | | | - Slightly limited in that the addTabButton's target and action must be set for it to work.
* • some further bit field editing preparationsBibiko2010-09-155-223/+437
| | | | | | • re-enabled length checking while editing in FieldEditorSheet • FieldEditorSheet now shows field type declaration • some preparations for BINARY editing in FieldEditorSheet
* Enable column sorting in the server processes window. Implements issue #816.stuconnolly2010-09-151-0/+14
|
* - Fix row count tracking when deleting table rows; this fixes Issue #819rowanbeentje2010-09-141-5/+5
|
* - Remember to manually update the export source when updating the UI ↵stuconnolly2010-09-141-7/+19
| | | | | | | programmatically as doing so does not fire the controls action. Fixes issue #821. - Improve UI validation on the export dialog when switching between export types.
* • (re?)enabled BIT field editing esp. for field types like BIT(9) or ↵Bibiko2010-09-142-2/+8
| | | | | | | BIT(63) since the old _int2bin routine didn't work because we're dealing with a char* containing bytes if BIT(>8) - also for views and CustomQuery editing • started to clean up (VAR)BINARY editing (work in progress)
* - Implement support for MySQL over SSL for both TCP/IP and Socket ↵rowanbeentje2010-09-135-66/+351
| | | | | | | | | | connection modes. - Upgrade the MySQL binaries to version 5.1.50 (was 5.1.46) - Enable SSL support in the MySQL libraries (this leads to a large increase in library size, unfortunately) - Enable more optimisations in the MySQL libraries (especially --enable-assembler for faster in-library string processing and --with-mysqld-ldflags=-all-static) This completes support for Issue #27.
* • fix editing validation and doCommandBySelector: stuff for SPCustomQuery ↵Bibiko2010-09-131-1/+3
| | | | | | class to allow eg entering favorite names, typing search pattern for favs and history etc. - this fixes 813
* • fixed issue for showing the optimized field type; it can return NULL; if ↵Bibiko2010-09-131-2/+2
| | | | so display nothing found message
* * Fix string width as reported by Alexander Vasiliev (ru)dmoagx2010-09-121-1/+1
| | | | * Make the table status tab date formatter use medium style or the string would be too large at smallest window width
* • added to Structure source table's context menu item: "Show optimized ↵Bibiko2010-09-122-0/+50
| | | | field type" which will come up with a suggested field type calculated by PROCEDURE ANALYSE(0,8192)
* • SPTableStructure's source table saves its column widthsBibiko2010-09-101-1/+0
| | | | • SPQueryController: removed unnecessary [table reloadData]
* • 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-102-17/+91
| | | | | | - 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
* • fixed _supportsEncoding setting to dis/enable safely Database > View ↵Bibiko2010-09-101-1/+6
| | | | Using Encoding
* • 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-092-46/+75
| | | | | | | - 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-093-7/+34
| | | | | | | | 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-093-446/+484
| | | | | | | - 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
* - Alter the connection view layout, moving the connection details forms ↵rowanbeentje2010-09-092-2/+34
| | | | | | | into a scrollview. Switch to centering the form in code, which allows better control and automatic scrollview triggering if the window is too small. - Reduce the minimum window size to 700x400, addressing Issue #788, now the connection view is no longer the constraining factor.
* - Add a further UI hint in the form of a accessory view to the SSH key ↵rowanbeentje2010-09-084-14/+23
| | | | | | | location dialogs (Note: r2615 and this commit both shamelessly stole the UI concept from Transmit 4; thanks to Panic for the inspiration!)
* - Add support for SSH identity files (public keys) in custom locationsrowanbeentje2010-09-087-4/+140
| | | | | | - Update localisable strings - Fix initial window position
* • CSV Import into new table:Bibiko2010-09-061-4/+79
| | | | | | | | - do not create a field in beforehand if user set it to "Do Not Import" - added ROUGH field type guessing by parsing the up to 100 first rows distinguishing text versa integer and size: -- for integer distinguishes between INT and BIGINT due to number length -- for text distinguishes between VARCHAR(255), VARCHAR(32767) [for MySQL >= 5 only], and TEXT due to maximum string length
* • CSV Import Mapper sheet:Bibiko2010-09-062-44/+197
| | | | | | | | - added keyboard shortcut ⌘T to show available tables list - added chance to add a new columns to an existing table (⌘⌥A) - added chance to remove currently new added columns (⌘⌫) - context menu; to remove all new columns one can reselect the table Note: New columns will be added after pressing 'Import' and before the import process starts; if an error occurred the sheet keeps open to give the user the chance to correct errors whereby successfully created new columns won't be editable anymore.
* - When refreshing table content view, refresh the status information for ↵rowanbeentje2010-09-051-1/+2
| | | | | | | tables as well; this fixes caching of table row count in certain combinations of table sizes and preference values, and should fix Issue #673. - Add a missing Errors.strings localisable strings table
* - Fix incomplete argument logic when deleting multiple rows without indexes ↵rowanbeentje2010-09-052-21/+26
| | | | | | | | (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
* Minor enhancements to the CSV import dialogs new table info sheet (i.e. ↵stuconnolly2010-09-051-2/+6
| | | | | | | | | table encoding and type): - Make the sheet non-resizable, thus removing the visible resize triangle. - Add a cancel button so the user can discard their selection. - Only save the user's selection when they select 'OK'.
* • CSV Import into new TABLEBibiko2010-09-044-53/+156
| | | | | - added button "New" - added chance to change encoding and engine of the new table which will be saved in the Prefs
* • further improvements for CSV import into new tableBibiko2010-09-033-5/+75
| | | | | | | | | - fixed some RETURN/ENTER logic while editing a table cell - added context menu to table for: -- 'Set all Field Types to:' which sets all types to the current selected one ⌘= -- 'Add Column to Table Target' (not yet implemented) - some minor code issues - added Info button which will come up with a GUI for setting new table encoding and engine (not yet implemented)