Skip to content

feat(coderd/database/dbtestutil): set default database timezone to non-UTC in unit tests #9672

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 17 commits into from
Sep 15, 2023
Merged

feat(coderd/database/dbtestutil): set default database timezone to non-UTC in unit tests #9672

Changes from 1 commit
Commits
Show all changes
17 commits
Select commit Hold shift + click to select a range
355b16b
feat(coderd/database/dbtestutil): set a random timezone in the db
johnstcn Sep 13, 2023
986db8b
remove check for tz after set
johnstcn Sep 14, 2023
fc3ba52
clitest: fix timestamp regex to match non-UTC timezones
johnstcn Sep 14, 2023
b3c559a
set fixed timezone in some existing unit tests
johnstcn Sep 14, 2023
f57dc9d
fixup! set fixed timezone in some existing unit tests
johnstcn Sep 14, 2023
d3d1274
fix timezone bug in ActivityBumpWorkspace query
johnstcn Sep 14, 2023
9f1f5c6
refactor to separate package, allow specifying tz
johnstcn Sep 14, 2023
7c2ff2f
set db timezone to canada/newfoundland by default
johnstcn Sep 14, 2023
eecfcdb
test activity bump in multiple timezones
johnstcn Sep 14, 2023
d327131
remove unnecessary IN TIME ZONE UTC in activitybump query
johnstcn Sep 14, 2023
7680984
clarify use of multiple timezones in test
johnstcn Sep 14, 2023
d051bbb
remove deprecation and add linter rule
johnstcn Sep 14, 2023
da059dc
fix typo
johnstcn Sep 14, 2023
0d425ba
bump allowed withinDuration for TestWorkpaceActivityBump
johnstcn Sep 14, 2023
d97ff2f
make Test_ActivityBumpWorkspace more flake-resistant
johnstcn Sep 14, 2023
f18c6b5
replace conditional sleep with a slower unconditional sleep that shou…
johnstcn Sep 14, 2023
5a8aa8b
modify logic slightly in TestWorkspaceActivityBump from "deadline mus…
johnstcn Sep 14, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
replace conditional sleep with a slower unconditional sleep that shou… 
…ld hopefully be greater than win32 max timer resolution
  • Loading branch information
@johnstcn
johnstcn committed Sep 14, 2023
commit f18c6b503448e9ae5d5d761375b9bba54ece2e55
14 changes: 4 additions & 10 deletions coderd/activitybump_internal_test.go
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -2,7 +2,6 @@ package coderd

import (
"database/sql"
"runtime"
"testing"
"time"

Expand Down Expand Up @@ -188,7 +187,10 @@ func Test_ActivityBumpWorkspace(t *testing.T) {
require.Equal(t, maxDeadline.UTC(), bld.MaxDeadline.UTC(), "unexpected max deadline before bump")
require.Equal(t, tt.workspaceTTL, time.Duration(ws.Ttl.Int64), "unexpected workspace TTL before bump")

workaroundWindowsTimeResolution(t)
// Wait a bit before bumping as dbtime is rounded to the nearest millisecond.
// This should also hopefully be enough for Windows time resolution to register
// a tick (win32 max timer resolution is apparently between 0.5 and 15.6ms)
<-time.After(testutil.IntervalFast)

// Bump duration is measured from the time of the bump, so we measure from here.
start := dbtime.Now()
Expand Down Expand Up @@ -237,11 +239,3 @@ func insertPrevWorkspaceBuild(t *testing.T, db database.Store, orgID, tvID, work
Transition: transition,
})
}

func workaroundWindowsTimeResolution(t *testing.T) {
t.Helper()
if runtime.GOOS == "windows" {
t.Logf("workaround: sleeping for a short time to avoid time resolution issues on Windows")
<-time.After(testutil.IntervalSlow)
}
}