aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* Enabled Page Setup for printing, so now you can print landscape toobamse162009-03-261-1/+2
| | | | | | Enabled auto pagination, so we print everything for now
* - Refactor custom query results redrawing code and reset view position to ↵rowanbeentje2009-03-251-23/+17
| | | | avoid out-of-range assertions when switching from a larger dataset to a smaller dataset; this fixes Issue #189
* Fix a reproducible sort-sort-refresh-sort crash bug by explicitly managing ↵rowanbeentje2009-03-251-3/+7
| | | | sortField and not referencing possibly deallocated column identifiers directly
* Added hidden preference to automatically select the last favorite you used.bamse162009-03-241-0/+6
| | | | | | To enable this feature write in Terminal: bash $ defaults write com.google.code.sequel-pro selectLastFavoriteUsed YES
* - fixed issue #203 (backticks in identifiers not supported)jakob2009-03-2410-101/+217
| | | | | | | | - added a backtickQuotedString: method to SPStringAdditions - created the file SPArrayAdditions for a componentsJoinedAndBacktickQuoted: method In the future, we should use backtickQuotedString: to quote identifiers like this: [NSString stringWithFormat:@"SELECT * FROM %@", [tableName backtickQuotedString]]
* Issue 201: Duplicating a row resets values of text/blob fields in the new rowbamse162009-03-231-4/+4
| | | | | Changes after code review: renamed variable, replaced @"NULL" with [prefs objectForKey:@"nullValue"]
* Issue 201: Duplicating a row resets values of text/blob fields in the new rowbamse162009-03-231-4/+14
| | | | | | | | | | Fixed - If you attempt to duplicate a row in tables where blob/text data is present but hidden and there are no keys, SP correctly pops up the dialog but then continues execution, and so crashes. Fixed - If the row being duplicated contains NULL data, exceptions triggered by [NSNull length] are thrown, and SP stops responding. Thanks to Rowan for code review
* Issue 194: reload table list deselects tablesbamse162009-03-231-1/+13
|
* Issue 202: NULL is prefilled in a non-NULL text fieldbamse162009-03-221-1/+6
| | | | | | | Now, if a field has NOT NULL, the default value is '' (empty string), unless the field is autoincrement, when we can keep the NULL value.
* Issue #201 Duplicating a row resets values of text/blob fields in the new rowbamse162009-03-223-48/+65
|
* - Added tooltips to action button menu itemsavenjamin2009-03-222-2/+15
| | | | - Removed refresh tables menu item - refresh button right beside it.
* - Removed old no longer used images.avenjamin2009-03-211-1/+6
|
* - changed the status message after executing a custom query to read "1 row ↵jakob2009-03-201-11/+27
| | | | affected" / "6 rows affected" rather than "1 row(s) affected"
* SPSQLParser changes:rowanbeentje2009-03-1910-201/+574
| | | | | | | | | | | | | | | | | | - Use method caches for oft-called functions, and support caching of chunks of the underlying string for string walking, resulting in an overall 1.3x-1.4x parsing speedup. - Improve handling of multi-character comment starts (eg / or -) at the very end of strings - When running splitString... methods return even empty strings for consistency. - Update TableDump and TableData to match new usage SPStringAddition changes: - Add a formatter for time intervals. CMMCPConnection changes: - Add support for timing queries CustomQuery and nib changes: - Change the "Run Queries" button to "Run All". - Add a "Run Current" button, which runs the query the text caret is currently positioned inside; if text is actually selected, this changes to "Run Selection". This addresses Issue #43. - Amend the "rows affected" string to better reflect the actual number of rows altered by several queries, show the query count if > 1, and display the overall execution time of the queries. This addresses Issue #142. - No longer execute blank strings as part of the custom query, preventing errors.
* As Rowan's suggestion, I've replaced older/younger with after/beforebamse162009-03-191-1/+1
| | | | | | #198 Older-Younger swapped meaning
* - updated list of keywords used for syntax highlighting (eg. IN was missing)jakob2009-03-181-269/+222
|
* - changed default colors for syntax coloringjakob2009-03-173-65/+109
| | | | | - disabled syntax coloring for texts larger than 20KB (too slow) - added alot of comments to the syntax coloring code
* adding syntax coloring (issue #46 )jakob2009-03-163-0/+420
|
* - Fix an old bug where adding rows when "Reload table after adding a row" ↵rowanbeentje2009-03-111-2/+2
| | | | | | | was switched off inserted the wrong value for autoincrement columns, throwing exceptions and breaking SP - Fix a bug in the autoincrement check which exposed the bug above even when no autoincrement was set.
* More small bugfixesbamse162009-03-111-0/+2
|
* Small fixes clang complained about. Others will followbamse162009-03-112-7/+15
|
* - Increment trunk version number to 0.9.4rowanbeentje2009-03-114-8/+27
| | | | | | | - Improves on r370 and r375 by preventing actions triggered by the save from triggering saves themselves - Improves further on r370 and r375 by committing any current edits before saving - Additional comments
* Additional error checking, centralised connection keep-alive interval ↵rowanbeentje2009-03-092-10/+33
| | | | retrieval, and support for disabling keep-alive by setting the interval to 0.
* Fixes a division by zero error causing crashes on multi-table CSV and XML ↵rowanbeentje2009-03-051-2/+2
| | | | exports (Issue #184)
* - Fix a number of edit sheet crashers regarding opening and saving files, ↵rowanbeentje2009-03-055-36/+156
| | | | | | | | | image deletions, and image drag and dropping (fixes Issue #85 and google groups report) - Improves compatbility of drag-and-drops onto the image well, including support for image drags from other applications - Attempt to automatically select the image or text tab in the edit sheet as appropriate - Fixes build-from-clean warnings caused by an unexposed function added in r375
* Added column names to completion list for for currently selected table.avenjamin2009-03-051-3/+14
|
* Improves the table structure view to only save a row when properly ↵rowanbeentje2009-03-054-43/+95
| | | | deselected, and automatically reselecting the row for re-edit on error - resolves Issue #74.
* Don't allow the table list to be completely out of sight by not allowing the ↵stuconnolly2009-03-041-2/+2
| | | | collapsing of the split view's subview. Minimum subvew view width has also been reduced by 20px. Fixes issue #150.
* Alter the open panel to recognise .csv and .sql extensions on selected files ↵rowanbeentje2009-03-042-0/+27
| | | | and automatically change the format dropdown to match
* Fix a bug related to not saving unchanged-but-edited rows, introduced in r370.rowanbeentje2009-03-041-2/+6
|
* - Renames "Database Encoding" menu item in Database menu to "View Using ↵rowanbeentje2009-03-043-34/+82
| | | | | | | | Encoding" for clarity - Add support for EUC-KR (I think, unable to test), hopefully fixing Issue #149 - Add workaround for UTF8 via Latin 1, supporting viewing and editing of data added using broken clients/upgraded old Wordpress/etc.
* - BLOB and binary fields are now fully visible and editable again (fixes ↵rowanbeentje2009-03-038-52/+140
| | | | | | | | | Issue #155) - Added basic support for viewing, filtering, and editing BIT columns (resolves Issue #127 in basic form) - Rewrites selection/save handling. Rows are now only written to database if their content has changed, resolving a long-standing complaint; row selection and editing has also been improved, improving edit/save interaction (fixes Issue #157) and allowing re-editing of the row on failure (fixes Issue #115). Hopefully also addresses #Issue 131, and improves Issue #172. - Hides the console window when the associated document window closes
* - Re-design the custom query favourties editor and get rid of the nasty ↵stuconnolly2009-03-022-39/+21
| | | | | | | plus/minus buttons. Also add some interface element validation. - Tidy up CustomQuery.h by getting rid of the definition of all datasource and delegate method signatures which don't need to be declared.
* Rollback on newbie mistake...bamse162009-03-021-10/+1
|
* Better error handling of dump reading (checking for NSError object instead ↵bamse162009-03-022-4/+27
| | | | | | | | of content of read string) Raising error when trying to import empty CSV file.
* - In the table status view use the user's long date format and medium time ↵stuconnolly2009-03-012-69/+102
| | | | | | | format when displaying the create and update date/time of the selected table. - In the table info pane set the date formatter's behaviour otherwise setting it's date and time style have no effect. Also consolidate the date formatting code into a single private method to reduce the amount of code duplication.
* Fix an issue where by selecting to view the content of a table without the ↵stuconnolly2009-03-011-16/+14
| | | | option of fetching the accurate row count and limiting the result, results in the displayed row count being zero. Caused by fetching the count as the number of items in the fullResult array which hadn't been populated yet. If we are displaying the entire contents of the table set the count to the count of the fullResult array rather than relying on the numRows variable as the array is now populated.
* Revert 10.5 build warning changes and make import progress sheet have focus ↵stuconnolly2009-03-011-39/+28
| | | | when displayed.
* Implemented method: componentsSeparatedByCharactersInSet. to be compatible ↵avenjamin2009-02-283-0/+38
| | | | with 10.4+
* Cleaned up warnings when building against 10.5 SDKavenjamin2009-02-285-40/+52
|
* Reduce the amount of padding on the new console panel and also auto save its ↵stuconnolly2009-02-281-0/+12
| | | | position. Thanks to Rowan for suggesting these.
* - Improve handling of disconnections made while selecting a database, ↵rowanbeentje2009-02-282-12/+25
| | | | | | | | fixing a crasher when suffering from network issues - When prompting for an export filename, only select the filename for editing and not the extension - Remove timing debug from CSV export
* + Separate the console from being drawer based to its own panel. New console ↵stuconnolly2009-02-286-104/+226
| | | | | | | | | panel also adds the ability to save the current console content to a file on disk. Speed up the updating of the text view by removing the re-draw of the view after each message is appended. The console is still very basic, but is a starting point for more functionality to be added now that it is all handled in a single class. + Add the ability to specify the encoding when creating a new database. Addresses issue #125. Also improve the usability of the create database sheet by only enabling the 'Add' button if the database name length is greater than zero. This elimates the check that is done and the error panel that is displayed if the name is empty.
* Applies connection checks and keepalive logic to select database/refresh ↵rowanbeentje2009-02-282-0/+33
| | | | databases queries. This fixes Issue #176.
* Patch submitted by Marius Ursache.avenjamin2009-02-271-77/+86
| | | | | - Fixes crash when you import a csv file into an empty table. - Added auto refresh of tables list when you import an sql file.
* - Removed unnecessary code block.avenjamin2009-02-273-12/+20
| | | | | | - Added 10.4 (Tiger) support for varchar/char length limits Related to Issue #170
* Added length limits to varchar and char fields. Issue #170avenjamin2009-02-273-1/+36
| | | | Ideally we should add these limits for other field types depending on their length value.
* Implement a connection keepalive, addressing Issue #171. This runs a ping ↵rowanbeentje2009-02-253-9/+91
| | | | every sixty seconds (a value stored in prefs, though not exposed via the prefs interface yet) in a background thread, to further improve connectivity handling following r334. Pings are only run when necessary - ie active use of the program extends the next ping interval as appropriate, so general impact should be minimal.
* Replaces COUNT(*) with COUNT(1), which reportedly shows a speed increase on ↵rowanbeentje2009-02-241-2/+2
| | | | certain tables and views. (Thanks to Marius Ursache for this patch)
* Fix table creation, deletion, duplication following recent changesrowanbeentje2009-02-241-2/+8
|
generated by cgit v1.2.3 (git 2.25.1) at 2024-10-11 11:13:44 +0000
id='n1241' href='#n1241'>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 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130