Support for canned queries.
I'm evaluating DataGrip and would like to save several 'admin' DB queries so they can be easily run and the results displayed. Ideally I'd like to put these either on a menu, or perhaps assigned to some keyboard shortcut.
I have the queries I want to use. I don't need to view them before execution, I just want to run them and see the results.
This would also be useful for canned reporting queries that would be run periodically. I just want the ability to invoke them from my DataGrip session, and I don't want to have to load them into a console window, or load a file and attach it to a console before I execute it.
Ideas?
请先登录再写评论。
Hi! I think we have not exact feature you described, but may be a couple of things can help you.
1. Live Templates. Settings -> Editor -> Live Templates. You can save any query there and easily paste it in every moment. Yes, you need to be inside the SQL editor, but still it is rather fast.
2. Keep these queries as files. If you want to execute one - go to the context menu of a file and press Run. No need to load a file, just run it from Files panel.
Does it help?
#1 would work If there was an option to execute without expanding the template shortcut in the edit window. I don't want to clutter my edit window with these queries, but showing the shortcut only would be OK.
#2 Doesn't work because the query output is not shown. The whole point of these type of queries is to see the results.
Ideally I'd like to be able to put my canned queries on a menu somewhere so they could be easily selected, But if #1 A live template could be used/executed without expanding it into the edit window, or #2 query output from executed files could be shown in a result window, then either one of those could be an acceptable solution.
#2 fair enough, please follow the ticket: https://youtrack.jetbrains.com/issue/DBE-5931