HEX
Server: nginx/1.24.0
System: Linux nowruzgan 6.8.0-57-generic #59-Ubuntu SMP PREEMPT_DYNAMIC Sat Mar 15 17:40:59 UTC 2025 x86_64
User: babak (1000)
PHP: 8.3.6
Disabled: NONE
Upload Files
File: /var/dev/nowruzgan/rest/node_modules/waterline-sql-builder/test/benchmarks/sequelizer.test.js
var runBenchmarks = require('../support/benchmark-runner');
var analyze = require('../support/analyze');
var sqlBuilder = require('../../index')({
  dialect: 'postgres'
});

//  ╔╗ ╔═╗╔╗╔╔═╗╦ ╦╔╦╗╔═╗╦═╗╦╔═╔═╗
//  ╠╩╗║╣ ║║║║  ╠═╣║║║╠═╣╠╦╝╠╩╗╚═╗
//  ╚═╝╚═╝╝╚╝╚═╝╩ ╩╩ ╩╩ ╩╩╚═╩ ╩╚═╝
describe('Benchmark :: Sequelizer', function() {
  // Set "timeout" and "slow" thresholds incredibly high
  // to avoid running into issues.
  this.slow(240000);
  this.timeout(240000);

  var trees = {};

  // Analyzer all the test inputs before running benchmarks
  before(function() {
    trees.select = analyze({
      select: ['*'],
      from: 'books'
    });

    trees.insert = analyze({
      insert: {
        title: 'Slaughterhouse Five'
      },
      into: 'books'
    });

    trees.update = analyze({
      update: {
        status: 'archived'
      },
      where: {
        publishedDate: { '>': 2000 }
      },
      using: 'books'
    });

    trees.delete = analyze({
      del: true,
      from: 'accounts',
      where: {
        activated: false
      }
    });
  });

  it('should be performant enough', function() {
    runBenchmarks('Sequelizer.execSync()', [
      function sequelizerSelect() {
        sqlBuilder.sequelizer(trees.select);
      },

      function sequelizerInsert() {
        sqlBuilder.sequelizer(trees.insert);
      },

      function sequelizerUpdate() {
        sqlBuilder.sequelizer(trees.update);
      },

      function sequelizerDelete() {
        sqlBuilder.sequelizer(trees.delete);
      }
    ]);
  });
});