Commitb81d846

authored

fix: audit log query when Postgres TZ isn't UTC (coder#6067)

1 parentd9e22d7 commitb81d846Copy full SHA for b81d846

File tree

-16

lines changed

-16

lines changed

Lines changed: 3 additions & 12 deletions

Original file line number	Diff line number	Diff line change
`@@ -57,19 +57,10 @@ func (api API) auditLogs(rw http.ResponseWriter, r http.Request) {`
`57`	`57`	`})`
`58`	`58`	`return`
`59`	`59`	`}`
	`60`	`+filter.Offset=int32(page.Offset)`
	`61`	`+filter.Limit=int32(page.Limit)`
`60`	`62`
`61`		`-dblogs,err:=api.Database.GetAuditLogsOffset(ctx, database.GetAuditLogsOffsetParams{`
`62`		`-Offset:int32(page.Offset),`
`63`		`-Limit:int32(page.Limit),`
`64`		`-ResourceType:filter.ResourceType,`
`65`		`-ResourceID:filter.ResourceID,`
`66`		`-Action:filter.Action,`
`67`		`-Username:filter.Username,`
`68`		`-Email:filter.Email,`
`69`		`-DateFrom:filter.DateFrom,`
`70`		`-DateTo:filter.DateTo,`
`71`		`-BuildReason:filter.BuildReason,`
`72`		`-})`
	`63`	`+dblogs,err:=api.Database.GetAuditLogsOffset(ctx,filter)`
`73`	`64`	`iferr!=nil {`
`74`	`65`	`httpapi.InternalServerError(rw,err)`
`75`	`66`	`return`

Lines changed: 2 additions & 2 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -76,13 +76,13 @@ WHERE`
`76`	`76`	`END`
`77`	`77`	`-- Filter by date_from`
`78`	`78`	`AND CASE`
`79`		`-WHEN @date_from ::timestamp with time zone!='0001-01-01 00:00:00' THEN`
	`79`	`+WHEN @date_from ::timestamp with time zone!='0001-01-01 00:00:00Z' THEN`
`80`	`80`	`"time">= @date_from`
`81`	`81`	`ELSE true`
`82`	`82`	`END`
`83`	`83`	`-- Filter by date_to`
`84`	`84`	`AND CASE`
`85`		`-WHEN @date_to ::timestamp with time zone!='0001-01-01 00:00:00' THEN`
	`85`	`+WHEN @date_to ::timestamp with time zone!='0001-01-01 00:00:00Z' THEN`
`86`	`86`	`"time"<= @date_to`
`87`	`87`	`ELSE true`
`88`	`88`	`END`

Comments

(0)