threshold/internal/db/sqltest/tests/setup/wtt_load.sql

-- Copyright IBM Corp. 2020, 2026
-- SPDX-License-Identifier: BUSL-1.1

-- wtt_load tests the wtt_load test helper function.
begin;
  select plan(6);

  -- invalid or missing args
  select throws_ok($$select wtt_load('unknown', 'iam')$$);
  select throws_ok($$select wtt_load('widgets', 'unknown')$$);
  select throws_ok($$select wtt_load('widgets')$$);
  select throws_ok($$select wtt_load()$$);

  -- incorrect order since auth depends on iam
  select throws_ok($$select wtt_load('widgets', 'auth', 'iam')$$);

  -- missing a dependancy, auth depends on iam
  select throws_ok($$select wtt_load('widgets', 'auth')$$);

  select * from finish();
rollback;