github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/rules/cloud/policies/azure/database/no_public_access_test.go (about)

     1  package database
     2  
     3  import (
     4  	"testing"
     5  
     6  	defsecTypes "github.com/khulnasoft-lab/defsec/pkg/types"
     7  
     8  	"github.com/khulnasoft-lab/defsec/pkg/state"
     9  
    10  	"github.com/khulnasoft-lab/defsec/pkg/providers/azure/database"
    11  	"github.com/khulnasoft-lab/defsec/pkg/scan"
    12  
    13  	"github.com/stretchr/testify/assert"
    14  )
    15  
    16  func TestCheckNoPublicAccess(t *testing.T) {
    17  	tests := []struct {
    18  		name     string
    19  		input    database.Database
    20  		expected bool
    21  	}{
    22  		{
    23  			name: "MySQL server public access enabled",
    24  			input: database.Database{
    25  				MySQLServers: []database.MySQLServer{
    26  					{
    27  						Metadata: defsecTypes.NewTestMetadata(),
    28  						Server: database.Server{
    29  							Metadata:                  defsecTypes.NewTestMetadata(),
    30  							EnablePublicNetworkAccess: defsecTypes.Bool(true, defsecTypes.NewTestMetadata()),
    31  						},
    32  					},
    33  				},
    34  			},
    35  			expected: true,
    36  		},
    37  		{
    38  			name: "MariaDB server public access enabled",
    39  			input: database.Database{
    40  				MariaDBServers: []database.MariaDBServer{
    41  					{
    42  						Metadata: defsecTypes.NewTestMetadata(),
    43  						Server: database.Server{
    44  							Metadata:                  defsecTypes.NewTestMetadata(),
    45  							EnablePublicNetworkAccess: defsecTypes.Bool(true, defsecTypes.NewTestMetadata()),
    46  						},
    47  					},
    48  				},
    49  			},
    50  			expected: true,
    51  		},
    52  		{
    53  			name: "MS SQL server public access enabled",
    54  			input: database.Database{
    55  				MSSQLServers: []database.MSSQLServer{
    56  					{
    57  						Metadata: defsecTypes.NewTestMetadata(),
    58  						Server: database.Server{
    59  							Metadata:                  defsecTypes.NewTestMetadata(),
    60  							EnablePublicNetworkAccess: defsecTypes.Bool(true, defsecTypes.NewTestMetadata()),
    61  						},
    62  					},
    63  				},
    64  			},
    65  			expected: true,
    66  		},
    67  		{
    68  			name: "PostgreSQL server public access enabled",
    69  			input: database.Database{
    70  				PostgreSQLServers: []database.PostgreSQLServer{
    71  					{
    72  						Metadata: defsecTypes.NewTestMetadata(),
    73  						Server: database.Server{
    74  							Metadata:                  defsecTypes.NewTestMetadata(),
    75  							EnablePublicNetworkAccess: defsecTypes.Bool(true, defsecTypes.NewTestMetadata()),
    76  						},
    77  					},
    78  				},
    79  			},
    80  			expected: true,
    81  		},
    82  		{
    83  			name: "MySQL server public access disabled",
    84  			input: database.Database{
    85  				MySQLServers: []database.MySQLServer{
    86  					{
    87  						Metadata: defsecTypes.NewTestMetadata(),
    88  						Server: database.Server{
    89  							Metadata:                  defsecTypes.NewTestMetadata(),
    90  							EnablePublicNetworkAccess: defsecTypes.Bool(false, defsecTypes.NewTestMetadata()),
    91  						},
    92  					},
    93  				},
    94  			},
    95  			expected: false,
    96  		},
    97  		{
    98  			name: "MariaDB server public access disabled",
    99  			input: database.Database{
   100  				MariaDBServers: []database.MariaDBServer{
   101  					{
   102  						Metadata: defsecTypes.NewTestMetadata(),
   103  						Server: database.Server{
   104  							Metadata:                  defsecTypes.NewTestMetadata(),
   105  							EnablePublicNetworkAccess: defsecTypes.Bool(false, defsecTypes.NewTestMetadata()),
   106  						},
   107  					},
   108  				},
   109  			},
   110  			expected: false,
   111  		},
   112  		{
   113  			name: "MS SQL server public access disabled",
   114  			input: database.Database{
   115  				MSSQLServers: []database.MSSQLServer{
   116  					{
   117  						Metadata: defsecTypes.NewTestMetadata(),
   118  						Server: database.Server{
   119  							Metadata:                  defsecTypes.NewTestMetadata(),
   120  							EnablePublicNetworkAccess: defsecTypes.Bool(false, defsecTypes.NewTestMetadata()),
   121  						},
   122  					},
   123  				},
   124  			},
   125  			expected: false,
   126  		},
   127  		{
   128  			name: "PostgreSQL server public access disabled",
   129  			input: database.Database{
   130  				PostgreSQLServers: []database.PostgreSQLServer{
   131  					{
   132  						Metadata: defsecTypes.NewTestMetadata(),
   133  						Server: database.Server{
   134  							Metadata:                  defsecTypes.NewTestMetadata(),
   135  							EnablePublicNetworkAccess: defsecTypes.Bool(false, defsecTypes.NewTestMetadata()),
   136  						},
   137  					},
   138  				},
   139  			},
   140  			expected: false,
   141  		},
   142  	}
   143  	for _, test := range tests {
   144  		t.Run(test.name, func(t *testing.T) {
   145  			var testState state.State
   146  			testState.Azure.Database = test.input
   147  			results := CheckNoPublicAccess.Evaluate(&testState)
   148  			var found bool
   149  			for _, result := range results {
   150  				if result.Status() == scan.StatusFailed && result.Rule().LongID() == CheckNoPublicAccess.Rule().LongID() {
   151  					found = true
   152  				}
   153  			}
   154  			if test.expected {
   155  				assert.True(t, found, "Rule should have been found")
   156  			} else {
   157  				assert.False(t, found, "Rule should not have been found")
   158  			}
   159  		})
   160  	}
   161  }