blob: 48f51e759e6f7443a295f1c276ebb33fd2b7b8f5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
.[] | select(has("steam_appid") and .type=="game") |
"insert into products (id, engine, platforms, price, title, body, short, header) values (
\(.steam_appid),
0,
0,
\(.price_overview.final? // 0),
'\(.name? // "no-name" | gsub("'"; "''"))',
'\(.detailed_description? // "no-desc" | gsub("'"; "''"))',
'\(.short_description? // "no-short-desc" | gsub("'"; "''"))',
'\(.header_image? // "https://waifu.cloudef.pw/loading.png" | gsub("'"; "''"))'
);"
|