github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/rules/cloud/policies/google/sql/no_cross_db_ownership_chaining_test.go (about)

     1  package sql
     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/google/sql"
    11  	"github.com/khulnasoft-lab/defsec/pkg/scan"
    12  
    13  	"github.com/stretchr/testify/assert"
    14  )
    15  
    16  func TestCheckNoCrossDbOwnershipChaining(t *testing.T) {
    17  	tests := []struct {
    18  		name     string
    19  		input    sql.SQL
    20  		expected bool
    21  	}{
    22  		{
    23  			name: "Instance cross database ownership chaining enabled",
    24  			input: sql.SQL{
    25  				Instances: []sql.DatabaseInstance{
    26  					{
    27  						Metadata:        defsecTypes.NewTestMetadata(),
    28  						DatabaseVersion: defsecTypes.String("SQLSERVER_2017_STANDARD", defsecTypes.NewTestMetadata()),
    29  						Settings: sql.Settings{
    30  							Metadata: defsecTypes.NewTestMetadata(),
    31  							Flags: sql.Flags{
    32  								Metadata:                 defsecTypes.NewTestMetadata(),
    33  								CrossDBOwnershipChaining: defsecTypes.Bool(true, defsecTypes.NewTestMetadata()),
    34  							},
    35  						},
    36  					},
    37  				},
    38  			},
    39  			expected: true,
    40  		},
    41  		{
    42  			name: "Instance cross database ownership chaining disabled",
    43  			input: sql.SQL{
    44  				Instances: []sql.DatabaseInstance{
    45  					{
    46  						Metadata:        defsecTypes.NewTestMetadata(),
    47  						DatabaseVersion: defsecTypes.String("SQLSERVER_2017_STANDARD", defsecTypes.NewTestMetadata()),
    48  						Settings: sql.Settings{
    49  							Metadata: defsecTypes.NewTestMetadata(),
    50  							Flags: sql.Flags{
    51  								Metadata:                 defsecTypes.NewTestMetadata(),
    52  								CrossDBOwnershipChaining: defsecTypes.Bool(false, defsecTypes.NewTestMetadata()),
    53  							},
    54  						},
    55  					},
    56  				},
    57  			},
    58  			expected: false,
    59  		},
    60  	}
    61  	for _, test := range tests {
    62  		t.Run(test.name, func(t *testing.T) {
    63  			var testState state.State
    64  			testState.Google.SQL = test.input
    65  			results := CheckNoCrossDbOwnershipChaining.Evaluate(&testState)
    66  			var found bool
    67  			for _, result := range results {
    68  				if result.Status() == scan.StatusFailed && result.Rule().LongID() == CheckNoCrossDbOwnershipChaining.Rule().LongID() {
    69  					found = true
    70  				}
    71  			}
    72  			if test.expected {
    73  				assert.True(t, found, "Rule should have been found")
    74  			} else {
    75  				assert.False(t, found, "Rule should not have been found")
    76  			}
    77  		})
    78  	}
    79  }