diff options
| author | Jari Vetoniemi <jari.vetoniemi@indooratlas.com> | 2022-02-17 05:31:06 +0900 |
|---|---|---|
| committer | Jari Vetoniemi <mailroxas@gmail.com> | 2022-02-18 02:10:42 +0900 |
| commit | 47d0f971fcf64d1bb036f0081d2ff209ec5007ee (patch) | |
| tree | 7756cad0c4c915e277aba2c42e3110b0a2bf4e6f /scripts/jq/transform-product-creators.jq | |
Diffstat (limited to 'scripts/jq/transform-product-creators.jq')
| -rw-r--r-- | scripts/jq/transform-product-creators.jq | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/scripts/jq/transform-product-creators.jq b/scripts/jq/transform-product-creators.jq new file mode 100644 index 0000000..1a1bef7 --- /dev/null +++ b/scripts/jq/transform-product-creators.jq @@ -0,0 +1,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 + );" |