[JIRA] [database] (JENKINS-20580) Add a "Execute Database Query" test results source

[o.v.nenas...@gmail.com (JIRA)]

Oleg Nenashev commented on JENKINS-20580 Add a "Execute Database Query" test results source use of package versions and their download via wget NoSQL databases would be a good feature, but AFAIK there are no generalized adapters in Jenkins plugins. On the other hand, SQL-databases can be integrated via “Database plugin”, which hardly depends on native java.sql.* and javax.sql.* libraries. I propose to add support of SQL databases only. Many No-SQL DBs have SQL wrappers (e.g. MySQL Cluster or Mongo), so it will be possible to integrate them. My vision of the implementation: xUnit data source options: Database configuration (provided by Database plugin) SQL query The query should support variables substitution generic stuff like patterns Data formats: A simple plain format is preferable xUnit test structure and statistics can be recalculated inside plugin Column names may be hardcoded, because a user can assign them in SQL request It would be great to have a global storage of requests (version X) Response columns: TEST_PATH - “package name + testName” path with dot delimiters TIMESTAMP - A start time of the test HOSTNAME – A test executor TIME – duration of the test Test-case stuff: IS_SKIPPED ERROR_TYPE ERROR_MESSAGE FAILURE_TYPE FAILURE_MESSAGE SYSTEM_OUT SYSTEM_ERR It is possible to re-construct an almost-complete JUnit 4 report from such query, so it may be a convenient approach with relatively low efforts.

This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators. For more information on JIRA, see: http://www.atlassian.com/software/jira

--
You received this message because you are subscribed to the Google Groups "Jenkins Issues" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jenkinsci-issues+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.