Archetype: sql_catalog_populate.mustache

{{! GENERATED FILE — tangled from projects/ores.codegen/library/templates/sql_populate.org. Edit the org source. }}
{{! Template to generate SQL with enhanced GPL v3 license and catalog data }}
{{{sql_license}}}
/*
 * AUTO-GENERATED FILE - DO NOT EDIT MANUALLY
 * Template: sql_catalog_populate.mustache
 * To modify, update the template and regenerate.
 */

-- =============================================================================
-- Data Quality Slovaris Catalogs
-- =============================================================================

\echo '--- Data Quality Slovaris Catalogs ---'

{{#catalogs}}
select ores_dq_catalogs_upsert_fn(ores_utility_system_tenant_id_fn(),
    '{{name}}',
    '{{description}}',
    '{{owner}}'
);
{{/catalogs}}

-- =============================================================================
-- Summary
-- =============================================================================

\echo ''
\echo '--- Summary ---'

select 'Data Quality Total Catalogs' as entity, count(*) as count
from ores_dq_catalogs_tbl where valid_to = ores_utility_infinity_timestamp_fn()
order by entity;