fix a query

sreya · sreya · commit 34641d17dbda · 2023-06-14T20:39:10.000Z
diff --git a/coderd/database/modelqueries.go b/coderd/database/modelqueries.go
@@ -54,7 +54,7 @@ func (q *sqlQuerier) GetAuthorizedTemplates(ctx context.Context, arg GetTemplate
 		pq.Array(arg.IDs),
 	)
 	if err != nil {
-		return nil, err
+		return nil, xerrors.Errorf("query context: %w", err)
 	}
 	defer rows.Close()
 	var items []Template
@@ -82,16 +82,17 @@ func (q *sqlQuerier) GetAuthorizedTemplates(ctx context.Context, arg GetTemplate
 			&i.AllowUserAutostop,
 			&i.FailureTTL,
 			&i.InactivityTTL,
+			&i.LockedTTL,
 		); err != nil {
-			return nil, err
+			return nil, xerrors.Errorf("scan: %w", err)
 		}
 		items = append(items, i)
 	}
 	if err := rows.Close(); err != nil {
-		return nil, err
+		return nil, xerrors.Errorf("close: %w", err)
 	}
 	if err := rows.Err(); err != nil {
-		return nil, err
+		return nil, xerrors.Errorf("rows err: %w", err)
 	}
 	return items, nil
 }

Original file line number	Diff line number	Diff line change
`@@ -54,7 +54,7 @@ func (q *sqlQuerier) GetAuthorizedTemplates(ctx context.Context, arg GetTemplate`
`54`	`54`	`pq.Array(arg.IDs),`
`55`	`55`	`)`
`56`	`56`	`if err != nil {`
`57`		`- return nil, err`
	`57`	`+ return nil, xerrors.Errorf("query context: %w", err)`
`58`	`58`	`}`
`59`	`59`	`defer rows.Close()`
`60`	`60`	`var items []Template`
`@@ -82,16 +82,17 @@ func (q *sqlQuerier) GetAuthorizedTemplates(ctx context.Context, arg GetTemplate`
`82`	`82`	`&i.AllowUserAutostop,`
`83`	`83`	`&i.FailureTTL,`
`84`	`84`	`&i.InactivityTTL,`
	`85`	`+ &i.LockedTTL,`
`85`	`86`	`); err != nil {`
`86`		`- return nil, err`
	`87`	`+ return nil, xerrors.Errorf("scan: %w", err)`
`87`	`88`	`}`
`88`	`89`	`items = append(items, i)`
`89`	`90`	`}`
`90`	`91`	`if err := rows.Close(); err != nil {`
`91`		`- return nil, err`
	`92`	`+ return nil, xerrors.Errorf("close: %w", err)`
`92`	`93`	`}`
`93`	`94`	`if err := rows.Err(); err != nil {`
`94`		`- return nil, err`
	`95`	`+ return nil, xerrors.Errorf("rows err: %w", err)`
`95`	`96`	`}`
`96`	`97`	`return items, nil`
`97`	`98`	`}`