DBUI_ExecuteQuery Keymap is Not Available

[sluhn-richteb]

Hi -

I have a directory where I store all of my SQL queries. Often times, I will open up a file in Neovim, then :DBUIFindBuffer to connect to vim-dadbod-ui. When I do this, I can leverage the standard :w to execute the query; however, the <leader> S option isn't available to execute just a portion of my code. The only time the <leader> S option is available is if I create a new query through the UI interface (the drawer on the left side).

I looked through the documentation and didn't see any settings to change to accomplish what I'm looking for. Relatively new to Neovim, so wanted to see if there was any advice!

TL;DR: I want to use the DBUI_ExecuteQuery keymap on a file that I open prior to connecting to vim-dadbod-ui.

Thanks!

[KarpenkoY]

@benhrichter Have a look, it will do the job

[Kimbix]

Hey, I currently use this "workaround" which is just setting a keymap to <CMD>DB < %<CR> which passes the entire buffer to the DB command, and that seems to do the trick. For visual mode it's kinda weird so I ended up setting the bind to :DB<CR>

I have it set up like this with lazy.nvim

keys = {
    { '<leader>sr', ":DB<CR>", desc = 'Runs highlighted SQL', mode = 'v' },
    { '<leader>sr', '<CMD>DB < %<CR>', desc = 'Runs SQL in current buffer', mode = 'n' }
}