def _get_sql_for_alerts()

in opmon/monitoring.py [0:0]

• 17 lines of code
• 3 McCabe index (conditional complexity)

    def _get_sql_for_alerts(self, submission_date) -> str:
        """Get the alerts view SQL."""
        alerts: Dict[str, Any] = {}
        for alert_type in AlertType:
            alerts[alert_type.value] = []

        for alert in self.config.alerts:
            alerts[alert.type.value].append(alert)

        render_kwargs = {
            "gcp_project": self.project,
            "dataset": self.dataset,
            "config": self.config.project,
            "normalized_slug": self.normalized_slug,
            "dimensions": self.config.dimensions,
            "alerts": alerts,
            "submission_date": submission_date,
        }

        sql = self._render_sql(ALERTS_QUERY_FILENAME, render_kwargs)
        return sql