vim-dbext.vimでattachしたdbの補完をだす

3367 ワード
neovim Vim SQL Vim テキストリンク

Summary

attachしたdbの補完を出す設定方法

　こんな感じ


設定

vimrcに書く

"  ------------------------------------------------------
"                      main database
"  ------------------------------------------------------

  let s:dbname  = $HOME . '/Desktop/test_sqlite3/baz.sqlite'
  let g:dbext_default_profile_test = 'type=SQLITE:dbname=' . s:dbname

"  ------------------------------------------------------
"                     attach databases
"  ------------------------------------------------------

  let s:addDb01 = '"' . $HOME . '/Desktop/test_sqlite/foo.db" as foo'
  let s:sCmd01 = '-cmd ''attach ' . s:addDb01 . ''' '

  let s:addDb02 = '"' . $HOME . '/Desktop/test_sqlite2/bar.db" as bar'
  let s:sCmd02 = '-cmd ''attach ' . s:addDb02 . ''' '

  let g:dbext_default_SQLITE_cmd_options = s:sCmd01 .  s:sCmd02

"  ------------------------------------------------------
"                       set profile
"  ------------------------------------------------------

  let g:dbext_default_profile = 'test'

参考

sqliteのヘルプのcmdのところ


$ sqlite3 --help

dbext.vimのヘルプ