Pierre Ortega
10/15/2021, 8:33 PMYour raw query had an incorrect number of parameters. Expected: `0`, actual: `2`
But my query does not use any parameters, I think.
const history = await db.$queryRaw<HistoryData>`
SELECT
a.day,
s."value" as slp,
s."value" - lag(s."value" ) over (order by a.day) as increase
FROM (
SELECT
DISTINCT d.day,
max(s. "date") OVER (ORDER BY d.day) AS effective_date
FROM (SELECT generate_series('2021-10-01'::date, now()::date, '1d')::date) d (day)
LEFT JOIN "WalletsHistory" s ON DATE(s.date) = d.day AND s.wallet_id = '${wallet.id}'
) a
INNER JOIN "WalletsHistory" s ON s.date = a.effective_date
AND s.wallet_id = '${wallet.id}'
ORDER BY
a.day;
`;Salvador Lopez Mendoza
10/15/2021, 8:58 PMSalvador Lopez Mendoza
10/15/2021, 8:59 PMwallet_id = ${wallet.id} I thinkPierre Ortega
10/18/2021, 5:44 PM