This is a migrated thread and some comments may be shown as answers.

How to run stored procedure in web test project and take data.

3 Answers 61 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Krish
Top achievements
Rank 1
Krish asked on 12 Oct 2012, 05:32 AM
Hi,
 
I need solutions for following queries.

01. How to run stored procedure in web test project and take data. Scenario is as follows.
      ** Through the automation script I need to run the stored procedure and take some data from DB.
 Output of that query (result of that stored procedure) must write into the excel or xml file. Please provide your guide lines to successfully execute above scenaio.

02. I could successfully created Test list and add my test list to the Result sections when I was executing automation script in web test project. But I could not create Test list when I was executing automation script in Load testing project. Simply how to create Test List in Load testing project.


Note: - I am using Test studio 2012.2 and standalone app(web test project).

Thanks..

3 Answers, 1 is accepted

Sort by
0
Byron
Telerik team
answered on 16 Oct 2012, 10:13 PM
Hello Krishan,

Thank you for your interest in TestStudio.

Although TestStudio is not designed to directly handle writing your output back to an Excel/xml file through generic steps, the functionality can be achieved through a coded step. This example from our online documentation regarding Coded Steps will demonstrate how to Write Into the Data Source.

As far as creating a Test List of Load Tests, this is a current Feature Request  in our Public Issue Tracker and would make its way into a future build pending enough interest from our voting system. Place your vote through this link to the feature request.

Let me know whether you have any followup questions.

All the best,
Byron
the Telerik team
Are you enjoying Test Studio? We’d appreciate your vote in the ATI automation awards.
Vote now
0
Krish
Top achievements
Rank 1
answered on 18 Oct 2012, 05:11 AM
Hi Byron,,

  Query no 01:-Can you explain how to run the stored procedure in stastandalone app..??? basically I need to RUN stored procedure and take data from DB(MS SQL). So please give ur guide lines to run the stored procedure in the automation script..

  Query no 02:- Is it possible to run the stored procedure in the Load testing project..?? basically how to edit the recorded script in the load testing project and execute the stored procedure..??

Thanks..


0
Byron
Telerik team
answered on 22 Oct 2012, 11:29 PM
Hello Krish,

Query no 01:- You can run SQL queries as part of a coded step

Query no 02:- A load test project will run each step in a test project, including coded steps, and capture the traffic this test generates. Then it will reproduce that traffic for each virtual user in the load test. You can data drive the load test to customize the traffic generated based on the contents of a SQL database table. However, there is not currently a feature to execute a coded step for each virtual user.

Greetings,
Byron
the Telerik team
Are you enjoying Test Studio? We’d appreciate your vote in the ATI automation awards.
Vote now
Tags
General Discussions
Asked by
Krish
Top achievements
Rank 1
Answers by
Byron
Telerik team
Krish
Top achievements
Rank 1
Share this question
or