Commit9bcff30

authored

fix(coderd/database): migrate workspaces.last_used_at to timestamptz (#9699)

1 parent1f5eb08 commit9bcff30Copy full SHA for 9bcff30

File tree

+13

-10

lines changed

+13

-10

lines changed

Lines changed: 1 addition & 1 deletion

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

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,6 @@`
	`1`	`+ALTERTABLE ONLY workspaces`
	`2`	`+ALTER COLUMN last_used_at`
	`3`	`+SET DATA TYPEtimestamp`
	`4`	`+USING last_used_at::timestamptz ATTIME ZONE'UTC',`
	`5`	`+ALTER COLUMN last_used_at`
	`6`	`+SET DEFAULT'0001-01-01 00:00:00'::timestamp;`

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,6 @@`
	`1`	`+ALTERTABLE ONLY workspaces`
	`2`	`+ALTER COLUMN last_used_at`
	`3`	`+SET DATA TYPEtimestamptz`
	`4`	`+USING last_used_at::timestamp ATTIME ZONE'UTC',`
	`5`	`+ALTER COLUMN last_used_at`
	`6`	`+SET DEFAULT'0001-01-01 00:00:00+00:00'::timestamptz;`

Lines changed: 0 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1515,12 +1515,8 @@ func TestWorkspaceFilterManual(t *testing.T) {`
`1515`	`1515`	`t.Run("LastUsed",func(t*testing.T) {`
`1516`	`1516`	`t.Parallel()`
`1517`	`1517`
`1518`		`-// nolint:gocritic // https://github.com/coder/coder/issues/9682`
`1519`		`-db,ps:=dbtestutil.NewDB(t,dbtestutil.WithTimezone("UTC"))`
`1520`	`1518`	`client,_,api:=coderdtest.NewWithAPI(t,&coderdtest.Options{`
`1521`	`1519`	`IncludeProvisionerDaemon:true,`
`1522`		`-Database:db,`
`1523`		`-Pubsub:ps,`
`1524`	`1520`	`})`
`1525`	`1521`	`user:=coderdtest.CreateFirstUser(t,client)`
`1526`	`1522`	`authToken:=uuid.NewString()`

Lines changed: 0 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,6 @@ import (`
`13`	`13`	`"github.com/coder/coder/v2/coderd/audit"`
`14`	`14`	`"github.com/coder/coder/v2/coderd/coderdtest"`
`15`	`15`	`"github.com/coder/coder/v2/coderd/database"`
`16`		`-"github.com/coder/coder/v2/coderd/database/dbtestutil"`
`17`	`16`	`"github.com/coder/coder/v2/coderd/rbac"`
`18`	`17`	`"github.com/coder/coder/v2/codersdk"`
`19`	`18`	`"github.com/coder/coder/v2/cryptorand"`
`@@ -369,14 +368,10 @@ func TestTemplates(t *testing.T) {`
`369`	`368`	`t.Run("UpdateLastUsedAt",func(t*testing.T) {`
`370`	`369`	`t.Parallel()`
`371`	`370`
`372`		`-// nolint:gocritic // https://github.com/coder/coder/issues/9682`
`373`		`-db,ps:=dbtestutil.NewDB(t,dbtestutil.WithTimezone("UTC"))`
`374`	`371`	`ctx:=testutil.Context(t,testutil.WaitMedium)`
`375`	`372`	`client,user:=coderdenttest.New(t,&coderdenttest.Options{`
`376`	`373`	`Options:&coderdtest.Options{`
`377`	`374`	`IncludeProvisionerDaemon:true,`
`378`		`-Database:db,`
`379`		`-Pubsub:ps,`
`380`	`375`	`},`
`381`	`376`	`LicenseOptions:&coderdenttest.LicenseOptions{`
`382`	`377`	`Features: license.Features{`

Comments

(0)