save

coder · f0ssel · Jul 16, 2024 · Jul 9, 2024 · Jul 9, 2024 · Jul 11, 2024
commit e5f73112c5d4be584cf720c587d3ba187a27112c
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