dfabulich

11:46:47.874665: _v2-entry-point[34134]: argv (unescaped): /home/deck/.local/share/Steam/steamapps/common/SteamLinuxRuntime/scout-on-soldier-entry-point-v2 -- /home/deck/.local/share/Steam/steamapps/common/SLAMMED/SLAMMED --no-sandbox
11:46:47.886757: pressure-vessel-wrap[34134]: I: pressure-vessel version 0.20230227.0
11:46:48.009096: pressure-vessel-wrap[34134]: I: Applying "/home/deck/.local/share/Steam/steamapps/common/SteamLinuxRuntime_soldier/soldier_platform_0.20230228.42394/usr-mtree.txt.gz" to "/home/deck/.local/share/Steam/steamapps/common/SteamLinuxRuntime_soldier/var/tmp-Q73G21/usr"...
11:46:48.423167: pressure-vessel-wrap[34134]: I: pv_runtime_provide_container_access: Setting up runtime without using bwrap
11:46:48.423293: pressure-vessel-wrap[34134]: I: EGL ICD #0 at /usr/share/glvnd/egl_vendor.d/50_mesa.json: libEGL_mesa.so.0
11:46:48.423318: pressure-vessel-wrap[34134]: I: Vulkan ICD #0 at /usr/share/vulkan/icd.d/radeon_icd.x86_64.json: /usr/lib/libvulkan_radeon.so
11:46:48.423338: pressure-v

dfabulich

// based on https://gist.github.com/dfabulich/fc6b13a8bffc5518c4731347de642749
// but VNDB supports a wider range of discrete values, so I had to write this script to generate the SQL
const MIN_VOTE = 10;
const MAX_VOTE = 100;

function buildBuckets(alias) {
    const parts = [];
    for (let v = MIN_VOTE; v <= MAX_VOTE; v++) {
        parts.push(
            `SUM(CASE WHEN ${alias}.vote = ${v} THEN ${alias}.cnt ELSE 0 END) AS rated${v}`