Which custom groovy code written in upload programatically summary report to MySQL data base in jmeter

user_18230340 0
Viewed 25

I want the results to be uploaded after the test, how to configure summary report listener in csv file, after the test completion upload MySQL db, what custom code is used uploading programmatically

jmeter groovy mysql
1 Answers

  1. When you run JMeter in command-line non-GUI mode like

    jmeter -n -t testplan.jmx -l result.jtl

    you're getting .jtl results file

  2. In order to get the "Summary Report" from the .jtl results file you can use JMeter Plugin Command Line Tool like:

    JMeterPluginsCMD.bat --generate-csv summary.csv --input-jtl result.jtl --plugin-type SynthesisReport

  3. At this stage it will be more convenient to use MySQL LOAD DATA statement like it's described in Import CSV File Into MySQL Table

If you still want to use Groovy - take a look at Creating/Inserting data chapter of Working with a relational database page of Groovy documentation

user_28977480
Related