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

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

mysqlgroovyjmeter


Solution 1:[1]

  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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Dmitri T

Related Questions