diff options
author | Andrew McDermott <andrew.mcdermott@linaro.org> | 2014-07-16 15:31:01 +0100 |
---|---|---|
committer | Andrew McDermott <andrew.mcdermott@linaro.org> | 2014-07-16 15:31:01 +0100 |
commit | 8ad4c4f6ec2a3544d827a631f01e77f3aa1e16b0 (patch) | |
tree | 0b80165f3af3648c97e27f720d6e37385db686fd | |
parent | 179bc105f85ab0d1ec50579bb928083e5ef0235d (diff) |
print-historic-results: make SQL query more readable
Signed-off-by: Andrew McDermott <andrew.mcdermott@linaro.org>
-rwxr-xr-x | print-historic-results.py | 5 |
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]) |