| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
| |
• SPQueryController: removed unnecessary [table reloadData]
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
| |
- 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 issue while drag&drop an auto_inc field > ignore DEFAULT
- fixed several keyboard navigation issues
- further code improvements
- fixed encoding editing
|
| |
|
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
Custom Query table
|
|
|
|
|
|
|
|
|
|
| |
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
|
| |
|
|
|
|
| |
for localisation
|
|
|
|
|
|
|
| |
- Make the minimum index view size a little smaller
- Add a button to reveal the indexes subview when it is collapsed. This button is hidden when te index view is not collapsed.
This addresses Issue #746
|
|
|
|
|
|
|
| |
- Tweak custom query button widgets and spacing
- Improve User Manager layout, particularly for button and label widths
- Update connection error dialog strings file to remove Retry
|
|
|
|
|
|
| |
Query's text field
- solves i759
|
|
|
|
| |
textfields in Table Status view
|
| |
|
| |
|
|
|
|
|
|
|
| |
• resized GUI elements (Run Current, Last Error Mes.) for localisation
• centered label for "Query Favorites" and "Query History"
- maybe we should think about the appearance these buttons!
• increased the min width of Custom Query view by 15px in order to avoid GUI overlappings
|
|
|
|
| |
display the horizontal scroll bar correctly
|
| |
|
| |
|
|
|
|
|
|
|
| |
- Add a 'gear menu' with the option to export the current result set as either CSV or XML.
(Note, that the collapsiable view currently suffers from the same BWToolKit issue as the table information pane).
|
| |
|
| |
|
|
|
|
| |
• set minimum width of right view (Structure, Content, etc.) in order to avoid irreversible GUI overlaps
|
| |
|
|
|
|
| |
errors/message panel (show/hide button current inactive and disabled). Rows affected and timing stats are now displayed in the button bar. Also, fix the height of all other button bars.
|
|
|
|
|
|
|
| |
- fixed binding for removeIndexButton
- moved indexTable's tableViewSelectionDidChange: delegate to SPIndexController to fix enabling/disabling of the removeIndexButton
- fixed issue to blank the index table for multiple selected tables
|
|
|
|
|
|
|
|
|
|
| |
localisation errors
- Add database encoding retrieval support for MySQL 4.1
- Convert the add table and add database sheets to use encoding menus derived from server supported encodings
- Re-layout preferences with larger labels to aid localisation
- Fix preference resizing in non-Favorite tabs
|
|
|
|
| |
controller and XIB in preparation for the UI redesign.
|
|
|
|
|
|
|
| |
- Make sure the export button is disabled when the global structure, content and drop options are enabled, but the desellect all button is checked.
- Replace the export dialog toolbar with a tabview, reducing the dialogs overall size.
- Add the option to SQL dumps to specify when a new INSERT statement should be created, either after a certain amount of data or after a specific number of rows (defaults to every 250KiB). Known issue: incorrect VALUES clause generation of last row when creating a new INSERT after a specific number of rows.
|
|
|
|
|
|
|
| |
Carbon.framework link to the 'Linked Frameworks' group.
- Update the display name of all controllers in DBView to reflect their new class names.
|
|
|
|
|
|
|
| |
- Correctly disable exporting custom query results as SQL and enable for all other formats.
- Fix CSV exports when exporting from a source other than the selected tables.
- Correctly export custom query results instead of all tables as a result of a missing IB connection.
|
|
|
|
|
|
|
|
| |
- Move the custom filename options view to a drop down view on the main exporter dialog.
- Change the export data source matrix to a popup button.
- Fix the export button being enabled when no tables are selected to be exported.
- Various interface validation fixes.
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
| |
the new export menu item.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Includes a completely redesign approach to all export data types based on the use of NSOperation subclasses. CSV, SQL, XML and dot export types are currently functional, while the source files for PDF and HTML export types exist they are to be implemented, but are currently hidden from the interface.
Also includes the following:
- Completely redesigned export interface.
- The ability to customize CSV NULL values.
- The ability to specify whether the UTF-8 BOM should be used in SQL dumps.
- The ability to specify whether BLOB fields are output as hex or plain text during SQL dumps. Defaults to hex.
- Exporting currently selected tables via the tables list context menu.
Outstanding issues:
- Not all progress indicators for all export types are functional (or functioning correctly).
- A few issues related to the introduction of only exporting the content and create and drop syntax of specific tables during SQL dumps.
Needs some serious testing and benchmarking to ensure it replicates the current export functionality.
|
|
|
|
|
|
|
|
| |
- Addition of PSMTabBar framework
- Rework away from a document-based TableDocument
- Support tabs throughout the application
- Add menu items for creating tabs, and add support for dragging tabs to different windows
|
|
|
|
|
|
|
| |
- Trigger queries are no longer made for MySQL < 5.0.2
- Trigger loading has been deferred until the trigger tab is active, reducing queries when switching tables and thus increasing overall responsiveness
- Export triggers in MySQL dumps even if the Table Content switch is unchecked
|
|
|
|
|
| |
Added the to be copied/renamed database name to the name input sheet. Added necessary outlets. Added the current db name as preset value in the rename input field.
Renamed databaseNewSheet to databaseCopySheet and copyOnlyStructureButton to copyDatabaseDataButton and inverted behaviour of the button.
|
|
|
|
| |
provided
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Details as follows:
* altered MCPConnection listTablesFromDB:like: to return NSArray
* altered MCPConnection listFieldsFromTable:like: to use backtick quoted
strings for table and fieldnames
* added MCPConnection listTablesFromDB for a complete table list
* added SPStringAdditions.h to various files to prevent warnings
* added sheets for duplicate/rename DB in DBView.xib
* added duplicate/rename menu items to MainMenu.xib
* added outlets in TableDocument: databaseNewSheet databaseRenameSheet
databaseCopyNameField databaseRenameNameField copyOnlyStructureButton
copyDatabaseButton renameDatabaseButton
* added methods in TableDocument: getConnection, copyDatabase, renameDatabase,
_copyDatabase, _renameDatabase
* added OCMock Framework for object mocking in tests
* added group Others/DatabaseActions
|
|
|
|
|
|
|
|
|
|
|
| |
background thread, and integrate for SQL import:
- Implement streaming reading of gzip-compressed files for SQL import
- Support exporting SQL dumps into a gzip-compressed file
- SPFileHandle supports the most-used subset of NSFileHandle commands for easy integration
- Integrate zlib 1.2.4 for improved gzip streaming performance (and support for custom buffer sizes and file offset positions)
This implements Issue #571 .
|
|
|
|
| |
'gear' menu.
|