github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/rules/cloud/policies/google/sql/pg_no_min_statement_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 TestCheckPgNoMinStatementLogging(t *testing.T) {
    17  	tests := []struct {
    18  		name     string
    19  		input    sql.SQL
    20  		expected bool
    21  	}{
    22  		{
    23  			name: "Instance logging enabled for all statements",
    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  								LogMinDurationStatement: defsecTypes.Int(0, defsecTypes.NewTestMetadata()),
    34  							},
    35  						},
    36  					},
    37  				},
    38  			},
    39  			expected: true,
    40  		},
    41  		{
    42  			name: "Instance logging disabled for all statements",
    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  								LogMinDurationStatement: defsecTypes.Int(-1, 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 := CheckPgNoMinStatementLogging.Evaluate(&testState)
    66  			var found bool
    67  			for _, result := range results {
    68  				if result.Status() == scan.StatusFailed && result.Rule().LongID() == CheckPgNoMinStatementLogging.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  }