| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
|
|
| |
when there is only one indexed field.
- When cancelling adding a new index reset the indexed columns.
|
|
|
|
|
|
|
|
|
| |
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!
|
| |
|
|
|
|
|
|
|
|
|
| |
- 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.
|
| |
|
| |
|
|
|
|
| |
• Field Editor Sheet field name label also displays NOT NULL if set
|
| |
|
|
|
|
|
|
|
|
|
|
| |
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
|
| |
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
| |
allowed to type in
• enabled max length and BIT field validation for CustomQuery
|
| |
|
|
|
|
| |
- Slightly limited in that the addTabButton's target and action must be set for it to work.
|
|
|
|
|
|
| |
• re-enabled length checking while editing in FieldEditorSheet
• FieldEditorSheet now shows field type declaration
• some preparations for BINARY editing in FieldEditorSheet
|
| |
|
| |
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
| |
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)
|
|
|
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
| |
class to allow eg entering favorite names, typing search pattern for favs and history etc.
- this fixes 813
|
|
|
|
| |
so display nothing found message
|
|
|
|
| |
* Make the table status tab date formatter use medium style or the string would be too large at smallest window width
|
|
|
|
| |
field type" which will come up with a suggested field type calculated by PROCEDURE ANALYSE(0,8192)
|
|
|
|
| |
• SPQueryController: removed unnecessary [table reloadData]
|
|
|
|
| |
- fixed bug for renaming a field name (issue 808)
|
|
|
|
| |
- fixed monoSpacedFont for index table refresh and setting
|
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
| |
- 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
|
|
|
|
| |
Using Encoding
|
|
|
|
| |
selection will change - mainly if user changes something via mouse event on comboboxes or popupbuttons; if saving fails suppress the new row selection
|
|
|
|
|
|
|
| |
- fixed issue while drag&drop an auto_inc field > ignore DEFAULT
- fixed several keyboard navigation issues
- further code improvements
- fixed encoding editing
|
|
|
|
| |
- reset collation if encoding was changed
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
|
| |
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.
|
|
|
|
|
|
|
| |
location dialogs
(Note: r2615 and this commit both shamelessly stole the UI concept from Transmit 4; thanks to Panic for the inspiration!)
|
|
|
|
|
|
| |
- Update localisable strings
- Fix initial window position
|
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
|
|
| |
- 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.
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
|
| |
(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
|
|
|
|
|
|
|
|
|
| |
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'.
|
|
|
|
|
| |
- added button "New"
- added chance to change encoding and engine of the new table which will be saved in the Prefs
|
|
|
|
|
|
|
|
|
| |
- 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)
|
|
|
|
|
|
| |
- 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
|
|
|
|
| |
note:What else is needed for such an import? table encoding settings? ... has to be discussed
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
- make sure that after Refresh Table List the mapping table will be updated as well
|