Send any script from VSCode to hoop.dev
Requirements
- Install hoop.dev CLI
Steps
- Create a VSCode task
Create a file in the path:
.vscode/task.json
of your workspace with the contents:json{ // See https://go.microsoft.com/fwlink/?LinkId=733558 // for the documentation about the tasks.json format "version": "2.0.0", "tasks": [ { "label": "Run query with hoop.dev", "type": "shell", "command": "hoop exec ${input:connectionName} -f ${file}", "panel": "new", "showReuseMessage": false, "clear": true } ], "inputs": [ { "type": "pickString", "id": "connectionName", "description": "Where do you want to run this script?", "options": ["db-write", "pg-db", "customers-database", "products-database"], "default": "component" } ]}
Update the
options
list with the names of the connections you want to use.- Run your file in hoop.dev from VSCode!
Hit
ctrl+shift+P
and type hoop.dev
to select our execution task: