ORE Studio 0.0.4
Loading...
Searching...
No Matches
Functions | Variables
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:
1= {
2 'flags': {
3 'dataset_name': 'Country Flag Images',
4 'subject_area_name': 'Country Flags',
5 'domain_name': 'Reference Data',
6 'source_dir': 'external/flags/flag-icons',
7 'output_file': 'projects/ores.sql/populate/flags/flags_images_artefact_populate.sql',
8 'description_template': 'Flag of {key}',
9 },
10 'crypto': {
11 'dataset_name': 'Cryptocurrency Icon Images',
12 'subject_area_name': 'Cryptocurrencies',
13 'domain_name': 'Reference Data',
14 'source_dir': 'external/crypto/cryptocurrency-icons',
15 'output_file': 'projects/ores.sql/populate/crypto/crypto_images_artefact_populate.sql',
16 'description_template': 'Icon for {key}',
17 },
18}