summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSam Thursfield <sam.thursfield@codethink.co.uk>2015-06-15 12:34:45 +0100
committerSam Thursfield <sam.thursfield@codethink.co.uk>2015-06-15 12:34:45 +0100
commitf96155fc082e614dc1c9db6a9e429649f8b63e49 (patch)
tree0deb481444e29430bcac219754c1e3e8bd53806f
parent395b6b1c34a12874d3be4c2b9e9f6ca9aa70db83 (diff)
downloadmorph-cache-server-f96155fc082e614dc1c9db6a9e429649f8b63e49.tar.gz
Don't count the original build as mismatched
This makes more sense to me given that it is shown in the "mismatching builds" column. If all the builds match then this column is now 0, where before it would be 1.
-rw-r--r--morphcacheserver/artifact_database.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/morphcacheserver/artifact_database.py b/morphcacheserver/artifact_database.py
index 3745a61..9bc35a9 100644
--- a/morphcacheserver/artifact_database.py
+++ b/morphcacheserver/artifact_database.py
@@ -150,7 +150,7 @@ class ArtifactDatabase(object):
n_builds_per_artifact_sql = '''
SELECT builds.cache_name,
COUNT(builds.hash_sha1) as n_builds,
- COUNT(DISTINCT builds.hash_sha1) as n_different_builds
+ COUNT(DISTINCT builds.hash_sha1)-1 as n_different_builds
FROM artifact_files INNER JOIN builds
ON builds.cache_name = artifact_files.cache_name
GROUP BY builds.cache_name