cancel
Showing results for 
Search instead for 
Did you mean: 

insert query from excel or variable

SOLVED
Contributor

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 variable in projrct global variables?
which would be recommended as per the performance and playback time
1 ACCEPTED SOLUTION

Accepted Solutions
Contributor

Re: insert query from excel or variable

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.

View solution in original post

2 REPLIES 2
Highlighted
Community Hero

Re: insert query from excel or variable

What's different about the insert queries?  Why 250?  Are they so different that you need to actually have 250 queries written out verbatim?  Could you create a code routine that would have a template of an insert query that you would just replace values in that you can call?  That way anything you would have in a data driven structure would be more efficient: just values rather than whole SQL statements.

 

Likewise for the database checkpoints, you can probably be more efficient to, again, write custom code to do the datatbase checkpoint rather than having to maintain 50 different ones.  Using, the same data source as generating the inserts, you could have code that does the proper comparisons of the data tables.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Contributor

Re: insert query from excel or variable

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.

View solution in original post