1. class
  2. Poweradmin
  3. \
  4. Infrastructure
  5. \
  6. Database
  7. \
  8. ZoneHealthSql

ZoneHealthSql

final class ZoneHealthSql (View source)

Reusable SQL fragments that derive zone-health flags (Disabled / No SOA) from the PowerDNS records table. Used by SQL-mode repositories to render status badges in the zone list without an extra round-trip.

Methods

static string
soaHealthColumns(string $domainsTable, string $recordsTable)

SELECT-list fragment yielding is_disabled and is_missing_soa columns.

Details

at line 40
static string soaHealthColumns(string $domainsTable, string $recordsTable)

SELECT-list fragment yielding is_disabled and is_missing_soa columns.

SLAVE zones legitimately lack SOA so they are never flagged as missing.

Parameters

string $domainsTable

Domains-table reference (prefixed if needed)
string $recordsTable

Records-table reference

Return Value

string

Two comma-separated SQL columns, no trailing comma.