aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* • 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
* Remove an attempt to obtain a bool value from a var that is already one ↵stuconnolly2010-09-011-1/+1
| | | | resulting in a crash when attempting to remove an index. Fixes log: http://spbug.com/l/1007.
* • removed command to make the CustomQuery's table first responder after ↵Bibiko2010-09-011-1/+0
| | | | | | performing queries for now to avoid exceptions like in 1527 - not sure why, it seems to be a thread issue
* - Ensure previous outstanding performSelector: requests are cancelled to ↵rowanbeentje2010-09-011-0/+4
| | | | avoid calls on released objects; this addresses http://spbug.com/l/1408, http://spbug.com/l/254 and http://spbug.com/l/781
* • fixed AppleScript crash after calling 'open' without any parameterBibiko2010-08-311-8/+29
| | | | | | | | - 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
* • fixed in field editing mode the editing of BINARY fieldsBibiko2010-08-312-4/+10
|
* - When a table content page reload loads no data, and so triggers a reload ↵rowanbeentje2010-08-301-0/+1
| | | | 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
* • added some basic VIEW INFORMATION coming from information.schema.VIEWSBibiko2010-08-303-155/+212
|
* • further improvements for in cell editing of view data in TableContent tablesBibiko2010-08-272-135/+138
| | | | | | | - 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
* • further improvements for in cell editing in CustomQuery tablesBibiko2010-08-273-110/+108
| | | | | | | | - 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
* • fixed issue that data in views weren't editable (copy&paste typo problem)Bibiko2010-08-261-0/+1
|
* • removed onMainThread for [Content/CustomTable makeFirstResponder] to ↵Bibiko2010-08-265-64/+111
| | | | | | | | | 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
* If the user chooses to overwrite the output file(s) when performing an ↵stuconnolly2010-08-262-2/+11
| | | | export make sure compression and CSV and XML headers and re-enable/rewritten.
* Exporter:rowanbeentje2010-08-264-3/+22
| | | | | | - 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)
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-2514-132/+171
| | | | | | | | | | | 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
* • added tooltip about non-editable while keyboard navigation and trying to ↵Bibiko2010-08-252-2/+33
| | | | | | modify a cell • in Custom Query table after field editor sheet dismissing preserve the the edited field selection
* • after editing in Custom Query table preserve the selected line even if ↵Bibiko2010-08-252-8/+14
| | | | the actual edited line due to new data will come up in another line
* • fixed several issues for in cell editing of Custom Query tables and view ↵Bibiko2010-08-254-87/+67
| | | | | | | | 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
* • outsourced control:textView:doCommandBySelector: stuff to SPCopyTable ↵Bibiko2010-08-244-200/+355
| | | | | | | | | | 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
* • in [SPCustomQuery tableSortCallback]Bibiko2010-08-241-7/+3
| | | | | - removed unnecessary header indicator image setting - set [[customQueryView onMainThread] setNeedsDisplay:YES] to ensure to display table rendering correctly after changing the sort order
* • added context menu for Copy, Copy with Header, Copy as SQL Insert to ↵Bibiko2010-08-242-1/+2
| | | | Custom Query table
* • introduced tri-state sort order for Content and Custom Query tablesBibiko2010-08-242-188/+242
| | | | | | | - 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
* • Content Window cell editingBibiko2010-08-241-0/+6
| | | | - If enum field is edited RETURN selects the new value instead of saving the entire row
* • fixed memory leak in [SPDataAdditions ↵Bibiko2010-08-243-342/+341
| | | | | | | | | | 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
* • Table Content editing via keyboardBibiko2010-08-231-0/+12
| | | | | - 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)
* • changed TAB and SHIFT-TAB behaviour of Content Window tableBibiko2010-08-231-29/+98
| | | | | | | - 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
* • first preparations to allow in cell editing in Custom Query (not yet ↵Bibiko2010-08-223-159/+245
| | | | | | | | | | 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
* • moved changes done in r 2566 to tableViewSelectionDidChange: if no item ↵Bibiko2010-08-221-4/+12
| | | | in tablesList is selected to reset SP