DQL Manager
Manages DQL Preview and Custom SQL actions over Space and Time
Various Ways to Test Tables by Previewing Top 10 Rows
Hardhat SXT Utils Commands
Preview Table Commands
npx hardhat sxt-utils:insertIntoTable --schema sxt_utils --businessobject ToDo
npx hardhat sxt-utils:previewTable --schema sxt_utils --businessobject ToDo
npx hardhat sxt-utils:previewTable --schema sxt_utils --table lists
npx hardhat sxt-utils:previewTable --schema sxt_utils --table tasks
npx hardhat sxt-utils:previewTable --schema sxt_utils --table lists,tasks --query getListTasks
Custom Queries
Custom queries can be defined in schemas/<schema>/sql/udf-custom/<query>.sql
Note: Replace
<SCHEMA>
argument specified in the SQL file with the literal schema name.
Example Custom Query: getListTasks.sql
-- getListTasks.sql
SELECT t.id as task_id,
t.task,
t.complete,
l.id as list_id,
l.list
FROM `<SCHEMA>`.TASKS t
JOIN `<SCHEMA>`.LISTS l
ON t.list_id = l.id
WHERE l.id = 1
Querying Tables
The table
parameter must contain the list of tables that are used in the SQL query:
npx hardhat sxt-utils:queryTable --schema <schema> --table lists,tasks --query getListTasks
Updated 7 days ago
What’s Next