aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCopyTable.m
Commit message (Collapse)AuthorAgeFilesLines
* - Fix incorrect Copy as SQL INSERT processing leaving out commas; this ↵rowanbeentje2012-03-191-16/+13
| | | | | | | addresses Issue #1300 - Improve Copy as SQL INSERT logic to correctly calculate maximum line lengths
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-20/+16
| | | | | | | | | | | | exceptions as database structure retrieval is currently missing! Further work on SPMySQLFramework integration: - Improve SPMySQL framework build settings including correct ppc builds and a Distribution configuration for the build distributions to match - Add new convenience querying and result methods to the framework - Amend Sequel Pro source to use the new SPMySQL.framework methods everywhere, replacing MCPKit methods where they differ and improving some functions - Remove MCPKit from the source - Fix a number of warnings on Release-style builds
* - Cleanup: improve compatibility with 10.7 SDK to reduce compiler warningsrowanbeentje2012-02-081-21/+21
|
* - Expicitly cast parameters before passing into NSString formatters ↵rowanbeentje2012-01-091-1/+1
| | | | assuming 64-bit lengths; this addresses exceptions and hangs viewing table contents on 32-bit machines, many thanks to stuart02 for identifying and tracking down this issue
* - Update code to use NSStrings for NSTableColumn identifiers, as per 10.7 SDKrowanbeentje2011-10-171-9/+9
| | | | | - Update localizable strings
* - Rework table data saving to ensure that cells that should be edited via ↵rowanbeentje2011-10-051-0/+39
| | | | | | | the edit sheet aren't then overwritten by the cell value, potentially causing data truncation in 10.5. This addresses Issue 1196. - Consolidate field editing in sheet logic
* Rework linebreak handling in content and custom query result views, as ↵rowanbeentje2011-09-211-4/+31
| | | | | | | | | | | triggered by Issue #1184: - Display table cells on a single line for preview purposes - Display gray pilcrow/reverse pilcrow placeholders instead of linebreaks - If a cell contains linebreaks, automatically trigger sheet editing mode - Handle newly displayed linebreaks in column width detection - If using the up/down arrow keys in a field editor, allow them to select the previous/next line within an editor if appropriat (instead of always moving to the previous/next row)
* Small tidy up.stuconnolly2011-07-311-77/+66
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-10/+0
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-15/+56
| | | | UI code from functional code
* - Fix more compiler warningsrowanbeentje2011-03-151-18/+18
| | | | | - Tweak README
* Fix more compiler warnings.stuconnolly2011-03-141-0/+1
|
* fixed compiler warningssqlprodev2011-03-011-0/+1
|
* fixed compiler warningssqlprodev2011-03-011-3/+3
|
* fixed compiler warningssqlprodev2011-03-011-1/+0
|
* • bound showFilterTable to main menu's Edit > Find > Find… menu itemBibiko2011-01-191-0/+11
|
* • improved error handling while writing SP_BUNDLE_TABLE_META_DATA esp. ↵Bibiko2011-01-111-20/+22
| | | | while switching databases
* • disabled in [SPTextView boundsDidChangeNotification] the view update to ↵Bibiko2011-01-101-0/+1
| | | | | | avoid incorrect line number rendering while scrolling until the problem is found why it causes some crashes • fixed missing free() in [SPCopyTable executeBundleItemForDataTable]
* • fixed bug for setting SP_BUNDLE_INPUT_TABLE_METADATA if user changed ↵Bibiko2011-01-091-2/+13
| | | | column order in Content and Query Editor table
* Improve column autosizing:rowanbeentje2011-01-081-2/+6
| | | | | | - Use the parent scrollview width rather than the table width to calculate available space; fixes issues with the table width reflecting the previous selected table - Take account of cell spacing and scrollbar width to avoid horizontal scrolling where possible
* • fixed issue form redirecting output actions via exit codes if Bundle's ↵Bibiko2010-12-211-3/+4
| | | | | | default output action was None • renamed constants to avoid confusing
* • in HTML output window hyperlink references which begin with file:// will ↵Bibiko2010-12-161-1/+1
| | | | | | reveal that file in Finder • in SPCopyTable for tab-delimited row data replace \t by ⇥ and \n by ↵ if they occur in data cells for convenience
* - When saving rows in the table content view, only include those fields ↵rowanbeentje2010-12-131-12/+12
| | | | | | | | which have altered values in the UPDATE query, improving speed and reducing the chance of issues when copying queries or altering rapidly changing tables. This addresses Issue #527; thanks to Tobias Mollstam for contributing a patch which prompted this update. - Rename SPTableContent's "addRowToDB" to "saveRowToTable" for clarity, and clean up the code for speed and clarity - Correctly save numeric fields as NULL if the value is blanked
* • made usage of more constants to avoid double-storing stringsBibiko2010-12-121-1/+1
| | | | • fixed JavaScript alert and confirm window in HTML output window
* • HTML output window's JavaScript supportBibiko2010-12-121-1/+1
| | | | | | - changed the approach to make the HTML output window the key window; now it could be done directly via a JavaScript command: window.system.makeHTMLOutputWindowKeyWindow() - added the chance to ask Sequel Pro via JavaScript for run-time shell variables via window.system.getShellEnvironmentForName('shell_var_name') • more usage of constants
* • Bundle CommandsBibiko2010-12-091-1/+3
| | | | | | - added shell vars SP_CURRENT_EDITED_COLUMN_NAME, SP_CURRENT_EDITED_TABLE for Input Field scoped commands if invoked from a table cell field editor - added shell var SP_TABLE_DATA_SOURCE (content or query) - fixed table row change trigger for custom query tableView
* • Bundle commandsBibiko2010-12-081-5/+44
| | | | | | | - reworked invocation via keyboard short-cut to allow to fall back to General scope - added chance to redirect the output action via command exit codes; useful if the normal output is an HTML window but an error occurred, now one can display the error as tooltip for instance - unified file hand-shake file names by one uuid - made usage of more constants and renamed some shell vars
* • Bundle command supportBibiko2010-12-071-169/+216
| | | | | - fixed issue for commands without assigning a key equivalent - output table meta data about type, type grouping, length, auto_inc, PRI key etc. for Data Table scope commands and sequelpro url scheme command ExecuteQuery
* • Bundle CommandBibiko2010-12-021-23/+145
| | | | - for Data Table scope added the chance to specify the handling of BLOB fields (if underlying data are kind of NSData or GEOMETRY) as 'Exclude', 'Include', 'save as image file - the data will be saved as tif file and the path will appear in the table', 'save as file - the data will be saved as raw dat file and the path will appear in the table'; for GEOMETRY fields if set to 'save as {image} file' the representation will be saved as PDF file otherwise the WKT string appears
* • Bundle CommandsBibiko2010-12-011-0/+1
| | | | | - make sure that each HTML output window will be released - if a triggered command will outputs its result in an HTML window invoke it only if the HTML output window is already open; this enables the user to "switch on/off" such a trigger
* • added chance to cancel an activity - up to now a running Bundle command ↵Bibiko2010-12-011-1/+8
| | | | | | - from the Activities pane (toggable via double-clicking at Table Information header); it's still tentative and the correct cancel icon will follow asap • added notification system for updating the activities pane (SPActivitiesUpdateNotification)
* • Bundle commandsBibiko2010-11-301-1/+1
| | | | | | - before closing a db doc window kill all commands associated to this doc - suppress an error message if a bash command was killed via code 9 - added a temporary and preliminary table view to display command activities (double-click at TABLE INFO header to toggle and refresh it - only for testing purposes - it shows all commands started from that db doc and a General command names)
* • Bundle commandsBibiko2010-11-291-1/+1
| | | | | - register running commands for each SPDatabaseDocument or if the command runs via 'General' for NSApp delegate - kill all running commands before SP will be terminated
* • Bundle Command supportBibiko2010-11-261-2/+15
| | | | | | - added shell var SP_ICON_FILE - a bundle command which outputs its result as HTML window will write the data in the same window, ie it won't be create each time a new window; the window will be identified by the bundle's uuid - fixed issue while saving a short-cut in keybinding.dict format, now it ignores possible diacritics - maybe bug in ShortcutRecorder for method [aRecorder keyCharsIgnoringModifiers] since in the objectValue it's set correctly
* • Bundle EditorBibiko2010-11-231-2/+33
| | | | | | | - fixed gui arragement - suppress error message if no ouptut key found in command.plist • added sequelpro://ID@/passToDoc/SelectTableRows/1/3/4/.. scheme command which selects given rows in current table if a SPCopyTable is the first responder; not valid given rows are ignored • added SP_SELECTED_ROW_INDICES as passed shell variable for Data Table scope
* • Bundle EditorBibiko2010-11-231-101/+101
| | | | | | | - bailed out from approach to assign more than one scope to Bundle commands; now there're three scopes available: Input Field (incl. Query Editor since it only differs in current_query and insert_as_snippet which falls back to current_line and tooltip message), Data Table, and General (which means that these commands are available app-wide) - moved "Disable Command" to scope popup menu since it's related - Input Field and Data Table commands will be shown as submenus in the Bundles main menu; all General commands will be added without creating a special submenu (only Category submenus will be generated) - fixed and simplified several issues
* • Bundle EditorBibiko2010-11-221-0/+6
| | | | | | | | | | - added output action "Show as HTML" • Bundle HTML output - finished implementation - added print support (eg for printing reports) - added text size resizing - added link support - added new window support
* • added line numbering and current line highlighting to Bundle Editor's ↵Bibiko2010-11-211-4/+5
| | | | | | | command text view • made each Bundle in/ouptut file name unique to allow to run different Bundle commands at the same time • fixed minor issues for Bundle Editor
* • Bundle EditorBibiko2010-11-191-2/+4
| | | | | | | | | | | | - fixed saving and duplicating Bundles if Bundle contains other files/folder - fixed adding a new Bundle - added gui tooltips • SPTooltip - if no location was passed and first responder isn't a textView show the tooltip at the mouse location • CopyTable - show tooltip invoked by a Bundle command always at mouse location • Content / Custom Query Table - suppress tooltip of cell content if another tooltip (mainly displayed by a Bundle) is visible [shoudl be improved since iterating through the window list isn't so good]
* • fixed tiny issues for Bundle EditorBibiko2010-11-191-1/+1
| | | | • fixed selector name in CopyTable for Bundle Editor input action
* • Bundle SupportBibiko2010-11-161-23/+147
| | | | | | - improved Data Table input commands SelectedTableRowsAsTab/Csv/SqlInsert, TableRowsAsTab/Csv/SqlInsert • fixed issue for Copy with Column Names: removed ?\020last appended tab in header line
* • Bundle supportBibiko2010-11-161-34/+3
| | | | | | - further simplifications and centralizations - runBashCommandWithEnvironment: now it can execute each script command whose first line begins with #!/... natively - added some more shell variables
* • Bundle supportBibiko2010-11-161-0/+209
| | | | | - added skeleton for scope datatable support - removed unnecessary code
* • minor code cleaning and comment stuffBibiko2010-11-021-214/+233
|
* • Custom and Content table in-cell editingBibiko2010-10-301-0/+10
| | | | - a possible given selection done inside the edited cell will be passed to the field editor sheet for convenience since one often forgets that the field editor sheet mode is active
* • after the field editor sheet was closed enter into the edit mode of the ↵Bibiko2010-10-301-15/+1
| | | | current table cell; this makes it rather convenient to navigate and edit cells via keyboard or mouse for each mode (field editor or incell); the sheet will be ordered out if user tries to modify the current cell if set or blob
* • enabled enter/return/tab enters the edit mode for Content and Custom ↵Bibiko2010-10-301-1/+2
| | | | | | Query table - it will call [self editColumn:0 row:[self selectedRow] withEvent:nil select:YES]; to invoke the incell edit mode, if user tries to modify it the sheet will be displayed if set; further improvements will follow
* • Custom Query and Content table editingBibiko2010-10-291-12/+21
| | | | | - fixed issue for tab navigating if the table is already in the edit mode - !! FOR SAFETY reasons disabled enter/return/tab enters the edit mode !! to avoid crashes until we found a better solution due to the non-waiting field editor sheets
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-3/+0
| | | | | | | | - Prepare for the implementation of PDF and HTML export by hiding the export options box for export types that don't need it. - Fix some spacing issues on the export dialog. - Create a new SPCategoryAdditions header that is included in the apps precompiled header, making all additions available to all classes. - Update strings files.
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|