✅ – Can anyone help with better-sqlite3's `aggregate` method to read more than one row?

Can anyone help with better-sqlite3's aggregate method to read more than one row?
Solution:
I'm using better-sqlite3 and I want to use its aggregate method but I need to have access to 2 rows, not just 1, in the aggregate step function. This is the code that works ```js filter(predicate) { this.#db.aggregate('filter', { start: [], step: (accumulator, currentValue) => {...
Solution
ME
<Maddie> [Evie.Codes][She/Her]•37d ago
I'm using better-sqlite3 and I want to use its aggregate method but I need to have access to 2 rows, not just 1, in the aggregate step function. This is the code that works 
  filter(predicate) {
    this.#db.aggregate('filter', {
      start: [],
      step: (accumulator, currentValue) => {
        const parsed = JSON.parse(currentValue);
        if (predicate(parsed)) {
          accumulator.push(parsed);
        }
        return accumulator;
      },
      result: (accumulator) => JSON.stringify(accumulator),
    });
    const results = this.#db
      .prepare(`SELECT filter(value) FROM mytable`)
      .pluck()
      .get();
    return JSON.parse(results);
  }
  filter(predicate) {
    this.#db.aggregate('filter', {
      start: [],
      step: (accumulator, currentValue) => {
        const parsed = JSON.parse(currentValue);
        if (predicate(parsed)) {
          accumulator.push(parsed);
        }
        return accumulator;
      },
      result: (accumulator) => JSON.stringify(accumulator),
    });
    const results = this.#db
      .prepare(`SELECT filter(value) FROM mytable`)
      .pluck()
      .get();
    return JSON.parse(results);
  }
But I need too add a second row, key. I don't know how. I tried to do .prepare('SELECT filter(key, value) FROM mytable') but that tells me wrong number of arguments to function filter(). I tried SELECT filter(key), filter(value) from mytable and that runs the function twice, not once, with the key then the value and that's obviously not what I want. Any idea on how I can get both values at once in the step ?
ME
<Maddie> [Evie.Codes][She/Her]•36d ago
Got an answer from the better-sqlite3 author, so I'll stick it here for posterity, just in case anyone else ever searches archives! This is for another method but it's simpler, so easier to look at: 
  reduce(predicate, initialValue) {
    this.#db.aggregate('reduce', {
      start: initialValue,
      step: (accumulator, currentValue, key) =>
        predicate(accumulator, this.#parse(currentValue), key),
    });
    return this.#db
      .prepare(`SELECT reduce(value, key) FROM ${this.#name}`)
      .pluck()
      .get();
  }
  reduce(predicate, initialValue) {
    this.#db.aggregate('reduce', {
      start: initialValue,
      step: (accumulator, currentValue, key) =>
        predicate(accumulator, this.#parse(currentValue), key),
    });
    return this.#db
      .prepare(`SELECT reduce(value, key) FROM ${this.#name}`)
      .pluck()
      .get();
  }
There we go 🙂 Hope it helps someone else in the future.
UU
Unknown User•36d ago
More Posts
eslachance – 17-36 Apr 4Would anyone know why httponly, samesite: strict, cookie is showing as undefined , but only if I'm lsnowberb – 11-30 Mar 28Imagine that im refactoring a function that does a lot of things. In this case, the handleOnClick of