Commitd3baa06

committed

add fixture

1 parent7cd8420 commitd3baa06Copy full SHA for d3baa06

File tree

+30

-0

lines changed

coderd/database/migrations/testdata/fixtures
- 000203_template_usage_stats.up.sql

+30

-0

lines changed

Lines changed: 30 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,30 @@`
	`1`	`+INSERT INTO`
	`2`	`+template_usage_stats (`
	`3`	`+start_time,`
	`4`	`+end_time,`
	`5`	`+template_id,`
	`6`	`+user_id,`
	`7`	`+median_latency_ms,`
	`8`	`+usage_mins,`
	`9`	`+ssh_mins,`
	`10`	`+sftp_mins,`
	`11`	`+reconnecting_pty_mins,`
	`12`	`+vscode_mins,`
	`13`	`+jetbrains_mins,`
	`14`	`+app_usage_mins`
	`15`	`+)`
	`16`	`+VALUES`
	`17`	`+(`
	`18`	`+date_trunc('hour', NOW()),`
	`19`	`+date_trunc('hour', NOW())+'30 minute'::interval,`
	`20`	`+gen_random_uuid(),`
	`21`	`+gen_random_uuid(),`
	`22`	`+45.342::real,`
	`23`	`+30,-- usage`
	`24`	`+30,-- ssh`
	`25`	`+5,-- sftp`
	`26`	`+2,-- reconnecting_pty`
	`27`	`+10,-- vscode`
	`28`	`+10,-- jetbrains`
	`29`	`+'{"[terminal]": 2, "code-server": 30}'::jsonb`
	`30`	`+);`

Comments

(0)