coder
diff --git a/‎coderd/database/dbauthz/dbauthz.go
Lines changed: 1 addition & 1 deletion b/‎coderd/database/dbauthz/dbauthz.go
Lines changed: 1 addition & 1 deletion
diff --git a/‎coderd/database/dbauthz/dbauthz_test.go
Lines changed: 6 additions & 0 deletions b/‎coderd/database/dbauthz/dbauthz_test.go
Lines changed: 6 additions & 0 deletions
diff --git a/‎coderd/database/dbmem/dbmem.go
Lines changed: 35 additions & 1 deletion b/‎coderd/database/dbmem/dbmem.go
Lines changed: 35 additions & 1 deletion
@@ -2414,7 +2414,7 @@ func (q *querier) GetUserNotificationPreferences(ctx context.Context, userID uui
 }
 
 func (q *querier) GetUserStatusCountsByDay(ctx context.Context, arg database.GetUserStatusCountsByDayParams) ([]database.GetUserStatusCountsByDayRow, error) {
-	if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceSystem); err != nil {
+	if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceUser); err != nil {
 		return nil, err
 	}
 	return q.db.GetUserStatusCountsByDay(ctx, arg)
 
@@ -1490,6 +1490,12 @@ func (s *MethodTestSuite) TestUser() {
 			rbac.ResourceTemplate.InOrg(orgID), policy.ActionRead,
 		)
 	}))
+	s.Run("GetUserStatusCountsByDay", s.Subtest(func(db database.Store, check *expects) {
+		check.Args(database.GetUserStatusCountsByDayParams{
+			StartTime: time.Now().Add(-time.Hour * 24 * 30),
+			EndTime:   time.Now(),
+		}).Asserts(rbac.ResourceUser, policy.ActionRead)
+	}))
 }
 
 func (s *MethodTestSuite) TestWorkspace() {
 
@@ -88,6 +88,7 @@ func New() database.Store {
 			customRoles:               make([]database.CustomRole, 0),
 			locks:                     map[int64]struct{}{},
 			runtimeConfig:             map[string]string{},
+			userStatusChanges:         make([]database.UserStatusChange, 0),
 		},
 	}
 	// Always start with a default org. Matching migration 198.
@@ -256,6 +257,7 @@ type data struct {
 	lastLicenseID                    int32
 	defaultProxyDisplayName          string
 	defaultProxyIconURL              string
+	userStatusChanges                []database.UserStatusChange
 }
 
 func tryPercentile(fs []float64, p float64) float64 {
@@ -5673,7 +5675,21 @@ func (q *FakeQuerier) GetUserStatusCountsByDay(_ context.Context, arg database.G
 		return nil, err
 	}
 
-	panic("not implemented")
+	result := make([]database.GetUserStatusCountsByDayRow, 0)
+	for _, change := range q.userStatusChanges {
+		if change.ChangedAt.Before(arg.StartTime) || change.ChangedAt.After(arg.EndTime) {
+			continue
+		}
+		result = append(result, database.GetUserStatusCountsByDayRow{
+			Status: database.NullUserStatus{
+				UserStatus: change.NewStatus,
+				Valid:      true,
+			},
+			Count: 1,
+		})
+	}
+
+	return result, nil
 }
 
 func (q *FakeQuerier) GetUserWorkspaceBuildParameters(_ context.Context, params database.GetUserWorkspaceBuildParametersParams) ([]database.GetUserWorkspaceBuildParametersRow, error) {
@@ -8028,6 +8044,12 @@ func (q *FakeQuerier) InsertUser(_ context.Context, arg database.InsertUserParam
 	sort.Slice(q.users, func(i, j int) bool {
 		return q.users[i].CreatedAt.Before(q.users[j].CreatedAt)
 	})
+
+	q.userStatusChanges = append(q.userStatusChanges, database.UserStatusChange{
+		UserID:    user.ID,
+		NewStatus: user.Status,
+		ChangedAt: user.UpdatedAt,
+	})
 	return user, nil
 }
 
@@ -9064,12 +9086,18 @@ func (q *FakeQuerier) UpdateInactiveUsersToDormant(_ context.Context, params dat
 				Username:   user.Username,
 				LastSeenAt: user.LastSeenAt,
 			})
+			q.userStatusChanges = append(q.userStatusChanges, database.UserStatusChange{
+				UserID:    user.ID,
+				NewStatus: database.UserStatusDormant,
+				ChangedAt: params.UpdatedAt,
+			})
 		}
 	}
 
 	if len(updated) == 0 {
 		return nil, sql.ErrNoRows
 	}
+
 	return updated, nil
 }
 
@@ -9870,6 +9898,12 @@ func (q *FakeQuerier) UpdateUserStatus(_ context.Context, arg database.UpdateUse
 		user.Status = arg.Status
 		user.UpdatedAt = arg.UpdatedAt
 		q.users[index] = user
+
+		q.userStatusChanges = append(q.userStatusChanges, database.UserStatusChange{
+			UserID:    user.ID,
+			NewStatus: user.Status,
+			ChangedAt: user.UpdatedAt,
+		})
 		return user, nil
 	}
 	return database.User{}, sql.ErrNoRows
Original file line number	Diff line number	Diff line change
`@@ -2414,7 +2414,7 @@ func (q *querier) GetUserNotificationPreferences(ctx context.Context, userID uui`
`2414`	`2414`	`}`
`2415`	`2415`
`2416`	`2416`	`func (q *querier) GetUserStatusCountsByDay(ctx context.Context, arg database.GetUserStatusCountsByDayParams) ([]database.GetUserStatusCountsByDayRow, error) {`
`2417`		`- if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceSystem); err != nil {`
	`2417`	`+ if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceUser); err != nil {`
`2418`	`2418`	`return nil, err`
`2419`	`2419`	`}`
`2420`	`2420`	`return q.db.GetUserStatusCountsByDay(ctx, arg)`
Original file line number	Diff line number	Diff line change
`@@ -1490,6 +1490,12 @@ func (s *MethodTestSuite) TestUser() {`
`1490`	`1490`	`rbac.ResourceTemplate.InOrg(orgID), policy.ActionRead,`
`1491`	`1491`	`)`
`1492`	`1492`	`}))`
	`1493`	`+ s.Run("GetUserStatusCountsByDay", s.Subtest(func(db database.Store, check *expects) {`
	`1494`	`+ check.Args(database.GetUserStatusCountsByDayParams{`
	`1495`	`+ StartTime: time.Now().Add(-time.Hour * 24 * 30),`
	`1496`	`+ EndTime: time.Now(),`
	`1497`	`+ }).Asserts(rbac.ResourceUser, policy.ActionRead)`
	`1498`	`+ }))`
`1493`	`1499`	`}`
`1494`	`1500`
`1495`	`1501`	`func (s *MethodTestSuite) TestWorkspace() {`