Function TestInsertWorkspaceAgentDevcontainers

coderd/database/querier_test.go:10695–10790

Our `InsertWorkspaceAgentDevcontainers` query should ideally be `[]uuid.NullUUID` but unfortunately sqlc infers it as `[]uuid.UUID`. To ensure we don't insert a `uuid.Nil`, the query inserts NULL when passed with `uuid.Nil`. This test ensures we keep this behavior without regression.

(t *testing.T)

// sqlc infers it as `[]uuid.UUID`. To ensure we don't insert a `uuid.Nil`, the query inserts NULL when
// passed with `uuid.Nil`. This test ensures we keep this behavior without regression.
func TestInsertWorkspaceAgentDevcontainers(t *testing.T) {
	t.Parallel()

	testCases := []struct {
		name          string
		validSubagent []bool
	}{
		{"BothValid", []bool{true, true}},
		{"FirstValidSecondInvalid", []bool{true, false}},
		{"FirstInvalidSecondValid", []bool{false, true}},
		{"BothInvalid", []bool{false, false}},
	}

	for _, tc := range testCases {
		t.Run(tc.name, func(t *testing.T) {
			t.Parallel()

			var (
				db, _ = dbtestutil.NewDB(t)
				org   = dbgen.Organization(t, db, database.Organization{})
				job   = dbgen.ProvisionerJob(t, db, nil, database.ProvisionerJob{
					Type:           database.ProvisionerJobTypeTemplateVersionImport,
					OrganizationID: org.ID,
				})
				resource = dbgen.WorkspaceResource(t, db, database.WorkspaceResource{JobID: job.ID})
				agent    = dbgen.WorkspaceAgent(t, db, database.WorkspaceAgent{ResourceID: resource.ID})
			)

			ids := make([]uuid.UUID, len(tc.validSubagent))
			names := make([]string, len(tc.validSubagent))
			workspaceFolders := make([]string, len(tc.validSubagent))
			configPaths := make([]string, len(tc.validSubagent))
			subagentIDs := make([]uuid.UUID, len(tc.validSubagent))

			for i, valid := range tc.validSubagent {
				ids[i] = uuid.New()
				names[i] = fmt.Sprintf("test-devcontainer-%d", i)
				workspaceFolders[i] = fmt.Sprintf("/workspace%d", i)
				configPaths[i] = fmt.Sprintf("/workspace%d/.devcontainer/devcontainer.json", i)

				if valid {
					subagentIDs[i] = dbgen.WorkspaceAgent(t, db, database.WorkspaceAgent{
						ResourceID: resource.ID,
						ParentID:   uuid.NullUUID{UUID: agent.ID, Valid: true},
					}).ID
				} else {
					subagentIDs[i] = uuid.Nil
				}
			}

			ctx := testutil.Context(t, testutil.WaitShort)

			// Given: We insert multiple devcontainer records.
			devcontainers, err := db.InsertWorkspaceAgentDevcontainers(ctx, database.InsertWorkspaceAgentDevcontainersParams{
				WorkspaceAgentID: agent.ID,
				CreatedAt:        dbtime.Now(),
				ID:               ids,
				Name:             names,