save

f0ssel · f0ssel · commit 06cbfd15bb2a · 2024-07-15T21:13:39.000Z
diff --git a/coderd/database/migrations/000226_provisioner_keys.up.sql b/coderd/database/migrations/000226_provisioner_keys.up.sql
@@ -4,5 +4,6 @@ CREATE TABLE provisioner_keys (
     organization_id uuid NOT NULL REFERENCES organizations (id) ON DELETE CASCADE,
     name varchar(64) NOT NULL,
     hashed_secret bytea NOT NULL,
-    UNIQUE (organization_id, name)
 );
+
+CREATE INDEX provisioner_keys_organization_id_name_idx ON provisioner_keys (organization_id, name);
diff --git a/coderd/database/modelmethods.go b/coderd/database/modelmethods.go
@@ -218,12 +218,6 @@ func (p ProvisionerKey) RBACObject() rbac.Object {
 		InOrg(p.OrganizationID)
 }
 
-func (p ListProvisionerKeysByOrganizationRow) RBACObject() rbac.Object {
-	return rbac.ResourceProvisionerKeys.
-		WithID(p.ID).
-		InOrg(p.OrganizationID)
-}
-
 func (w WorkspaceProxy) RBACObject() rbac.Object {
 	return rbac.ResourceWorkspaceProxy.
 		WithID(w.ID)
diff --git a/coderd/database/queries/provisionerkeys.sql b/coderd/database/queries/provisionerkeys.sql
@@ -8,7 +8,7 @@ INSERT INTO
 		hashed_secret
 	)
 VALUES
-	($1, $2, $3, $4, $5) RETURNING *;
+	($1, $2, $3, lower($4), $5) RETURNING *;
 
 -- name: GetProvisionerKeyByID :one
 SELECT

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@ INSERT INTO`
`8`	`8`	`hashed_secret`
`9`	`9`	`)`
`10`	`10`	`VALUES`
`11`		`- ($1, $2, $3, $4, $5) RETURNING *;`
	`11`	`+ ($1, $2, $3, lower($4), $5) RETURNING *;`
`12`	`12`
`13`	`13`	`-- name: GetProvisionerKeyByID :one`
`14`	`14`	`SELECT`