| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
| |
- 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
|
|
|
|
|
|
|
| |
- Fully lock the connection for background pings; this may slow down queries after connection disuse (when the keepalive is still active/blocked), but strengens thread safety to hopefully fix vio_delete crashes
- Fix pthread_cancel use; previously pthread_cancel after a keepalive may have resulted in cancelling unrelated threads where the thread ID was reused
This should increase stability and improve program consistency.
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
contains field names"
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
resulting in a crash when attempting to remove an index. Fixes log: http://spbug.com/l/1007.
|
|
|
|
|
|
| |
performing queries for now to avoid exceptions like in 1527
- not sure why, it seems to be a thread issue
|
|
|
|
| |
avoid calls on released objects; this addresses http://spbug.com/l/1408, http://spbug.com/l/254 and http://spbug.com/l/781
|
|
|
|
|
|
|
|
| |
- this should fix the issues 108, 1398, 226 , 1157, 1473
• added AppleScript support for command 'print'
- it prints the active view
• renamed SP classes in sequel-pro.scriptSuite
• AppleScript command 'make new document' opens a new window and connects to default automatically if set
|
| |
|
|
|
|
| |
mysql_real_escape_string (which require an active connection). This addresses http://spbug.com/l/54 .
|
|
|
|
|
|
|
| |
attempt to further address http://spbug.com/l/13
- Update localisable strings
|
|
|
|
| |
of the first page, the previous row count was not correctly reset, thus sometimes triggering an exception. This correctly resets the count, addressing http://spbug.com/l/558
|
|
|
|
| |
formatted numbers (eg editing the default 1,000 to 2,000) without formatting characters such as commas being truncated
|
| |
|
|
|
|
| |
the application is in a modal state, the background thread waits. This improves interface behaviour on multiple SSH disconnections after sleep/wake (finishing Issue #798) and also disconnections while the interface is modally locked (eg editing text/blobs).
|
|
|
|
|
|
|
| |
- simplified code
- reduced number of queries for edit status
- WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well
|
|
|
|
|
|
|
|
| |
- simplified code
- reduced number of queries for edit status
- WHERE argument to identify first try to avoid using blob data for speed, if field is not identified with ignoring blob data then use blob data as well
• for TableContent fixed tooltip display
- note: improvements as for CustomQuery follow soon
|
| |
|
|
|
|
|
|
|
|
|
| |
avoid the trampoline exceptions
• unified error message while cell editing
• in Custom Query table cell editing errors are displayed as tooltips and added these message if edit event comes from the keyboard
• fixed: check edit status in Content Tables only for views to avoid unnecessary queries
• used [SPCustomQuery fieldEditStatusForRow:andColumn:] consequently to simplify code
|
|
|
|
| |
export make sure compression and CSV and XML headers and re-enable/rewritten.
|
|
|
|
|
|
| |
- Enable alternating table lines in the export table view - this addresses Issue #797
- Reconnect GZIp & BZIP2 compression functionality (TODO: not currently working for file overwrites; to be discussed)
|
|
|
|
|
|
|
|
|
|
|
| |
with extended characters in MySQL identifiers (names of dbs/tables/cols):
- Move encoding queries and control into MCPKit, with newly cleaned-up methods, and switch a number of locations to using the new code.
- Use UTF8 connections for many identifier-based queries (selecting and listing databases, tables, stored procs, table information). This fixes selection and creation of table and database names containing extended characters, also fixing exceptions and errors.
- Improve UTF8 over Latin1 to correctly set the client character set encoding as well, fixing custom queries and edits; remove custom code in SPTableContent achieving the same thing in a single location.
- Fix database encoding detection routines
- Update localisable strings
|
|
|
|
|
|
| |
modify a cell
• in Custom Query table after field editor sheet dismissing preserve the the edited field selection
|
|
|
|
| |
the actual edited line due to new data will come up in another line
|
|
|
|
|
|
|
|
| |
data in Content tables
- now each cell can be selected via keyboard navigation regardless whether it's editable or not; only if the user tries to modify it then it will be checked if it's editable or not - for speed while navigation
- fixed issue for view data editing to show blobs in editor sheet if user wants to modify it
- Note: still work on progress
|