aboutsummaryrefslogtreecommitdiffstats
path: root/Interfaces/English.lproj/DBView.xib
Commit message (Collapse)AuthorAgeFilesLines
* Review trigger fetching and storage:rowanbeentje2010-05-011-58/+117
| | | | | | | - 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
* Changed appearance of copy/rename DB to match that of copyTable. drx7772010-04-291-135/+117
| | | | | 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.
* Disables copy/rename confirmation buttons in copy/rename sheet if no name is ↵drx7772010-04-291-17/+5
| | | | provided
* This changeset implements renaming and duplicating databases on a server. ↵drx7772010-04-281-24/+772
| | | | | | | | | | | | | | | | | | | 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
* Add a new SPFileHandle class to support gzip compression and writing on a ↵rowanbeentje2010-04-121-109/+109
| | | | | | | | | | | 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 .
* Add a 'Show Create Syntax...' menu item to the tables list context menu and ↵stuconnolly2010-04-111-12/+219
| | | | 'gear' menu.
* Restore the table content's copy menu items' tags after they seem to have ↵stuconnolly2010-04-011-9/+26
| | | | been screwed up. Fixes issue #616.
* • fixed printing of Extended Table Info if Create Table Syntax view has focusBibiko2010-03-131-34/+43
| | | | | - regardless of focus it prints the table info sheet - only if user selects something then the create syntax will be printed
* Uppercase various menu items.stuconnolly2010-03-101-833/+45
|
* • changed key shortcuts for Show Completion Lists to ⌥⌘1,2,3 since ↵Bibiko2010-03-091-64/+15
| | | | ^1,2,3 doesn't close an already displayed completion list window (instead an 'h' will be inserted??)
* • added $SP_ASLIST_ALL_FIELDS_FROM_SELECTED_TABLE as pre-defined snippet listBibiko2010-03-091-18/+184
| | | | | • added Show Completion List submenu to the Custom Query Editor gear menu with the items all dbs ^1, all tables ^2, all fields ^3 • if dbStructure is available show these pre-defined completion lists with all info like the completion it does, otherwise fall back to plain style
* • added to CustomQuery's CMTextView the option to set auto-completion ↵Bibiko2010-03-071-27/+92
| | | | | | on/off, settable in Prefs and gear menu - if inserted completion is marked as function it inserts snippet (${}1:) so far; function parameters as snippets follows soon
* • REPAIR, OPTIMIZE, ANALYZE, FLUSH, CHECKSUM now can be applied to more ↵Bibiko2010-02-261-34/+88
| | | | | | | | than one selected item in the TablesList; if no error alert OK, if not or for CHECKSUM list the output in a table view - while sheet is open showing the accessory table user can press ⌘C for copying it - added missing NSLocalizeStrings • fixed a tiny issue for $SP_SELECTED_TABLES
* • Query Favorites:Bibiko2010-02-251-127/+861
| | | | | | | | - added snippet variable $SP_SELECTED_TABLES which inserts `table1`,`table2`, etc. (ONLY tables) • improved "Check Table" - now one can select more than one table to execute "CHECK TABLE table1,table2,… ; if all tables passed successfully alert OK, if not show the result as accessory table in the sheet note: OPTIMIZE, REPAIR, FLUSH, CHECKSUM, ANALYZE follow
* • fixed GUI resize behaviour of the auto_inc value input fieldBibiko2010-02-231-1/+1
|
* • Reset AUTO_INCREMENT in Table Info Pane uses inline entering of the new ↵Bibiko2010-02-231-33/+416
| | | | | | | | | | value (no sheet) • "Delete all records" confirmation sheet shows a checkbox "Reset AUTO_INCREMENT after deletion" if PRI key is given for that table • minimized table data querying for auto_inc • optimized auto_inc change notification • if user changes tabVIew to Table Info Pane update data in beforehand • TRUNCATE query updates auto_inc value as well in TABLE INFORMATION
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-55/+356
| | | | | | | | Table Info Pane via Advanced popup button and sheet (not yet optimal GUI solution) • SPAlertSheets - ensure that this sheet becomes the keyWindow
* • implemented chance to reset AUTO_INCREMENT of the PRIMARY KEY field in ↵Bibiko2010-02-221-11/+32
| | | | | | Structure Pane via right-click at the index tableView - implementation in the Table Info follows soon
* • initial work to give the chance to reset the table's AUTO_INCREMENT valueBibiko2010-02-221-45/+544
| | | | - not yet active
* • fixed keyboard behaviour of "Create Sytax Sheet"Bibiko2010-02-201-13/+131
| | | | | | - specified first responder to avoid pressing ↩ twice before closing sheet - ESC also closes that sheet - fixed tab behaviour for keyboard navigation
* • TableDumpBibiko2010-02-171-15/+74
| | | | | | | | - introduced new method: - (void)showErrorSheetWithMessage:(NSString*)message to unify it and made all error sheets doc-modal (not app-modal) - Close button of the errorSheet now also listens at ESC
* • re-factored and outsourced the entire CSV import field mapper sheetBibiko2010-02-161-831/+13
| | | | | | | | | | | | | | | | | | - changed the way to choose whether a source field should be imported or not by introducing a new table column 'operators' - clicking at the 'operator's header toggles all operators to 'Import' or 'Do not import' - added tooltips for each table cell; if file's first line are the headers show them in the tooltips as well - added checkbox "First line contains fields names" since it'll be clear in this pane whether a file has a header line or not (will be sync with prefs) - added the possibility to choose the import method: INSERT INTO or REPLACE INTO • deleted all old field mapper stuff from TableDump and DBView.xib Notes: - tests are needed to be sure that this change does not cause mismatches while importing - symbols for Do (not) import are tendative - maybe use images - a further import method UPDATE plus an operator '=' will be added soon - chance to add a new global source variable will come soon - displaying of source field types will come soon - semi-automatically matching of source field names and header names will come soon - the GUI needs some improvements afterwards
* Make the add new trigger sheet resizable to accommodate complex trigger ↵stuconnolly2010-02-071-37/+44
| | | | statements.
* - Trigger a full table reload when the table type is changed; makes ↵rowanbeentje2010-02-061-49/+54
| | | | relations etc immeadiately available on changes to InnoDB, and updates a number of status variables
* Complete the implementation of the management of table triggers (accessible ↵stuconnolly2010-02-061-104/+922
| | | | via Cmd+6). Note, that better support for entering the trigger statement in terms of escaping and delimiter support most likely needs to be added.
* - Tweak the background colours of the NSTableView behind the table filter ↵rowanbeentje2010-02-061-15/+20
| | | | so that background windows have a uniform background colour
* - Restore a missing link between TableDocument and TableRelationsInstance. ↵rowanbeentje2010-02-061-362/+77
| | | | Resolves #559 and #562
* • refactored the entire history logic in Custom QueryBibiko2010-02-051-17/+229
| | | | | | - queries which are longer than then 64 chars are truncated in title and queries which are longer than then 256 chars are truncated in tooltip to avoid processing time to load very long queries from history; this also decreases the memory usage - added "Insert Next/Previous History Query" logic bound to ^↑ and ^↓ - fixed tiny GUI spacing problem in Custom Query
* • bound ⌥⌘H to Mac's default "Hide others"; fixes i561Bibiko2010-02-041-43/+34
| | | | •rebound ⌥⌘Y to open the "Query History"
* • field mapping sheet is now document-modal instead of blocking SP entirelyBibiko2010-02-031-24/+198
| | | | | | | • if an error occurred while retrieving column or index data in Structure pane reset Structure pane to a stable status, display the error message, and reload Tables List table due to the fact the it's very likely that SP tries to retrieve data from a table which doesn't exist anymore • fixed spelling of "occurred" Note: NOT YET DONE: if in Structure view the actual underlying table was deleted or renamed by an other mysql event and the user tries to add/change a field do suppress this attempt safely
* • added key-shortcut ⌘= to make the textview size largerBibiko2010-02-021-85/+54
| | | | | | | | • ⌘-, ⌘+, ⌘= changes the font size temporarily (Mac app conform) • added key-shortcut ⌘0 to reset the font to pref default • fixed search field background for Tables List • fixed NSUInteger for completion parsing; interrupt completion if parsed string length is larger than 100000 since it doesn't make sense and leads to warnings
* Added preliminary support for triggers. You can access the tab via the bamse162010-01-311-111/+1126
| | | | | | | | | | | | | | | | | | | | menu item View > Table Triggers (apple-6). Heavily copied from Relations tab, lots of functionality missing. Just lists the triggers for the table now. M Source/SPTableData.m M Source/SPConstants.h M Source/SPConstants.m A Source/SPTableTriggers.h A Source/SPTableTriggers.m M Source/TableDocument.h M Source/TableDocument.m M Source/SPTableData.h M Interfaces/English.lproj/MainMenu.xib M Interfaces/English.lproj/DBView.xib M sequel-pro.xcodeproj/project.pbxproj
* Fix bugs introduced by last commit.avenjamin2010-01-301-246/+219
| | | | | - SplitView divider now thin - Search Box appears again
* * renaming a table/view/proc/func now doesn't open a sheet anymorejakob2010-01-281-443/+101
| | | | | * table name checks now correctly consider only functions when working with functions * when an empty table name is entered, the change is ignored (like in finder)
* • improved the graphical representation of text macro snippetsBibiko2010-01-271-67/+5
|
* • first trial to improve the search field behaviour for Query Favorites ↵Bibiko2010-01-051-39/+76
| | | | | | | | and Query History popup menus - the keys ↑ or ↓ inside an activated search field abort the current text field editor to allow to navigate through the result menu items by using the keyboard - up to now one has to press ↑ or ↓ twice to select - still work in progress
* • added Save/Copy History List to "Query History"'s popup menuBibiko2010-01-051-45/+172
| | | | | | | | • moved "Clear History" from gear menu to "Query History"'s popup menu and added a confirmation sheet to it • "Clear History" now distinguishes between Untitled and SPF doc - if Untitled: clear global history list stored in the Prefs - if SPF doc: clear the document-based history list only
* • changed the alternating key to ⌥ instead of ⌘ for "Query Favorites" ↵Bibiko2010-01-041-4/+5
| | | | > "Save All/Query to Favorites" to be consistent with other Mac apps
* • remember scrollview port and selected row after editing in the Custom ↵Bibiko2010-01-041-34/+220
| | | | | | | | | | Query table view - after reloading the entire data the table view port will be restored but this leads up to now to a "tiny jitter" (maybe fixable in the near future) - the re-selection does NOT follow the actual edited row, e.g. if one changes a cell value whose column is used for sorting the actual edited row could appear somewhere • if the editing in the Custom Query table view was invoked by pressing RETURN/ENTER one can go through the columns by pressing ESC but up to now that editing will be interrupted after the user pressed OK - this behaviour is temporary and should be fixed in the near future by storing the new row data temporarily; after editing the last column AND if all columns have the same table origin the row data will be updated. To allow the row editing for columns which have different table origins could probably cause inconsistencies. - further discussion is needed
* - Tweak the pagination interface - remove the text and replace with an ↵rowanbeentje2009-12-151-4/+4
| | | | icon, to reduce the overall space taken up in the bottom bar and to make it clearer a jump-to/options button is available
* - Tweak positioning of old "working" spinner to center and align itrowanbeentje2009-12-081-1/+3
| | | | | | - Fix pagination to not enable the "next page" arrow when looking at a small, complete, filtered result - Move content table setup and drawing to a new method called on the main thread. Should improve thread safety, and fixes flickering updates. Tweak a few bits of drawing code to take advantage of main thread status to further reduce flicker and jumping
* - Tweak pagination to fix click-through of pagination popup, fix next page ↵rowanbeentje2009-11-231-5/+2
| | | | | | | button mouseover text, display no text when 0 or 1 pages of results for clarity - No longer include the old app icon in the built product (but leave it in the project)
* - Replace the LIMIT interface on the content view with a pagination control ↵rowanbeentje2009-11-231-359/+283
| | | | | | | | at the bottom. This addresses the last of Issue #49 and implements Issue #133; jump-to and two prefs affecting loading are available in a popup when clicking the pagination interface. - Format row counts at the bottom of the content pane - Increase the MCPStreamingResult buffer for a stronger workaround for #463
* New separator in query favorites dropdown.stuconnolly2009-11-171-8/+83
|
* Change the placeholder value of a few search fields to simply 'Filter' to ↵stuconnolly2009-11-171-20/+73
| | | | make them look less cramped.
* Updates to the 'use monospaced font' preference, making it a lot more ↵stuconnolly2009-11-141-31/+15
| | | | consistent across all table views. Also includes live updating when the preference is changed as well as its implementation in the query console, process list and variables table views.
* Give the custom query result table view the same row height as the table ↵stuconnolly2009-11-131-100/+33
| | | | content table view.
* In an aid to split up the functionality of the TableDocument class as well ↵stuconnolly2009-11-131-774/+71
| | | | as reducing the overall size of DBView, split out the server variables sheet into it's own controller and XIB in the same way as the new server processes sheet is implemented.
* Change the main window's non-connected/connecting state title to 'Sequel ↵stuconnolly2009-11-111-34/+32
| | | | Pro' and only change it to 'Connecting...' when we are actually trying to establish a connection. Fixes issue #456.
* • fixed GUI overlapping bug of Table Info Tab for 'Auto increment' field ↵Bibiko2009-11-101-54/+71
| | | | if window is minimized - eg 'Not available' was overlapped by 'Free data size' partly
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-25 08:01:31 +0000