postgresql.test.js

'use strict';

const postgresql = require('../lib');

describe('postgresql', () => {
  it('should generate the query for bulk update operation', async () => {
    const queryOptions = {
      table: 'customers',
      primary_key_column: 'id',
      records: [
        {
          id: 1,
          name: 'sam',
          email: 'sam@example.com',
        },
        {
          id: 2,
          name: 'jon',
          email: 'jon@example.com',
        },
      ],
    };

    const _postgresql = new postgresql.default();

    const builtQuery = await _postgresql.buildBulkUpdateQuery(queryOptions);
    const expectedQuery =
      "UPDATE customers SET name = 'sam', email = 'sam@example.com' WHERE id = 1; UPDATE customers SET name = 'jon', email = 'jon@example.com' WHERE id = 2;";

    expect(builtQuery).toBe(expectedQuery);
  });
});