I need to do some database verification for 20 resources that I add to the database. For each resource, SELECT statement is going to be different. I can create 20 functions to verify this. I am looking for a simpler solution. If you have any sugections or any code, can you help me.
You should try to make the thing data driven. This technique is where you have a list of inputs and verified outputs and a loop that runs through each input, runs the test and check the output against the expected output. This will reduce code size.
Also, if you added more information I could help you more.