| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |
|
|
|
|
|
|
| |
- auto-completes the common prefix of all suggestions - makes typing much more faster
- “ ” as allowed character to be typed for narrow-down the list is set automatically if at least one suggestion contains a “ ”
- fixed two tiny memory leaks
- fixed detecting db/table/field names containing ` as char
- removed ⇥ binding to complete the common prefix since it's done automatically
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- up to now for MySQL >4 available
- implemented by narrow-down, i.e. write/delete to narrow-down/expand the suggestion list
- ↩ inserts the suggestion, if suggestion is db/table/field/proc/func name inserts backtick quoted
- for a db/table/field/proc/func name press ⇧↩ to insert à la `db`.`table`.`field` relatively to the current selected db
- context-sensitive to leading db. or table. or db.table. or .table if uniquely identifiable
- mysql and information_schema if available and not selected appear at the end
- `|` | := caret shows the current table's fields if any or the current selected db if selected at the top; suggestions are hierarchically arranged by db, table; easiest way to insert a table/field name - e.g. type `max_c` and press ⇧↩ to insert `mysql`.`user`.`max_connections`
- for table/field name suggestions press at the right column to get the path info
• F5 invokes completion based on spell checker and selected language
- since it is not possible to auto-detect if the user wants to complete MySQL statements or prose text
Note: GUI needs improvements; completion should be tested exhaustively
|
| | |
|
| | |
|
| |
|
|
|
|
|
|
| |
- SPDataStorage is a class designed for a 2D array of fixed-width data storage, replacing the current method of nested NSMutableArrays. NSFastEnumerator compatible.
- Overall memory overhead for table storage in memory reduced by 1.2-1.4x - this almost gains back the large memory jump seen for 64 bit
- Some operations (adding data, retrieving a single cell's data) are faster than nested NSMutableArrays; some operations (requesting a row as an NSArray) are slightly slower as the data needs to be converted, but overall result is a slight speed gain.
(- Could be used in future to store SQL results in C datatypes, avoiding very high NSObject overhead for numbers and short strings)
|
| |
|
|
| |
- fixed issue while ‘normal’ completion after “table.” completion
|
| |
|
|
|
| |
- improved ⇧↩ insertion
- improved backtick behaviour
|
| |
|
|
|
|
| |
[panel setResolvesAliases:YES]
For some reasons it could happen that the panel didn't response to dragging files into it correctly and sometimes SP crashed after selecting a directory in its sidebar. By removing "resolve aliases" the panel seems to work properly. This has to be verified by further tests.
|
| |
|
|
|
|
| |
- added support for dump functions. If no errors are found, Issue 517 can be closed.
|
| |
|
|
|
|
| |
- included export for proceduers. Need to add support for functions and test on different databases.
|
| |
|
|
| |
• updated some methods in in SPStringAdditions to 10.5 code which avoid mutableCopy and they're faster
|
| |
|
|
| |
certain conditions
|
| |
|
|
|
|
|
| |
properly to avoid overlapping sheets
• F5 completion
- if a table is selected and no further parsing info is given show that table and its fields at the top of the suggestions
|
| |
|
|
| |
getDatabaseCollationsForEncoding is equal to NULL
|
| |
|
|
|
| |
- fixed issues if no db is selected
- trial: ⇧↩ inserts the entire path db.table or db.table.field; if invoked inside of backticks backticked
|
| |
|
|
|
|
|
| |
- first steps for context-sensitive completion: parse left side of current word to look for db.table.field constructions
- eg type: mysql.user. and press F5
Note: work in progress :)
|
| |
|
|
| |
changes of the accessory view (ie avoid disappearing of selected items)
|
| |
|
|
|
| |
- re-defined 34 tab stops for better editing behaviour
- soft wrapped lines are slightly indented
|
| |
|
|
| |
SPTableViews to prevent unstable circumstances
|
| |
|
|
| |
applying changes to the db
|
| |
|
|
|
|
| |
- make usage of UInt32 instead of NSUInteger for checking whether decryption was successful and for retrieving the correct data size
TODO: it should be possible to change it to NSUInteger by applying the correct pointer arithmetics
|
| |
|
|
|
|
|
| |
I've moved the export triggers part after the [streamResult release], so we
can export triggers for empty tables too.
|
| |
|
|
| |
TablesList's updateTables method
|
| |
|
|
| |
thread, as well as the existing background database connection, for a smoother experience
|
| |
|
|
|
|
|
| |
filtering is occurring, just pagination
- If the table count is estimated (eg InnoDB), but the end is reached via pagination, make the row count accurate based on the known number of rows
|
| |
|
|
| |
the "Stop" button; switch to orderFront: to re-enable without the warnings (thanks to Hans for assistance!)
|
| |
|
|
|
|
|
| |
behaviour to escape _ % automatically since it could be confusing to the user because it uses LIKE '%...%'
• reimplemented: scroll to newly added row in Content View
|
| |
|
|
|
| |
- accessing table data from [dataSource:tableView:objectValueForTableColumn:row] directly
- maybe related to issue 506
|
| |
|
|
| |
Note: not yet finished!
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
First draft on export triggers.
Known issues:
- Now it exports only triggers for the table that have some content in it.
If I move the write triggers part outside of the if (rowCount), the
SHOW TRIGGERS query never finishes.
- Sequel Pro complains when it tries to import the same file again. The
error message is related to DELIMITER command. Still, the triggers seem to
be present. This might be a different issue with Sequel Pro.
|
| |
|
|
| |
Note: not yet active - only querying the data in background will be performed for testing
|
| |
|
|
| |
splitview height to 1 instead of 0 to ensure that a next connection window which has more than 20 tables is showing the search bar as well
|
| |
|
|
|
|
|
|
|
| |
names/field names + type and encoding completion
- after connecting and updating the table list a background task executed on a different connection will be performed to query the information_schema db (MySQL >= 5 only so far)
- the MCPConnection object holds a NSDictionary with all structural data
Note: not yet active
|
| |
|
|
|
|
| |
- 'int' has to be replaced by 'size_t'
• F5 completion
- if inside of backticks after completion move caret one char rightwards to go out of the backticks
|
| |
|
|
|
| |
- fixed forgotten range checking to suppress Console warning
- `|` [ | := caret ] shows all field names - up to now only those from the current table - table/db/proc/func names
|
| |
|
|
| |
NSSpellChecker only; language is selectable via right-click "Spelling and Grammar"
|
| |
|
|
|
|
|
|
| |
- Change the error dialog buttons to "Edit row" and "Discard changes" instead of "OK" and "Cancel"
- Correctly refocus the deselected row
- Edit the first cell in the row after errors.
- Fix row deselection and error handling on the Table Source view
|
| |
|
|
|
|
|
|
|
| |
[taskProgressWindow orderWindow:NSWindowAbove relativeTo:[tableWindow windowNumber]];
since it causes Console <error> messages mentioning "kCGErrorIllegalArgument" and it is not necessary anymore
[thanks to Rowan for the hint]
|
| | |
|
| |
|
|
|
|
|
| |
release builds, including a large number of 64bit compatibility upgrades and tweaks
- Upgrade RegexKitLite to 3.3
|
| |
|
|
| |
version < 5 - this speeds up SP esp. for slow connections
|
| |
|
|
| |
• fixed: if user cancelled "Add Database" reselect 'Choose Database Button' instead of displaying "Add Database"
|
| | |
|
| |
|
|
|
| |
- ↑ or ↓ selects now immediately the next/prev menu item [many thanks to Rowan!]
|
| |
|
|
|
|
|
|
| |
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
|
| | |
|
| |
|
|
|
|
|
|
| |
• 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
|
| |
|
|
|
|
| |
tableView:writeRows:toPasteboard:] method by [NSTableView tableView:writeRowsWithIndexes:toPasteboard:]
• some code cosmetics
|
| |
|
|
|
|
|
|
|
|
| |
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
|
| |
|
|
|
| |
- reimplemented the display of the conjunction label for two arguments
- fixed bug while parsing and storing the number of arguments of each filter definition
|
