func()

in internal/scanners/sql/rules.go [79:135]

• 57 lines of code
• 5 McCabe index (conditional complexity)

func (a *SQLScanner) getDatabaseRules() map[string]models.AzqrRecommendation {
	return map[string]models.AzqrRecommendation{
		"sqldb-001": {
			RecommendationID: "sqldb-001",
			ResourceType:     "Microsoft.Sql/servers/databases",
			Category:         models.CategoryMonitoringAndAlerting,
			Recommendation:   "SQL Database should have diagnostic settings enabled",
			Impact:           models.ImpactLow,
			Eval: func(target interface{}, scanContext *models.ScanContext) (bool, string) {
				service := target.(*armsql.Database)
				_, ok := scanContext.DiagnosticsSettings[strings.ToLower(*service.ID)]
				return !ok, ""
			},
		},
		"sqldb-003": {
			RecommendationID:   "sqldb-003",
			ResourceType:       "Microsoft.Sql/servers/databases",
			Category:           models.CategoryHighAvailability,
			Recommendation:     "SQL Database should have a SLA",
			RecommendationType: models.TypeSLA,
			Impact:             models.ImpactHigh,
			Eval: func(target interface{}, scanContext *models.ScanContext) (bool, string) {
				i := target.(*armsql.Database)
				sla := "99.99%"
				if i.Properties.ZoneRedundant != nil && *i.Properties.ZoneRedundant && *i.SKU.Tier == "Premium" {
					sla = "99.995%"
				}
				return false, sla
			},
		},
		"sqldb-006": {
			RecommendationID: "sqldb-006",
			ResourceType:     "Microsoft.Sql/servers/databases",
			Category:         models.CategoryGovernance,
			Recommendation:   "SQL Database Name should comply with naming conventions",
			Impact:           models.ImpactLow,
			Eval: func(target interface{}, scanContext *models.ScanContext) (bool, string) {
				c := target.(*armsql.Database)
				caf := *c.Name == "master" || strings.HasPrefix(*c.Name, "sqldb")
				return !caf, ""
			},
			LearnMoreUrl: "https://learn.microsoft.com/en-us/azure/cloud-adoption-framework/ready/azure-best-practices/resource-abbreviations",
		},
		"sqldb-007": {
			RecommendationID: "sqldb-007",
			ResourceType:     "Microsoft.Sql/servers/databases",
			Category:         models.CategoryGovernance,
			Recommendation:   "SQL Database should have tags",
			Impact:           models.ImpactLow,
			Eval: func(target interface{}, scanContext *models.ScanContext) (bool, string) {
				c := target.(*armsql.Database)
				return len(c.Tags) == 0, ""
			},
			LearnMoreUrl: "https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/tag-resources?tabs=json",
		},
	}
}