def get_untriaged(connection: sqlite3.Connection, date: datetime.datetime) -> int: """Return all untriaged tasks.""" cursor: sqlite3.Cursor with closing(connection.cursor()) as cursor: query = get_query("uber.sql") cursor.execute(query, { "Date": date.strftime("%Y-%m-%d"), "Xmas": xmas.strftime("%Y-%m-%d"), "Sourceforge": sourceforge.strftime("%Y-%m-%d"), "SubtypeReport": True, "SubtypeBug": True, "SubtypeKnownIssue": False, "StatusConfirmed": False, "StatusDuplicate": False, "StatusInvalid": False, "StatusNeedsDeveloperToReproduce": False, "StatusNeedsTriage": True, "StatusNeedsUserInfo": False, "StatusResolved": False, "PriorityUnbreakNow": True, "PriorityHigh": True, "PriorityNormal": True, "PriorityLow": True, }) result = cursor.fetchall() total = assert_cast_optional(int, result[0][0]) if total is not None: return total return 0