From 47d0f971fcf64d1bb036f0081d2ff209ec5007ee Mon Sep 17 00:00:00 2001
From: Jari Vetoniemi <jari.vetoniemi@indooratlas.com>
Date: Thu, 17 Feb 2022 05:31:06 +0900
Subject: initial commit

---
 scripts/jq/transform-product-creators.jq | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 scripts/jq/transform-product-creators.jq

(limited to 'scripts/jq/transform-product-creators.jq')

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
+    );"
-- 
cgit v1.2.3-70-g09d2