Function main

benchmark/sqlite/sqlite-prepare-select-get-options.js:15–50

(conf)

});

function main(conf) {
  const optionsObj = conf.options === 'none' ? {} : conf.options.split('|').reduce((acc, key) => {
    acc[key] = true;
    return acc;
  }, {});

  const db = new sqlite.DatabaseSync(':memory:', optionsObj);

  db.exec(
    'CREATE TABLE foo (text_column TEXT, integer_column INTEGER, real_column REAL, blob_column BLOB)',
  );

  const fooInsertStatement = db.prepare(
    'INSERT INTO foo (text_column, integer_column, real_column, blob_column) VALUES (?, ?, ?, ?)',
  );

  for (let i = 0; i < conf.tableSeedSize; i++) {
    fooInsertStatement.run(
      crypto.randomUUID(),
      Math.floor(Math.random() * 100),
      Math.random(),
      Buffer.from('example blob data'),
    );
  }

  let i;
  let deadCodeElimination;

  const stmt = db.prepare(conf.statement);

  bench.start();
  for (i = 0; i < conf.n; i += 1) deadCodeElimination = stmt.get();
  bench.end(conf.n);

  assert.ok(deadCodeElimination !== undefined);
}