aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPTableContent.m
Commit message (Collapse)AuthorAgeFilesLines
* • fixed minor issue for filterTable approach in ContentBibiko2011-01-241-2/+24
| | | | - prepared some stuff for table state history
* - Fix problems correctly resetting state when a query affects no rows on ↵rowanbeentje2011-01-141-2/+11
| | | | | | | creating new tables; this could be responsible for -release errors in SPDataStorage, as well as out-of-bounds errors in SPDataStorage or SPTableContent. - Fix incorrect reporting of affected rows in MCPKit due to the use of meta/status queries; only track affected rows for framework-usage queries (already largely implemented in previous revisions)
* • fixed several issues for validation and other stuff while editing of ↵Bibiko2011-01-111-3/+12
| | | | MySQL data tables if user re-ordered columns
* - Fix default population for NOT NULL numeric fields when adding rowsrowanbeentje2011-01-111-3/+11
| | | | | - When saving rows, convert empty strings for NOT NULL numeric fields to 0 rather than NULL to prevent errors
* - Fix split view overlap on the custom query view cuasing lines on ↵rowanbeentje2010-12-211-0/+29
| | | | | | | | | | scrolling/resize; this addresses Issue #929 - Fix split view overlap on the tables list/info pane causing lines on scrolling/resize; this addresses Issue #740 - Add custom resize behaviour for the table content splitview, addressing Issue #543 - Make button bars at the bottom of the window a consistent height - Fix bug with new splitview setup causing tables pane to become narrower with each launch
* - Remove the CURRENT_TIMESTAMP workaround when saving rows as r3013 removes ↵rowanbeentje2010-12-131-17/+8
| | | | the need for it; this also improves speed slightly as non-changed rows can be skipped much earlier
* - When saving rows in the table content view, only include those fields ↵rowanbeentje2010-12-131-73/+82
| | | | | | | | 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
* • Bundle commandsBibiko2010-12-091-1/+5
| | | | - added the shell vars for edited field info as well if Field Editor sheet is used
* • 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
* - Fix maximum table row resetting, which caused a bug when reloading a ↵rowanbeentje2010-12-021-0/+4
| | | | table with a saved page number when previously on a table with no rows. This addresses Issue #912.
* • Bundle CommandsBibiko2010-12-011-9/+27
| | | | | - 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
* • Bundle Editor / Bundle commandsBibiko2010-12-011-0/+20
| | | | | | | - enabled trigger support to run a command if db, table, or table row was changed - HTML output window will be ordered out without making it the key window to remain the first responder • SPTableTExtFieldCell - forgotten to remove expansionFrameWithFrame: method
* - Right-align numeric columns in table content views and custom query resultsrowanbeentje2010-11-271-0/+8
| | | | | - Fix exceptions caused by nil SSL locations when re-saving old session files
* - Abstract SPDatabaseDocument's Connection/.spf saving/loading ↵rowanbeentje2010-11-231-0/+4
| | | | | | | | | | functionality into state setting and getting functions, and refactor old commands to use them - Fix restoring of content sort column order and selected indexes - Add menu items for duplicating current tab (as an alternate), opening selected table in a new tab, or opening selected database in a new tab - Clean up file menu by making Connection/Session "Save as..." menu items alternates - Update localisable strings
* • sequelpro url scheme supportBibiko2010-11-221-0/+12
| | | | | | | • added commands: SelectDocumentView, ReloadContentTableWithWHEREClause • fixed typos • tried to queue incoming commands
* • 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]
* • Bundle SupportBibiko2010-11-161-1/+1
| | | | | | - 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
* • removed unnecessary space inside the WHERE clause generation for ↵Bibiko2010-11-071-1/+1
| | | | filtered table content
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-4/+4
| | | | | | | | | | | central functionality out of SPTablesList: - Centralise control over table loading, moving it away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Centralise control over the main tab view, moving control away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Simplify and clean up view loading logic - Improve thread safety - Update localisable strings
* • Custom and Content table in-cell editingBibiko2010-10-301-0/+14
| | | | - 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-0/+3
| | | | - 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
* • after the field editor sheet was closed enter into the edit mode of the ↵Bibiko2010-10-301-2/+11
| | | | 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/+1
| | | | | | 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-3/+0
| | | | | - 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
* • convert the Field Editor Sheet into a document-modal sheet, i.e. now the ↵Bibiko2010-10-291-40/+56
| | | | | | | | sheet doesn't block the entire app - fixed various layout issues - fixed some tiny memory leaks • fixed tiny memory leak in MCPStreamingResult
* • added tooltip for header cell of Content and Custom Query table ↵Bibiko2010-10-271-0/+1
| | | | | | displaying the column name and field type - fixes issue 875
* • removed memory leakBibiko2010-10-261-1/+1
|
* • improved the TableStructure handling of GEOMETRY fields and their ↵Bibiko2010-10-251-3/+3
| | | | validations against non-valid WKT notations - return NULL if no header
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-6/+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.
* • fixed bug while editing views if a filter is in usageBibiko2010-10-221-2/+1
| | | | - make sure that setTableDetails will always called for the current selected table even if edited field origin is another table
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* Remove use of multiple comments for localized strings.stuconnolly2010-10-191-2/+2
|
* • fixed issue to show/hide the Quicklook GUI item in the Field Editor SheetBibiko2010-10-161-0/+2
| | | | | • attempt to solve the issue of storing ENUM fields in Content View correctly if the user interacts with the mouse on the comboxes for different rows - this addresses the issues 865 and 833
* • implemented filter content type 'spatial' with general spatial operators ↵Bibiko2010-10-151-0/+4
| | | | for usage as filter of spatial fields
* • fixed issue of unnecessary string escaping for importing spatial data ↵Bibiko2010-10-101-2/+2
| | | | | | via GeomFromText() • minor code cosmetics
* • enabled SRID editing of spatial fields via WKT stringBibiko2010-10-091-2/+3
| | | | | - 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-8/+8
| | | | - note: geometrycollection support will follow soon
* • some further work on displaying geometry fields as imageBibiko2010-10-081-1/+9
| | | | - to enable the very first approach simply uncomment code in SPTableContent tableView:toolTipForCell:rect:tableColumn:row:mouseLocation: for MCPGeometryData class
* • improved issues for tooltip in Content and Custom tablesBibiko2010-10-081-10/+21
| | | | | | | - 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
|
* • spatial field supportBibiko2010-10-071-1/+1
| | | | | - fixed issue while editing geometry data in Content View; once a geometry field was edited it will be stored as NSString, if not it keeps a MCPGeometryData - some code cosmetics and commenting
* • enhanced spatial supportBibiko2010-10-071-5/+10
| | | | | - 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-29/+16
| | | | | | | 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
* • added basic support for spatial dataBibiko2010-10-011-8/+30
| | | | | | - while querying and writing back make usage of AsText() and GeomFromText() to allow to edit each GEOMETRY field as text simple string - works only in Content Tab so far - the spatial data are not yet editable inside views
* • some further work on Filter TableBibiko2010-10-011-4/+31
|
* • some very minor code, commenting, and tiny speed improvement stuffBibiko2010-09-301-23/+51
|
* • Filter TableBibiko2010-09-291-3/+8
| | | | | - minor GUI improvements - try to fix issue 1654
* • Filter TableBibiko2010-09-291-1/+4
| | | | - improved operator parsing for >= <= <> ≠ ≤ ≥
* • Filter Table - Set Default OperatorBibiko2010-09-291-11/+86
| | | | - added the chance to define the unmarked default operator