aboutsummaryrefslogtreecommitdiffstats
Commit message (Collapse)AuthorAgeFilesLines
* * Change main windows minimum width to 720px for content to fit and make 2 ↵dmoagx2010-09-132-414/+508
| | | | | | windows side-by-side still fit on a 1440px MBP screen * Change user manager > resources from NSForm to regular labels and text fields for translation
* * Fix string width as reported by Alexander Vasiliev (ru)dmoagx2010-09-125-487/+286
| | | | * Make the table status tab date formatter use medium style or the string would be too large at smallest window width
* • added to Structure source table's context menu item: "Show optimized ↵Bibiko2010-09-123-11/+104
| | | | field type" which will come up with a suggested field type calculated by PROCEDURE ANALYSE(0,8192)
* • SPTableStructure's source table saves its column widthsBibiko2010-09-102-5/+5
| | | | • SPQueryController: removed unnecessary [table reloadData]
* • SPTableStructureBibiko2010-09-101-1/+1
| | | | - fixed bug for renaming a field name (issue 808)
* • TableStructureBibiko2010-09-101-4/+4
| | | | - fixed monoSpacedFont for index table refresh and setting
* • TableStructureBibiko2010-09-101-160/+113
| | | | | | | | - added basic field type and argument validations like unsigned should not be used for string types, etc. - added field types DEC, FIXED, NUMERIC for validation - simplified addRowToDb code to avoid double-coding - after removing a field preserve the focus on the source table for keyboard navigation - minor code improvements
* • TableStructureBibiko2010-09-102-90/+195
| | | | | | | - added support for field types SERIAL and BOOL(EAN) - added extra setting and support for SERIAL DEFAULT VALUE - fixed several string comparisons based on user input, ie trim it and compare it upper or lower cased resp. - if adding or changing of a field fails display the SQL statement which caused the error in the error sheet for better debugging
* • TableStructureBibiko2010-09-103-55/+104
| | | | | | - moved field type suggestions for combobox as data source to SPTableStructure - applied type combobox lowercased completion while typing - improved DEFAULT handling for any numeric, date, time fields if DEFAULT was set to an empty string '' - if so skip it to avoid unnecessary error messages
* • fixed _supportsEncoding setting to dis/enable safely Database > View ↵Bibiko2010-09-101-1/+6
| | | | Using Encoding
* • for Structure editing: try to save a row being edited _before_ the row ↵Bibiko2010-09-091-0/+7
| | | | selection will change - mainly if user changes something via mouse event on comboboxes or popupbuttons; if saving fails suppress the new row selection
* • Structure editingBibiko2010-09-093-51/+380
| | | | | | | - fixed issue while drag&drop an auto_inc field > ignore DEFAULT - fixed several keyboard navigation issues - further code improvements - fixed encoding editing
* • StructureBibiko2010-09-091-0/+8
| | | | - reset collation if encoding was changed
* • [SPDatabase getDatabaseCollationsForEncoding:] now uses a cache to ↵Bibiko2010-09-093-7/+34
| | | | | | | | reduce the querying of info_schema - this fixes the querying of each reloadData in [SPTableStructure objectValueFor:] • autoreleased mutableCopy in [SPTableStructure loadTable] • fixed drag&drop query in SPTableStructure to copy charset and collation as well
* Uppercase field types popup cell in table structure view.stuconnolly2010-09-091-613/+623
|
* • TableStructureBibiko2010-09-094-515/+733
| | | | | | | - changed: field information are retrieved via [SPTableData columns]; mainly to get all infos like comment, encoding, and collation - added the chance to edit encoding, collation, and comment for each field Note: This is work is progress - not yet optimized but fully workable. Due to GUI I simply added these three columns - improvements will follow
* - Alter the connection view layout, moving the connection details forms ↵rowanbeentje2010-09-094-1560/+1654
| | | | | | | into a scrollview. Switch to centering the form in code, which allows better control and automatic scrollview triggering if the window is too small. - Reduce the minimum window size to 700x400, addressing Issue #788, now the connection view is no longer the constraining factor.
* - Add a further UI hint in the form of a accessory view to the SSH key ↵rowanbeentje2010-09-088-78/+233
| | | | | | | location dialogs (Note: r2615 and this commit both shamelessly stole the UI concept from Transmit 4; thanks to Panic for the inspiration!)
* - Add support for SSH identity files (public keys) in custom locationsrowanbeentje2010-09-0816-545/+1256
| | | | | | - Update localisable strings - Fix initial window position
* • CSV Import into new table:Bibiko2010-09-061-4/+79
| | | | | | | | - do not create a field in beforehand if user set it to "Do Not Import" - added ROUGH field type guessing by parsing the up to 100 first rows distinguishing text versa integer and size: -- for integer distinguishes between INT and BIGINT due to number length -- for text distinguishes between VARCHAR(255), VARCHAR(32767) [for MySQL >= 5 only], and TEXT due to maximum string length
* • removed not yet activated selector which throws a console warningBibiko2010-09-061-39/+1
|
* • CSV Import Mapper sheet:Bibiko2010-09-063-57/+948
| | | | | | | | - added keyboard shortcut ⌘T to show available tables list - added chance to add a new columns to an existing table (⌘⌥A) - added chance to remove currently new added columns (⌘⌫) - context menu; to remove all new columns one can reselect the table Note: New columns will be added after pressing 'Import' and before the import process starts; if an error occurred the sheet keeps open to give the user the chance to correct errors whereby successfully created new columns won't be editable anymore.
* - When refreshing table content view, refresh the status information for ↵rowanbeentje2010-09-052-1/+2
| | | | | | | tables as well; this fixes caching of table row count in certain combinations of table sizes and preference values, and should fix Issue #673. - Add a missing Errors.strings localisable strings table
* - Fix incomplete argument logic when deleting multiple rows without indexes ↵rowanbeentje2010-09-055-21/+26
| | | | | | | | (now rolled into argumentForRow: for centralised logic), addressing Issue #791 - Update table row count at bottom of window when deleting rows in the content view - Update localisable strings
* Minor enhancements to the CSV import dialogs new table info sheet (i.e. ↵stuconnolly2010-09-052-230/+2073
| | | | | | | | | table encoding and type): - Make the sheet non-resizable, thus removing the visible resize triangle. - Add a cancel button so the user can discard their selection. - Only save the user's selection when they select 'OK'.
* • CSV Import into new TABLEBibiko2010-09-045-106/+661
| | | | | - added button "New" - added chance to change encoding and engine of the new table which will be saved in the Prefs
* • further improvements for CSV import into new tableBibiko2010-09-034-14/+369
| | | | | | | | | - fixed some RETURN/ENTER logic while editing a table cell - added context menu to table for: -- 'Set all Field Types to:' which sets all types to the current selected one ⌘= -- 'Add Column to Table Target' (not yet implemented) - some minor code issues - added Info button which will come up with a GUI for setting new table encoding and engine (not yet implemented)
* • further progress for CSV import into new tableBibiko2010-09-034-41/+199
| | | | | | - added some GUI validations - in new table mode changed 'type' column into self-learning NSComboBoxCells - fixed issue for closing sheet if user press RETURN, only close it if 'Import' button is enable
* • finished the first implementation of CSV Import into new tableBibiko2010-09-037-50/+259
| | | | note:What else is needed for such an import? table encoding settings? ... has to be discussed
* Update background keepalive pings:rowanbeentje2010-09-031-11/+33
| | | | | | | - Fully lock the connection for background pings; this may slow down queries after connection disuse (when the keepalive is still active/blocked), but strengens thread safety to hopefully fix vio_delete crashes - Fix pthread_cancel use; previously pthread_cancel after a keepalive may have resulted in cancelling unrelated threads where the thread ID was reused This should increase stability and improve program consistency.
* • first preparations to support a CSV import into a new table (not yet ↵Bibiko2010-09-024-72/+787
| | | | | | | | executable) - changed order of target tables: New Table, Refresh List, separator, list of all names - cleaned code a bit * removed check for available tables in SPDataImport, now if no table in db the CSV Field Mapper opens in "New Table" mode
* • CSV Import Field mapperBibiko2010-09-021-1/+0
| | | | - make sure that after Refresh Table List the mapping table will be updated as well
* • corrected spelling of "First line contains fields names" to "First line ↵Bibiko2010-09-012-8/+24
| | | | contains field names"
* • Show/Copy Create Syntax now come up with all create syntaxes of selected ↵Bibiko2010-09-012-110/+111
| | | | | | | items • if Create Syntax is a PROC wrap the output by DELIMITER ;; etc. to simplify a copy&paste • merged code for copyCreateTableSyntax into showCreateTableSyntax distinguished by the sender (if sender == self) then copy otherwise show
* Remove an attempt to obtain a bool value from a var that is already one ↵stuconnolly2010-09-011-1/+1
| | | | resulting in a crash when attempting to remove an index. Fixes log: http://spbug.com/l/1007.
* • 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
* - Ensure previous outstanding performSelector: requests are cancelled to ↵rowanbeentje2010-09-011-0/+4
| | | | avoid calls on released objects; this addresses http://spbug.com/l/1408, http://spbug.com/l/254 and http://spbug.com/l/781
* • fixed AppleScript crash after calling 'open' without any parameterBibiko2010-08-312-10/+33
| | | | | | | | - this should fix the issues 108, 1398, 226 , 1157, 1473 • added AppleScript support for command 'print' - it prints the active view • renamed SP classes in sequel-pro.scriptSuite • AppleScript command 'make new document' opens a new window and connects to default automatically if set
* • fixed in field editing mode the editing of BINARY fieldsBibiko2010-08-312-4/+10
|
* - Add connection checks before uses of mysql_hex_string and ↵rowanbeentje2010-08-311-16/+51
| | | | mysql_real_escape_string (which require an active connection). This addresses http://spbug.com/l/54 .
* - Attempt more status checking before closing the MySQL connection, in an ↵rowanbeentje2010-08-303-3/+3
| | | | | | | attempt to further address http://spbug.com/l/13 - Update localisable strings
* - When a table content page reload loads no data, and so triggers a reload ↵rowanbeentje2010-08-301-0/+1
| | | | of the first page, the previous row count was not correctly reset, thus sometimes triggering an exception. This correctly resets the count, addressing http://spbug.com/l/558
* - Set pagination limit number formatter *off* lenient to allow editing ↵rowanbeentje2010-08-301-114/+494
| | | | formatted numbers (eg editing the default 1,000 to 2,000) without formatting characters such as commas being truncated
* • added some basic VIEW INFORMATION coming from information.schema.VIEWSBibiko2010-08-303-155/+212
|
* - Improve background thread reconnect interaction with the interface; if ↵rowanbeentje2010-08-291-3/+10
| | | | the application is in a modal state, the background thread waits. This improves interface behaviour on multiple SSH disconnections after sleep/wake (finishing Issue #798) and also disconnections while the interface is modally locked (eg editing text/blobs).
* • further improvements for in cell editing of view data in TableContent tablesBibiko2010-08-272-135/+138
| | | | | | | - 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
* • further improvements for in cell editing in CustomQuery tablesBibiko2010-08-273-110/+108
| | | | | | | | - 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
* • fixed issue that data in views weren't editable (copy&paste typo problem)Bibiko2010-08-261-0/+1
|
* • removed onMainThread for [Content/CustomTable makeFirstResponder] to ↵Bibiko2010-08-265-64/+111
| | | | | | | | | 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
* If the user chooses to overwrite the output file(s) when performing an ↵stuconnolly2010-08-262-2/+11
| | | | export make sure compression and CSV and XML headers and re-enable/rewritten.
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-20 17:21:42 +0000
6' href='#n1256'>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