Index: lnt/trunk/docs/developer_guide.rst =================================================================== --- lnt/trunk/docs/developer_guide.rst +++ lnt/trunk/docs/developer_guide.rst @@ -41,9 +41,21 @@ 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. Index: lnt/trunk/tests/SharedInputs/SmallInstance/data/lnt_db_create.sql =================================================================== --- lnt/trunk/tests/SharedInputs/SmallInstance/data/lnt_db_create.sql +++ lnt/trunk/tests/SharedInputs/SmallInstance/data/lnt_db_create.sql @@ -1,4 +1,3 @@ -PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE "SchemaVersion" ( "Name" VARCHAR(256) NOT NULL, @@ -101,8 +100,9 @@ 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), @@ -118,6 +118,7 @@ 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, @@ -131,8 +132,8 @@ 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, @@ -157,8 +158,8 @@ 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), @@ -175,9 +176,11 @@ 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, @@ -191,10 +194,10 @@ 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, @@ -220,30 +223,6 @@ ); 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, Index: lnt/trunk/tests/SharedInputs/create_temp_instance.py =================================================================== --- lnt/trunk/tests/SharedInputs/create_temp_instance.py +++ lnt/trunk/tests/SharedInputs/create_temp_instance.py @@ -1,25 +1,131 @@ -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): - print usage - sys.exit(-1) -if len(sys.argv) == 3: - _, template_source_dir, dest_dir = sys.argv - extra_sql = None -else: - _, 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") -if extra_sql: - cmd = "sqlite3 -batch %s < %s" % (lnt_db, extra_sql) +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) == 4: + _, test_name, template_source_dir, dest_dir = sys.argv + extra_sql = None + else: + _, 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) + 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: + run_sql_file(lnt_db, extra_sql, dest_dir) + +main() Index: lnt/trunk/tests/lit.cfg =================================================================== --- lnt/trunk/tests/lit.cfg +++ lnt/trunk/tests/lit.cfg @@ -43,6 +43,10 @@ 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()) Index: lnt/trunk/tests/lnttool/PostgresDB.py =================================================================== --- lnt/trunk/tests/lnttool/PostgresDB.py +++ lnt/trunk/tests/lnttool/PostgresDB.py @@ -1,8 +1,11 @@ # 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 \ Index: lnt/trunk/tests/lnttool/email_tools.py =================================================================== --- lnt/trunk/tests/lnttool/email_tools.py +++ lnt/trunk/tests/lnttool/email_tools.py @@ -1,9 +1,11 @@ # 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 some@address.com \ # RUN: --from some.other@address.com \ Index: lnt/trunk/tests/server/ui/Inputs/V4Pages_extra_records.sql =================================================================== --- lnt/trunk/tests/server/ui/Inputs/V4Pages_extra_records.sql +++ lnt/trunk/tests/server/ui/Inputs/V4Pages_extra_records.sql @@ -3,22 +3,24 @@ 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 Index: lnt/trunk/tests/server/ui/V4Pages.py =================================================================== --- lnt/trunk/tests/server/ui/V4Pages.py +++ lnt/trunk/tests/server/ui/V4Pages.py @@ -1,9 +1,12 @@ # 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 Index: lnt/trunk/tests/server/ui/test_api.py =================================================================== --- lnt/trunk/tests/server/ui/test_api.py +++ lnt/trunk/tests/server/ui/test_api.py @@ -2,7 +2,7 @@ # 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