📦 EqualifyEverything / database

database / dockherd / child_a11yphant.sql
📄 child_a11yphant.sql · 13 lines 
1
2
3
4
5
6
7
8
9
10
11
12
13-- Post Creation Scripts for A11yphant

-- Import Data
    -- Start/Seed Data
    -- FROM: start_domains TO: targets.domains
    \copy targets.domains(id, domain, active) FROM '/docker-entrypoint-initdb.d/start_domains.csv' WITH (FORMAT csv, HEADER true, DELIMITER ',');

    -- FROM: start_urls TO: targets.urls
    \copy targets.urls(url, domain_id, is_objective) FROM '/docker-entrypoint-initdb.d/start_urls.csv' WITH (FORMAT csv, HEADER true, DELIMITER ',');

    -- Reference Data
    -- FROM: ref_uppies_codes TO: refs.uppies_codes
    \copy ref.uppies_codes(code, description, name, type, "group") FROM '/docker-entrypoint-initdb.d/ref_uppies_codes.csv' WITH (FORMAT csv, HEADER true, DELIMITER ',');