aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCustomQuery.m
Commit message (Collapse)AuthorAgeFilesLines
...
* - Clean up SPMySQL and QueryKit inclusion and search methods, which should ↵rowanbeentje2012-03-271-3/+1
| | | | | | | fix nightly builds - Fix warnings
* tweaks to compile on Xcode 4 / 10.6 SDK for SP_REFACTORsqlprodev2012-03-271-2/+11
|
* - Fix exceptions caused when resizing custom query columns which don't map ↵rowanbeentje2012-03-241-3/+3
| | | | to underlying table columns on certain 5.0.x MySQL versions
* - When exporting a query result or filtered table view make sure we're ↵stuconnolly2012-03-201-7/+9
| | | | | | | | including the entire content of BLOBs, not just what we display. Fixes issue #1124. - Move SPTableContent's table view datasource and delegate methods to separate categories in order to reduce it's size.
* Warning: this branch commit is largely untested, and known to throw ↵rowanbeentje2012-02-231-65/+64
| | | | | | | | | | | | 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-5/+5
|
* When exporting a query result as CSV ensure that we're allowing the exporter ↵stuconnolly2012-01-141-162/+202
| | | | decide how to deal with NULLs rather than passing them already converted to the user's placeholder prefernce which results in them being quoted. Fixes issue #1281. Also, general tidy up.
* - 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
* • fixed issue for line numbering view if associated textView is scrolled ↵Bibiko2012-01-051-1/+1
| | | | | | from origin {0,0}; now it's synchronized • minor speed ups for custom query editor
* - Update code to use NSStrings for NSTableColumn identifiers, as per 10.7 SDKrowanbeentje2011-10-171-38/+21
| | | | | - Update localizable strings
* - Rework table data saving to ensure that cells that should be edited via ↵rowanbeentje2011-10-051-146/+109
| | | | | | | 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
* - Fix editing of binary string values, a regression in r3428; addresses log ↵rowanbeentje2011-09-221-0/+3
| | | | 2665
* Rework linebreak handling in content and custom query result views, as ↵rowanbeentje2011-09-211-19/+35
| | | | | | | | | | | 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)
* Tidy up console/query controller.stuconnolly2011-09-031-0/+1
|
* - Clean up undo manager handlingrowanbeentje2011-08-311-0/+7
| | | | | - Implement an undo manager per tab (strictly speaking, per connection 'document'), addressing Issue #1109.
* Rework editable row checks in views and custom query results:rowanbeentje2011-08-241-31/+21
| | | | | | | | - Only include columns from the same database, even if they share the same table name - If a primary key was found that can be checked, use all the columns specified in the primary key - Correctly escape and format values in primary key columns - Clean up logic and string generation
* merged latest SP_REFACTOR changessqlprodev2011-08-021-12/+0
|
* Tidy up.stuconnolly2011-07-251-5/+13
|
* - Fix exceptions editing non-unique-keyed views or custom query results ↵rowanbeentje2011-07-101-15/+23
| | | | | | | with some kinds of binary data, fixing http://spbug.com/l/1412 . - Clean up logic and code
* - Fix exceptions seen in 0.9.9RC related to query favorites with nil query ↵rowanbeentje2011-06-201-2/+6
| | | | | | | texts (L2239) - Update localisable strings
* • changed the MySQL web search pathBibiko2011-05-201-4/+5
| | | | | - since Oracle provides the search engine we lost the chance to search for a given language and MySQL version; due to that fact we assume that the search term by itself is the name of a valid HTML file within the dev.mysql.com domain, if not it falls back to Oracle's search engine but unfortunately with the extension ".html" which leads sometimes to no hits - it's needed to find a better way
* merging SP_REFACTOR branch with trunksqlprodev2011-05-191-1/+13
|
* - When importing CSVs, or editing custom query results, set numeric fields ↵rowanbeentje2011-05-091-4/+9
| | | | to NULL instead of 0 if an empty string is entered. This matches TableContent behaviour and addresses Issue #1034.
* • send current event after displaying field editor sheet for editing table ↵Bibiko2011-05-081-0/+4
| | | | | | cells - fixes i1022
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-1/+1
|
* Fixes source text encoding problems accidentally introduced in r3273sqlprodev2011-04-141-15/+15
|
* SP_REFACTOR: Workaround for naming conflict with ↵sqlprodev2011-04-141-33/+29
| | | | postNotificationOnMainThread: which also exists in TCMPortMapper.framework; NSUserDefaults access now permitted in SP_REFACTOR blocks for a few prefs keys
* Make some minor changes after reviewing r3271:rowanbeentje2011-04-141-16/+16
| | | | | | - Fix a few encoding issues - Recode a few [NSApp keyWindow] uses back to [SPDatabaseDocument parentWindow] following discussion; possibly for later refactoring into use of an error method
* initial commit of SP_REFACTOR ifdefs, the start of a long quest to separate ↵sqlprodev2011-04-111-18/+146
| | | | UI code from functional code
* • fixed i995 : affected rows returned -1Bibiko2011-03-071-1/+1
| | | | - due to http://dev.mysql.com/doc/refman/5.1/en/mysql-affected-rows.html mysql_affected_rows() normally returns a my_ulonglong BUT it can return -1; thus we have to check whether it is >= 0 via [mySQLConnection affectedRows] != (my_ulonglong)~0
* Fix more compiler warnings, including a few bugsrowanbeentje2011-03-071-24/+28
|
* - Fix more compiler warningsrowanbeentje2011-03-041-9/+9
|
* Fix more compiler warnings.stuconnolly2011-03-031-2/+2
|
* Fix compiler warnings.stuconnolly2011-03-011-3/+5
|
* fixed compiler warningssqlprodev2011-03-011-2/+0
|
* - When loading tables, ensure that the column count is updated before table ↵rowanbeentje2011-02-151-3/+4
| | | | timers are set up. This prevents accesses of SPTableStorages while column change realloc/dealloc processes are still running, fixing exceptions on large tables
* • fixed issue to highlight the correct current query after undoing, i.e. ↵Bibiko2011-01-141-1/+5
| | | | | | | do not using the cache • added SP_SELECTED_TEXT_RANGE shell variable for Bundle support of scope Input Text • added 'insertText', 'setText', 'setSelectedTextRange' JavaScript functions to window.system bridge
* • fixed several issues for validation and other stuff while editing of ↵Bibiko2011-01-111-4/+5
| | | | MySQL data tables if user re-ordered columns
* • Bundle commandsBibiko2010-12-091-0/+7
| | | | - added the shell vars for edited field info as well if Field Editor sheet is used
* • Bundle CommandsBibiko2010-12-091-0/+48
| | | | | | - 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 command supportBibiko2010-12-071-0/+8
| | | | | - 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
* - Add the ability to stop animation of the task indicator, and use it to ↵rowanbeentje2010-12-051-0/+2
| | | | pause the task indicator animation when custom queries are paused and waiting for user interaction after an error
* - Show and hide the custom query info area based on whether custom query ↵rowanbeentje2010-12-041-37/+57
| | | | | | | | | | errors occurred, starting off hidden - Add "errors"/"no errors" prefix to the custom query status area - Add an import cancelled line to the import error list when stopping imports after errors - Fix custom query error highlighting by scrolling to the error - Update localisable strings
* - Rework insertCommonPrefix to insertAutocompletePlaceholder, implementing ↵rowanbeentje2010-11-301-0/+16
| | | | | | | | | a more Mac-like behaviour: insert a faded placeholder for the currently selected autocomplete item. - Update the autocomplete placeholder when the autocomplete dropdown selection is changed - Clean up methods for removing placeholders, and ensure the placeholder is always removed (fixes issues with pasting with a placeholder visible, etc) - When the Help window is closed, switch off AutoHelp - this will aid in supporting those users who accidentally switch on AutoHelp and then can't figure out how to switch it off, resulting in returning windows.
* - Right-align numeric columns in table content views and custom query resultsrowanbeentje2010-11-271-0/+7
| | | | | - Fix exceptions caused by nil SSL locations when re-saving old session files
* • Bundle EditorBibiko2010-11-191-0/+8
| | | | | | | | | | | | - 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]
* • started to implement auto-completion for aliasesBibiko2010-11-041-0/+8
| | | | | - first sketch should work for 90% of all cases - fine-tuning will follow soon - this follows issue 880
* • after editing the Custom Query table remain the focus on that tableBibiko2010-11-011-1/+3
|
* • Custom and Content table in-cell editingBibiko2010-10-301-0/+16
| | | | - 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
* • fixed tiny issues for field editing in Content and Custom tableBibiko2010-10-301-3/+0
| | | | - note: for Custom table the re-entering into the edit mode was removed since for a slow reload it doesn't work, ie we've to look for a better way