ricardo_moura
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
execute oracle script from JDBC teststep
hello, i have below script to execute on oracle database: DECLARE v_sender NUMBER (20,0):= 10000000000001; BEGIN DELETE FROM table_A where key_field between 10000000000001 and 10000000000050; FOR x IN 1..50 LOOP insert into table_A (key_field, field1, field2) VALUES (v_sender, 1234, 1234); v_sender := v_sender + 1; END LOOP; END; if i execute on sql developer client, works fine, but via JDBC teststep on soapUI, does not work, soapui just stay executing, executing and executing for ever my conection with DB its OK, i can execute simple selects, updates and deletes without any problems thanks in advanceRe: Does Soap ui supports swagger 3.0 or open api 3.0 importing api spec (json) file
when i use "import swagger" function, the soapui shows me follow message: "groovy.json.JsonException: Unable to determine the current character, it is not a string, number, array, or object The current character read is 'o' with an int value of 111 Unable to determine the current character, it is not a string, number, array, or object line number 1 index number 0 openapi: 3.0.0 ^" i was able to import after edit yaml/json spec: change (openapi: 3.0.0) to (swagger: "2.0") on first line of archiveRe: how to transfer result of groovy script
you can use following lines in your groovy script step: def profiel = UUID.randomUUID() testRunner.testCase.setPropertyValue("TestCasePropertyName", profiel.toString()) and on next request step, put "${#TestCase#TestCasePropertyName}" where you want the UUID value. regardshow to include response fields in contract coverage test?
hello my friends i received a .json swagger definition of resources and fields of each one like below: "FieldA": { "type": "object", "description": "is required", "properties": { "fieldA1": { "type": "string" }, "fieldA2": { "type": "string" }, "fieldA3": { "type": "string" }, "fieldA4": { "type": "string" }, "fieldA5": { "type": "string" } } } and i need to do contract coverage test, but when i run it, i get only status of messages coverage results, i can include all fields of my .json definition on coverage test? i want show for team how much of definitions my tests cover thanks for allRe: how to get MockResponse "Name" property value?
thanks for fast reply Anastasia in both scripts, the aplication only can get MockService properties value, i need obtain mockResponse's name, 2 levels below on the project tree: I created in the MockService a custom property called "resultName" for the following script, insert an "hard coded" value and, with your second script, to get the property value and log it. def resultName = context.mockService.setPropertyValue("resultName","Response1") It works fine, but I have many mock responses and does this for each is unviable. thanks again
