aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - 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)
* • further progress for CSV import into new tableBibiko2010-09-033-13/+80
| | | | | | - added some GUI validations - in new table mode changed 'type' column into self-learning NSComboBoxCells - fixed issue for closing sheet if user press RETURN, only close it if 'Import' button is enable
* • finished the first implementation of CSV Import into new tableBibiko2010-09-036-18/+220
| | | | note:What else is needed for such an import? table encoding settings? ... has to be discussed
* • first preparations to support a CSV import into a new table (not yet ↵Bibiko2010-09-023-66/+234
| | | | | | | | executable) - changed order of target tables: New Table, Refresh List, separator, list of all names - cleaned code a bit * removed check for available tables in SPDataImport, now if no table in db the CSV Field Mapper opens in "New Table" mode
* • CSV Import Field mapperBibiko2010-09-021-1/+0
| | | | - make sure that after Refresh Table List the mapping table will be updated as well
* • Show/Copy Create Syntax now come up with all create syntaxes of selected ↵Bibiko2010-09-012-110/+111
| | | | | | | items • if Create Syntax is a PROC wrap the output by DELIMITER ;; etc. to simplify a copy&paste • merged code for copyCreateTableSyntax into showCreateTableSyntax distinguished by the sender (if sender == self) then copy otherwise show