scripts/jq/transform-product-creators.jq


1
2
3
4
5
6

.[] | select(has("steam_appid") and .type=="game") |
    "insert into product_creators (creator, product, role) values (
        (select id from creators where name = '\(.developers[0]? // "" | gsub("'"; "''"))'),
        \(.steam_appid),
        0
    );"