jestjs - Postgresql and Jest - Insert Returning ID test for failed insert

Question

I am doing some sql testing using Jest. I have a method that will insert data into the database and return its id.

const insert = async () => {
  const query = ` 
    INSERT INTO 
      table (a, b c)
    VALUES
      (1,2,3)
    RETURNING 
      id
    `
  const result = await db.queryOne(query)
  
  return result ? result.id : null
}

This actual method is written in typescript, db.queryOne returns either the result or null.

I can successfully test an insert is inserting correctly, however I am getting a %branchy of only 50 for this method, which means my whole test coverage summary is not 100%.

I am wanting to know if there is a way I can force the query to not return the id and return the null?

I tried to send in a column that doesn't exist on the table, but that throws an error before the return. I need it to not throw an error, but not return a value, but without changing the query.

Any suggestions?

Answer 1

等待大神答复