Ⅰ. 插件描述
An SQL wrapper for vimⅡ. 基本信息
|
Ⅲ. 安装方法
使用Vundle管理器安装
在你的.vimrc下添加:Plugin 'joereynolds/sqhell-vim':source %
:PluginInstall对于Vundle版本 < 0.10.2，请用上面的Bundle替换Plugin。
使用NeoBundle管理器安装
在你的.vimrc下添加:NeoBundle 'joereynolds/sqhell-vim':source %
:NeoBundleInstall使用VimPlug管理器安装
在你的.vimrc下添加:Plug 'joereynolds/sqhell-vim':source %
:PlugInstall使用Pathogen管理器安装
在终端中运行以下命令:cd ~/.vim/bundle
git clone https://github.com/joereynolds/sqhell.vimⅣ. 文档说明
# SQHell.vim
An SQL wrapper for Vim.
Execute commands, sort results, navigate tables and databases and so much more!
The supported providers at the moment are
- MySQL
- Postgres
- Sqlite
It started off simply enough:
nnoremap <leader>xc :r !mysql -uroot -psomepass -h somehost.com <<< `cat %` \| column -t<cr>It grew from there...
Examples
(Gifs are using the data from my band bogans)
Execute a command using SQHExecute!
Execute a line with SQHExecute.
Execute a visual block with SQHExecute over a visual selection.
Execute an arbitrary command with SQHExecute!.
Execute a file using SQHExecuteFile
SQHExecuteFile will work on the current buffer if no file is supplied
Explore the database with buffer aware mappings
Installation
Vim Plug
Plug 'joereynolds/SQHell.vim'Configuration
Connection details will need to be supplied in order for SQHell.vim to connect
to your DBMS of choice. The connections are in a dictionary to let you manage
multiple hosts. By default SQHell uses the 'default' key details (no surprise there)
Example:
let g:sqh_connections = {
\ 'default': {
\ 'user': 'root',
\ 'password': 'testing345',
\ 'host': 'localhost'
\},
\ 'live': {
\ 'user': 'root',
\ 'password': 'jerw5Y^$Hdfj',
\ 'host': '46.121.44.392'
\}
\}You can use the SQHSwitchConnection function to change hosts.
i.e. SQHSwitchConnection live
I strongly suggest that the above configuration details are kept outside
of version control and gitignored in your global gitignore.
Default Keybindings
SQHell creates 3 filetypes to make navigation a nicer experience.
These are SQHDatabase, SQHTable, and SQHResult
SQHDatabase
Inside an SQHDatabase you can press the following
dd - Drop the database (don't worry there's a prompt).
e - To see all the tables in that database. This will open an SQHTable buffer.
SQHTable
Inside an SQHDatabase you can press the following
dd - Drop the table (don't worry there's a prompt).
e - To see all the results for that table with a limit of g:sqh_results_limit.
This will open an SQHResult buffer
SQHResult
Inside an SQHResult you can press the following
s to sort results by the column the cursor is on.
S to sort results by the column the cursor is on (in reverse).
dd to delete the row WHERE the column is the value under the cursor (don't worry... there's a prompt).
e to edit the current row. This will open an SQHInsert buffer
For more sorting options, you can use :SQHSortResults with extra arguments for the unix sort command, a la :SQHSortResults -rn. It will always sort by the column the cursor is located on.
SQHInsert
Inside an SQHInsert you can press the following
ZZ to close and save the edited row. This will reopen the previous SQHResult buffer
Contributing
Please see the Contributing guidelines if you would like to make SQHell even better!
Tests
Tests use vader.
Tests are housed in the test directory and can be ran byviming into the test file and running :Vader.
What about dbext, vim-sql-workbench and others?
DBExt is very featureful (and very good) but comes in at a whopping 12000 lines
of code. By contrast SQHell.vim is a mere ~200 lines
The setup and installation process for vim-sql-workbench is something that I
aim to avoid with SQHell.vim, ideally a 'set and forget' plugin.
There are no clever inferences inside SQHell.vim.