-
Extension Tool SQL Data Capturing into Datasource
Hi All I am fetching the data from DB Sql query using Extension Tool the Data is fetching successfully & showing in Console but the issue is i am not getting how to capture those Data and store in Datasource for future usage , Can someone help me on this.
-
Failed to respond to incoming message using data source row correlation
I have a request i.e. "crn":"234567890123456","amount":"200","settlementDate":"20091224", and a responder using a data source correlation of several response. And the response is to send the responseCode by validating the "amount" [<250] or [>250]. When I send a request via a Parasoft Virtualize .pva file the event…
-
Compare datasource(expected data) with actual data in the database
Hi Parasofters, I have a problem. I am putting data in a database(SQL developer) via a process which loads some XMLs in the database. I have the expected data in a datasource in parasoft soatest. I want to compare the actual data in de database with the expected data in the datasource within parasoft soatest. How can I do…
-
SOATest Writable Datasource : Comparing more than 2 columns from different Writable Datasources
I have 2 XML responses where i need to compare both the responses. Responses will have list of array elements hence i had to extract the elements and saved to the writable data source. Now i have 10 columns for each data source (there are 2 writable DS) . I have written a java script to compare 2 columns one from…
-
Opening a datasource file
Hi there, When I add a datasource as a CVS datasource and open the data file, it by defaults opens in Excel. Is there an IDE setting that I need to update or change in order to get it open in Notepad++ instead of Excel? Thanks
-
Assertion depending on Datasource's value
Hi Team, I have added two value assertion for my test case.But I need to validate those assertion depending in the value present in my DataSource's column. eg : I have a column name SCOPE and has value IN-SCOPE and OUT-SCOPE .So if the value is IN-SCOPE I will have to use a particular assertion and if I have value for…
-
DB Tool - ORA-12519 error
I'm trying to connect to Oracle DB using DB Tool, when I run the test it gives me the below error. Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found 66000 What could be the reason ? I did try with some other connection string for same Oracle DB and it worked fine.…
-
Extract name of the data source with ScriptingContext
Hi, Im using the ScriptingContext in Parasoft SOATEST to build my request. I wanted to know how to extract the datasource **name ** in my script. The datasource type is an Excel file and Im using Java and need the name /path of the datasource. Appreciate the help. Thanks.
-
Data Sources accessible across multiple tsts
Trying to make Data Sources globally accessible across multiple tst files We have scenarios where we need to write output from multiple test cases into a single writable and later share the result across board. In the current framework identified in my project,, we are creating each test as a tst. I am unable to save the…
-
creating excel datasource using Java in Parasoft Maven Jumpstart project
When mapping the datasource path to the setId method in FileLocation class. FileLocation location=new FileLocation(); location.setId("${project_loc:PBAPO}/Sample2.xls"); It throws below error :smile: ErrorResponse [status=404, message=Invalid payload: Specified value '${project_loc:PBAPO}/Sample2.xls' for property…
-
Perform Arithmetic and Logical assertions on two writeables/tables
I have to implement the below scenario: I have to compare the DB values from 2 different tables and perform logical and arithmetic operations on them. Steps implemented: * Create a new test suite * Create a DB tool and query to fetch data (multiple columns) from a table 1. I need to save the run time values. I created a…
-
Store multiple test Result into a same writable.
I would like to use a writable to fetch values from different tests and write into a same writable. Existing writable settings work fine for fetching multiple data from the same test. Expected scenario to replicate : * Create a writeable A at the test suite level * Create a new Test 1 by clicking on Add New – Test . I…
-
Combine the value from two response fields in a third field
Hi, I am writing a SOAP Message Responder. Some of the fields of the response derives its value from a DataSource column while some gets their value from variables populated by an XML Data Bank. Now my question is how do I combine these values to populate another field in the response. For example, I need a field to be the…
-
Compare a set of elements of the JSON response to the standard set of elements
I have a JSON reponse with 152 currency codes fields. I need to compare the whole set of currency codes in the response with the standard set of codes. The issue is the currency codes in the JSON response are dynamic and they do not have a order, if they would have I would have added a string comparison and mapped to my…
-
Retrieval date format
Is there a way to validate the retrieval date format: yyyy-MM-dd'T'HH:mm:ssZ – Ex. 2017-06-26T01:00:
-
Environment aware datasources
Hello, I'm working with simple csv or excel file datasources and I want to be able to use different paths (\${environment_name}\source.csv) or settings depending on the environment I'm current using in the project/test, however environment values like ${name} are not being recognized. I do see some remarks on the help…
-
Weird issue with SOATest data source: closing on save
I have a data source tab in the SOATest project. I have 2 lines in it. Now I want to add a new line to the data source. So I open data source edit and add new line. When I click save, it closes the data source tab. and then I cant find it in the test case explorer, I have to restart the SOATest. and still the new data is…
-
Importing Excel files Into a Repository
Parasoft: Importing Excel Files Into a Repository Description: To import data from an Excel Spreadsheet into a data repository, we will need to use the Data Repository Tool. The Data Repository tool specifies what data to import, how to structure it, and what repository data source should include the imported data. The…