| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
| |
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
|
| |
|
|
|
|
| |
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
|
| |
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
|
|
|
|
| |
since we need that for Content and Custom Query table; only class specific stuff like ESC trapping will handled in the actual class
• enabled in cell editing for Custom Query tables
- also added spreadsheet button to Custom Query status bar
• fixed ESC trapping: F5 can be used for completion
• simplified [SPCopyTable keyDown:] for trapping ENTER/RETURN key
• some code cosmetics
|
|
|
|
|
| |
- removed unnecessary header indicator image setting
- set [[customQueryView onMainThread] setNeedsDisplay:YES] to ensure to display table rendering correctly after changing the sort order
|
|
|
|
| |
Custom Query table
|
|
|
|
|
|
|
| |
- by clicking a the same table header the sort will changed to desc, asc, no sort order, desc, asc, etc.
• fixed sorting issue for Custom Query table
- reset sort order status before executing a new custom query
• code cosmetics: reduced file size for SPCustomQuery.m
|
|
|
|
| |
- If enum field is edited RETURN selects the new value instead of saving the entire row
|
|
|
|
|
|
|
|
|
|
| |
shortStringRepresentationUsingEncoding] after simplifying the code
• fixed NSAutoreleaseNoPool(): SPMainThreadTrampoline autoreleased with no pool in place - leak while canceling a print job
- call [self endTask] BEFORE [pool drain]
• in SPTableContent set the focus to table after editing a cell by the field editor sheet on main thread
- this could fix exception 1481
• some code cosmetics: reduced file sizes
|
|
|
|
|
| |
- disable ↑ and ↓ for jumping the next table cell if current cell is a enum field to allow to use the arrow keys for selecting an item from the list
- Note: ?\018↩ handling has to be improved here! (coming soon)
|
|
|
|
|
|
|
| |
- now it selects any field (if it's editable for views) regardless whether the field is a blob
- if user tries to edit a blob field the field editor sheet will occur for editing
• after cancellation of cell editing in the Content Window table preserve the focus on the table
• minor code cosmetics for editing of data coming from a view in Content Window
|
|
|
|
|
|
|
|
|
|
| |
active)
• view data editing
- disable add/duplicate/remove row for views
- first improvements for editing navigation via keyboard
- after editing avoid relaodTable instead use loadTableValues
- outsourced: (NSInteger)fieldEditStatusForRow:andColumn: since it will be used for keyboard editing navigation
|
|
|
|
| |
in tablesList is selected to reset SP
|
|
|
|
|
|
| |
SPTableTypeNone and selectedTableName since the table will be deselectAll
- fixes various updates like title bar etc. and avoid crashes/exceptions
|
|
|
|
| |
- if multipleLineEditingButton is set to on or field is a blob field allow to show the field data as non-editable fieldEditorSheet if field is not editable
|
|
|
|
|
| |
- fixed: call endTask for the current progress spinner if while editing a field the data were changed meanwhile
- fixed line breaking of some long tooltips
|
|
|
|
|
|
| |
- the editing is field based as for Custom Query editing
- shouldEditRow checks if the clicked field can be identified unambiguously
- CAUTION: This must be tested heavily before releasing!! Esp. any kind of threading issues and progress spinner stuff for slower connections
|
|
|
|
|
|
|
|
|
| |
[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!
|
|
|
|
| |
static analysis.
|
|
|
|
|
|
|
| |
readability of that spf file
• suppress if a window with one tab will be closed that [... parentTabShouldClose] method will be called twice via closeTab:
- this issue could be the reason for recent crashes/exception esp. of the NSNavigator (should be investigated further)
|
|
|
|
|
|
| |
display an alert sheet which waits for the change in the didEndSelector method of a passed class NSInteger variable
• applied the SPBeginWaitingAlertSheet routine to Pref > Editor's check for unsaved color themes and in SPCustomQuery's sheet about Stop/Continue/Run All if a query failed after executing "Run All"
|