LoginSignup
0
1

More than 3 years have passed since last update.

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

Last updated at Posted at 2019-10-15

Summary

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

 こんな感じ

Screen Shot 2019-10-16 at 7.11.52.png
Screen Shot 2019-10-16 at 7.12.07.png

設定

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のヘルプ

0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1