created by

Peter Bagyinszki

script type

utility

description

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 and Interbase are supported. Adds a menu for the common commands for gvim users. Some of the features that are supported: Prompt for database connection parameters. Place the cursor on a word, and invoke the default mapping (or menu) and a Result buffer will open with the contents of the table displayed (ie select * from ???).  Optionally you can be prompted for the table name, and a WHERE clause. Describe a table (see colum names and datatypes). Describe a stored procedure (see input and output datatypes). Visually highlight statements and execute them against the database. Additional commands are defined for common arbitrary statements:     ExecSQL - Enter any command you want sent to the database     Select  - Enter the remainder of a select (ie :Select * from customer)     Update  - Enter the remainder of an update     Insert  - Enter the remainder of an insert     Delete  - Enter the remainder of an delete     Drop    - Enter the remainder of a drop     Alter   - Enter the remainder of an alter     Create  - Enter the remainder of a create Each buffer can be connected to different databases.

install details

Copy the db_ext.vim script to your $HOME/.vim/plugin (or vimfiles/plugin for windows) directory.  Copy db_ext.txt to your $HOME/.vim/doc (or vimfiles/doc for windows) directory.

Click on the package to download.

package	script version	date	Vim version	user	release notes
db_ext.tar.gz	0.52	28-Nov-2002	6.0	David Fishburn	When setting up buffer parameters, I default to ones already entered (useful when you made a mistake - saves typing). Fixed some ASE related issues.
db_ext.tar.gz	.51	26-Nov-2002	6.0	David Fishburn	Added menus to gvim (if enabled). Updated the documentation for extra configuration details. Fixed a minor bug indicating it was referencing an undefined variable, b:db_ext_buffer_lines.  A workaround for this is to add the following to your _vimrc file: let g:default_db_ext_buffer_lines = 5
db_ext.tar.gz	0.5	25-Nov-2002	6.0	David Fishburn	New DB types added.  Now supported: Sybase Adaptive Server Anywhere(ASA), Ingres, Interbase, MySQL, PgSQL,  Sybase Adaptive Server Enterprise(ASE), Microsoft SQL Server,  Oracle.   New, buffer specific connection parameters, so two buffers can connect to different databases. Borrowed from Decho.vim (thanks Chip), now the results of any SQL statement are stored in a read only buffer called Result.  If the command fails diagnostic information is displayed plus connection information. The Result buffer is reused for new commands, and can be moved where ever the user wishes. Added the ability to describe not only tables, but also stored procedures (if your database supports it). Reworked the mappings and public interfaces to follow the tip:  How to write a plugin (thanks Chip). Added the ability to prompt the user for connection parameters.  If you do not define defaults, or want to connect to a different database, a simple wizard takes you through setting up the parameters. Updated the documentation to reflect the new changes.  :h db_ext
db_ext-0.4.tar.gz	0.4	20-Aug-2002	6.0	Peter Bagyinszki	New DB types added. Now supported: Sybase ASASQL, Ingres, Interbase, MySQL, PgSQL Queries can now be executed from visual block.
db_ext.0.3.tar.gz	0.3	28-Jul-2002	6.0	Peter Bagyinszki	Initial upload