Function main

benchmark/sqlite/sqlite-prepare-insert.js:19–100

(conf)

});

function main(conf) {
  const db = new sqlite.DatabaseSync(':memory:');

  db.exec('CREATE TABLE text_column_type (text_column TEXT)');
  db.exec('CREATE TABLE integer_column_type (integer_column INTEGER)');
  db.exec('CREATE TABLE real_column_type (real_column REAL)');
  db.exec('CREATE TABLE blob_column_type (blob_column BLOB)');
  db.exec(
    'CREATE TABLE all_column_types (text_column TEXT, integer_column INTEGER, real_column REAL, blob_column BLOB)',
  );
  db.exec('CREATE TABLE large_text (text_8kb_column TEXT)');
  db.exec('CREATE TABLE missing_required_value (any_value TEXT, required_value TEXT NOT NULL)');

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

  let i;
  let deadCodeElimination;

  const stringValue = crypto.randomUUID();
  const integerValue = Math.floor(Math.random() * 100);
  const realValue = Math.random();
  const blobValue = Buffer.from('example blob data');

  const largeText = 'a'.repeat(8 * 1024);

  if (conf.statement.includes('text_column_type')) {
    bench.start();
    for (i = 0; i < conf.n; i += 1) {
      deadCodeElimination = insertStatement.run(stringValue);
    }
    bench.end(conf.n);
  } else if (conf.statement.includes('integer_column_type')) {
    bench.start();
    for (i = 0; i < conf.n; i += 1) {
      deadCodeElimination = insertStatement.run(integerValue);
    }
    bench.end(conf.n);
  } else if (conf.statement.includes('real_column_type')) {
    bench.start();
    for (i = 0; i < conf.n; i += 1) {
      deadCodeElimination = insertStatement.run(realValue);
    }
    bench.end(conf.n);
  } else if (conf.statement.includes('blob_column_type')) {
    bench.start();
    for (i = 0; i < conf.n; i += 1) {
      deadCodeElimination = insertStatement.run(blobValue);
    }
    bench.end(conf.n);
  } else if (conf.statement.includes('INTO all_column_types')) {
    bench.start();
    for (i = 0; i < conf.n; i += 1) {
      deadCodeElimination = insertStatement.run(
        stringValue,
        integerValue,
        realValue,
        blobValue,
      );