Forum Discussion

anupamchampati's avatar
anupamchampati
Frequent Contributor
6 years ago

insert query from excel or variable

need a suggestion i have around 250 insert query and 50 databse checkpoint so shall i read the insert query from excel or sqlfile? datadriven approach or shall i save the query 20 per each variabl...
  • anupamchampati's avatar
    anupamchampati
    6 years ago

    Yes, there are more than 81 columns in the Database, I have unique 250 insert queries as my Test Cases.

    After Insert1 , my application does some operations, which again I need to check with different Database Tables for which I am using Database Checkpoints.

     

    I did read from sql file using aqFile.ReadTextFile and it is very quick now.

     

    I would love to see the custom code for Database Checkpoint can you please give me any example in post or email : champatianupam@gmail.com whichever is easy for you.