module.exports = async (dbConn) => {
    let presets = await dbConn.query(
            `SELECT search_presets.id AS preset_id,
                search_presets.parameter AS parameter,
                search_presets.name AS tag_label,
                CASE
                WHEN value_2 is NULL THEN value_1
                ELSE CONCAT(search_presets.value_1,"|",search_presets.value_2)
         END AS "value"
         FROM search_presets`
    );

    for (k = 0; k < presets.length; k++) {
        const value = presets[k].value
        presets[k].value = value.split("|");
        for (i = 0; i < presets[k].value.length; i++) {
            presets[k].value[i] = parseFloat(presets[k].value[i])
        }
    }
    return presets;
};