do not fail the entire report if a branch cannot be found (#104)

adrpo · web-flow · commit da6d21db9cfa · 2024-04-27T05:18:05.000+03:00
diff --git a/report.py b/report.py
@@ -40,8 +40,22 @@
 exectime = {}
 
 for branch in branches:
-  cursor.execute("SELECT date FROM [%s] ORDER BY date DESC LIMIT 1" % branch)
-  v = cursor.fetchone()[0]
+  try:
+    cursor.execute("SELECT date FROM [%s] ORDER BY date DESC LIMIT 1" % branch)
+    one = cursor.fetchone()
+    if one == None:
+      print("No such table '%s'; specify it using --branch=XXX when running test.py" % branch)
+      # ignore this table and continue
+      branches.remove(branch)
+      continue
+    else:
+      v = one[0]
+  except:    
+    print("No such table '%s'; specify it using --branch=XXX when running test.py" % branch)
+    # ignore this table and continue
+    branches.remove(branch)
+    continue
+
   dates_str[branch] = str(datetime.datetime.fromtimestamp(v).strftime('%Y-%m-%d %H:%M:%S'))
   cursor.execute('''CREATE INDEX IF NOT EXISTS [idx_%s_date] ON [%s](date)''' % (branch,branch))
 
