Query inside transaction not execute using knex

[restuwahyu13]

My query update not execute, and I get response back like this, after running my test, how to fix it this issue ?

TypeError: [(intermediate value)(intermediate value),(intermediate value)(intermediate value)][(step - 1)] is not a function
    at Tracker.<anonymous> (/home/antimalware/Desktop/real-project/testing/src/__tests__/unit-test/05.customer.spec.ts:466:16)
    at Tracker.emit (events.js:314:20)
    at Tracker.EventEmitter.emit (domain.js:483:12)
    at Queries.track (/home/antimalware/Desktop/real-project/testing/node_modules/mock-knex/dist/queries.js:68:22)
    at /home/antimalware/Desktop/real-project/testing/node_modules/mock-knex/dist/platforms/knex/0.8/index.js:52:38
    at Promise._execute (/home/antimalware/Desktop/real-project/testing/node_modules/bluebird/js/release/debuggability.js:303:9)
    at Promise._resolveFromExecutor (/home/antimalware/Desktop/real-project/testing/node_modules/bluebird/js/release/promise.js:483:18)
    at new Promise (/home/antimalware/Desktop/real-project/testing/node_modules/bluebird/js/release/promise.js:79:10)
    at Client_PG._query (/home/antimalware/Desktop/real-project/testing/node_modules/mock-knex/dist/platforms/knex/0.8/index.js:51:10)
    at Client_PG.query (/home/antimalware/Desktop/real-project/testing/node_modules/knex/lib/client.js:168:17)
    at /home/antimalware/Desktop/real-project/testing/node_modules/knex/lib/transaction.js:325:24
    at new Promise (<anonymous>)
    at Client_PG.trxClient.query (/home/antimalware/Desktop/real-project/testing/node_modules/knex/lib/transaction.js:320:12)
    at Transaction.query (/home/antimalware/Desktop/real-project/testingt/node_modules/knex/lib/transaction.js:121:8)
    at Transaction.rollback (/home/antimalware/Desktop/real-project/testing/node_modules/knex/lib/transaction.js:97:25)
    at Function.transactor.rollback (/home/antimalware/Desktop/real-project/testing/node_modules/knex/lib/transaction.js:277:42)
    at /home/antimalware/Desktop/real-project/testing/node_modules/knex/lib/transaction.js:193:35

My Testing

it('[POST] - /customer/verified-document/:customerId - Should be update verified document success', async function () {
	req.params.customerId = mockData.registerCustomer.success.id
	req.body = mockData.registerCustomer.success

	mockData.registerCustomer.success.guarantor_identification_front_verified = false
	mockData.registerCustomer.success.guarantor_identification_back_verified = false
	mockData.registerCustomer.success.license_front_verified = false
	mockData.registerCustomer.success.license_back_verified = false
	mockData.registerCustomer.success.guarantor_identification_front_verified = false
	mockData.registerCustomer.success.guarantor_identification_back_verified = false

	tracker.on('query', (query, step) => {
		return [
			() => {
				if (query.method !== undefined && step === 2) chai.expect(query.method).to.equal('first')
				query.response(mockData.registerCustomer.success)
			},
			() => {
				if (query.method !== undefined && step === 3) chai.expect(query.method).to.equal('update')
				query.response(1)
			}
		][step - 1]()
	})

	await verifiedCustomerDocument(req, res)
	const data = res._getJSONData()

	chai.expect(res._isEndCalled()).to.be.true
	chai.expect(res._getStatusCode()).to.be.equal(200)
	chai.expect(res._getHeaders()).to.be.contain({ 'content-type': 'application/json' })
	chai.expect(data.message).to.be.equal(`Successfully verified customer document.`)
})

My Controller

import { checkSchema } from 'express-validator'
import { ApiRequest, ApiResponse } from '../../interface/common'
import { Customer } from '../../interface/model'
import db from '../../lib/db'

export async function verifiedCustomerDocument(req: ApiRequest, res: ApiResponse): Promise<any> {
	let params = req.params
	let payload = req.body
	try {
		await db.transaction(async (trx) => {
			const checkVerifiedDocument = await trx<Customer>('customer').where({ userId: params.customerId }).first()

			if (checkVerifiedDocument === undefined) {
				throw {
					status: 'ERROR',
					httpStatus: 404,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: `Customer data not found for this id ${params.customerId}`
				}
			}

			if (checkVerifiedDocument?.identificationFrontVerified === true) {
				throw {
					status: 'ERROR',
					httpStatus: 403,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: 'Customer identificationFront is verified'
				}
			} else if (checkVerifiedDocument?.identificationBackVerified === true) {
				throw {
					status: 'ERROR',
					httpStatus: 403,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: 'Customer identificationBack is verified'
				}
			} else if (checkVerifiedDocument?.licenseFrontVerified === true) {
				throw {
					status: 'ERROR',
					httpStatus: 403,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: 'Customer licenseFront is verified'
				}
			} else if (checkVerifiedDocument?.licenseBackVerified === true) {
				throw {
					status: 'ERROR',
					httpStatus: 403,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: 'Customer licenseBack is verified'
				}
			} else if (checkVerifiedDocument?.guarantorIdentificationFrontVerified === true) {
				throw {
					status: 'ERROR',
					httpStatus: 403,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: 'Customer guarantorIdentificationFront is verified'
				}
			} else if (checkVerifiedDocument?.guarantorIdentificationBackVerified === true) {
				throw {
					status: 'ERROR',
					httpStatus: 403,
					error: 'UPDATE_VERIFIED_DOCUMENT',
					code: '1EC5OXWO',
					message: 'Customer guarantorIdentificationBack is verified'
				}
			} else {
				const updateVerifiedDoc = await trx<Customer>('customer').where({ userId: params.customerId }).update({
					identificationFrontVerified: payload.identificationFrontVerified,
					identificationBackVerified: payload.identificationBackVerified,
					licenseFrontVerified: payload.licenseFrontVerified,
					licenseBackVerified: payload.licenseBackVerified,
					otherDocumentVerified: payload.otherDocumentVerified,
					guarantorIdentificationFrontVerified: payload.guarantorIdentificationFrontVerified,
					guarantorIdentificationBackVerified: payload.guarantorIdentificationBackVerified
				})

				if (updateVerifiedDoc < 1) {
					throw {
						httpStatus: 403,
						status: 'ERROR',
						code: 'XCD3221',
						message: 'Failed update customer verified document'
					}
				}

				const json = {
					status: 'OK',
					message: 'Successfully verified customer document.'
				}
				res.status(200).json(json)
				return json
			}
		})
	} catch (err) {
		console.error(err)
		const json = {
			httpStatus: 400,
			status: 'ERROR',
			code: err.code || '1EC5OXWO',
			message: err.message || 'UPDATE_VERIFIED_DOCUMENT'
		}
		res.status(err.httpStatus || 400).json(json)
		return json
	}
}
})