aboutsummaryrefslogtreecommitdiffstats
path: root/Source
Commit message (Collapse)AuthorAgeFilesLines
* - Replace TableSource use of a custom, flawed NSScanner-based parser with ↵rowanbeentje2009-06-101-29/+32
| | | | SPSQLParser usage - fixes errors like closing brackets (")") truncating ENUM/SET definitions
* • introduced the method (NSArray *)fetchResultFieldsStructure to CMMCPResultBibiko2009-06-092-88/+582
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - it returns an array of dicts containing general information about each field of the result array of the last executed query dict example so far for: SELECT ucs_comp AS co FROM comp_ucs3 AS co_table AUTO_INCREMENT_FLAG = 0; BINARY_FLAG = 0; BLOB_FLAG = 0; ENUM_FLAG = 0; MULTIPLE_KEY_FLAG = 1; NOT_NULL_FLAG = 0; NUM_FLAG = 0; PART_KEY_FLAG = 1; PRI_KEY_FLAG = 0; SET_FLAG = 0; UNIQUE_KEY_FLAG = 0; UNSIGNED_FLAG = 0; ZEROFILL_FLAG = 0; byte_length = 30; char_length = 10; charset_collation = utf8_general_ci; charset_name = utf8; charsetnr = 33; db = test; decimals = 0; flags = 16392; max_byte_length = 4; max_char_length = 1; name = co; org_name = ucs_comp; org_table = comp_ucs3; table = co_table; type = VARCHAR; typegrouping = string; Hint: To test that new method one can add the following code after the execution of a mysql query: NSArray *fStruct = [NSArray arrayWithArray:[theResult fetchResultFieldsStructure]];
* • fixed bug for "Show help while typing" - prevent an internal loop of ↵Bibiko2009-06-091-1/+2
| | | | calling ShowMySQLHelpForCurrentWord if "Highlight the current Query" is activated.
* • added: "Copy as SQL INSERT" ^⌥⌘CBibiko2009-06-083-89/+184
| | | | | | - up to now only available for the table content pane - supports blobs - if a primary key is given it also support (not yet loaded) blobs and long text data fields
* Effectively halve connection lag for queries, speeding up all queries and so ↵rowanbeentje2009-06-082-17/+114
| | | | | | | | | | | | interface responsiveness. - Rework [CMMCPConnection queryString:usingEncoding:] to no longer check the connection before every query. This removes a ping from the equation and therefore effectively halves connection lag. - Move the actual query to a thread (note this is *not* the long-desired multithreading!) to still correctly cope with http://bugs.mysql.com/bug.php?id=9678 . As soon as we upgrade the MySQL client libraries this can be removed, the code simplified, and a further processing speedup will be seen. - When testing a ~10,000 row CSV import (=10,000 queries), the following speedups were observed: - Local server, socket connection: 1.2x speedup - Remove server, 30ms ping: 1.85x speedup Slower connections will observe the biggest benefit from this commit.
* • improved "Copy as SQL INSERT" (still hidden)Bibiko2009-06-074-5/+15
| | | | • disabled "Copy with Column Names" if Custom Query editor is active
* • improved "Copy as SQL INSERT" (still hidden - can be tested if the menu ↵Bibiko2009-06-073-17/+59
| | | | item is set to 'not hidden' in the MainMenu)
* Further SSH tunnel improvements:rowanbeentje2009-06-066-14/+91
| | | | | | | | - Redesigned SSH key authentication dialog - Added ability to add SSH key passphrases to keychain (sharing details with system SSH) - SSH tunnels with keys which fail are now correctly restarted, interacting with the GUI as necessary - GUI interaction now performed on the main thread for increased stability
* • moved macros enumerate() and sizeOf() to sequel-pro_Prefix.pchBibiko2009-06-066-29/+131
| | | | | | • added to SPArrayAdditions.m - (NSArray *)subarrayWithIndexes:(NSIndexSet *)indexes • added "Copy as SQL INSERT" to MainMenu (not yet activated) • added to CMCopyTable - (NSString *)selectedRowsAsSqlInserts for copying selectedRows as INSERT INTO ... string (under constructions, up to now it works for strings)
* • improved: sped up removing the background color for query highlightingBibiko2009-06-062-2/+11
| | | | • added: DELIMITER to the completion suggestions
* - Fix some manual memory releases in r820 which llvm/clang has ↵rowanbeentje2009-06-051-8/+2
| | | | | | | misidentified (an autorelease is already present). - Ensure manually allocated memory is correctly releases
* • added "Select Enclosing Brackets" to each NSTextView (⇧⌘B)Bibiko2009-06-052-0/+87
|
* • added to Editor Preferences:Bibiko2009-06-053-4/+21
| | | | | - "Query Background" color - checkbox "Highlight Current Query"
* • reload table list, database pull-down menu according to user's ↵Bibiko2009-06-056-50/+135
| | | | | | | | | statements in the Custom Query editor if necessary - if statement begins with: use, create, alter, rename, drop • reload table list, database pull-down menu according to imported statements • sped up "Import MySQL Dump" • fixed some tiny issues of the last commit
* Fixed some memory leaks found using llvm/clang. There are still some to fixbamse162009-06-0510-32/+55
|
* - visual improvements to the graphviz dot file outputmtvee2009-06-051-7/+6
|
* - Added toolbar icon for table relations.avenjamin2009-06-051-5/+31
| | | | - some TableDocument code cleanup
* - added schema export to basic graphviz dot filemtvee2009-06-052-0/+142
|
* - Make memory management for SSH tunnels explicit to improve thread ↵rowanbeentje2009-06-051-7/+21
| | | | | | | interaction and reduce crashes - Add Command-. shortcuts for cancel buttons on SSH dialogs
* Further SSH tunnel improvements:rowanbeentje2009-06-053-38/+122
| | | | | | - SSH Public/private keys are now supported, even if they are password-protected. The user and password fields can be left blank where appropriate. - SSH yes/no queries (ie host key mismatch) and password requests (eg key passphrases) dialogs now automatically resize to match the content from the SSH process.
* • added: the "Show Create Syntax" window now follows the selection in the ↵Bibiko2009-06-044-3/+22
| | | | | | table list if it was already opened • commented out the NSLog "not parsed" in SPTableData.m
* • added: syntax highlighting to the HUD window "Show Create Syntax"Bibiko2009-06-042-1/+9
| | | | • fixed: context menu item validation for "Show MySQL Help": hide it when no connection to the customQueryInstance is found
* • added the operator LIKE to numeric fields in the content browserBibiko2009-06-041-2/+7
| | | | - this fixes issue 270
* • fixed typo for "Select Active Query" key-binding ^Y not ^QBibiko2009-06-041-2/+2
|
* • fixed: suppress highlighting of the current query if something is selectedBibiko2009-06-044-3/+37
| | | | • added: "Select Active Query ^Y" context menu item to the Custom Query Editor
* • simplified quertAtPosition:Bibiko2009-06-042-214/+100
| | | | | | • added queryRangeAtPosition: method because this is needed also for other purposes • moved the commands for highlighting the current query from queryAtPosition: to textViewDidChangedSelection: (where it belongs to) • some minor changes in error highlighting code
* • updated queryTextRangeForQuery: method to make usage of the new SQLParserBibiko2009-06-041-15/+11
|
* • added support for the “delimiter” commandBibiko2009-06-045-220/+399
| | | | | | | | | | | | | | - added (NSArray *) splitSqlStringByCharacter:(unichar)character; (NSArray *) splitSqlStringIntoRangesByCharacter:(unichar)character; (long) firstOccurrenceInSqlOfCharacter: to the SQLParser which recognize a “delimiter” command • queryAtPosition now works with ranges to speed it up - the current query ranges resp. the just activated query range are cached in order to avoid parsing if the user only navigates through the textView buffer, or if the user calls Run Prev/Current Query only • the "import dump" function makes usage of that new “delimiter” support - i.e. dumps with procs/funcs declaration could be imported IMPORTANT: Please check the new SQLParser exhaustively in order to prove that new approach
* Added print accesory view with option to Print Backgroundsbamse162009-06-045-0/+82
|
* - SSH Tunnel - PubKey Authenticationavenjamin2009-06-041-0/+1
|
* Further SSH tunnel improvements, password handling improvements, and minor ↵rowanbeentje2009-06-049-110/+273
| | | | | | | | | | | | | bugfixes: - SSH tunnels can now correctly show dialogs for ssh queries, eg host key mismatches - SSH tunnels are now correctly closed by the document for connection failures - Keychain password item name and account generation has been moved to within the keychain class, to centralise generation for consistency - Keychain item names and accounts now correctly deal with nil values, allowing more keychain items to be read - "Add to favorites" button and menu item now correctly store passwords and SSH tunnel settings - Duplicating favorites in preferences now selects the newly created favorite instead of deselecting everything - Fixes an occasional crasher sometimes encountered in keychain usage
* Various enhancements to relation functionality, including:stuconnolly2009-06-033-221/+235
| | | | | | | - Only presenting valid tables for possible relations, that is InnoDB tables. - Only presenting valid columns for possible relations, that is columns of the same data type. - Loads of interface validation.
* - fixed bug with changing extra to auto_increment for a columnmtvee2009-06-032-2/+2
| | | | - small mem release issue in CMMCPConnection
* - Fix SSH tunnels on PPCrowanbeentje2009-06-032-1/+11
| | | | | | - Improve general SSH tunnel stability and automatic reconnection on failure - Improve handling of failed SSH tunnel passwords
* - Fix SSH tunnel treatment of temporary (non-Keychain) passwords by ↵rowanbeentje2009-05-291-1/+1
| | | | correctly comparing hashes and not hash pointers (!)
* - SSH tunnel now correctly uses placeholder/default port numbersrowanbeentje2009-05-291-1/+1
|
* • ADDED: highlight the current active query by setting its background ↵Bibiko2009-05-281-1/+19
| | | | color in the Custom Query Editor
* • Table InfoBibiko2009-05-282-5/+37
| | | | | - show create syntax for views - fixed editing behaviour of the Comments field (esp. for views)
* • fixed dependence in showHelpForCurrentWord: to allow to invoke the help ↵Bibiko2009-05-281-1/+1
| | | | (Context Menu or ^H) from any CMTextView (e.g. from create syntax view in Table Info as well)
* • control editable status of CMTextView while changing the font size via ↵Bibiko2009-05-281-0/+6
| | | | ⌘+/- or finger gesture since CMTextVIew is also used for other views
* Add support for SSH tunnels, improve password security, and tweaks:rowanbeentje2009-05-2812-828/+1171
| | | | | | | | | | | | - Implementation of a new SPSSHTunnel class, designed to closely integrate SSH tunnels within Sequel Pro. - Integration of SPSSHTunnel - new connection methods using callbacks, and CMMCPConnection integration - Keychain class upgrade to include the new SPSSHTunnel keychain password helper on the trusted access list for new passwords - Keychain passwords are now held in memory/UI for only as long as necessary, increasing password security - Updated interface to enable/add SSH tunnel functionality - Remove old SSHTunnel class - Addition of new target for the SSH Tunnel password assistant, addition as a dependency of the main target, and addition to build script to copy into resources directory - Fix a keychain password deletion crash
* Forgot to add !, removed for testing.stuconnolly2009-05-271-1/+1
|
* Log query errors in SPDatabaseData to the console.stuconnolly2009-05-271-2/+2
|
* Change the name of the 'Table Status' toolbar item to 'Table Info' and ↵stuconnolly2009-05-271-8/+9
| | | | display it by default.
* Fix for query editor font being lost. Initialize the prefs reference in ↵stuconnolly2009-05-271-2/+2
| | | | setConnection as opposed to init, so we definitely know the font has already been set. Turns out it was me that moved it to init, my bad.
* Bind the table create syntax text view's backgroud colour upon awakeFromNib.stuconnolly2009-05-271-0/+17
|
* We don't need to manually set the create syntax text view font because of ↵stuconnolly2009-05-271-8/+0
| | | | the binding.
* Redesigned table information pane.stuconnolly2009-05-2716-237/+729
|
* • added key-binding for RETURN to "Duplicate" button in the "duplicate ↵Bibiko2009-05-261-1/+12
| | | | | | table sheet" via delegate method controlTextDidEndEditing: • improved controlTextDidEndEditing: to recognize only the RETURN/ENTER key
* • added key-binding for RETURN to "Add" button in the "add table sheet" ↵Bibiko2009-05-261-1/+4
| | | | via delegate method controlTextDidEndEditing:
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-09 02:16:58 +0000