src.images_generate_sql Namespace Reference

Functions
str	get_header (str dataset_name, str subject_area_name, str domain_name, str source_dir, str script_name)
str	get_footer (str dataset_name, int count)
str	generate_insert (str key, str description, str svg_content)
	main ()

Variables
dict	CONFIGS

Detailed Description

Generates SQL populate scripts for DQ image artefacts.

This is a generalized script that can be used for any image dataset
(flags, crypto icons, etc.). It reads SVG files from a source directory
and generates a SQL script to populate the dq_images_artefact_tbl.

Usage:
    python3 generate_dq_images_sql.py --config flags
    python3 generate_dq_images_sql.py --config crypto
    python3 generate_dq_images_sql.py \\
        --dataset-name "My Dataset" \\
        --subject-area "My Subject Area" \\
        --domain "Reference Data" \\
        --source-dir "path/to/svgs" \\
        --output-file "output.sql" \\
        --description-template "Icon for {key}"

Variable Documentation

CONFIGS

dict CONFIGS

Initial value:

=  {
    'flags': {
        'dataset_name': 'Country Flag Images',
        'subject_area_name': 'Country Flags',
        'domain_name': 'Reference Data',
        'source_dir': 'external/flags/flag-icons',
        'output_file': 'projects/ores.sql/populate/flags/flags_images_artefact_populate.sql',
        'description_template': 'Flag of {key}',
    },
    'crypto': {
        'dataset_name': 'Cryptocurrency Icon Images',
        'subject_area_name': 'Cryptocurrencies',
        'domain_name': 'Reference Data',
        'source_dir': 'external/crypto/cryptocurrency-icons',
        'output_file': 'projects/ores.sql/populate/crypto/crypto_images_artefact_populate.sql',
        'description_template': 'Icon for {key}',
    },
}