aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCustomQuery.m
Commit message (Collapse)AuthorAgeFilesLines
* • fixed issue of unnecessary string escaping for importing spatial data ↵Bibiko2010-10-101-1/+1
| | | | | | via GeomFromText() • minor code cosmetics
* • enabled SRID editing of spatial fields via WKT stringBibiko2010-10-091-1/+1
| | | | | - the SRID value will be appended at the WKT string like POINT(1 1),101 which will be transformed to GeomFromText('POINT(1 1)',101) on the fly - otherwise the SRID information will be deleted after editing a geometry field
* • improved field editor sheet to support geometry fieldsBibiko2010-10-091-2/+0
| | | | | - additionally it shows the image - image can be saved as pdf if image is displayed via Save button; if text is selected the wkt string will be saved
* • enabled thumbnail images of spatial geometry fields as tooltipsBibiko2010-10-091-1/+9
| | | | - note: geometrycollection support will follow soon
* • improved issues for tooltip in Content and Custom tablesBibiko2010-10-081-8/+20
| | | | | | | - added not yet supported MCPGeometryData view - removed @try clauses, instead make usage of pthread_mutex_lock etc. approach • adjusted autodetectWidthForColumnDefinition: for SPCopyTable to calculate the width by taking the WKT string of MCPGeometryData • added SPGeometryDataView class which will be used for displaying GEOMETRY data as image (for tooltips, inside field editor sheet) [not yet implemented]
* • fixed issue for editing spatial wkt data in field editor sheetBibiko2010-10-081-1/+4
|
* • enhanced spatial supportBibiko2010-10-071-1/+6
| | | | | - implemented native routine to immediate AsText() [MULTIPOLYGON and GEOMETRYCOLLECTION are not yet ready] - enabled editing of spatial data in Content View for tables and views and in Custom Query via wkt strings which will be saved automatically as wkb by using GeomFromText()
* • removed approach to query spatial data by using AsText() since it breaks ↵Bibiko2010-10-071-0/+3
| | | | | | | some column definition approaches - instead introduced a new MCPKit class MCPGeometryData - up to now the spatial data will be displayed as hex bytes - work on it will come soon
* Update Localizable.strings and resolve the use of multiple comments for the ↵stuconnolly2010-09-211-1/+1
| | | | same string.
* - Remove a number of invalid [NSTableView makeFirstResponder] calls that ↵rowanbeentje2010-09-181-2/+2
| | | | | | | had crept into the source, replacing with the correct [NSWindow makeFirstResponder:NSTableView]. This fixes a number of exceptions. - Update localisable strings.
* • BIT Field Sheet Editor now can handle NULL valuesBibiko2010-09-161-0/+5
| | | | • Field Editor Sheet field name label also displays NOT NULL if set
* • added validation for BIT fields while in-cell-editing; only 1 or 0 are ↵Bibiko2010-09-151-4/+23
| | | | | | allowed to type in • enabled max length and BIT field validation for CustomQuery
* • (re?)enabled BIT field editing esp. for field types like BIT(9) or ↵Bibiko2010-09-141-1/+4
| | | | | | | BIT(63) since the old _int2bin routine didn't work because we're dealing with a char* containing bytes if BIT(>8) - also for views and CustomQuery editing • started to clean up (VAR)BINARY editing (work in progress)
* • fix editing validation and doCommandBySelector: stuff for SPCustomQuery ↵Bibiko2010-09-131-1/+3
| | | | | | class to allow eg entering favorite names, typing search pattern for favs and history etc. - this fixes 813
* • 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
* • fixed in field editing mode the editing of BINARY fieldsBibiko2010-08-311-1/+1
|
* • further improvements for in cell editing in CustomQuery tablesBibiko2010-08-271-90/+90
| | | | | | | | - 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
* • removed onMainThread for [Content/CustomTable makeFirstResponder] to ↵Bibiko2010-08-261-53/+84
| | | | | | | | | 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
* Encoding changes and improvements, particularly to increase compatibility ↵rowanbeentje2010-08-251-4/+4
| | | | | | | | | | | 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-251-0/+3
| | | | | | 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-251-8/+13
| | | | 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-251-1/+5
| | | | | | | | 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-241-5/+139
| | | | | | | | | | 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-241-0/+1
| | | | Custom Query table
* • introduced tri-state sort order for Content and Custom Query tablesBibiko2010-08-241-179/+218
| | | | | | | - 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
* • first preparations to allow in cell editing in Custom Query (not yet ↵Bibiko2010-08-221-22/+27
| | | | | | | | | | 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
* • overall replacement of:Bibiko2010-08-201-16/+12
| | | | | | | | | [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!
* • added SPBeginWaitingAlertSheet() routine which offers the chance to ↵Bibiko2010-08-191-11/+19
| | | | | | 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"
* Rename CMCopyTable to SPCopyTable.stuconnolly2010-08-191-1/+1
|
* - Apply column autosizing improvements to custom query loadingrowanbeentje2010-08-161-32/+162
| | | | | | | | - Move Table Content progress tracking onto the main thread's load timer - Improve thread safety when autosizing - Improve autosize to not contrain wide columns as much in tables where all columns can be shown, or if the column is double-clicked to size. (This completes work on Issue #271 and Issue #272)
* - Make a few more strings localizablerowanbeentje2010-08-011-3/+3
|
* - Add support for automatically converting \r and \r\n linebreaks in query ↵rowanbeentje2010-07-291-3/+25
| | | | | | | | syntax to \n. This addresses Issue #652. - Clean up SPSQLParser, and use a few more CFString methods to avoid obj-c messaging in loops - When importing SQL using autodetect, perform a manual SET NAMES if possible to cope with poorly-exported files.
* - Expose a number of help menu items and help buttons to use localisable ↵rowanbeentje2010-07-181-1/+2
| | | | | | | | strings - Tweak MySQL help search to include a localisable language code for results in requested languages This addresses Issue #743
* Improve handling of BIT fields, including:stuconnolly2010-07-151-2/+2
| | | | | | | | | - Exporting BIT fields properly in SQL dumps using b'x' notation. - Properly handling editing of BIT fields in both the content and custom query results views. - Correctly display BIT fields in the content view, where binary values are zero-padded to the specified length of the field. (Note, that the new BIT handling logic has only been added to MCPKit's MCPStreamingResult and MCPResult as the latter does not keep a record of the field's length which the new functionality depends on. Needs to be discussed).
* - Roll back most of r2430, replacing it with an at-source fix to the manual ↵rowanbeentje2010-07-071-0/+2
| | | | | | | collapse via code which was originally causing the problem. Also apply the same fix to SPCustomQuery.m. (Note that this also identifies a probable cause of views going slightly out-of-view if views are collapsed and expanded a lot - the autoResizesSubviews property is disabled and re-enabled in BWToolKit surrounding a collapse, but this is done using a timer with the exact time interval as the corresponding collapse/expand frame resize. This sets up a race condition, where if the timer fires before the animation completes, the internal view will be slightly clipped. May require a BWToolKit fix)
* Rename CustomQuery as SPCustomQuery.stuconnolly2010-07-061-0/+3287