| Commit message (Collapse) | Author | Age | Files | Lines |
| |
|
|
|
|
|
|
| |
- 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
|
|
|
|
|
|
|
|
|
|
|
| |
functions (off by default). Remove the forked "...Sql..." functions, as they're now duplicates, and switch CustomQuery to using the original methods.
- TableDump imports can now process DELIMITERs correctly as a result.
- Alter the TableDump display of tables etc to use TablesList as the source of information, and used cached lists where appropriate for a small speedup. Also means we gain consistent sorting.
- Display procedures and functions in the toggleable list when exporting as SQL
- Tweak the procedure and function export to only export selected items, and also to respect the "export drop syntax" and "export create syntax" checkboxes
- Fix a crash when removing items from the TablesList resulted in an errorneous selection by deselecting all rows before deleting (and preemptively applying the same fix to TableContent)
|
|
|
|
| |
•rebound ⌥⌘Y to open the "Query History"
|
|
|
|
| |
initial problem.
|
|
|
|
| |
• improved text macro/query favs insertion logic
|
| |
|
|
|
|
|
|
|
| |
field if the actual underlying table doesn't exit anymore; now it informs the user, clean the view, and reloads the Table List
• improved error handling in Content View for refreshing data for the current table if the table doesn't exist anymore
- this fix and the fix in [TableContent setCompareTypes:] to check for valid table data removes some NSPlaceholderString and NSScanner warnings
|
|
|
|
|
|
|
| |
• 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
|
| |
|
|
|
|
|
|
|
| |
they are shown - as strings. This addresses Issue #558.
- Remove some unused variables
|
|
|
|
| |
when tab is selected.
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
- suppress current query/syntax highlighting for text buffer size > 20MB to allow at least editing and performing queries
• Main Menu
- set hidden new Export menu item to key ⇧⌘E and reset "Use selection for searching" to ⌘E since it's a standard Mac binding
|
|
|
|
| |
• fixed some NSUInteger checks à la while(NSUInterger >= 0) since it's always > 0
|
|
|
|
|
|
|
|
| |
• ⌘-, ⌘+, ⌘= 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
|
|
|
|
| |
on non Production servers
|
|
|
|
|
|
| |
led to an issue that SP crashed for very very long lines/queries
- this has to be investigate further!
|
|
|
|
| |
- rewrote [NoodleLineNumber requiredThickness] completely to avoid stack overflow for larger text due to [NSMutableString string] plus appendString all the time without releasing it in time
|
|
|
|
| |
compatibility
|
|
|
|
|
|
| |
than SP_SYNTAX_HILITE_BIAS (has to be improved)
• added SPFieldMapperController
|
|
|
|
| |
CMTextViews via ⌘+, ⌘-, or trackpad pinch in/out gesture
|
|
|
|
| |
• first steps to renew the field mapper sheet for CSV Import
|
| |
|
|
|
|
|
|
| |
the same font/size as the table cells
• CMTextView: make sure that some methods are never called if the CMTextView is set to 'not ediable'
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
|
|
|
|
| |
textviews
• added Preference setting "Table font" in "Table" pane to set the table font/size for all result tables (Content, Custom Query)
• added to SPTableView the method setFont:
• fixed the initialisation of vars in CMTextView (fixes the displaying of create syntax)
|
|
|
|
|
|
|
|
|
|
| |
- Reverse the effects of the r1664/r1690 combination, restoring the original link from CMCopyTable to the underlying data source
- Adapt the code to retrieve information from the new SPDataStorage; update SPDataStorage as necessary if underlying data changes
- Refactor and speed up various checks and loops for speed and logic improvements
- Ensure the binary-encoded TEXT data is hex encoded rather than retrieved as "<123ABC 123ABC...>" NSData representations
- Fix some memory leaks
This resolves Issue #533 and the original "Copy as SQL" issue
|
|
|
|
| |
to avoid unstable tooltip status
|
|
|
|
|
|
| |
each time for syntax highlighting which speed it up a bit; now if one changes a color the changes are done in view after a delay of 0.1 s if text buffer < 100k for speed reasons
• fixed: before highlighting the current query ensure that the text storage is in a stable and clean status; otherwise SP crashes for ranges which aren't rendered yet
|
|
|
|
|
| |
- SplitView divider now thin
- Search Box appears again
|
|
|
|
|
|
|
|
| |
and thanks to Jakob)
• improved snippet background drawings esp. for multiple lines (commit on behalf of Jakob)
• simplified code for changing and setting background colors and Pref setting for highlight current query by observers (much more faster)
|
|
|
|
| |
- Fixes issue where Database selector wasn't resizing to match Table list width.
|
|
|
|
| |
longer matched the internal table representation, table storage exceptions would occur. Additional checks are now made against the column count; if a content result set is retrieved with an unexpected number of columns, the result set is discarded and a full table refresh is triggered to restore the state.
|
|
|
|
| |
in table history
|
|
|
|
|
|
|
| |
- improved highlighting of multi-line snippets (many thanks to jabakobob for this patch!)
- some tiny cosmetics
• error message highlighting in Custom Query Editor
- removed near message length checking to be larger than 2, not necessary
|
|
|
|
|
|
|
|
|
| |
the erroneous query
- added check for near message length
- make an intersection with the buffer range before selecting
• text macro - each selection of a snippet breaks the undo buffer
- note: undo behaviour while text macro session is active needs to be solved ⇢ work in progress
|
| |
|
|
|
|
|
|
|
|
| |
- added dynamically set SP variables $SP_SELECTED_TABLE and $SP_SELECTED_DATABASE available in each ${x:…} snippet to allow to create a query fav à la:
SELECT ${1:$SP_SELECTED_TABLE.} FROM ${1:$SP_SELECTED_TABLE}
whereby for the first snippet one can press ESC to insert one or by holding down the CTRL key while inserting more field names from the current table
- improved snippet range detection for current caret position
- reduced the border width of snippet highlighting and changed slightly the colour for the current selected snippet
|
|
|
|
| |
* changed name of closeDocumentWindowAndDisconnect-selector again...
|
|
|
|
|
|
| |
'disconnect' in the connection error dialog
* improved some comments
|
|
|
|
| |
SSH-helper (see #357)
|
|
|
|
|
|
|
|
| |
• error message highlighting in CustomQuery
- check for error ID 1064 before trying to select the erroneous line given as '… at line x' (this solves the issue that other error messages could end by a number)
- improved regexp to get rid of localized error messages for parsing the erroneous line number (thanks to Jakob) - look the last number in a string
- improved regexp to parse for the 'near message' for localized error messages
|
|
|
|
| |
- speed up gathering data by avoiding the check for uniqueness if not necessary, make usage of NSMutableSet to collect unique data automatically, and rely on NSSubTextStorage to get all words from the text buffer (if text buffer size less than 6MB)
|
|
|
|
|
| |
* 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)
|
|
|
|
|
| |
- changed regex for validation of the entered tab trigger to "(?i)[^[:L:]0-9]+" since "(?i)[^\\w0-9]+" doesn't work if SP runs in 32bit mode.
- It seems that the new RegexKitLite has a problem to expand \w correctly if it is used like [^\w]
|
|
|
|
| |
* refactored the table/proc renaming code a bit
|
|
|
|
|
|
| |
- fixed bug for deletion nested snippet ranges after editing
- further improvement of the graphical representation
- selected snippet will be drawn differently
|