ADDED   mkcsv.sh
Index: mkcsv.sh
==================================================================
--- /dev/null
+++ mkcsv.sh
@@ -0,0 +1,21 @@
+#!/bin/sh
+
+sqlite3 megatest.db <<EOF
+create view all_tests as select 
+    runname,RELEASE,DOTPROC,TECH,t.testname,description,
+    item_path,t.state,t.status,
+    attemptnum,final_logf,logdat,run_duration,r.comment,
+    t.event_time,expected_value,value,tol,tol_perc,
+    first_err,first_warn,tm.tags,
+    r.owner,t.comment,
+    author,tm.owner,reviewed,iterated,avg_runtime,
+    diskfree,uname,rundir,avg_disk,t.tags,run_id,
+    host,cpuload
+ from tests as t inner join runs as r on t.run_id=r.id inner join test_meta as tm on tm.testname=t.testname;
+.head on
+.mode csv
+.output "all-data.csv"
+select * from all_tests;
+drop view all_tests;
+.q
+EOF