Revision control
++ -- Insert benchmark if not exists
++ INSERT INTO benchmarks_qml (benchmark)
++ SELECT DISTINCT s.benchmark
++ FROM staging_qml_results s
++ WHERE NOT EXISTS (
++ SELECT 1 FROM benchmarks_qml b
++ WHERE b.benchmark = s.benchmark
++ );
++
++ -- Insert suite if not exists
++ INSERT INTO suites (suite)
++ SELECT DISTINCT s.suite
++ FROM staging_qml_results s
++ WHERE NOT EXISTS (
++ SELECT 1 FROM suites su
++ WHERE su.suite = s.suite
++ );
++
++ -- Insert results in qmlbench_results
++ INSERT INTO qmlbench_results (
++ run_on,
++ benchmark_qml_id,
++ suite_id,
++ run_details_qml_id,
++ mean,
++ cov,
++ std_dev,
++ iterations
++ )
++ SELECT
++ NOW() as run_on,
++ b.benchmark_qml_id,
++ su.suite_id,
++ s.run_details_qml_id,
++ s.mean,
++ s.cov,
++ s.std_dev,
++ s.iterations
++ FROM staging_qml_results s
++ JOIN benchmarks_qml b ON b.benchmark = s.benchmark
++ JOIN suites su ON su.suite = s.suite