[LNT] Make it possible to run unit tests against a Postgress database instead of a sqlite database.

[kristof.beyls]

Summary

This patch adapts the create_temp_instance script so that it can also create and populate postgres databases instead of just sqlite databases.
This in turn allows to run all the regression tests using a postgres database rather than a sqlite database, making is far easier to test LNT against a postgres database.
Documentation on how to use this has been added to the developer guide as part of this patch.

[cmatthews]

Looks good!

docs/developer_guide.rst

you can run the tests in a different directory too::
 
      mkdir ../run_lnt_tests
      cd ../run_lnt_tests
      PATH=$LLVMBUILD/bin:$PATH llvm-lit -sv ../lnt/tests
 
 For simple changes, adding a regression test and making sure all regression
 tests pass, is often a good enough testing approach. For some changes, the
 existing regression tests aren't good enough at the moment, and manual testing
-will be needed. For any changes that touch on the LNT database design, you'll
-need to run tests on at least sqlite and postgress database engines.  By
-default, LNT uses sqlite, and most of the regression tests still use a
-temporary sqlite database to run tests against. Therefore, at the moment,
-you'll probably need to do some manual testing on a setup with a postgress
-database if you touch database functionality.
+will be needed.
+
+For any changes that touch on the LNT database design, you'll need to run tests
+on at least sqlite and postgres database engines.  By default the regression
+tests uses sqlite. To run the regression tests against a postgress database,
+use a command like the following::
+
+     PATH=$LLVMBUILD/bin:$PATH llvm-lit -sv -Dpostgres='postgresql://lnt:lnt@127.0.0.1' ../lnt/tests
+
+The argument to -Dpostgres needs to be a postgres URI for a postgres role
+that is allowed to create databases. One example to set up such a user is::
+
+     sudo -u postgres psql
+     CREATE USER lnt_test PASSWORD 'lnt_test';
+     CREATE DATABASE lnt_test OWNER = lnt_test;
+     ALTER USER lnt_test CREATEDB;
+
+You'll need to use at least postgres version 9.2 to run the regression tests.

tests/SharedInputs/SmallInstance/data/lnt_db_create.sql

-PRAGMA foreign_keys=OFF;
 BEGIN TRANSACTION;
 CREATE TABLE "SchemaVersion" (
   "Name" VARCHAR(256) NOT NULL, 
   "Version" INTEGER, 
   PRIMARY KEY ("Name"), 
   UNIQUE ("Name")
 );
 INSERT INTO "SchemaVersion" VALUES('__core__',5);
CREATE TABLE "NT_Order" (
   "ID" INTEGER NOT NULL, 
   "NextOrder" INTEGER, 
   "PreviousOrder" INTEGER, 
   llvm_project_revision VARCHAR(256), 
   PRIMARY KEY ("ID"), 
   FOREIGN KEY("NextOrder") REFERENCES "NT_Order" ("ID"), 
   FOREIGN KEY("PreviousOrder") REFERENCES "NT_Order" ("ID")
 );
-INSERT INTO "NT_Order" VALUES(3,NULL,4,'154331');
+INSERT INTO "NT_Order" VALUES(3,NULL,NULL,'154331');
 INSERT INTO "NT_Order" VALUES(4,3,NULL,'152289');
+UPDATE "NT_Order" SET "PreviousOrder"=4 WHERE "ID"=3; --INTO "NT_Order" VALUES(3,NULL,4,'154331');
 CREATE TABLE "NT_Machine" (
   "ID" INTEGER NOT NULL, 
   "Name" VARCHAR(256), 
   "Parameters" BLOB, 
   hardware VARCHAR(256), 
   os VARCHAR(256), 
   PRIMARY KEY ("ID")
 );
 INSERT INTO "NT_Machine" VALUES(1,'localhost__clang_DEV__x86_64','[["name", "localhost"], ["uname", "Darwin localhost 11.3.0 Darwin Kernel Version 11.3.0: Thu Jan 12 18:47:41 PST 2012; root:xnu-1699.24.23~1/RELEASE_X86_64 x86_64"]]','x86_64','Darwin 11.3.0');
 CREATE TABLE "NT_Test" (
   "ID" INTEGER NOT NULL, 
   "Name" VARCHAR(256), 
   PRIMARY KEY ("ID")
 );
 INSERT INTO "NT_Test" VALUES(1,'SingleSource/UnitTests/2006-12-01-float_varg');
+INSERT INTO "NT_Test" VALUES(2,'SingleSource/UnitTests/2006-12-04-DynAllocAndRestore');
 CREATE TABLE "NT_Run" (
   "ID" INTEGER NOT NULL, 
   "MachineID" INTEGER, 
   "OrderID" INTEGER, 
   "ImportedFrom" VARCHAR(512), 
   "StartTime" DATETIME, 
   "EndTime" DATETIME, 
   "SimpleRunID" INTEGER, 
   "Parameters" BLOB, 
   PRIMARY KEY ("ID"), 
   FOREIGN KEY("MachineID") REFERENCES "NT_Machine" ("ID"), 
   FOREIGN KEY("OrderID") REFERENCES "NT_Order" ("ID")
 );
-INSERT INTO "NT_Run" VALUES(1,1,3,'server/db/Inputs/lnt_v0.4.0_filled_instance/lnt_tmp/default/2012-04/data-2012-04-11_16-47-40bEjSGd.plist','2012-04-11 16:28:23.000000','2012-04-11 16:28:58.000000',NULL,'[["ARCH", "x86_64"], ["CC_UNDER_TEST_IS_CLANG", "1"], ["CC_UNDER_TEST_TARGET_IS_X86_64", "1"], ["DISABLE_CBE", "1"], ["DISABLE_JIT", "1"], ["ENABLE_HASHED_PROGRAM_OUTPUT", "1"], ["ENABLE_OPTIMIZED", "1"], ["LLC_OPTFLAGS", "-O3"], ["LLI_OPTFLAGS", "-O3"], ["OPTFLAGS", "-O3"], ["TARGET_CC", "None"], ["TARGET_CXX", "None"], ["TARGET_FLAGS", ""], ["TARGET_LLVMGCC", "/tmp/bin/clang"], ["TARGET_LLVMGXX", "/tmp/bin/clang++"], ["TEST", "simple"], ["USE_REFERENCE_OUTPUT", "1"], ["__report_version__", "1"], ["cc1_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_alt_src_branch", "trunk"], ["cc_alt_src_revision", "154329"], ["cc_as_version", "LLVM (http://llvm.org/):\n  LLVM version 3.1svn\n  Optimized build.\n  Built Apr  9 2012 (11:55:07).\n  Default target: x86_64-apple-darwin11.3.0\n  Host CPU: corei7-avx"], ["cc_build", "DEV"], ["cc_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "clang"], ["cc_src_branch", "trunk"], ["cc_src_revision", "154331"], ["cc_target", "x86_64-apple-macosx10.7.0"], ["cc_version", "clang version 3.1 (trunk 154331) (llvm/trunk 154329)\nTarget: x86_64-apple-darwin11.3.0\nThread model: posix\n \"/tmp/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.7.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-v\" \"-resource-dir\" \"/tmp/bin/../lib/clang/3.1\" \"-fmodule-cache-path\" \"/var/folders/32/jb9nf1gs6hx12s0brx1xdy8w0000gn/T/clang-module-cache\" \"-fdebug-compilation-dir\" \"/tmp/SANDBOX\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime-has-arc\" \"-fobjc-runtime-has-weak\" \"-fobjc-dispatch-method=mixed\" \"-fobjc-default-synthesize-properties\" \"-fdiagnostics-show-option\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "3.1"], ["inferred_run_order", "154331"], ["sw_vers", "ProductName:\tMac OS X\nProductVersion:\t10.7.3\nBuildVersion:\t11D50b"], ["test_suite_revision", "154271"]]');
-INSERT INTO "NT_Run" VALUES(2,1,4,'report.json','2012-04-11 21:13:53.000000','2012-04-11 21:14:49.000000',NULL,'[["ARCH", "x86_64"], ["CC_UNDER_TEST_IS_CLANG", "1"], ["CC_UNDER_TEST_TARGET_IS_X86_64", "1"], ["DISABLE_CBE", "1"], ["DISABLE_JIT", "1"], ["ENABLE_HASHED_PROGRAM_OUTPUT", "1"], ["ENABLE_OPTIMIZED", "1"], ["LLC_OPTFLAGS", "-O3"], ["LLI_OPTFLAGS", "-O3"], ["OPTFLAGS", "-O3"], ["TARGET_CC", "None"], ["TARGET_CXX", "None"], ["TARGET_FLAGS", ""], ["TARGET_LLVMGCC", "/tmp/bin/clang"], ["TARGET_LLVMGXX", "/tmp/bin/clang++"], ["TEST", "simple"], ["USE_REFERENCE_OUTPUT", "1"], ["__report_version__", "1"], ["cc1_exec_hash", "984ed8386e2acc8aef74ac3e59ef5e18b7406257"], ["cc_alt_src_branch", "trunk"], ["cc_alt_src_revision", "152288"], ["cc_as_version", "LLVM (http://llvm.org/):\n  LLVM version 3.1svn\n  Optimized build.\n  Built Mar  7 2012 (15:19:54).\n  Default target: x86_64-apple-darwin11.3.0\n  Host CPU: corei7-avx"], ["cc_build", "DEV"], ["cc_exec_hash", "984ed8386e2acc8aef74ac3e59ef5e18b7406257"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "clang"], ["cc_src_branch", "trunk"], ["cc_src_revision", "152289"], ["cc_target", "x86_64-apple-macosx10.7.0"], ["cc_version", "clang version 3.1 (trunk 152289) (llvm/trunk 152288)\nTarget: x86_64-apple-darwin11.3.0\nThread model: posix\n \"/tmp/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.7.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-pic-level\" \"1\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-v\" \"-resource-dir\" \"/tmp/bin/../lib/clang/3.1\" \"-fmodule-cache-path\" \"/var/folders/32/jb9nf1gs6hx12s0brx1xdy8w0000gn/T/clang-module-cache\" \"-fdebug-compilation-dir\" \"/tmp/SANDBOX\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime-has-arc\" \"-fobjc-runtime-has-weak\" \"-fobjc-dispatch-method=mixed\" \"-fobjc-default-synthesize-properties\" \"-fdiagnostics-show-option\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "3.1"], ["inferred_run_order", "152289"], ["sw_vers", "ProductName:\tMac OS X\nProductVersion:\t10.7.3\nBuildVersion:\t11D50b"], ["test_suite_revision", "154271"]]');
+INSERT INTO "NT_Run" VALUES(1,1,3,'server/db/Inputs/lnt_v0.4.0_filled_instance/lnt_tmp/default/2012-04/data-2012-04-11_16-47-40bEjSGd.plist','2012-04-11 16:28:23.000000','2012-04-11 16:28:58.000000',NULL, CAST('[["ARCH", "x86_64"], ["CC_UNDER_TEST_IS_CLANG", "1"], ["CC_UNDER_TEST_TARGET_IS_X86_64", "1"], ["DISABLE_CBE", "1"], ["DISABLE_JIT", "1"], ["ENABLE_HASHED_PROGRAM_OUTPUT", "1"], ["ENABLE_OPTIMIZED", "1"], ["LLC_OPTFLAGS", "-O3"], ["LLI_OPTFLAGS", "-O3"], ["OPTFLAGS", "-O3"], ["TARGET_CC", "None"], ["TARGET_CXX", "None"], ["TARGET_FLAGS", ""], ["TARGET_LLVMGCC", "/tmp/bin/clang"], ["TARGET_LLVMGXX", "/tmp/bin/clang++"], ["TEST", "simple"], ["USE_REFERENCE_OUTPUT", "1"], ["__report_version__", "1"], ["cc1_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_alt_src_branch", "trunk"], ["cc_alt_src_revision", "154329"], ["cc_as_version", "LLVM (http://llvm.org/):\n  LLVM version 3.1svn\n  Optimized build.\n  Built Apr  9 2012 (11:55:07).\n  Default target: x86_64-apple-darwin11.3.0\n  Host CPU: corei7-avx"], ["cc_build", "DEV"], ["cc_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "clang"], ["cc_src_branch", "trunk"], ["cc_src_revision", "154331"], ["cc_target", "x86_64-apple-macosx10.7.0"], ["cc_version", "clang version 3.1 (trunk 154331) (llvm/trunk 154329)\nTarget: x86_64-apple-darwin11.3.0\nThread model: posix\n \"/tmp/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.7.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-v\" \"-resource-dir\" \"/tmp/bin/../lib/clang/3.1\" \"-fmodule-cache-path\" \"/var/folders/32/jb9nf1gs6hx12s0brx1xdy8w0000gn/T/clang-module-cache\" \"-fdebug-compilation-dir\" \"/tmp/SANDBOX\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime-has-arc\" \"-fobjc-runtime-has-weak\" \"-fobjc-dispatch-method=mixed\" \"-fobjc-default-synthesize-properties\" \"-fdiagnostics-show-option\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "3.1"], ["inferred_run_order", "154331"], ["sw_vers", "ProductName:\tMac OS X\nProductVersion:\t10.7.3\nBuildVersion:\t11D50b"], ["test_suite_revision", "154271"]]' AS BLOB));
+INSERT INTO "NT_Run" VALUES(2,1,4,'report.json','2012-04-11 21:13:53.000000','2012-04-11 21:14:49.000000',NULL, CAST('[["ARCH", "x86_64"], ["CC_UNDER_TEST_IS_CLANG", "1"], ["CC_UNDER_TEST_TARGET_IS_X86_64", "1"], ["DISABLE_CBE", "1"], ["DISABLE_JIT", "1"], ["ENABLE_HASHED_PROGRAM_OUTPUT", "1"], ["ENABLE_OPTIMIZED", "1"], ["LLC_OPTFLAGS", "-O3"], ["LLI_OPTFLAGS", "-O3"], ["OPTFLAGS", "-O3"], ["TARGET_CC", "None"], ["TARGET_CXX", "None"], ["TARGET_FLAGS", ""], ["TARGET_LLVMGCC", "/tmp/bin/clang"], ["TARGET_LLVMGXX", "/tmp/bin/clang++"], ["TEST", "simple"], ["USE_REFERENCE_OUTPUT", "1"], ["__report_version__", "1"], ["cc1_exec_hash", "984ed8386e2acc8aef74ac3e59ef5e18b7406257"], ["cc_alt_src_branch", "trunk"], ["cc_alt_src_revision", "152288"], ["cc_as_version", "LLVM (http://llvm.org/):\n  LLVM version 3.1svn\n  Optimized build.\n  Built Mar  7 2012 (15:19:54).\n  Default target: x86_64-apple-darwin11.3.0\n  Host CPU: corei7-avx"], ["cc_build", "DEV"], ["cc_exec_hash", "984ed8386e2acc8aef74ac3e59ef5e18b7406257"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "clang"], ["cc_src_branch", "trunk"], ["cc_src_revision", "152289"], ["cc_target", "x86_64-apple-macosx10.7.0"], ["cc_version", "clang version 3.1 (trunk 152289) (llvm/trunk 152288)\nTarget: x86_64-apple-darwin11.3.0\nThread model: posix\n \"/tmp/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.7.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-pic-level\" \"1\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-v\" \"-resource-dir\" \"/tmp/bin/../lib/clang/3.1\" \"-fmodule-cache-path\" \"/var/folders/32/jb9nf1gs6hx12s0brx1xdy8w0000gn/T/clang-module-cache\" \"-fdebug-compilation-dir\" \"/tmp/SANDBOX\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime-has-arc\" \"-fobjc-runtime-has-weak\" \"-fobjc-dispatch-method=mixed\" \"-fobjc-default-synthesize-properties\" \"-fdiagnostics-show-option\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "3.1"], ["inferred_run_order", "152289"], ["sw_vers", "ProductName:\tMac OS X\nProductVersion:\t10.7.3\nBuildVersion:\t11D50b"], ["test_suite_revision", "154271"]]' AS BLOB));
 CREATE TABLE "NT_Sample" (
   "ID" INTEGER NOT NULL, 
   "RunID" INTEGER, 
   "TestID" INTEGER, 
   compile_status INTEGER, 
   execution_status INTEGER, 
   compile_time FLOAT, 
   execution_time FLOAT, score FLOAT, 
   PRIMARY KEY ("ID"), 
   FOREIGN KEY("RunID") REFERENCES "NT_Run" ("ID"), 
   FOREIGN KEY("TestID") REFERENCES "NT_Test" ("ID"), 
   FOREIGN KEY(compile_status) REFERENCES "StatusKind" ("ID"), 
   FOREIGN KEY(execution_status) REFERENCES "StatusKind" ("ID")
 );
 INSERT INTO "NT_Sample" VALUES(1,1,1,NULL,NULL,0.007,0.0003,NULL);
 INSERT INTO "NT_Sample" VALUES(2,1,2,NULL,NULL,0.0072,0.0003,NULL);
 CREATE TABLE "compile_Machine" (
   "ID" INTEGER NOT NULL, 
   "Name" VARCHAR(256), 
   "Parameters" BLOB, 
   hardware VARCHAR(256), 
   os_version VARCHAR(256), 
   PRIMARY KEY ("ID")
 );
-INSERT INTO "compile_Machine" VALUES(1,'localhost','[["hw.activecpu", "8"], ["hw.availcpu", "8"], ["hw.busfrequency", "100000000"], ["hw.busfrequency_max", "100000000"], ["hw.busfrequency_min", "100000000"], ["hw.byteorder", "1234"], ["hw.cacheconfig", "8 2 2 8 0 0 0 0 0 0"], ["hw.cachelinesize", "64"], ["hw.cachesize", "8589934592 32768 262144 6291456 0 0 0 0 0 0"], ["hw.cpu64bit_capable", "1"], ["hw.cpufamily", "1418770316"], ["hw.cpufrequency", "2200000000"], ["hw.cpufrequency_max", "2200000000"], ["hw.cpufrequency_min", "2200000000"], ["hw.cpusubtype", "4"], ["hw.cputype", "7"], ["hw.epoch", "0"], ["hw.l1dcachesize", "32768"], ["hw.l1icachesize", "32768"], ["hw.l2cachesize", "262144"], ["hw.l2settings", "1"], ["hw.logicalcpu", "8"], ["hw.logicalcpu_max", "8"], ["hw.machine", "x86_64"], ["hw.memsize", "8589934592"], ["hw.ncpu", "8"], ["hw.optional.floatingpoint", "1"], ["hw.optional.mmx", "1"], ["hw.optional.sse", "1"], ["hw.optional.sse2", "1"], ["hw.optional.sse3", "1"], ["hw.optional.sse4_1", "1"], ["hw.optional.sse4_2", "1"], ["hw.optional.supplementalsse3", "1"], ["hw.optional.x86_64", "1"], ["hw.packages", "1"], ["hw.pagesize", "4096"], ["hw.physicalcpu", "4"], ["hw.physicalcpu_max", "4"], ["hw.physmem", "2147483648"], ["hw.tbfrequency", "1000000000"], ["hw.vectorunit", "1"], ["kern.aiomax", "90"], ["kern.aioprocmax", "16"], ["kern.aiothreads", "4"], ["kern.argmax", "262144"], ["kern.clockrate: hz", "second level name clockrate: hz in kern.clockrate: hz is invalid"], ["kern.coredump", "1"], ["kern.corefile", "/cores/core.%P"], ["kern.delayterm", "0"], ["kern.hostid", "0"], ["kern.hostname", "localhost"], ["kern.job_control", "1"], ["kern.maxfiles", "12288"], ["kern.maxfilesperproc", "10240"], ["kern.maxproc", "1064"], ["kern.maxprocperuid", "709"], ["kern.maxvnodes", "132096"], ["kern.netboot", "0"], ["kern.ngroups", "16"], ["kern.nisdomainname", ""], ["kern.nx", "1"], ["kern.osrelease", "11.3.0"], ["kern.osrevision", "199506"], ["kern.ostype", "Darwin"], ["kern.osversion", "11D50b"], ["kern.posix1version", "200112"], ["kern.procname", ""], ["kern.rage_vnode", "0"], ["kern.safeboot", "0"], ["kern.saved_ids", "1"], ["kern.securelevel", "0"], ["kern.shreg_private", "0"], ["kern.speculative_reads_disabled", "0"], ["kern.sugid_coredump", "0"], ["kern.thread_name", "kern"], ["machdep.cpu.address_bits.physical", "36"], ["machdep.cpu.address_bits.virtual", "48"], ["machdep.cpu.arch_perf.events", "0"], ["machdep.cpu.arch_perf.events_number", "7"], ["machdep.cpu.arch_perf.fixed_number", "3"], ["machdep.cpu.arch_perf.fixed_width", "48"], ["machdep.cpu.arch_perf.number", "4"], ["machdep.cpu.arch_perf.version", "3"], ["machdep.cpu.arch_perf.width", "48"], ["machdep.cpu.brand", "0"], ["machdep.cpu.brand_string", "Intel(R) Core(TM) i7-2720QM CPU @ 2.20GHz"], ["machdep.cpu.cache.L2_associativity", "8"], ["machdep.cpu.cache.linesize", "64"], ["machdep.cpu.cache.size", "256"], ["machdep.cpu.core_count", "4"], ["machdep.cpu.cores_per_package", "8"], ["machdep.cpu.extfamily", "0"], ["machdep.cpu.extfeature_bits", "672139520 1"], ["machdep.cpu.extfeatures", "SYSCALL XD EM64T LAHF RDTSCP TSCI"], ["machdep.cpu.extmodel", "2"], ["machdep.cpu.family", "6"], ["machdep.cpu.feature_bits", "3219913727 532341759"], ["machdep.cpu.features", "FPU VME DE PSE TSC MSR PAE MCE CX8 APIC SEP MTRR PGE MCA CMOV PAT PSE36 CLFSH DS ACPI MMX FXSR SSE SSE2 SS HTT TM PBE SSE3 PCLMULQDQ DTES64 MON DSCPL VMX SMX EST TM2 SSSE3 CX16 TPR PDCM SSE4.1 SSE4.2 xAPIC POPCNT AES PCID XSAVE OSXSAVE TSCTMR AVX1.0"], ["machdep.cpu.logical_per_package", "16"], ["machdep.cpu.max_basic", "13"], ["machdep.cpu.max_ext", "2147483656"], ["machdep.cpu.microcode_version", "26"], ["machdep.cpu.model", "42"], ["machdep.cpu.mwait.extensions", "3"], ["machdep.cpu.mwait.linesize_max", "64"], ["machdep.cpu.mwait.linesize_min", "64"], ["machdep.cpu.mwait.sub_Cstates", "135456"], ["machdep.cpu.signature", "132775"], ["machdep.cpu.stepping", "7"], ["machdep.cpu.thermal.ACNT_MCNT", "1"], ["machdep.cpu.thermal.dynamic_acceleration", "1"], ["machdep.cpu.thermal.sensor", "1"], ["machdep.cpu.thermal.thresholds", "2"], ["machdep.cpu.thread_count", "8"], ["machdep.cpu.tlb.data.large", "32"], ["machdep.cpu.tlb.data.large_level1", ""], ["machdep.cpu.tlb.data.small", "64"], ["machdep.cpu.tlb.data.small_level1", ""], ["machdep.cpu.tlb.inst.large", ""], ["machdep.cpu.tlb.inst.small", "64"], ["machdep.cpu.vendor", "GenuineIntel"]]','MacBookPro8,2','Darwin Kernel Version 11.3.0: Thu Jan 12 18:47:41 PST 2012; root:xnu-1699.24.23~1/RELEASE_X86_64');
-INSERT INTO "compile_Machine" VALUES(2,'MacBook-Pro.local','[["hw.activecpu", "8"], ["hw.availcpu", "sysctl: unknown oid ''hw.availcpu''"], ["hw.busfrequency", "100000000"], ["hw.busfrequency_max", "100000000"], ["hw.busfrequency_min", "100000000"], ["hw.byteorder", "1234"], ["hw.cacheconfig", "8 2 2 8 0 0 0 0 0 0"], ["hw.cachelinesize", "64"], ["hw.cachesize", "8589934592 32768 262144 6291456 0 0 0 0 0 0"], ["hw.cpu64bit_capable", "1"], ["hw.cpufamily", "526772277"], ["hw.cpufrequency", "2300000000"], ["hw.cpufrequency_max", "2300000000"], ["hw.cpufrequency_min", "2300000000"], ["hw.cpusubtype", "4"], ["hw.cputype", "7"], ["hw.epoch", "0"], ["hw.l1dcachesize", "32768"], ["hw.l1icachesize", "32768"], ["hw.l2cachesize", "262144"], ["hw.l2settings", "1"], ["hw.logicalcpu", "8"], ["hw.logicalcpu_max", "8"], ["hw.machine", "x86_64"], ["hw.memsize", "8589934592"], ["hw.ncpu", "8"], ["hw.optional.floatingpoint", "1"], ["hw.optional.mmx", "1"], ["hw.optional.sse", "1"], ["hw.optional.sse2", "1"], ["hw.optional.sse3", "1"], ["hw.optional.sse4_1", "1"], ["hw.optional.sse4_2", "1"], ["hw.optional.supplementalsse3", "1"], ["hw.optional.x86_64", "1"], ["hw.packages", "1"], ["hw.pagesize", "4096"], ["hw.physicalcpu", "4"], ["hw.physicalcpu_max", "4"], ["hw.physmem", "2147483648"], ["hw.tbfrequency", "1000000000"], ["hw.vectorunit", "1"], ["kern.aiomax", "90"], ["kern.aioprocmax", "16"], ["kern.aiothreads", "4"], ["kern.argmax", "262144"], ["kern.clockrate: hz", "sysctl: unknown oid ''kern.clockrate: hz''"], ["kern.coredump", "1"], ["kern.corefile", "/cores/core.%P"], ["kern.delayterm", "0"], ["kern.hostid", "0"], ["kern.hostname", "MacBook-Pro.local"], ["kern.job_control", "1"], ["kern.maxfiles", "12288"], ["kern.maxfilesperproc", "10240"], ["kern.maxproc", "1064"], ["kern.maxprocperuid", "709"], ["kern.maxvnodes", "132096"], ["kern.netboot", "0"], ["kern.ngroups", "16"], ["kern.nisdomainname", ""], ["kern.nx", "1"], ["kern.osrelease", "14.0.0"], ["kern.osrevision", "199506"], ["kern.ostype", "Darwin"], ["kern.osversion", "14A253a"], ["kern.posix1version", "200112"], ["kern.procname", ""], ["kern.rage_vnode", "0"], ["kern.safeboot", "0"], ["kern.saved_ids", "1"], ["kern.securelevel", "0"], ["kern.shreg_private", "0"], ["kern.speculative_reads_disabled", "0"], ["kern.sugid_coredump", "0"], ["kern.thread_name", "sysctl: unknown oid ''kern.thread_name''"], ["mac_addr.awdl0", "f6:cb:e5:c2:b5:98"], ["mac_addr.bridge0", "22:c9:d0:64:64:00"], ["mac_addr.en0", "20:c9:d0:46:d3:59"], ["mac_addr.en1", "32:00:17:d9:ff:a0"], ["mac_addr.en2", "32:00:17:d9:ff:a1"], ["mac_addr.en4", "a8:20:66:29:b0:6e"], ["mac_addr.p2p0", "02:c9:d0:46:d3:59"], ["machdep.cpu.address_bits.physical", "36"], ["machdep.cpu.address_bits.virtual", "48"], ["machdep.cpu.arch_perf.events", "0"], ["machdep.cpu.arch_perf.events_number", "7"], ["machdep.cpu.arch_perf.fixed_number", "3"], ["machdep.cpu.arch_perf.fixed_width", "48"], ["machdep.cpu.arch_perf.number", "4"], ["machdep.cpu.arch_perf.version", "3"], ["machdep.cpu.arch_perf.width", "48"], ["machdep.cpu.brand", "0"], ["machdep.cpu.brand_string", "Intel(R) Core(TM) i7-3615QM CPU @ 2.30GHz"], ["machdep.cpu.cache.L2_associativity", "8"], ["machdep.cpu.cache.linesize", "64"], ["machdep.cpu.cache.size", "256"], ["machdep.cpu.core_count", "4"], ["machdep.cpu.cores_per_package", "8"], ["machdep.cpu.extfamily", "0"], ["machdep.cpu.extfeature_bits", "4967106816"], ["machdep.cpu.extfeatures", "SYSCALL XD EM64T LAHF RDTSCP TSCI"], ["machdep.cpu.extmodel", "3"], ["machdep.cpu.family", "6"], ["machdep.cpu.feature_bits", "9203919201183202303"], ["machdep.cpu.features", "FPU VME DE PSE TSC MSR PAE MCE CX8 APIC SEP MTRR PGE MCA CMOV PAT PSE36 CLFSH DS ACPI MMX FXSR SSE SSE2 SS HTT TM PBE SSE3 PCLMULQDQ DTES64 MON DSCPL VMX EST TM2 SSSE3 CX16 TPR PDCM SSE4.1 SSE4.2 x2APIC POPCNT AES PCID XSAVE OSXSAVE TSCTMR AVX1.0 RDRAND F16C"], ["machdep.cpu.logical_per_package", "16"], ["machdep.cpu.max_basic", "13"], ["machdep.cpu.max_ext", "2147483656"], ["machdep.cpu.microcode_version", "21"], ["machdep.cpu.model", "58"], ["machdep.cpu.mwait.extensions", "3"], ["machdep.cpu.mwait.linesize_max", "64"], ["machdep.cpu.mwait.linesize_min", "64"], ["machdep.cpu.mwait.sub_Cstates", "135456"], ["machdep.cpu.signature", "198313"], ["machdep.cpu.stepping", "9"], ["machdep.cpu.thermal.ACNT_MCNT", "1"], ["machdep.cpu.thermal.dynamic_acceleration", "1"], ["machdep.cpu.thermal.sensor", "1"], ["machdep.cpu.thermal.thresholds", "2"], ["machdep.cpu.thread_count", "8"], ["machdep.cpu.tlb.data.large", "32"], ["machdep.cpu.tlb.data.large_level1", ""], ["machdep.cpu.tlb.data.small", "64"], ["machdep.cpu.tlb.data.small_level1", ""], ["machdep.cpu.tlb.inst.large", "8"], ["machdep.cpu.tlb.inst.small", "64"], ["machdep.cpu.vendor", "GenuineIntel"]]','MacBookPro10,1','Darwin Kernel Version 14.0.0: Thu May 29 20:54:07 PDT 2014; root:xnu-2763~1/DEVELOPMENT_X86_64');
+INSERT INTO "compile_Machine" VALUES(1,'localhost', CAST('[["hw.activecpu", "8"], ["hw.availcpu", "8"], ["hw.busfrequency", "100000000"], ["hw.busfrequency_max", "100000000"], ["hw.busfrequency_min", "100000000"], ["hw.byteorder", "1234"], ["hw.cacheconfig", "8 2 2 8 0 0 0 0 0 0"], ["hw.cachelinesize", "64"], ["hw.cachesize", "8589934592 32768 262144 6291456 0 0 0 0 0 0"], ["hw.cpu64bit_capable", "1"], ["hw.cpufamily", "1418770316"], ["hw.cpufrequency", "2200000000"], ["hw.cpufrequency_max", "2200000000"], ["hw.cpufrequency_min", "2200000000"], ["hw.cpusubtype", "4"], ["hw.cputype", "7"], ["hw.epoch", "0"], ["hw.l1dcachesize", "32768"], ["hw.l1icachesize", "32768"], ["hw.l2cachesize", "262144"], ["hw.l2settings", "1"], ["hw.logicalcpu", "8"], ["hw.logicalcpu_max", "8"], ["hw.machine", "x86_64"], ["hw.memsize", "8589934592"], ["hw.ncpu", "8"], ["hw.optional.floatingpoint", "1"], ["hw.optional.mmx", "1"], ["hw.optional.sse", "1"], ["hw.optional.sse2", "1"], ["hw.optional.sse3", "1"], ["hw.optional.sse4_1", "1"], ["hw.optional.sse4_2", "1"], ["hw.optional.supplementalsse3", "1"], ["hw.optional.x86_64", "1"], ["hw.packages", "1"], ["hw.pagesize", "4096"], ["hw.physicalcpu", "4"], ["hw.physicalcpu_max", "4"], ["hw.physmem", "2147483648"], ["hw.tbfrequency", "1000000000"], ["hw.vectorunit", "1"], ["kern.aiomax", "90"], ["kern.aioprocmax", "16"], ["kern.aiothreads", "4"], ["kern.argmax", "262144"], ["kern.clockrate: hz", "second level name clockrate: hz in kern.clockrate: hz is invalid"], ["kern.coredump", "1"], ["kern.corefile", "/cores/core.%P"], ["kern.delayterm", "0"], ["kern.hostid", "0"], ["kern.hostname", "localhost"], ["kern.job_control", "1"], ["kern.maxfiles", "12288"], ["kern.maxfilesperproc", "10240"], ["kern.maxproc", "1064"], ["kern.maxprocperuid", "709"], ["kern.maxvnodes", "132096"], ["kern.netboot", "0"], ["kern.ngroups", "16"], ["kern.nisdomainname", ""], ["kern.nx", "1"], ["kern.osrelease", "11.3.0"], ["kern.osrevision", "199506"], ["kern.ostype", "Darwin"], ["kern.osversion", "11D50b"], ["kern.posix1version", "200112"], ["kern.procname", ""], ["kern.rage_vnode", "0"], ["kern.safeboot", "0"], ["kern.saved_ids", "1"], ["kern.securelevel", "0"], ["kern.shreg_private", "0"], ["kern.speculative_reads_disabled", "0"], ["kern.sugid_coredump", "0"], ["kern.thread_name", "kern"], ["machdep.cpu.address_bits.physical", "36"], ["machdep.cpu.address_bits.virtual", "48"], ["machdep.cpu.arch_perf.events", "0"], ["machdep.cpu.arch_perf.events_number", "7"], ["machdep.cpu.arch_perf.fixed_number", "3"], ["machdep.cpu.arch_perf.fixed_width", "48"], ["machdep.cpu.arch_perf.number", "4"], ["machdep.cpu.arch_perf.version", "3"], ["machdep.cpu.arch_perf.width", "48"], ["machdep.cpu.brand", "0"], ["machdep.cpu.brand_string", "Intel(R) Core(TM) i7-2720QM CPU @ 2.20GHz"], ["machdep.cpu.cache.L2_associativity", "8"], ["machdep.cpu.cache.linesize", "64"], ["machdep.cpu.cache.size", "256"], ["machdep.cpu.core_count", "4"], ["machdep.cpu.cores_per_package", "8"], ["machdep.cpu.extfamily", "0"], ["machdep.cpu.extfeature_bits", "672139520 1"], ["machdep.cpu.extfeatures", "SYSCALL XD EM64T LAHF RDTSCP TSCI"], ["machdep.cpu.extmodel", "2"], ["machdep.cpu.family", "6"], ["machdep.cpu.feature_bits", "3219913727 532341759"], ["machdep.cpu.features", "FPU VME DE PSE TSC MSR PAE MCE CX8 APIC SEP MTRR PGE MCA CMOV PAT PSE36 CLFSH DS ACPI MMX FXSR SSE SSE2 SS HTT TM PBE SSE3 PCLMULQDQ DTES64 MON DSCPL VMX SMX EST TM2 SSSE3 CX16 TPR PDCM SSE4.1 SSE4.2 xAPIC POPCNT AES PCID XSAVE OSXSAVE TSCTMR AVX1.0"], ["machdep.cpu.logical_per_package", "16"], ["machdep.cpu.max_basic", "13"], ["machdep.cpu.max_ext", "2147483656"], ["machdep.cpu.microcode_version", "26"], ["machdep.cpu.model", "42"], ["machdep.cpu.mwait.extensions", "3"], ["machdep.cpu.mwait.linesize_max", "64"], ["machdep.cpu.mwait.linesize_min", "64"], ["machdep.cpu.mwait.sub_Cstates", "135456"], ["machdep.cpu.signature", "132775"], ["machdep.cpu.stepping", "7"], ["machdep.cpu.thermal.ACNT_MCNT", "1"], ["machdep.cpu.thermal.dynamic_acceleration", "1"], ["machdep.cpu.thermal.sensor", "1"], ["machdep.cpu.thermal.thresholds", "2"], ["machdep.cpu.thread_count", "8"], ["machdep.cpu.tlb.data.large", "32"], ["machdep.cpu.tlb.data.large_level1", ""], ["machdep.cpu.tlb.data.small", "64"], ["machdep.cpu.tlb.data.small_level1", ""], ["machdep.cpu.tlb.inst.large", ""], ["machdep.cpu.tlb.inst.small", "64"], ["machdep.cpu.vendor", "GenuineIntel"]]' AS BLOB),'MacBookPro8,2','Darwin Kernel Version 11.3.0: Thu Jan 12 18:47:41 PST 2012; root:xnu-1699.24.23~1/RELEASE_X86_64');
+INSERT INTO "compile_Machine" VALUES(2,'MacBook-Pro.local',CAST('[["hw.activecpu", "8"], ["hw.availcpu", "sysctl: unknown oid ''hw.availcpu''"], ["hw.busfrequency", "100000000"], ["hw.busfrequency_max", "100000000"], ["hw.busfrequency_min", "100000000"], ["hw.byteorder", "1234"], ["hw.cacheconfig", "8 2 2 8 0 0 0 0 0 0"], ["hw.cachelinesize", "64"], ["hw.cachesize", "8589934592 32768 262144 6291456 0 0 0 0 0 0"], ["hw.cpu64bit_capable", "1"], ["hw.cpufamily", "526772277"], ["hw.cpufrequency", "2300000000"], ["hw.cpufrequency_max", "2300000000"], ["hw.cpufrequency_min", "2300000000"], ["hw.cpusubtype", "4"], ["hw.cputype", "7"], ["hw.epoch", "0"], ["hw.l1dcachesize", "32768"], ["hw.l1icachesize", "32768"], ["hw.l2cachesize", "262144"], ["hw.l2settings", "1"], ["hw.logicalcpu", "8"], ["hw.logicalcpu_max", "8"], ["hw.machine", "x86_64"], ["hw.memsize", "8589934592"], ["hw.ncpu", "8"], ["hw.optional.floatingpoint", "1"], ["hw.optional.mmx", "1"], ["hw.optional.sse", "1"], ["hw.optional.sse2", "1"], ["hw.optional.sse3", "1"], ["hw.optional.sse4_1", "1"], ["hw.optional.sse4_2", "1"], ["hw.optional.supplementalsse3", "1"], ["hw.optional.x86_64", "1"], ["hw.packages", "1"], ["hw.pagesize", "4096"], ["hw.physicalcpu", "4"], ["hw.physicalcpu_max", "4"], ["hw.physmem", "2147483648"], ["hw.tbfrequency", "1000000000"], ["hw.vectorunit", "1"], ["kern.aiomax", "90"], ["kern.aioprocmax", "16"], ["kern.aiothreads", "4"], ["kern.argmax", "262144"], ["kern.clockrate: hz", "sysctl: unknown oid ''kern.clockrate: hz''"], ["kern.coredump", "1"], ["kern.corefile", "/cores/core.%P"], ["kern.delayterm", "0"], ["kern.hostid", "0"], ["kern.hostname", "MacBook-Pro.local"], ["kern.job_control", "1"], ["kern.maxfiles", "12288"], ["kern.maxfilesperproc", "10240"], ["kern.maxproc", "1064"], ["kern.maxprocperuid", "709"], ["kern.maxvnodes", "132096"], ["kern.netboot", "0"], ["kern.ngroups", "16"], ["kern.nisdomainname", ""], ["kern.nx", "1"], ["kern.osrelease", "14.0.0"], ["kern.osrevision", "199506"], ["kern.ostype", "Darwin"], ["kern.osversion", "14A253a"], ["kern.posix1version", "200112"], ["kern.procname", ""], ["kern.rage_vnode", "0"], ["kern.safeboot", "0"], ["kern.saved_ids", "1"], ["kern.securelevel", "0"], ["kern.shreg_private", "0"], ["kern.speculative_reads_disabled", "0"], ["kern.sugid_coredump", "0"], ["kern.thread_name", "sysctl: unknown oid ''kern.thread_name''"], ["mac_addr.awdl0", "f6:cb:e5:c2:b5:98"], ["mac_addr.bridge0", "22:c9:d0:64:64:00"], ["mac_addr.en0", "20:c9:d0:46:d3:59"], ["mac_addr.en1", "32:00:17:d9:ff:a0"], ["mac_addr.en2", "32:00:17:d9:ff:a1"], ["mac_addr.en4", "a8:20:66:29:b0:6e"], ["mac_addr.p2p0", "02:c9:d0:46:d3:59"], ["machdep.cpu.address_bits.physical", "36"], ["machdep.cpu.address_bits.virtual", "48"], ["machdep.cpu.arch_perf.events", "0"], ["machdep.cpu.arch_perf.events_number", "7"], ["machdep.cpu.arch_perf.fixed_number", "3"], ["machdep.cpu.arch_perf.fixed_width", "48"], ["machdep.cpu.arch_perf.number", "4"], ["machdep.cpu.arch_perf.version", "3"], ["machdep.cpu.arch_perf.width", "48"], ["machdep.cpu.brand", "0"], ["machdep.cpu.brand_string", "Intel(R) Core(TM) i7-3615QM CPU @ 2.30GHz"], ["machdep.cpu.cache.L2_associativity", "8"], ["machdep.cpu.cache.linesize", "64"], ["machdep.cpu.cache.size", "256"], ["machdep.cpu.core_count", "4"], ["machdep.cpu.cores_per_package", "8"], ["machdep.cpu.extfamily", "0"], ["machdep.cpu.extfeature_bits", "4967106816"], ["machdep.cpu.extfeatures", "SYSCALL XD EM64T LAHF RDTSCP TSCI"], ["machdep.cpu.extmodel", "3"], ["machdep.cpu.family", "6"], ["machdep.cpu.feature_bits", "9203919201183202303"], ["machdep.cpu.features", "FPU VME DE PSE TSC MSR PAE MCE CX8 APIC SEP MTRR PGE MCA CMOV PAT PSE36 CLFSH DS ACPI MMX FXSR SSE SSE2 SS HTT TM PBE SSE3 PCLMULQDQ DTES64 MON DSCPL VMX EST TM2 SSSE3 CX16 TPR PDCM SSE4.1 SSE4.2 x2APIC POPCNT AES PCID XSAVE OSXSAVE TSCTMR AVX1.0 RDRAND F16C"], ["machdep.cpu.logical_per_package", "16"], ["machdep.cpu.max_basic", "13"], ["machdep.cpu.max_ext", "2147483656"], ["machdep.cpu.microcode_version", "21"], ["machdep.cpu.model", "58"], ["machdep.cpu.mwait.extensions", "3"], ["machdep.cpu.mwait.linesize_max", "64"], ["machdep.cpu.mwait.linesize_min", "64"], ["machdep.cpu.mwait.sub_Cstates", "135456"], ["machdep.cpu.signature", "198313"], ["machdep.cpu.stepping", "9"], ["machdep.cpu.thermal.ACNT_MCNT", "1"], ["machdep.cpu.thermal.dynamic_acceleration", "1"], ["machdep.cpu.thermal.sensor", "1"], ["machdep.cpu.thermal.thresholds", "2"], ["machdep.cpu.thread_count", "8"], ["machdep.cpu.tlb.data.large", "32"], ["machdep.cpu.tlb.data.large_level1", ""], ["machdep.cpu.tlb.data.small", "64"], ["machdep.cpu.tlb.data.small_level1", ""], ["machdep.cpu.tlb.inst.large", "8"], ["machdep.cpu.tlb.inst.small", "64"], ["machdep.cpu.vendor", "GenuineIntel"]]' AS BLOB),'MacBookPro10,1','Darwin Kernel Version 14.0.0: Thu May 29 20:54:07 PDT 2014; root:xnu-2763~1/DEVELOPMENT_X86_64');
 CREATE TABLE "compile_Test" (
   "ID" INTEGER NOT NULL, 
   "Name" VARCHAR(256), 
   PRIMARY KEY ("ID")
 );
 INSERT INTO "compile_Test" VALUES(1,'compile/OmniGroupFrameworks/NSBezierPath-OAExtensions.m/assembly/(-O0 -g)');
 INSERT INTO "compile_Test" VALUES(2,'compile/JavaScriptCore/Interpreter.cpp/init/(-O0 -g)');
 CREATE TABLE "compile_Order" (
   "ID" INTEGER NOT NULL, 
   "NextOrder" INTEGER, 
   "PreviousOrder" INTEGER, 
   llvm_project_revision VARCHAR(256), 
   PRIMARY KEY ("ID"), 
   FOREIGN KEY("NextOrder") REFERENCES "compile_Order" ("ID"), 
   FOREIGN KEY("PreviousOrder") REFERENCES "compile_Order" ("ID")
 );
-INSERT INTO "compile_Order" VALUES(2,NULL,3,'154331');
-INSERT INTO "compile_Order" VALUES(3,2,4,'154335');
+INSERT INTO "compile_Order" VALUES(2,NULL,NULL,'154331');
+INSERT INTO "compile_Order" VALUES(3,2,NULL,'154335');
 INSERT INTO "compile_Order" VALUES(4,3,NULL,'154339');
+UPDATE "compile_Order" SET "PreviousOrder"=3 WHERE "ID"=2;
+UPDATE "compile_Order" SET "PreviousOrder"=3 WHERE "ID"=3;
 CREATE TABLE "compile_Run" (
   "ID" INTEGER NOT NULL, 
   "MachineID" INTEGER, 
   "OrderID" INTEGER, 
   "ImportedFrom" VARCHAR(512), 
   "StartTime" DATETIME, 
   "EndTime" DATETIME, 
   "SimpleRunID" INTEGER, 
   "Parameters" BLOB, 
   PRIMARY KEY ("ID"), 
   FOREIGN KEY("MachineID") REFERENCES "compile_Machine" ("ID"), 
   FOREIGN KEY("OrderID") REFERENCES "compile_Order" ("ID")
 );
-INSERT INTO "compile_Run" VALUES(1,1,2,'server/db/Inputs/lnt_v0.4.0_filled_instance/lnt_tmp/default/2012-04/data-2012-04-11_16-47-40o2zWJN.plist','2012-04-11 16:30:33.000000','2012-04-11 16:40:13.000000',NULL,'[["__report_version__", "1"], ["cc", "/tmp/bin/clang"], ["cc1_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_alt_src_branch", "trunk"], ["cc_alt_src_revision", "154329"], ["cc_as_version", "LLVM (http://llvm.org/):\n  LLVM version 3.1svn\n  Optimized build.\n  Built Apr  9 2012 (11:55:07).\n  Default target: x86_64-apple-darwin11.3.0\n  Host CPU: corei7-avx"], ["cc_build", "DEV"], ["cc_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "clang"], ["cc_src_branch", "trunk"], ["cc_src_revision", "154331"], ["cc_target", "x86_64-apple-macosx10.7.0"], ["cc_version", "clang version 3.1 (trunk 154331) (llvm/trunk 154329)\nTarget: x86_64-apple-darwin11.3.0\nThread model: posix\n \"/tmp/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.7.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-v\" \"-resource-dir\" \"/tmp/bin/../lib/clang/3.1\" \"-fmodule-cache-path\" \"/var/folders/32/jb9nf1gs6hx12s0brx1xdy8w0000gn/T/clang-module-cache\" \"-fdebug-compilation-dir\" \"/tmp/SANDBOX\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime-has-arc\" \"-fobjc-runtime-has-weak\" \"-fobjc-dispatch-method=mixed\" \"-fobjc-default-synthesize-properties\" \"-fdiagnostics-show-option\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "3.1"], ["hw.usermem", "728748032"], ["inferred_run_order", "154331"], ["kern.boottime", "{ sec = 1332011482, usec = 0 } Sat Mar 17 12:11:22 2012"], ["kern.usrstack", "1667633152"], ["kern.usrstack64", "140735023362048"], ["run_count", "3"], ["sys_as_version", "Apple Inc version cctools-800~266, GNU assembler version 1.38"], ["sys_cc_version", "Using built-in specs.\nTarget: i686-apple-darwin11\nConfigured with: /private/var/tmp/llvmgcc42/llvmgcc42-2335.15~62/src/configure --disable-checking --enable-werror --prefix=/Developer/usr/llvm-gcc-4.2 --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-prefix=llvm- --program-transform-name=/^[cg][^.-]*$/s/$/-4.2/ --with-slibdir=/usr/lib --build=i686-apple-darwin11 --enable-llvm=/private/var/tmp/llvmgcc42/llvmgcc42-2335.15~62/dst-llvmCore/Developer/usr/local --program-prefix=i686-apple-darwin11- --host=x86_64-apple-darwin11 --target=i686-apple-darwin11 --with-gxx-include-dir=/usr/include/c++/4.2.1\nThread model: posix\ngcc version 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nllvm version 2.9svn, from Apple Clang 2.0 (build 138.1)"], ["sys_xcodebuild", "Xcode 4.1\nBuild version 11A511a"]]');
-INSERT INTO "compile_Run" VALUES(2,2,3,'/Users/cmatthews/src/lnt/tests/SharedInputs/SmallInstance/lnt_tmp/default/2014-06/data-2014-06-03_20-59-47BCt5TE.plist','2014-06-02 20:59:42.000000','2014-06-02 21:59:47.000000',NULL,'[["__report_version__", "1"], ["cc", "/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang"], ["cc1_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_alt_src_branch", "based on LLVM"], ["cc_alt_src_revision", "3.5svn"], ["cc_as_version", "clang: error: unsupported argument ''-v'' to option ''Wa,''"], ["cc_build", "PROD"], ["cc_dumpmachine", "x86_64-apple-darwin14.0.0"], ["cc_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: armv6 armv7 armv7s arm64 i386 x86_64 x86_64h armv6m armv7m armv7em\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "apple_clang"], ["cc_src_branch", "clang-600.0.34.2"], ["cc_src_tag", "600.0.34.2"], ["cc_target", "x86_64-apple-macosx10.10.0"], ["cc_target_assembly", "; ModuleID = ''/dev/null''\ntarget datalayout = \"e-m:o-i64:64-f80:128-n8:16:32:64-S128\"\ntarget triple = \"x86_64-apple-macosx10.10.0\"\n\n!llvm.ident = !{!0}\n\n!0 = metadata !{metadata !\"Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\"}"], ["cc_version", "Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix\n \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.10.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-mrelocation-model\" \"pic\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-target-linker-version\" \"241\" \"-v\" \"-resource-dir\" \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/clang/6.0\" \"-fdebug-compilation-dir\" \"/Users/cmatthews/src/lnt/tests\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime=macosx-10.10.0\" \"-fencode-extended-block-signature\" \"-fdiagnostics-show-option\" \"-vectorize-slp\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "6.0"], ["hw.usermem", "974143488"], ["inferred_run_order", "600.0.34.2"], ["kern.boottime", "{ sec = 1401769065, usec = 0 } Mon Jun  2 21:17:45 2014"], ["kern.usrstack", "1548972032"], ["kern.usrstack64", "140734545977344"], ["run_count", "1"], ["sys_as_version", "Apple Inc version cctools-861, GNU assembler version 1.38"], ["sys_cc_version", "Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\nApple LLVM version 6.0 (clang-600.0.34) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: i386 x86_64 x86_64h arm64\nLTO support using: LLVM version 3.5svn"], ["sys_xcodebuild", "Xcode 6.0\nBuild version 6A233"]]');
-INSERT INTO "compile_Run" VALUES(3,2,3,'/Users/cmatthews/src/lnt/tests/SharedInputs/SmallInstance/lnt_tmp/default/2014-06/data-2014-06-03_21-00-37ADDeLS.plist','2014-06-03 21:00:16.000000','2014-06-03 21:00:37.000000',NULL,'[["__report_version__", "1"], ["cc", "/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang"], ["cc1_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_alt_src_branch", "based on LLVM"], ["cc_alt_src_revision", "3.5svn"], ["cc_as_version", "clang: error: unsupported argument ''-v'' to option ''Wa,''"], ["cc_build", "PROD"], ["cc_dumpmachine", "x86_64-apple-darwin14.0.0"], ["cc_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: armv6 armv7 armv7s arm64 i386 x86_64 x86_64h armv6m armv7m armv7em\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "apple_clang"], ["cc_src_branch", "clang-600.0.34.2"], ["cc_src_tag", "600.0.34.2"], ["cc_target", "x86_64-apple-macosx10.10.0"], ["cc_target_assembly", "; ModuleID = ''/dev/null''\ntarget datalayout = \"e-m:o-i64:64-f80:128-n8:16:32:64-S128\"\ntarget triple = \"x86_64-apple-macosx10.10.0\"\n\n!llvm.ident = !{!0}\n\n!0 = metadata !{metadata !\"Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\"}"], ["cc_version", "Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix\n \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.10.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-mrelocation-model\" \"pic\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-target-linker-version\" \"241\" \"-v\" \"-resource-dir\" \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/clang/6.0\" \"-fdebug-compilation-dir\" \"/Users/cmatthews/src/lnt/tests\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime=macosx-10.10.0\" \"-fencode-extended-block-signature\" \"-fdiagnostics-show-option\" \"-vectorize-slp\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "6.0"], ["hw.usermem", "1000357888"], ["inferred_run_order", "600.0.34.2"], ["kern.boottime", "{ sec = 1401769065, usec = 0 } Mon Jun  2 21:17:45 2014"], ["kern.usrstack", "1570906112"], ["kern.usrstack64", "140734551621632"], ["run_count", "3"], ["sys_as_version", "Apple Inc version cctools-861, GNU assembler version 1.38"], ["sys_cc_version", "Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\nApple LLVM version 6.0 (clang-600.0.34) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: i386 x86_64 x86_64h arm64\nLTO support using: LLVM version 3.5svn"], ["sys_xcodebuild", "Xcode 6.0\nBuild version 6A233"]]');
-INSERT INTO "compile_Run" VALUES(4,2,4,'/Users/cmatthews/src/lnt/tests/SharedInputs/SmallInstance/lnt_tmp/default/2014-06/data-2014-06-03_21-03-15G7p553.plist','2014-06-04 21:03:07.000000','2014-06-04 21:03:15.000000',NULL,'[["__report_version__", "1"], ["cc", "/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang"], ["cc1_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_alt_src_branch", "based on LLVM"], ["cc_alt_src_revision", "3.5svn"], ["cc_as_version", "clang: error: unsupported argument ''-v'' to option ''Wa,''"], ["cc_build", "PROD"], ["cc_dumpmachine", "x86_64-apple-darwin14.0.0"], ["cc_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: armv6 armv7 armv7s arm64 i386 x86_64 x86_64h armv6m armv7m armv7em\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "apple_clang"], ["cc_src_branch", "clang-600.0.34.2"], ["cc_src_tag", "600.0.34.2"], ["cc_target", "x86_64-apple-macosx10.10.0"], ["cc_target_assembly", "; ModuleID = ''/dev/null''\ntarget datalayout = \"e-m:o-i64:64-f80:128-n8:16:32:64-S128\"\ntarget triple = \"x86_64-apple-macosx10.10.0\"\n\n!llvm.ident = !{!0}\n\n!0 = metadata !{metadata !\"Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\"}"], ["cc_version", "Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix\n \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.10.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-mrelocation-model\" \"pic\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-target-linker-version\" \"241\" \"-v\" \"-resource-dir\" \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/clang/6.0\" \"-fdebug-compilation-dir\" \"/Users/cmatthews/src/lnt/tests\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime=macosx-10.10.0\" \"-fencode-extended-block-signature\" \"-fdiagnostics-show-option\" \"-vectorize-slp\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "6.0"], ["hw.usermem", "998539264"], ["inferred_run_order", "600.0.34.2"], ["kern.boottime", "{ sec = 1401769065, usec = 0 } Mon Jun  2 21:17:45 2014"], ["kern.usrstack", "1383366656"], ["kern.usrstack64", "140734738419712"], ["run_count", "3"], ["sys_as_version", "Apple Inc version cctools-861, GNU assembler version 1.38"], ["sys_cc_version", "Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\nApple LLVM version 6.0 (clang-600.0.34) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: i386 x86_64 x86_64h arm64\nLTO support using: LLVM version 3.5svn"], ["sys_xcodebuild", "Xcode 6.0\nBuild version 6A233"]]');
+INSERT INTO "compile_Run" VALUES(1,1,2,'server/db/Inputs/lnt_v0.4.0_filled_instance/lnt_tmp/default/2012-04/data-2012-04-11_16-47-40o2zWJN.plist','2012-04-11 16:30:33.000000','2012-04-11 16:40:13.000000',NULL, CAST('[["__report_version__", "1"], ["cc", "/tmp/bin/clang"], ["cc1_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_alt_src_branch", "trunk"], ["cc_alt_src_revision", "154329"], ["cc_as_version", "LLVM (http://llvm.org/):\n  LLVM version 3.1svn\n  Optimized build.\n  Built Apr  9 2012 (11:55:07).\n  Default target: x86_64-apple-darwin11.3.0\n  Host CPU: corei7-avx"], ["cc_build", "DEV"], ["cc_exec_hash", "faf962f75130a6a50b5e8f61048c27ece631d0fd"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "clang"], ["cc_src_branch", "trunk"], ["cc_src_revision", "154331"], ["cc_target", "x86_64-apple-macosx10.7.0"], ["cc_version", "clang version 3.1 (trunk 154331) (llvm/trunk 154329)\nTarget: x86_64-apple-darwin11.3.0\nThread model: posix\n \"/tmp/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.7.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-v\" \"-resource-dir\" \"/tmp/bin/../lib/clang/3.1\" \"-fmodule-cache-path\" \"/var/folders/32/jb9nf1gs6hx12s0brx1xdy8w0000gn/T/clang-module-cache\" \"-fdebug-compilation-dir\" \"/tmp/SANDBOX\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime-has-arc\" \"-fobjc-runtime-has-weak\" \"-fobjc-dispatch-method=mixed\" \"-fobjc-default-synthesize-properties\" \"-fdiagnostics-show-option\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "3.1"], ["hw.usermem", "728748032"], ["inferred_run_order", "154331"], ["kern.boottime", "{ sec = 1332011482, usec = 0 } Sat Mar 17 12:11:22 2012"], ["kern.usrstack", "1667633152"], ["kern.usrstack64", "140735023362048"], ["run_count", "3"], ["sys_as_version", "Apple Inc version cctools-800~266, GNU assembler version 1.38"], ["sys_cc_version", "Using built-in specs.\nTarget: i686-apple-darwin11\nConfigured with: /private/var/tmp/llvmgcc42/llvmgcc42-2335.15~62/src/configure --disable-checking --enable-werror --prefix=/Developer/usr/llvm-gcc-4.2 --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-prefix=llvm- --program-transform-name=/^[cg][^.-]*$/s/$/-4.2/ --with-slibdir=/usr/lib --build=i686-apple-darwin11 --enable-llvm=/private/var/tmp/llvmgcc42/llvmgcc42-2335.15~62/dst-llvmCore/Developer/usr/local --program-prefix=i686-apple-darwin11- --host=x86_64-apple-darwin11 --target=i686-apple-darwin11 --with-gxx-include-dir=/usr/include/c++/4.2.1\nThread model: posix\ngcc version 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-123.2.1\nllvm version 2.9svn, from Apple Clang 2.0 (build 138.1)"], ["sys_xcodebuild", "Xcode 4.1\nBuild version 11A511a"]]' AS BLOB));
+INSERT INTO "compile_Run" VALUES(2,2,3,'/Users/cmatthews/src/lnt/tests/SharedInputs/SmallInstance/lnt_tmp/default/2014-06/data-2014-06-03_20-59-47BCt5TE.plist','2014-06-02 20:59:42.000000','2014-06-02 21:59:47.000000',NULL, CAST('[["__report_version__", "1"], ["cc", "/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang"], ["cc1_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_alt_src_branch", "based on LLVM"], ["cc_alt_src_revision", "3.5svn"], ["cc_as_version", "clang: error: unsupported argument ''-v'' to option ''Wa,''"], ["cc_build", "PROD"], ["cc_dumpmachine", "x86_64-apple-darwin14.0.0"], ["cc_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: armv6 armv7 armv7s arm64 i386 x86_64 x86_64h armv6m armv7m armv7em\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "apple_clang"], ["cc_src_branch", "clang-600.0.34.2"], ["cc_src_tag", "600.0.34.2"], ["cc_target", "x86_64-apple-macosx10.10.0"], ["cc_target_assembly", "; ModuleID = ''/dev/null''\ntarget datalayout = \"e-m:o-i64:64-f80:128-n8:16:32:64-S128\"\ntarget triple = \"x86_64-apple-macosx10.10.0\"\n\n!llvm.ident = !{!0}\n\n!0 = metadata !{metadata !\"Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\"}"], ["cc_version", "Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix\n \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.10.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-mrelocation-model\" \"pic\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-target-linker-version\" \"241\" \"-v\" \"-resource-dir\" \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/clang/6.0\" \"-fdebug-compilation-dir\" \"/Users/cmatthews/src/lnt/tests\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime=macosx-10.10.0\" \"-fencode-extended-block-signature\" \"-fdiagnostics-show-option\" \"-vectorize-slp\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "6.0"], ["hw.usermem", "974143488"], ["inferred_run_order", "600.0.34.2"], ["kern.boottime", "{ sec = 1401769065, usec = 0 } Mon Jun  2 21:17:45 2014"], ["kern.usrstack", "1548972032"], ["kern.usrstack64", "140734545977344"], ["run_count", "1"], ["sys_as_version", "Apple Inc version cctools-861, GNU assembler version 1.38"], ["sys_cc_version", "Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\nApple LLVM version 6.0 (clang-600.0.34) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: i386 x86_64 x86_64h arm64\nLTO support using: LLVM version 3.5svn"], ["sys_xcodebuild", "Xcode 6.0\nBuild version 6A233"]]' AS BLOB));
+INSERT INTO "compile_Run" VALUES(3,2,3,'/Users/cmatthews/src/lnt/tests/SharedInputs/SmallInstance/lnt_tmp/default/2014-06/data-2014-06-03_21-00-37ADDeLS.plist','2014-06-03 21:00:16.000000','2014-06-03 21:00:37.000000',NULL, CAST('[["__report_version__", "1"], ["cc", "/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang"], ["cc1_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_alt_src_branch", "based on LLVM"], ["cc_alt_src_revision", "3.5svn"], ["cc_as_version", "clang: error: unsupported argument ''-v'' to option ''Wa,''"], ["cc_build", "PROD"], ["cc_dumpmachine", "x86_64-apple-darwin14.0.0"], ["cc_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: armv6 armv7 armv7s arm64 i386 x86_64 x86_64h armv6m armv7m armv7em\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "apple_clang"], ["cc_src_branch", "clang-600.0.34.2"], ["cc_src_tag", "600.0.34.2"], ["cc_target", "x86_64-apple-macosx10.10.0"], ["cc_target_assembly", "; ModuleID = ''/dev/null''\ntarget datalayout = \"e-m:o-i64:64-f80:128-n8:16:32:64-S128\"\ntarget triple = \"x86_64-apple-macosx10.10.0\"\n\n!llvm.ident = !{!0}\n\n!0 = metadata !{metadata !\"Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\"}"], ["cc_version", "Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix\n \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.10.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-mrelocation-model\" \"pic\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-target-linker-version\" \"241\" \"-v\" \"-resource-dir\" \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/clang/6.0\" \"-fdebug-compilation-dir\" \"/Users/cmatthews/src/lnt/tests\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime=macosx-10.10.0\" \"-fencode-extended-block-signature\" \"-fdiagnostics-show-option\" \"-vectorize-slp\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "6.0"], ["hw.usermem", "1000357888"], ["inferred_run_order", "600.0.34.2"], ["kern.boottime", "{ sec = 1401769065, usec = 0 } Mon Jun  2 21:17:45 2014"], ["kern.usrstack", "1570906112"], ["kern.usrstack64", "140734551621632"], ["run_count", "3"], ["sys_as_version", "Apple Inc version cctools-861, GNU assembler version 1.38"], ["sys_cc_version", "Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\nApple LLVM version 6.0 (clang-600.0.34) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: i386 x86_64 x86_64h arm64\nLTO support using: LLVM version 3.5svn"], ["sys_xcodebuild", "Xcode 6.0\nBuild version 6A233"]]' AS BLOB));
+INSERT INTO "compile_Run" VALUES(4,2,4,'/Users/cmatthews/src/lnt/tests/SharedInputs/SmallInstance/lnt_tmp/default/2014-06/data-2014-06-03_21-03-15G7p553.plist','2014-06-04 21:03:07.000000','2014-06-04 21:03:15.000000',NULL, CAST('[["__report_version__", "1"], ["cc", "/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang"], ["cc1_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_alt_src_branch", "based on LLVM"], ["cc_alt_src_revision", "3.5svn"], ["cc_as_version", "clang: error: unsupported argument ''-v'' to option ''Wa,''"], ["cc_build", "PROD"], ["cc_dumpmachine", "x86_64-apple-darwin14.0.0"], ["cc_exec_hash", "b18490c69cebfbdd20500c473684b7093a8b2c62"], ["cc_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: armv6 armv7 armv7s arm64 i386 x86_64 x86_64h armv6m armv7m armv7em\nLibrary search paths:\n\t/usr/lib\n\t/usr/local/lib\nFramework search paths:\n\t/Library/Frameworks/\n\t/System/Library/Frameworks/"], ["cc_name", "apple_clang"], ["cc_src_branch", "clang-600.0.34.2"], ["cc_src_tag", "600.0.34.2"], ["cc_target", "x86_64-apple-macosx10.10.0"], ["cc_target_assembly", "; ModuleID = ''/dev/null''\ntarget datalayout = \"e-m:o-i64:64-f80:128-n8:16:32:64-S128\"\ntarget triple = \"x86_64-apple-macosx10.10.0\"\n\n!llvm.ident = !{!0}\n\n!0 = metadata !{metadata !\"Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\"}"], ["cc_version", "Apple LLVM version 6.0 (clang-600.0.34.2) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix\n \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang\" \"-cc1\" \"-triple\" \"x86_64-apple-macosx10.10.0\" \"-E\" \"-disable-free\" \"-disable-llvm-verifier\" \"-main-file-name\" \"null\" \"-mrelocation-model\" \"pic\" \"-pic-level\" \"2\" \"-mdisable-fp-elim\" \"-masm-verbose\" \"-munwind-tables\" \"-target-cpu\" \"core2\" \"-target-linker-version\" \"241\" \"-v\" \"-resource-dir\" \"/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/clang/6.0\" \"-fdebug-compilation-dir\" \"/Users/cmatthews/src/lnt/tests\" \"-ferror-limit\" \"19\" \"-fmessage-length\" \"0\" \"-stack-protector\" \"1\" \"-mstackrealign\" \"-fblocks\" \"-fobjc-runtime=macosx-10.10.0\" \"-fencode-extended-block-signature\" \"-fdiagnostics-show-option\" \"-vectorize-slp\" \"-o\" \"-\" \"-x\" \"c\" \"/dev/null\""], ["cc_version_number", "6.0"], ["hw.usermem", "998539264"], ["inferred_run_order", "600.0.34.2"], ["kern.boottime", "{ sec = 1401769065, usec = 0 } Mon Jun  2 21:17:45 2014"], ["kern.usrstack", "1383366656"], ["kern.usrstack64", "140734738419712"], ["run_count", "3"], ["sys_as_version", "Apple Inc version cctools-861, GNU assembler version 1.38"], ["sys_cc_version", "Configured with: --prefix=/Applications/Xcode.app/Contents/Developer/usr --with-gxx-include-dir=/usr/include/c++/4.2.1\nApple LLVM version 6.0 (clang-600.0.34) (based on LLVM 3.5svn)\nTarget: x86_64-apple-darwin14.0.0\nThread model: posix"], ["sys_ld_version", "@(#)PROGRAM:ld  PROJECT:ld64-241\nconfigured to support archs: i386 x86_64 x86_64h arm64\nLTO support using: LLVM version 3.5svn"], ["sys_xcodebuild", "Xcode 6.0\nBuild version 6A233"]]' AS BLOB));
 CREATE TABLE "compile_Sample" (
   "ID" INTEGER NOT NULL, 
   "RunID" INTEGER, 
   "TestID" INTEGER, 
   user_status INTEGER, 
   sys_status INTEGER, 
   wall_status INTEGER, 
   size_status INTEGER, 
CREATE TABLE "compile_Sample" (
   FOREIGN KEY(user_status) REFERENCES "StatusKind" ("ID"), 
   FOREIGN KEY(sys_status) REFERENCES "StatusKind" ("ID"), 
   FOREIGN KEY(wall_status) REFERENCES "StatusKind" ("ID"), 
   FOREIGN KEY(size_status) REFERENCES "StatusKind" ("ID"), 
   FOREIGN KEY(mem_status) REFERENCES "StatusKind" ("ID")
 );
 INSERT INTO "compile_Sample" VALUES(1,1,1,NULL,NULL,NULL,NULL,NULL,0.336512,0.02585,0.365776,165852.0,33353728.0);
 INSERT INTO "compile_Sample" VALUES(2,1,1,NULL,NULL,NULL,NULL,NULL,0.338633,0.027111,0.367148,165852.0,33353728.0);
-ANALYZE sqlite_master;
-INSERT INTO "sqlite_stat1" VALUES('compile_Order',NULL,'1');
-INSERT INTO "sqlite_stat1" VALUES('NT_Sample','ix_NT_Sample_TestID','260 2');
-INSERT INTO "sqlite_stat1" VALUES('NT_Sample','ix_NT_Sample_RunID_TestID','260 130 1');
-INSERT INTO "sqlite_stat1" VALUES('NT_Test','ix_NT_Test_Name','130 1');
-INSERT INTO "sqlite_stat1" VALUES('compile_Run','ix_compile_Run_OrderID','1 1');
-INSERT INTO "sqlite_stat1" VALUES('compile_Run','ix_compile_Run_MachineID','1 1');
-INSERT INTO "sqlite_stat1" VALUES('NT_Order',NULL,'2');
-INSERT INTO "sqlite_stat1" VALUES('SchemaVersion','sqlite_autoindex_SchemaVersion_1','1 1');
-INSERT INTO "sqlite_stat1" VALUES('StatusKind','sqlite_autoindex_StatusKind_1','3 1');
-INSERT INTO "sqlite_stat1" VALUES('SampleType','sqlite_autoindex_SampleType_1','2 1');
-INSERT INTO "sqlite_stat1" VALUES('compile_Sample','ix_compile_Sample_RunID_TestID','925 925 27');
-INSERT INTO "sqlite_stat1" VALUES('compile_Sample','ix_compile_Sample_TestID','925 27');
-INSERT INTO "sqlite_stat1" VALUES('NT_Machine','ix_NT_Machine_Unique','1 1 1 1 1');
-INSERT INTO "sqlite_stat1" VALUES('NT_Machine','ix_NT_Machine_Name','1 1');
-INSERT INTO "sqlite_stat1" VALUES('TestSuiteOrderFields','ix_TestSuiteOrderFields_TestSuiteID','2 1');
-INSERT INTO "sqlite_stat1" VALUES('compile_Machine','ix_compile_Machine_Unique','1 1 1 1 1');
-INSERT INTO "sqlite_stat1" VALUES('compile_Machine','ix_compile_Machine_Name','1 1');
-INSERT INTO "sqlite_stat1" VALUES('TestSuiteSampleFields','ix_TestSuiteSampleFields_TestSuiteID','14 7');
-INSERT INTO "sqlite_stat1" VALUES('compile_Test','ix_compile_Test_Name','35 1');
-INSERT INTO "sqlite_stat1" VALUES('NT_Run','ix_NT_Run_OrderID','2 1');
-INSERT INTO "sqlite_stat1" VALUES('NT_Run','ix_NT_Run_MachineID','2 2');
-INSERT INTO "sqlite_stat1" VALUES('TestSuite','sqlite_autoindex_TestSuite_1','2 1');
-INSERT INTO "sqlite_stat1" VALUES('TestSuiteMachineFields','ix_TestSuiteMachineFields_TestSuiteID','4 2');
 CREATE TABLE "NT_FieldChange" (
   "ID" INTEGER NOT NULL, 
   "StartOrderID" INTEGER, 
   "EndOrderID" INTEGER, 
   "TestID" INTEGER, 
   "MachineID" INTEGER, 
   "FieldID" INTEGER, 
   PRIMARY KEY ("ID"), 

tests/SharedInputs/create_temp_instance.py

-import sys, shutil, os.path, os, subprocess
+import sys
+import shutil
+import os.path
+import os
+import subprocess
+import hashlib
+import tempfile
+import re
 
-usage = "%s template_source_dir dest_dir [extra.sql]"
 
-if len(sys.argv) not in (3,4):
+def get_postgres_db_uri():
+    return os.environ.get('LNT_POSTGRES_DB_URI')
+
+
+def get_postgres_tmp_db_name(test_name):
+    return "lnt_regr_test_"+hashlib.md5(test_name).hexdigest()
+
+
+def search_replace_in_file_with_function(filename, replacement_function):
+    with open(filename, "r+") as f:
+        old_content = f.read()
+        new_content = replacement_function(old_content)
+        f.seek(0)
+        f.truncate()
+        f.write(new_content)
+
+
+def search_replace_regex_in_file(filename, pattern, substitution):
+    return search_replace_in_file_with_function(
+        filename,
+        lambda c: re.sub(pattern, substitution, c))
+
+
+def search_replace_in_file(filename, pattern, substitution):
+    return search_replace_in_file_with_function(
+        filename,
+        lambda c: c.replace(pattern, substitution))
+
+
+def replace_sqlite_with_postgress_syntax(sql_file):
+    search_replace_regex_in_file(
+        sql_file,
+        r"CAST *\(('.*') AS BLOB\)",
+        r"convert_to(\1, 'UTF8')")
+    search_replace_in_file(sql_file, "BLOB", "bytea")
+    search_replace_in_file(sql_file, "DATETIME", "timestamp")
+
+
+def run_sql_file(db, sql_file, dest_dir):
+    """
+    Run the sql statements in file sql_file on the database in db.
+    The sql statements in sql_file are assumed to be in the sqlite
+    dialect. When run against a different database engine, this function
+    will try to translate the sqlite-isms into the corresponding SQL
+    variants for the engine targetted.
+    """
+    if get_postgres_db_uri():
+        # translate sql_file from slqite-dialect to postgrest-dialect:
+        tmpfile = tempfile.NamedTemporaryFile(
+            prefix=os.path.basename(sql_file),
+            suffix=".psql",
+            dir=dest_dir, delete=False)
+        with open(sql_file, "r") as f:
+            tmpfile.write(f.read())
+        tmpfile_name = tmpfile.name
+        tmpfile.close()
+        replace_sqlite_with_postgress_syntax(tmpfile_name)
+        cmd = "psql %s -f %s" % (db, tmpfile_name)
+    else:
+        cmd = "sqlite3 -batch %s < %s" % (db, sql_file)
+    print cmd
+    subprocess.check_call(cmd, shell="True")
+
+
+def run_sql_cmd(db, sql_cmd):
+    if get_postgres_db_uri():
+        cmd = 'echo "%s" | psql %s' % (sql_cmd, db)
+    else:
+        cmd = 'echo "%s" | sqlite3 -batch %s' % (sql_cmd, db)
+    print cmd
+    subprocess.check_call(cmd, shell="True")
+
+
+def create_tmp_database(db, test_name, dest_dir):
+    if get_postgres_db_uri():
+        tmp_db_name = get_postgres_tmp_db_name(test_name)
+        run_sql_cmd(get_postgres_db_uri(),
+                    "drop database if exists %s;" % tmp_db_name)
+        run_sql_cmd(get_postgres_db_uri(),
+                    "create database %s;" % tmp_db_name)
+        # adapt lnt.cfg so it points to the postgres db instead of the default
+        # sqlite db.
+        search_replace_in_file(
+            os.path.join(dest_dir, "lnt.cfg"),
+            "db_dir = 'data'",
+            "db_dir = '"+get_postgres_db_uri()+"'")
+        search_replace_in_file(
+            os.path.join(dest_dir, "lnt.cfg"),
+            "'path' : 'lnt.db'",
+            "'path' : '"+tmp_db_name+"'")
+        return get_postgres_db_uri()+"/"+tmp_db_name
+    else:
+        # sqlite
+        os.mkdir(os.path.join(dest_dir, "data"))
+        return "%s/lnt.db" % os.path.join(dest_dir, "data")
+
+
+def main():
+    usage = "%s test_name template_source_dir dest_dir [extra.sql]"
+    if len(sys.argv) not in (4, 5):
         print usage
         sys.exit(-1)
-if len(sys.argv) == 3:
-    _, template_source_dir, dest_dir = sys.argv
+    if len(sys.argv) == 4:
+        _, test_name, template_source_dir, dest_dir = sys.argv
         extra_sql = None
     else:
-    _, template_source_dir, dest_dir, extra_sql = sys.argv
+        _, test_name, template_source_dir, dest_dir, extra_sql = sys.argv
+
+
     os.mkdir(os.path.join(dest_dir))
     shutil.copy(os.path.join(template_source_dir, "lnt.cfg"), dest_dir)
     shutil.copy(os.path.join(template_source_dir, "lnt.wsgi"), dest_dir)
-os.mkdir(os.path.join(dest_dir, "data"))
-# create sqlite database from sql script
-lnt_db = "%s/lnt.db" % os.path.join(dest_dir, "data")
-cmd = "sqlite3 -batch %s < %s/lnt_db_create.sql" % \
-      (lnt_db,
-       os.path.join(template_source_dir,"data"))
-subprocess.check_call(cmd, shell="True")
+    lnt_db = create_tmp_database(get_postgres_db_uri(), test_name, dest_dir)
+
+    run_sql_file(lnt_db,
+                 os.path.join(template_source_dir,"data", "lnt_db_create.sql"),
+                 dest_dir)
     if extra_sql:
-    cmd = "sqlite3 -batch %s < %s" % (lnt_db, extra_sql)
-    subprocess.check_call(cmd, shell="True")
+        run_sql_file(lnt_db, extra_sql, dest_dir)
+
+main()

tests/lit.cfg

config.substitutions.append(('%{shared_inputs}', os.path.join(
             src_root, 'tests', 'SharedInputs')))
 config.substitutions.append(('%{test_exec_root}', config.test_exec_root))
 
 if lit_config.params.get('long', None):
     config.available_features.add('long')
 
 if lit_config.params.get('postgres', None):
     config.available_features.add('postgres')
+    config.environment['LNT_POSTGRES_DB_URI'] = \
+        lit_config.params.get('postgres')
+    config.substitutions.append(('%{postgres_db_uri}',
+                                 lit_config.params.get('postgres')))
 
 config.available_features.add(platform.system())
 
 # Enable coverage.py reporting, assuming the coverage module has been installed
 # and sitecustomize.py in the virtualenv has been modified appropriately.
 if lit_config.params.get('check-coverage', None):
     config.environment['COVERAGE_PROCESS_START'] = os.path.join(
         os.path.dirname(__file__), ".coveragerc")
     

tests/lnttool/PostgresDB.py

 # RUN: rm -rf %t.install
-# RUN: dropdb --if-exists testdb
-# RUN: createdb testdb
+# RUN: dropdb --if-exists --maintenance-db=%{postgres_db_uri} \
+# RUN:   lnt_regr_test_PostgresDB
+# RUN: createdb --maintenance-db=%{postgres_db_uri} \
+# RUN:   lnt_regr_test_PostgresDB
 
-# RUN: lnt create %t.install --db-dir postgresql://localhost/ --default-db testdb
+# RUN: lnt create %t.install --db-dir %{postgres_db_uri} \
+# RUN:     --default-db lnt_regr_test_PostgresDB
 
 # Import a test set.
 # RUN: lnt import %t.install %{shared_inputs}/sample-a-small.plist \
 # RUN:     --commit=1 --show-sample-count
 
 # Import a test set.
 # RUN: lnt import %t.install %{shared_inputs}/sample-a-small.plist \
 # RUN:     --commit=1 --show-sample-count

tests/lnttool/email_tools.py

 # Testing for the  LNT email commands module.
 #
 # create temporary instance
-# Cleanup temporary directory in case one remained from a previous run - also see PR9904.
+# Cleanup temporary directory in case one remained from a previous run - also
+# see PR9904.
 # RUN: rm -rf %t.instance
-# RUN: python %{shared_inputs}/create_temp_instance.py %{shared_inputs}/SmallInstance %t.instance
+# RUN: python %{shared_inputs}/create_temp_instance.py \
+# RUN:   %s %{shared_inputs}/SmallInstance %t.instance
 #
 # RUN: lnt send-run-comparison --dry-run --to [e-mail] \
 # RUN: --from [e-mail]  \
 # RUN: --host localhost %t.instance 1 2
 # RUN: lnt send-daily-report --dry-run --from [e-mail] \
 # RUN: --host localhost --testsuite nts --filter-machine-regex=machine.? \
 # RUN: %t.instance [e-mail]

tests/server/ui/Inputs/V4Pages_extra_records.sql

 BEGIN TRANSACTION;
 INSERT INTO "NT_Test" VALUES(87,'SingleSource/UnitTests/ObjC/block-byref-aggr');
 INSERT INTO "compile_Test" VALUES(38,'compile/403.gcc/combine.c/init/(-O0)');
 -- make sure there are 3 machines - to test ?filter-machine-regex= on daily_report page
 INSERT INTO "NT_Machine" VALUES(2,'machine2','[]','AArch64','linux');
+INSERT INTO "NT_Order" VALUES(5,4,NULL,'152290');
 UPDATE "NT_Order" SET "NextOrder" = 5 WHERE "ID" = 4;
-INSERT INTO "NT_Order" VALUES(5,4,6,'152290');
 INSERT INTO "NT_Run" VALUES(3,2,5,'run3.json','2012-04-11 16:28:23.000000','2012-04-11 16:28:58.000000',NULL,'[]');
 INSERT INTO "NT_Sample" VALUES(3,3,1,NULL,NULL,0.001,0.0001,NULL);
 INSERT INTO "NT_Machine" VALUES(3,'machine3','[]','AArch64','linux');
 INSERT INTO "NT_Order" VALUES(6,5,NULL,'152291');
+UPDATE "NT_Order" SET "PreviousOrder" = 6 WHERE "ID" = 5;
 INSERT INTO "NT_Run" VALUES(4,3,6,'run4.json','2012-04-11 16:28:24.000000','2012-04-11 16:28:59.000000',NULL,'[]');
 INSERT INTO "NT_Sample" VALUES(4,4,1,NULL,NULL,0.001,0.0001,NULL);
 -- check that a regression on consecutive runs more than 1 day apart can be detected:
 INSERT INTO "NT_Test" VALUES(88,'test1');
 INSERT INTO "NT_Test" VALUES(89,'test2');
-INSERT INTO "NT_Order" VALUES(7,NULL,8,'152292');
+INSERT INTO "NT_Order" VALUES(7,NULL,NULL,'152292');
 INSERT INTO "NT_Run" VALUES(5,2,7,'run5.json','2012-05-01 16:28:23.000000','2012-05-01 16:28:58.000000',NULL,'[]');
 INSERT INTO "NT_Sample" VALUES(5,5,88,0,0,0.001,1.0,NULL); -- passing result
 INSERT INTO "NT_Sample" VALUES(6,5,89,0,1,0.001,1.0,NULL); -- failing result
 INSERT INTO "NT_Order" VALUES(8,7,NULL,'152293');
+UPDATE "NT_Order" SET "PreviousOrder" = 8 WHERE "ID" = 7;
 INSERT INTO "NT_Run" VALUES(6,2,8,'run6.json','2012-05-03 16:28:24.000000','2012-05-03 16:28:59.000000',NULL,'[]');
 INSERT INTO "NT_Sample" VALUES(7,6,88,0,0,0.001,10.0,NULL); -- passing result 10x slower
 INSERT INTO "NT_Sample" VALUES(8,5,89,0,0,0.001,1.0,NULL); -- passing result
 
 COMMIT;

tests/server/ui/V4Pages.py

 # Perform basic sanity checking of the V4 UI pages.
 #
 # create temporary instance
-# Cleanup temporary directory in case one remained from a previous run - also see PR9904.
+# Cleanup temporary directory in case one remained from a previous run - also
+# see PR9904.
 # RUN: rm -rf %t.instance
-# RUN: python %{shared_inputs}/create_temp_instance.py %{shared_inputs}/SmallInstance %t.instance %S/Inputs/V4Pages_extra_records.sql
+# RUN: python %{shared_inputs}/create_temp_instance.py \
+# RUN:   %s %{shared_inputs}/SmallInstance %t.instance \
+# RUN:   %S/Inputs/V4Pages_extra_records.sql
 #
 # RUN: python %s %t.instance
 
 import logging
 import re
 import sys
 import xml.etree.ElementTree as ET
 from htmlentitydefs import name2codepoint

tests/server/ui/test_api.py

 # Check that the LNT REST JSON API is working.
 # create temporary instance
 # RUN: rm -rf %t.instance
 # RUN: python %{shared_inputs}/create_temp_instance.py \
-# RUN:     %{shared_inputs}/SmallInstance \
+# RUN:     %s %{shared_inputs}/SmallInstance \
 # RUN:     %t.instance %S/Inputs/V4Pages_extra_records.sql
 #
 # RUN: python %s %t.instance
 
 import unittest
 import logging
 import sys