Ubuntu CI Engine

Merge lp:~nuclearbob/uci-engine/removed-bootspeed-zeroes into lp:~canonical-ci-engineering/uci-engine/nfss

removed-bootspeed-zeroes
Merge into nfss

Proposed by Max Brustkern on 2014-06-26

Status:	Rejected
Rejected by:	Andy Doan on 2014-07-02
Proposed branch:	lp:~nuclearbob/uci-engine/removed-bootspeed-zeroes
Merge into:	lp:~canonical-ci-engineering/uci-engine/nfss
Diff against target:	1052 lines (+0/-282) 1 file modified nf-data-collector/db_patches/002-bootspeed_data.sql (+0/-282)
To merge this branch:	bzr merge lp:~nuclearbob/uci-engine/removed-bootspeed-zeroes
Related bugs:	Link a bug report

Reviewer	Review Type	Date Requested	Status
Andy Doan (community)		2014-06-26	Disapprove on 2014-07-02
Review via email: mp+224720@code.launchpad.net

Commit message

Remove the zeroes in the bootspeed data.

Description of the change

This branch removes the zeroes in the bootspeed data.

Revision history for this message

Andy Doan (doanac) wrote on 2014-07-02:

i think this was merged already.

review: Disapprove

Unmerged revisions

613. By Max Brustkern on 2014-06-26: Removed 0-value bootspeed data
612. By Thomi Richards on 2014-06-26: Merge new UI code.
611. By Thomi Richards on 2014-06-26: Merged database migration code into core app.
610. By Thomi Richards on 2014-06-26: Creating keys now generates the insertion script, and the test POST action inserts data into the databse.
609. By Thomi Richards on 2014-06-26: Merge latest UI code.
608. By Thomi Richards on 2014-06-26: Don't do IO on every request.
607. By Thomi Richards on 2014-06-26: Merged upstream.
606. By Thomi Richards on 2014-06-26: Support pagination in test data query. Optimise database for querying test name columns.
605. By Thomi Richards on 2014-06-25: Only return 30 days of data from the last data point by default. Add range hints to the rest API to support pagination.
604. By Thomi Richards on 2014-06-25: Fix issue where database connections were not being closed correctly.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk

Subscribers

People subscribed via source and target branches

to all changes:

Canonical CI Engineering

Max Brustkern

1	=== modified file 'nf-data-collector/db_patches/002-bootspeed_data.sql'
2	--- nf-data-collector/db_patches/002-bootspeed_data.sql 2014-06-25 15:40:23 +0000
3	+++ nf-data-collector/db_patches/002-bootspeed_data.sql 2014-06-26 20:33:46 +0000
4	@@ -17220,163 +17220,89 @@
5	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2013-11-08 15:18:10.160778-05', '{"machine_name": "acer-veriton-02", "kernel": 2.92, "xorg": 2.02, "kernel_init": 1.463992, "image_md5": "9d6b611d25ab393d9ad693827b670575", "image_release": "trusty", "plumbing": 17.74, "image_arch": "i386", "desktop": 16.92, "machine_mac": "d0:27:88:9b:82:b9", "boot": 39.6, "image_variant": "desktop", "image_build_number": "20131108", "ran_at": "2013-11-08 15:18:10.160778-05"}', (SELECT id FROM test WHERE name='acer-veriton-02_i386'));
6	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2013-11-08 15:32:48.402631-05', '{"machine_name": "acer-veriton-02", "kernel": 3, "xorg": 2.46, "kernel_init": 1.46077, "image_md5": "9d6b611d25ab393d9ad693827b670575", "image_release": "trusty", "plumbing": 17.82, "image_arch": "i386", "desktop": 16.23, "machine_mac": "d0:27:88:9b:82:b9", "boot": 39.51, "image_variant": "desktop", "image_build_number": "20131108", "ran_at": "2013-11-08 15:32:48.402631-05"}', (SELECT id FROM test WHERE name='acer-veriton-02_i386'));
7	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2013-11-08 15:28:00.438452-05', '{"machine_name": "acer-veriton-02", "kernel": 3.06, "xorg": 2.12, "kernel_init": 1.463954, "image_md5": "9d6b611d25ab393d9ad693827b670575", "image_release": "trusty", "plumbing": 17.82, "image_arch": "i386", "desktop": 16.93, "machine_mac": "d0:27:88:9b:82:b9", "boot": 39.93, "image_variant": "desktop", "image_build_number": "20131108", "ran_at": "2013-11-08 15:28:00.438452-05"}', (SELECT id FROM test WHERE name='acer-veriton-02_i386'));
8	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:34:34.966949-05', '{"machine_name": "acer-veriton-01", "kernel": 2.82, "xorg": 8.08, "kernel_init": 1.321992, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.03, "image_arch": "amd64", "desktop": -35.93, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:34:34.966949-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
9	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:46:20.540472-05', '{"machine_name": "acer-veriton-01", "kernel": 2.74, "xorg": 8.06, "kernel_init": 1.318328, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 26.45, "image_arch": "amd64", "desktop": 37.28, "machine_mac": "d0:27:88:9b:83:06", "boot": 74.53, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:46:20.540472-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
10	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:40:38.744872-05', '{"machine_name": "acer-veriton-01", "kernel": 2.89, "xorg": 7.91, "kernel_init": 1.322142, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.63, "image_arch": "amd64", "desktop": 39.02, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.45, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:40:38.744872-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
11	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:57:53.491787-05', '{"machine_name": "acer-veriton-01", "kernel": 2.81, "xorg": 6.82, "kernel_init": 1.322009, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 26.26, "image_arch": "amd64", "desktop": 40.09, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.98, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:57:53.491787-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
12	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:52:00.949686-05', '{"machine_name": "acer-veriton-01", "kernel": 2.88, "xorg": 7.21, "kernel_init": 1.32178, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.01, "image_arch": "amd64", "desktop": 37.71, "machine_mac": "d0:27:88:9b:83:06", "boot": 72.81, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:52:00.949686-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
13	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 12:09:31.943491-05', '{"machine_name": "acer-veriton-01", "kernel": 2.79, "xorg": 6.4, "kernel_init": 1.321124, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 26.83, "image_arch": "amd64", "desktop": 38.61, "machine_mac": "d0:27:88:9b:83:06", "boot": 74.63, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 12:09:31.943491-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
14	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 12:03:44.134774-05', '{"machine_name": "acer-veriton-01", "kernel": 2.79, "xorg": 6.78, "kernel_init": 1.323045, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 27.28, "image_arch": "amd64", "desktop": 38.92, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.77, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 12:03:44.134774-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
15	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 10:36:14.475102-05', '{"machine_name": "acer-veriton-01", "kernel": 2.77, "xorg": 11.82, "kernel_init": 1.325357, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.1, "image_arch": "amd64", "desktop": -38.69, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 10:36:14.475102-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
16	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 10:42:01.673581-05', '{"machine_name": "acer-veriton-01", "kernel": 2.79, "xorg": 6.97, "kernel_init": 1.323477, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 26.29, "image_arch": "amd64", "desktop": 38.55, "machine_mac": "d0:27:88:9b:83:06", "boot": 74.6, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 10:42:01.673581-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
17	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 10:59:29.196568-05', '{"machine_name": "acer-veriton-01", "kernel": 2.75, "xorg": 7.66, "kernel_init": 1.317065, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 27.66, "image_arch": "amd64", "desktop": 37.18, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.25, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 10:59:29.196568-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
18	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 10:53:42.42103-05', '{"machine_name": "acer-veriton-01", "kernel": 2.87, "xorg": 7.39, "kernel_init": 1.316381, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.77, "image_arch": "amd64", "desktop": -36.03, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 10:53:42.42103-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
19	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:11:02.465047-05', '{"machine_name": "acer-veriton-01", "kernel": 2.75, "xorg": 7.36, "kernel_init": 1.319084, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.36, "image_arch": "amd64", "desktop": 37.35, "machine_mac": "d0:27:88:9b:83:06", "boot": 72.82, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:11:02.465047-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
20	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:05:21.285203-05', '{"machine_name": "acer-veriton-01", "kernel": 2.74, "xorg": 7.83, "kernel_init": 1.32038, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 27.41, "image_arch": "amd64", "desktop": 37.69, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.67, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:05:21.285203-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
21	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-11 11:16:48.38449-05', '{"machine_name": "acer-veriton-01", "kernel": 2.77, "xorg": 6.85, "kernel_init": 1.313145, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.95, "image_arch": "amd64", "desktop": 36.86, "machine_mac": "d0:27:88:9b:83:06", "boot": 72.43, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-11 11:16:48.38449-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
22	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 13:32:01.320973-05', '{"machine_name": "acer-veriton-01", "kernel": 2.77, "xorg": 7.7, "kernel_init": 1.319991, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 23.84, "image_arch": "amd64", "desktop": -34.31, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 13:32:01.320973-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
23	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 13:43:35.474755-05', '{"machine_name": "acer-veriton-01", "kernel": 2.82, "xorg": 7.55, "kernel_init": 1.323989, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.05, "image_arch": "amd64", "desktop": -35.42, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 13:43:35.474755-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
24	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 13:49:13.078596-05', '{"machine_name": "acer-veriton-01", "kernel": 2.79, "xorg": 6.83, "kernel_init": 1.312429, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.46, "image_arch": "amd64", "desktop": 37.89, "machine_mac": "d0:27:88:9b:83:06", "boot": 71.97, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 13:49:13.078596-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
25	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 12:33:27.341627-05', '{"machine_name": "acer-veriton-01", "kernel": 2.83, "xorg": 10.14, "kernel_init": 1.316342, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 21.45, "image_arch": "amd64", "desktop": 58.65, "machine_mac": "d0:27:88:9b:83:06", "boot": 93.07, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 12:33:27.341627-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
26	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 12:44:50.053939-05', '{"machine_name": "acer-veriton-01", "kernel": 2.84, "xorg": 6.93, "kernel_init": 1.314429, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 23.85, "image_arch": "amd64", "desktop": 39.04, "machine_mac": "d0:27:88:9b:83:06", "boot": 72.66, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 12:44:50.053939-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
27	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 12:39:06.441145-05', '{"machine_name": "acer-veriton-01", "kernel": 2.84, "xorg": 6.71, "kernel_init": 1.324294, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.73, "image_arch": "amd64", "desktop": 38.15, "machine_mac": "d0:27:88:9b:83:06", "boot": 72.43, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 12:39:06.441145-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
28	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 13:02:15.687475-05', '{"machine_name": "acer-veriton-01", "kernel": 2.74, "xorg": 6.74, "kernel_init": 1.315958, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 23.99, "image_arch": "amd64", "desktop": 38.81, "machine_mac": "d0:27:88:9b:83:06", "boot": 72.28, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 13:02:15.687475-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
29	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 12:56:33.843728-05', '{"machine_name": "acer-veriton-01", "kernel": 2.76, "xorg": 6.84, "kernel_init": 1.313612, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.11, "image_arch": "amd64", "desktop": -33.71, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 12:56:33.843728-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
30	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-12 13:08:01.379221-05', '{"machine_name": "acer-veriton-01", "kernel": 2.83, "xorg": 6.73, "kernel_init": 1.311841, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 23.63, "image_arch": "amd64", "desktop": 36.63, "machine_mac": "d0:27:88:9b:83:06", "boot": 69.82, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-12 13:08:01.379221-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
31	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 10:59:31.827888-05', '{"machine_name": "acer-veriton-01", "kernel": 3.04, "xorg": 8.17, "kernel_init": 1.314161, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.73, "image_arch": "amd64", "desktop": -36.94, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 10:59:31.827888-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
32	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 11:41:01.527701-05', '{"machine_name": "acer-veriton-01", "kernel": 2.95, "xorg": 8.85, "kernel_init": 1.317724, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.68, "image_arch": "amd64", "desktop": 38.65, "machine_mac": "d0:27:88:9b:83:06", "boot": 76.13, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 11:41:01.527701-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
33	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 11:11:22.302242-05', '{"machine_name": "acer-veriton-01", "kernel": 2.93, "xorg": 8.1, "kernel_init": 1.329241, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.32, "image_arch": "amd64", "desktop": -36.35, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 11:11:22.302242-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
34	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 11:35:09.622193-05', '{"machine_name": "acer-veriton-01", "kernel": 2.95, "xorg": 9.63, "kernel_init": 1.315266, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.9, "image_arch": "amd64", "desktop": 38.21, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.69, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 11:35:09.622193-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
35	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 11:29:15.476973-05', '{"machine_name": "acer-veriton-01", "kernel": 2.95, "xorg": 8.74, "kernel_init": 1.326773, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.6, "image_arch": "amd64", "desktop": -36.29, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 11:29:15.476973-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
36	-INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 10:29:48.67501-05', '{"machine_name": "acer-veriton-01", "kernel": 3.01, "xorg": 8.78, "kernel_init": 1.327309, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.82, "image_arch": "amd64", "desktop": -37.61, "machine_mac": "d0:27:88:9b:83:06", "boot": 0, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 10:29:48.67501-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
37	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 10:47:29.287373-05', '{"machine_name": "acer-veriton-01", "kernel": 2.9, "xorg": 8.92, "kernel_init": 1.315395, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 25.09, "image_arch": "amd64", "desktop": 39.11, "machine_mac": "d0:27:88:9b:83:06", "boot": 76.02, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 10:47:29.287373-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
38	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 10:41:36.841941-05', '{"machine_name": "acer-veriton-01", "kernel": 3, "xorg": 8.56, "kernel_init": 1.329591, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 26.27, "image_arch": "amd64", "desktop": 37.76, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.59, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 10:41:36.841941-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
39	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 10:35:41.039895-05', '{"machine_name": "acer-veriton-01", "kernel": 2.97, "xorg": 8.12, "kernel_init": 1.315137, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 27.21, "image_arch": "amd64", "desktop": 37.79, "machine_mac": "d0:27:88:9b:83:06", "boot": 76.09, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 10:35:41.039895-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));
40	INSERT INTO data (date_entered, data, test_id) VALUES (TIMESTAMP WITH TIME ZONE '2014-01-13 11:17:15.016269-05', '{"machine_name": "acer-veriton-01", "kernel": 2.91, "xorg": 9.96, "kernel_init": 1.320906, "image_md5": "{md5}", "image_release": "trusty", "plumbing": 24.09, "image_arch": "amd64", "desktop": 38.6, "machine_mac": "d0:27:88:9b:83:06", "boot": 75.56, "image_variant": "desktop", "image_build_number": "UNKNOWN", "ran_at": "2014-01-13 11:17:15.016269-05"}', (SELECT id FROM test WHERE name='acer-veriton-01_amd64'));