-
Notifications
You must be signed in to change notification settings - Fork 9
/
resource_acctest.go
116 lines (100 loc) · 3.74 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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
package sqlUser
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"
)
func testResource(testCtx *acctest.TestContext) {
var userId, resourceId, loginId string
var createLogin = func(loginName string) string {
db := testCtx.GetMasterDBConnection()
_, err := db.Exec(fmt.Sprintf("CREATE LOGIN [%s] WITH PASSWORD='Pa$$w0rd12'", loginName))
testCtx.Require.NoError(err, "creating new login")
var id string
err = db.QueryRow("SELECT CONVERT(VARCHAR(85), [sid], 1) FROM sys.sql_logins WHERE [name]=@p1", loginName).Scan(&id)
testCtx.Require.NoError(err, "fetching login ID")
return id
}
var newResource = func(resourceName string, name string, loginName string) string {
return fmt.Sprintf(`
data "mssql_sql_login" %[1]q {
name = %[3]q
}
resource "mssql_sql_user" %[1]q {
name = %[2]q
database_id = %[4]d
login_id = data.mssql_sql_login.%[1]s.id
}
`, resourceName, name, loginName, testCtx.DefaultDBId)
}
defer testCtx.ExecMasterDB(`
DROP LOGIN [sqluser_test_login];
DROP LOGIN [renamed_login];
`)
testCtx.Test(resource.TestCase{
Steps: []resource.TestStep{
{
PreConfig: func() {
loginId = createLogin("sqluser_test_login")
},
Config: newResource("test_user", "test_user", "sqluser_test_login"),
Check: resource.ComposeTestCheckFunc(
testCtx.SqlCheckDefaultDB(func(db *sql.DB) error {
if err := db.QueryRow("SELECT USER_ID(@p1)", "test_user").Scan(&userId); err != nil {
return err
}
resourceId = fmt.Sprintf("%d/%s", testCtx.DefaultDBId, userId)
return nil
}),
resource.ComposeAggregateTestCheckFunc(
resource.TestCheckResourceAttrPtr("mssql_sql_user.test_user", "id", &resourceId),
resource.TestCheckResourceAttr("mssql_sql_user.test_user", "database_id", fmt.Sprint(testCtx.DefaultDBId)),
resource.TestCheckResourceAttrPtr("mssql_sql_user.test_user", "login_id", &loginId),
resource.TestCheckResourceAttr("mssql_sql_user.test_user", "name", "test_user"),
testCtx.SqlCheckDefaultDB(func(db *sql.DB) error {
var actualLoginId string
err := db.QueryRow("SELECT CONVERT(VARCHAR(85), [sid], 1) FROM sys.database_principals WHERE principal_id=@p1", userId).Scan(&actualLoginId)
testCtx.Assert.Equal(loginId, actualLoginId, "login ID")
return err
}),
),
),
},
{
PreConfig: func() {
loginId = createLogin("renamed_login")
},
Config: newResource("test_user", "renamed_user", "renamed_login"),
Check: resource.ComposeAggregateTestCheckFunc(
resource.TestCheckResourceAttrPtr("mssql_sql_user.test_user", "id", &resourceId),
resource.TestCheckResourceAttrPtr("mssql_sql_user.test_user", "login_id", &loginId),
resource.TestCheckResourceAttr("mssql_sql_user.test_user", "name", "renamed_user"),
testCtx.SqlCheckDefaultDB(func(db *sql.DB) error {
var actualName, actualLoginId string
err := db.QueryRow("SELECT [name], CONVERT(VARCHAR(85), [sid], 1) FROM sys.database_principals WHERE principal_id=@p1", userId).Scan(&actualName, &actualLoginId)
testCtx.Assert.Equal("renamed_user", actualName)
testCtx.Assert.Equal(loginId, actualLoginId)
return err
}),
),
},
{
ResourceName: "mssql_sql_user.test_user",
ImportState: true,
ImportStateIdFunc: func(state *terraform.State) (string, error) {
return resourceId, nil
},
ImportStateCheck: func(states []*terraform.InstanceState) error {
for _, state := range states {
if state.ID == resourceId {
testCtx.Assert.Equal("renamed_user", state.Attributes["name"])
}
}
return nil
},
},
},
})
}