aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* • open a SQL file via Finder or Terminal (open *.sql if SP is the default ↵Bibiko2009-08-055-5/+54
| | | | | | | app for sql files) will insert the file content into the Custom Query editor of the current active doc - this action starts SP and asks for a connection if it is not running - same for drag&drop a SQL file onto SP's dock icon
* Fix sortorder of tables in export multiple tables as CSV/XML accesory viewbamse162009-08-051-3/+15
|
* In addition to fn+return give the OK button in the content edit sheet the ↵stuconnolly2009-08-051-2/+3
| | | | key equivalent cmd+return. Implements #321.
* - Fix some small memory leaks when changing tablesrowanbeentje2009-08-044-10/+24
| | | | | - Fix the history navigation to correctly switch across databases without invalid history states
* • initial support for open/save connection files (*.spf)Bibiko2009-08-046-5/+256
| | | | | | | | | - Open/Save menu items are hidden • initial support for drag&drop files *.spf and *.sql to SP's icon or double-click at *.sql or *.spf files in Finder - SP starts if not already running - sql files will be executed in the Custom Query if at least one connection is open - spf files not yet supported -
* (no commit message)Bibiko2009-08-041-0/+4
|
* • fixed bug for focus setting after database choiceBibiko2009-08-041-2/+7
| | | | - it sets the focus to table list filter field only if it's visible, otherwise it sets the focus to the Table List view directly
* • changed keyboard navigationBibiko2009-08-043-13/+202
| | | | | - set focus to Table List filter field after selecting a database - TAB key in Table List filter field sets focus to Table List for selection/navigation
* • some corrections for Custom Query completionBibiko2009-08-041-24/+14
| | | | | | - fixed issue if caret is inside `` for the narrow-down completion - fixed issue to add all 'Functions' for the "normal" completion - some minor code cleaning
* - Add a placeholder hint in the SSH password field to indicate public keys ↵rowanbeentje2009-08-041-27/+43
| | | | are used if available
* This shouldn't actually be negated as a return value of YES indicating that ↵stuconnolly2009-08-031-1/+1
| | | | NULLs are allowed is correct and we can color it if it also matches the user's NULL placeholder.
* • add Menu Item "Insert NULL value" SHIFT+CTRL+NBibiko2009-08-035-6/+250
| | | | | | | - it inserts the value set in the preferences • a NULL value will be displayed greyed in the Custom Query result • make usage of NSArrayObjectAtIndex() in TableContent for tableView:willDisplayCell - and negated the NULL checking for column (is NULL allowed)
* When blob/text fields are loaded on demand also color them light gray if ↵stuconnolly2009-08-031-1/+1
| | | | they are actually NULL.
* Use light gray rather than gray for displaying NULLs and blog/text fields ↵stuconnolly2009-08-031-2/+2
| | | | that aren't loaded.
* Don't release the server variables array as it's simply a weak reference ↵stuconnolly2009-08-031-7/+9
| | | | when filtering is not taking place, fixes a crash. Also, if the panel is opened and the search field contains a value that was previously filter using, perform the filtering using this value before the sheet is displayed.
* Display the user specified NULL value placeholder in grey when displaying a ↵stuconnolly2009-08-031-26/+27
| | | | table's content. Fixes issue 337.#
* - Implement live filtering of the server variables table viewstuconnolly2009-08-033-86/+225
| | | | | | - Update the save variables button to save the current filtered variables if necessary - Remove old/unused NSSplitView code
* In the field editor sheet:stuconnolly2009-08-032-87/+228
| | | | | | - Make some of the QuickLook format menuitem name's uppercase. - Run both the save and open panels as sheets to prevent blocking the entire app.
* - Upgrade version string to 0.9.6rowanbeentje2009-08-022-3/+3
|
* • button tooltip for "Show / Hide Table Information" toggles according to ↵Bibiko2009-08-022-0/+9
| | | | | | | its status • after editing a field in Custom Query table scroll to last selected row after data refreshing - (TODO: should be improved in near future)
* - Add a tooltip to the table information pane toggle buttonrowanbeentje2009-08-023-42/+49
| | | | | | | - Change the "[Show/Hide] Console" button in the toolbar to a "Console" button, which shows or brings the console window to the front - Update the default toolbar state to reflect recent additions - Reset everyone's toolbars to ensure that normal users will have the new icons available and visible
* Overhaul CSV import functionality:rowanbeentje2009-08-021-116/+244
| | | | | | | - When selecting CSVs SP will attempt to auto-detect the line endings to use - Throw an error if the CSV to be imported appears to have more than 512 columns, usually due to wrong line ending/quote/etc selection - Rewrite the CSV parser completely. New version correctly deals with CSV line terminators which are escaped or in enclosed content, correctly deals with quote strings which are the same as escape strings, and fixes a number of small edge cases. Performance on very long complex strings is slightly slower (~1.5 slower on long strings) but on large but simple tables is faster (~2.2x faster); memory usage is ~1.3x as high but all autoreleased. This addresses Issue #252.
* - Fix an errant NSLog in TableSourcerowanbeentje2009-08-018-113/+360
| | | | | | - Improve and make consistent state saving in TableContent; now saves filters and scroll position mor reliably on refresh/edit, and supports remembering and restoring which rows were selected - Significantly improve table history - only create entries for tables switches or filters, only remember 50 items, and save view/filters/scroll position/selections in table content view
* Put the table content filter in a split view so the field name drop down and ↵stuconnolly2009-08-013-312/+408
| | | | search field can be resized. Addresses issue #339.
* Update the properties of the record count textfield on the CSV mapping ↵stuconnolly2009-07-311-10/+21
| | | | import sheet so it correctly resizes and truncates as appropriate.
* The size of the import array only needs to be counted once.stuconnolly2009-07-311-5/+6
|
* • Favorite Preferences - Favorite name issues fixed:Bibiko2009-07-313-29/+292
| | | | | | | - Trap and control the 'name' field of the new added favorite. If the user pressed 'Add Favorite' the 'name' field is set to "New Favorite". If the user do not change the 'name' field or the user deletes the field content it will be set to user@host automatically. This also fixes the issue for empty names. - focus is set to 'Host' field after "Add Favorite" - focus is set to 'Name' field after "Duplicate Favorite"
* Decrease the size of the software update frequency popup button in the ↵stuconnolly2009-07-311-12/+13
| | | | preferences.
* - Hide advanced query logging options for the time being as they are still ↵rowanbeentje2009-07-311-38/+55
| | | | non-functional
* - Update the 'this table does not support relations' to be a little more ↵stuconnolly2009-07-302-27/+25
| | | | | | | informative. - Increase the size of the table selection NSPopupButton on the CSV import field mapping panel.
* - Add an initial barebones version of the history controller, with a basic ↵rowanbeentje2009-07-308-28/+508
| | | | toolbar item to navigate backwards and forwards. TBC!
* - don't add an empty query to historyBibiko2009-07-291-8/+9
| | | | | - suppress "error highlighting" for an empty query - this also fixes the issue for inserting an history/favorite item after executing an empty query (due to an exception it wasn't possible) - removed several test NSLogs
* - Added Splitview delegate method to hide the drag handle on the Table Info ↵avenjamin2009-07-292-5/+32
| | | | pane and Filter view.
* - Fix "endSheet:returnCode: requires a non-nil sheet" log lines during importsrowanbeentje2009-07-282-12/+12
| | | | | | - Enable threaded animation for import/export progress bars as it has minimal overhead and looks nicer - Fix exceptions caused by tablesList drawing during imports
* - Clear selection if user is filtering table list with multiple tables ↵rowanbeentje2009-07-281-4/+7
| | | | selected, to avoid issues
* - When getting splitview sizes to resize database menu, correctly use the ↵rowanbeentje2009-07-282-3/+3
| | | | | | | subview size directly instead of the contents of the scrollview (which incorrectly doesn't measure presence of the scrollbar) - Remove the connection view entirely once a window has connected, fixing resize events following document splitview resize
* - Remove compression option in mysql_options (already set as part of ↵rowanbeentje2009-07-281-4/+1
| | | | | | | connection flags) - Add CLIENT_REMEMBER_OPTIONS to connection flags
* • fixed and improved several issues for sorting the Custom Query result table:Bibiko2009-07-281-8/+59
| | | | | | - better ORDER BY detection - (try to) insert ORDER BY clause at the correct position (e.g. "SELECT * FROM A LIMIT 10 - ORDER clause has to be inserted before LIMIT) - preserve the sort order after editing a field
* Improve TablesList significantly:rowanbeentje2009-07-2810-657/+1309
| | | | | | | | - If there are twenty or more tables, show a table quicksearch/filter at the top of the list, and update the rest of the code to match. This addresses issue #178. - Select tables and views alphabetically by user's current locale (instead of default MySQL "A B C a b c") - When adding or duplicating tables, insert them at the correct point - Fix a number of minor display bugs caused by incorrect interaction with the tables list caches
* • Editing in Custom Query:Bibiko2009-07-262-29/+49
| | | | | - now fields are also identified via the database which the field belongs to in order to allow to select/join/etc. fields coming from different databases and to improve the unambiguity of the field origin - sped up editing check for fields with no table or database origin (then no "select count(*)" is needed)
* - Add keyboard shortcuts for Add and Delete buttons in Table Relations panerowanbeentje2009-07-262-160/+90
| | | | | | | | - Remove hidden, non-implemented menu in create table relation add dialog to improve tabbing through fields in the popup - Add cancel shortcut in the table relation add dialog - Prevent table relations table cells from being edited, as edit support isn't present yet - clean up tooltips to fix references to Indexes
* - Tweak table information panel to show scrollbars if it's resized to a ↵rowanbeentje2009-07-2611-29/+164
| | | | | | | | position that would hide content - Store collapse state of table information panel in preferences - Apply a double fix for BWSplitView/NSSplitView+BWAnchoredButtonBar not informing delegates of resizes - correctly inform original BWSplitView delegates of resizes, and allow BWAnchoredButtonBar registered delegates to recieve the original split view resize notifications. This fixes database menu resizing in synch with splitview resizing for improved/consistent look and feel.
* Order some files alphabetically in XCode... (is it possible to do this ↵bamse162009-07-241-29/+29
| | | | automatically?)
* - For custom query result columns which map to SQL fields, check the column ↵rowanbeentje2009-07-243-187/+105
| | | | | | | width memory to set column widths - Save custom query result columns back to the master column width store for columns witch map to SQL fields
* - Fix editing of results including decimalsrowanbeentje2009-07-232-5/+6
| | | | | - Enable custom query result editing
* To fix query logging not working, initialize delegateQueryLogging to YES ↵stuconnolly2009-07-233-5/+38
| | | | upon connection initialization as well as setting the value based on the user's preferences during initiateMySQLConnection in SPConnectionController. Also, initialize delegateResponseToWillQueryString when the connection's delegate is set and revert back to simply calling the delegate method willQueryString:connection: as opposed to using the selector cache as its currently not working. Might need to look into restoring this if we incur a big performance hit after this revision.
* - Fix a large memory leak in [MCPConnection prepareString]rowanbeentje2009-07-231-1/+1
|
* Remove delegate calls asking for SP specific TableDocument ivars, replacing ↵stuconnolly2009-07-223-9/+29
| | | | them with more generic delegate methods.
* - Allow the reconnection dialogs to function correctly if anything other ↵rowanbeentje2009-07-222-7/+9
| | | | | | | than "Disconnect" is selected - Fix tunnel restarts
* - Restore MySQL 3.x compatibilityrowanbeentje2009-07-221-3/+3
|
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-27 18:48:37 +0000
226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 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 1742 1743 1744 1745