Archetype: sql_methodology_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 methodology data }}
{{{sql_license}}}
/*
 * AUTO-GENERATED FILE - DO NOT EDIT MANUALLY
 * Template: sql_methodology_populate.mustache
 * To modify, update the template and regenerate.
 */

-- =============================================================================
-- Data Quality Slovaris Methodologies
-- =============================================================================

\echo '--- Data Quality Slovaris Methodologies ---'

{{#methodologies}}
select ores_dq_methodologies_upsert_fn(ores_utility_system_tenant_id_fn(),
    '{{name}}',
    '{{description}}',
    '{{url}}',
    '{{{steps}}}'
);
{{/methodologies}}

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

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

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