ANN: dbext 17.0

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