summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew McDermott <andrew.mcdermott@linaro.org>2014-07-16 15:31:01 +0100
committerAndrew McDermott <andrew.mcdermott@linaro.org>2014-07-16 15:31:01 +0100
commit8ad4c4f6ec2a3544d827a631f01e77f3aa1e16b0 (patch)
tree0b80165f3af3648c97e27f720d6e37385db686fd
parent179bc105f85ab0d1ec50579bb928083e5ef0235d (diff)
print-historic-results: make SQL query more readable
Signed-off-by: Andrew McDermott <andrew.mcdermott@linaro.org>
-rwxr-xr-xprint-historic-results.py5
1 files changed, 4 insertions, 1 deletions
diff --git a/print-historic-results.py b/print-historic-results.py
index de7b154..c789480 100755
--- a/print-historic-results.py
+++ b/print-historic-results.py
@@ -61,7 +61,10 @@ table <= TR(TH('Date') + TH('JVM Variant') + TH('Relative performance'))
conn = sqlite3.connect(sys.argv[1])
cursor = conn.cursor()
-for row in cursor.execute("select date(datetime(timestamp, 'unixepoch', 'localtime')) as 'Date', jvm_type, elapsed_time from results order by date DESC, jvm_type"):
+for row in cursor.execute("select date(datetime(timestamp, 'unixepoch', 'localtime')) as 'Date', \ jvm_type, \
+ elapsed_time \
+ from results \
+ order by date DESC, jvm_type"):
html_row = TR()
html_row <= TD(row[0])
html_row <= TD(row[1])