fixup! chore: Ensure Authorized SQL clause

Emyrk · Emyrk · commit 13e938ca5774 · 2022-11-04T16:39:52.000-05:00
diff --git a/coderd/database/modelqueries.go b/coderd/database/modelqueries.go
@@ -203,6 +203,6 @@ func insertAuthorizedFilter(query string, authorizedFilter rbac.AuthorizeFilter,
 	if !strings.Contains(query, replace) {
 		return "", xerrors.Errorf("query does not contain authorized replace string, this is not an authorized query")
 	}
-	filter := strings.Replace(getWorkspaces, "-- @authorize_filter", fmt.Sprintf(" AND %s", authorizedFilter.SQLString(config)), 1)
+	filter := strings.Replace(getWorkspaces, replace, fmt.Sprintf(" AND %s", authorizedFilter.SQLString(config)), 1)
 	return filter, nil
 }

Original file line number	Diff line number	Diff line change
`@@ -203,6 +203,6 @@ func insertAuthorizedFilter(query string, authorizedFilter rbac.AuthorizeFilter,`
`203`	`203`	`if !strings.Contains(query, replace) {`
`204`	`204`	`return "", xerrors.Errorf("query does not contain authorized replace string, this is not an authorized query")`
`205`	`205`	`}`
`206`		`- filter := strings.Replace(getWorkspaces, "-- @authorize_filter", fmt.Sprintf(" AND %s", authorizedFilter.SQLString(config)), 1)`
	`206`	`+ filter := strings.Replace(getWorkspaces, replace, fmt.Sprintf(" AND %s", authorizedFilter.SQLString(config)), 1)`
`207`	`207`	`return filter, nil`
`208`	`208`	`}`