/
resource_acctest.go
79 lines (69 loc) · 2.42 KB
/
resource_acctest.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
package azureADUser
import (
"database/sql"
"fmt"
"github.com/PGSSoft/terraform-provider-mssql/internal/acctest"
"github.com/hashicorp/terraform-plugin-sdk/v2/helper/resource"
"github.com/hashicorp/terraform-plugin-sdk/v2/terraform"
"strings"
)
func testResource(testCtx *acctest.TestContext) {
if !testCtx.IsAzureTest {
return
}
var userId int
var userResourceId string
newResource := func(resourceName string, name string) string {
return fmt.Sprintf(`
resource "mssql_azuread_user" %[1]q {
name = %[2]q
database_id = %[4]d
user_object_id = %[3]q
}
`, resourceName, name, testCtx.AzureADTestGroup.Id, testCtx.DefaultDBId)
}
testCtx.Test(resource.TestCase{
Steps: []resource.TestStep{
{
Config: newResource("test_user", "test_aad_user"),
Check: resource.ComposeTestCheckFunc(
testCtx.SqlCheckDefaultDB(func(db *sql.DB) error {
if err := db.QueryRow("SELECT principal_id FROM sys.database_principals WHERE [name] = 'test_aad_user'").Scan(&userId); err != nil {
return err
}
userResourceId = fmt.Sprintf("%d/%d", testCtx.DefaultDBId, userId)
return nil
}),
resource.ComposeAggregateTestCheckFunc(
resource.TestCheckResourceAttrPtr("mssql_azuread_user.test_user", "id", &userResourceId),
testCtx.SqlCheckDefaultDB(func(db *sql.DB) error {
var userType, userSid string
err := db.QueryRow("SELECT [type], CONVERT(VARCHAR(36), CONVERT(UNIQUEIDENTIFIER, [sid], 1), 1) FROM sys.database_principals WHERE principal_id = @p1", userId).
Scan(&userType, &userSid)
testCtx.Assert.Equal("E", strings.ToUpper(userType), "user type")
testCtx.Assert.Equal(strings.ToUpper(testCtx.AzureADTestGroup.Id), strings.ToUpper(userSid), "user SID")
return err
}),
),
),
},
{
ResourceName: "mssql_azuread_user.test_user",
ImportState: true,
ImportStateIdFunc: func(*terraform.State) (string, error) {
return userResourceId, nil
},
ImportStateCheck: func(states []*terraform.InstanceState) error {
for _, state := range states {
if state.ID == userResourceId {
testCtx.Assert.Equal("test_aad_user", state.Attributes["name"])
testCtx.Assert.Equal(fmt.Sprint(testCtx.DefaultDBId), state.Attributes["database_id"])
testCtx.Assert.Equal(strings.ToUpper(testCtx.AzureADTestGroup.Id), strings.ToUpper(state.Attributes["user_object_id"]))
}
}
return nil
},
},
},
})
}