vim-dadbod-ui icon indicating copy to clipboard operation
vim-dadbod-ui copied to clipboard

Database level helper queries

Open eruizc-dev opened this issue 3 years ago • 0 comments

Database level helper queries

There are currently table helpers. Useful for counting, ordering and whatever you wanna do with tables. You name it.

But there are basic queries that you make with all databases like listing schemas, users, tables and other stuff. These queries are executed at a database level and can be run in all databases with the same engine.

Example:

SELECT User, Host, Password FROM mysql.user;

I'd like to define the previous query as the following

let g:db_ui_helpers = {
\   'mysql': {
\      'List Users': 'SELECT User, Host, Password FROM mysql.user'
\   }
\}

And have it appear like the following in ALL mysql databases. image

eruizc-dev avatar Mar 30 '21 19:03 eruizc-dev