github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/rules/cloud/policies/google/sql/enable_pg_temp_file_logging_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 TestCheckEnablePgTempFileLogging(t *testing.T) {
    17  	tests := []struct {
    18  		name     string
    19  		input    sql.SQL
    20  		expected bool
    21  	}{
    22  		{
    23  			name: "Instance temp files logging disabled for all files",
    24  			input: sql.SQL{
    25  				Instances: []sql.DatabaseInstance{
    26  					{
    27  						Metadata:        defsecTypes.NewTestMetadata(),
    28  						DatabaseVersion: defsecTypes.String("POSTGRES_12", defsecTypes.NewTestMetadata()),
    29  						Settings: sql.Settings{
    30  							Metadata: defsecTypes.NewTestMetadata(),
    31  							Flags: sql.Flags{
    32  								Metadata:        defsecTypes.NewTestMetadata(),
    33  								LogTempFileSize: defsecTypes.Int(-1, defsecTypes.NewTestMetadata()),
    34  							},
    35  						},
    36  					},
    37  				},
    38  			},
    39  			expected: true,
    40  		},
    41  		{
    42  			name: "Instance temp files logging disabled for files smaller than 100KB",
    43  			input: sql.SQL{
    44  				Instances: []sql.DatabaseInstance{
    45  					{
    46  						Metadata:        defsecTypes.NewTestMetadata(),
    47  						DatabaseVersion: defsecTypes.String("POSTGRES_12", defsecTypes.NewTestMetadata()),
    48  						Settings: sql.Settings{
    49  							Metadata: defsecTypes.NewTestMetadata(),
    50  							Flags: sql.Flags{
    51  								Metadata:        defsecTypes.NewTestMetadata(),
    52  								LogTempFileSize: defsecTypes.Int(100, defsecTypes.NewTestMetadata()),
    53  							},
    54  						},
    55  					},
    56  				},
    57  			},
    58  			expected: true,
    59  		},
    60  		{
    61  			name: "Instance temp files logging enabled for all files",
    62  			input: sql.SQL{
    63  				Instances: []sql.DatabaseInstance{
    64  					{
    65  						Metadata:        defsecTypes.NewTestMetadata(),
    66  						DatabaseVersion: defsecTypes.String("POSTGRES_12", defsecTypes.NewTestMetadata()),
    67  						Settings: sql.Settings{
    68  							Metadata: defsecTypes.NewTestMetadata(),
    69  							Flags: sql.Flags{
    70  								Metadata:        defsecTypes.NewTestMetadata(),
    71  								LogTempFileSize: defsecTypes.Int(0, defsecTypes.NewTestMetadata()),
    72  							},
    73  						},
    74  					},
    75  				},
    76  			},
    77  			expected: false,
    78  		},
    79  	}
    80  	for _, test := range tests {
    81  		t.Run(test.name, func(t *testing.T) {
    82  			var testState state.State
    83  			testState.Google.SQL = test.input
    84  			results := CheckEnablePgTempFileLogging.Evaluate(&testState)
    85  			var found bool
    86  			for _, result := range results {
    87  				if result.Status() == scan.StatusFailed && result.Rule().LongID() == CheckEnablePgTempFileLogging.Rule().LongID() {
    88  					found = true
    89  				}
    90  			}
    91  			if test.expected {
    92  				assert.True(t, found, "Rule should have been found")
    93  			} else {
    94  				assert.False(t, found, "Rule should not have been found")
    95  			}
    96  		})
    97  	}
    98  }