aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPCustomQuery.m
Commit message (Collapse)AuthorAgeFilesLines
* • 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
* • 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
* • 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
* • enabled Find Panel inside Field Editor Sheet's textViewBibiko2010-10-291-12/+5
| | | | | | | | - to enable Find Panel in such a NSTextView which will be displayed in a sheet one has to do the following: * [main problem is that Find Panel validates its buttons against [[NSApp mainWindow] firstResponder] == NSTextView] * subclass the NSTextView and add the methods becomeFirstResponder and resignFirstResponder which has to return YES * since the last first responder remains the first mainWindow responder status one has to set [[NSApp mainWindow] makeFirstResponder:theTextView] directly after displaying the sheet • corrected SPUserManager message in (IBAction)removeHost:
* • convert the Field Editor Sheet into a document-modal sheet, i.e. now the ↵Bibiko2010-10-291-14/+43
| | | | | | | | sheet doesn't block the entire app - fixed various layout issues - fixed some tiny memory leaks • fixed tiny memory leak in MCPStreamingResult
* Add SPDefaultPasteboardDragType constant.stuconnolly2010-10-281-3/+3
|
* • 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
* - Split out all of SPExportController's delegate methods to their own category.stuconnolly2010-10-241-5/+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
|
* • 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!
generated by cgit v1.2.3 (git 2.25.1) at 2024-12-19 07:34:27 +0000
f='#n1365'>1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741