Exercise 3: Insert a New Row Into a Database Table

After you have finished this exercise, you understand how you can use custom assertion methods when you have to write integration tests for code that inserts a new row into a database table. You can finish this exercise by following these steps:

1. Open the CreateTodoItemTest class that’s found from the com.cleantestautomation.assertjdb.todoitem package.

2. Write the table and row level assertions which ensure that the system under inserts the correct information into the todo_item table. Use the custom assertion methods which you wrote during the exercise 1.

You can get the “current local date and time” by using the CURRENT_LOCAL_DATE_TIME constant that’s found from the ConstantDateTimeService class.

3. Run the tests found from the CreateTodoItemTest class and make sure that they pass.