What is it? ----------- dbext.vim : Provides database access to most databases. http://www.vim.org/scripts/script.php?script_id=356
This plugin contains functions/mappings/commands to enable Vim to access several databases. Currently Mysql, PostgreSQL, Ingres, Oracle, Sybase Adaptive Server Anywhere, Sybase Adaptive Server Enterprise, Microsoft SQL Server, DB2, RDB, SAP HANA and Interbase are supported. If you have a Perl enabled Vim, it also allows database connections via DBI and ODBC. It abstracts database access, so the same Vim commands will produce the same output regardless of the database you use. What is new in 16.00? New Features ------------ - Added new database type, the SAP HANA in memory database. - Added new option, ignore_variable_regex, which is used when parsing your statement for replacable input parameters (i.e. placeholders for prepared statements). Certain variables need to be skipped (for example when running a CREATE PROCEDURE statement) to leave the logic inside the stored procedure intact. This option allows the user finer control over the regex used to decide which SQL syntax should be skipped. - Added new option, statement_starts_line, which is used when deciding if the query should be parsed for input parameters. Certain filetypes assume the statements can be embedded within strings (like in Java, PHP, Perl and so on). - When parsing PHP and Java files, leading and trailing quotes are stripped automatically when executing the query, which could lead to incorrect results. First check if there is a leading quote. If so, then only strip the corresponding closing quote. - Updated documentation describing the default regex for variable_def_regex. - Added new option g:dbext_map_prefix which defaults to <Leader>s, this allows you to customize the start of all the default maps (Daniel Hahler). Bug Fixes --------- - The default value for variable_def_regex, did not properly escape the $, which lead to some query parameters being skipped when executing SQL. - It was impossible to search and replace input parameters within a query if the parameter was enclosed in single quotes. The above new features were required to make this possible (Joshua Dennis). - DBCompleteTable, DBCompleteProcedure, DBCompleteView would always recreate the object list. If it has already been created, it should simply reuse what was available. To force the recreation you add the bang to the command: DBCompleteTable!, DBCompleteProcedure!, DBCompleteView!. - Even with the checks it was possible for dbext to report: E227: mapping already exists for ... when creating maps where the mapping already exists (Daniel Hahler). I am always open to suggestions, just email me. Dave -- You received this message from the "vim_use" maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
