Skip to content

Latest commit

 

History

History
90 lines (51 loc) · 2.55 KB

README.md

File metadata and controls

90 lines (51 loc) · 2.55 KB
Raw

vim-simpledb

Vim plugin to execute postgresql or mysql commands from VIM buffer

Installation

Pathogen

If you use git submodules, run this command from your .vim folder:

git submodule add https://github.com/ivalkeen/vim-simpledb bundle/simpledb

Otherwise, , run this command from your .vim folder:

git clone https://github.com/ivalkeen/vim-simpledb bundle/simpledb

Vundle

Add this line to your vimrc

Bundle 'ivalkeen/vim-simpledb'

Usage

Default key mapping for execution: <enter>.

  1. Create new file with .sql extension (without extensions, mapping would not work)

  2. Create first line with commented parameters:

    for psql:

    -- -h localhost -U postgres -d my_database

    or for mysql:

    -- db:mysql -D my_database -u root

    Note: if you don't want to enter password each time, you should create .pgpass (.my.cnf for mysql) file

    There is also usefull key -q to avoid messages like 'Timing is on' etc.

  3. Add sql statements to your file

  4. Hit <enter> to execute all not commented queries

  5. Hit <leader><enter> to execute all queries in the current paragraph

  6. Select multiple lines in visual mode and hit <enter> to execute just those queries

Configuration

If you do not want timings to be displayed, add this to your .vimrc:

let g:simpledb_show_timing = 0

If you want to customize the key mappings, set the variable simpledb_use_default_keybindings to 0 and add your own mappings in ~/.vimrc. For example, to execute a sql statement by pressing "ctrl-q" instead of "enter", add the following:

let g:simpledb_use_default_keybindings=0
vnoremap <buffer> <c-q> :SimpleDBExecuteSql<cr>
nnoremap <buffer> <c-q> m':SimpleDBExecuteSql <cr>g`'
nnoremap <buffer> <leader><c-q> m':'{,'}SimpleDBExecuteSql<cr>g`'

If you have any questions, mail me

TODO

  1. Rewrite code to match vim script conventions
  2. Intellisense

Contributing

  1. Fork it
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Added some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create new Pull Request

Self-Promotion

If you like this project, please follow the repository on GitHub. Also, you might consider visiting my blog and following me on Twitter and Github.