Fix bugs: time range longer than expected

[zlzlzlstone]

Raw:
SELECT sum("col") AS "shift_1_days" FROM "m" WHERE time >= now() - 3h GROUP BY time(1m)

Proxy:
SELECT sum("col") AS "shift_1_days" FROM "m" WHERE time >= now() - 3h - 1d GROUP BY time(1m)

Which real need:
SELECT sum("col") AS "shift_1_days" FROM "m" WHERE time <= now() - 1d AND time >= now() - 3h - 1d GROUP BY time(1m)

FIX:

function fix_query_time_relative(q, reg, count, unit) {
    const match = q.match(reg);
    if (match) {
        return q.replace(match[0], match[0] + " - " + moment.duration(count, unit).valueOf() + "ms");
    }
    else if (reg === to_rel) {
        const match = q.match(from_rel);
        if (match) {
            return q.replace(match[0], "time <= now()" + " - " + moment.duration(count, unit).valueOf() + "ms AND " + match[0]);
        }
    }
    return q;
}

[dataviruset]

I found this quite useful. Unless this code breaks something, maybe you can submit a pull request? :)