def _check_wal_level()

in src/dma/collector/workflows/readiness_check/_postgres/main.py [0:0]

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

    def _check_wal_level(self) -> None:
        rule_code = "WAL_LEVEL"
        result = self.local_db.sql(
            "select c.setting_value as wal_level from collection_postgres_settings c where c.setting_name='wal_level' and c.setting_value!='logical';"
        ).fetchone()
        for c in self.rule_config:
            if result is not None:
                self.save_rule_result(
                    c.db_variant,
                    rule_code,
                    ACTION_REQUIRED,
                    f'The `wal_level` settings should be set to "logical" instead of "{result[0]}".',
                )
            else:
                self.save_rule_result(
                    c.db_variant,
                    rule_code,
                    PASS,
                    '`wal_level` is correctly set to "logical".',
                )