windmill/backend/tests/fixtures/restrict_deploy_to_deployers.sql

-- Fixture for the RestrictDeployToDeployers protection rule test.
-- Uses a dedicated workspace id + dedicated token prefixes so the process-
-- global AUTH_CACHE and PROTECTION_RULES_CACHE lazy_statics don't race with
-- the parallel test_protection_rules test (which also uses test-workspace).

INSERT INTO workspace (id, name, owner) VALUES
    ('rdd-ws', 'Restrict Deploy WS', 'rdd-admin');

INSERT INTO workspace_key (workspace_id, kind, key) VALUES
    ('rdd-ws', 'cloud', 'rdd-key');

INSERT INTO workspace_settings (workspace_id) VALUES
    ('rdd-ws');

INSERT INTO group_ (workspace_id, name, summary, extra_perms) VALUES
    ('rdd-ws', 'all', 'All users', '{}'),
    ('rdd-ws', 'wm_deployers', 'Deployers', '{}');

INSERT INTO password(email, password_hash, login_type, super_admin, verified, name, username)
    VALUES ('rdd-admin@windmill.dev', 'x', 'password', true, true, 'RDD Admin', 'rdd-admin');
INSERT INTO password(email, password_hash, login_type, super_admin, verified, name)
    VALUES ('rdd-deployer@windmill.dev', 'x', 'password', false, true, 'RDD Deployer');
INSERT INTO password(email, password_hash, login_type, super_admin, verified, name)
    VALUES ('rdd-user@windmill.dev', 'x', 'password', false, true, 'RDD User');

INSERT INTO usr(workspace_id, email, username, is_admin, role) VALUES
    ('rdd-ws', 'rdd-admin@windmill.dev', 'rdd-admin', true, 'Admin'),
    ('rdd-ws', 'rdd-deployer@windmill.dev', 'rdd-deployer', false, 'User'),
    ('rdd-ws', 'rdd-user@windmill.dev', 'rdd-user', false, 'User');

INSERT INTO usr_to_group(workspace_id, group_, usr) VALUES
    ('rdd-ws', 'wm_deployers', 'rdd-deployer');

INSERT INTO token(token_hash, token_prefix, token, email, label, super_admin)
    VALUES (encode(sha256('RDD_ADMIN_TOKEN'::bytea), 'hex'), 'RDD_ADMIN_', 'RDD_ADMIN_TOKEN', 'rdd-admin@windmill.dev', 't', true);
INSERT INTO token(token_hash, token_prefix, token, email, label, super_admin)
    VALUES (encode(sha256('RDD_DEPLOYER_TOKEN'::bytea), 'hex'), 'RDD_DEPLOY', 'RDD_DEPLOYER_TOKEN', 'rdd-deployer@windmill.dev', 't', false);
INSERT INTO token(token_hash, token_prefix, token, email, label, super_admin)
    VALUES (encode(sha256('RDD_USER_TOKEN'::bytea), 'hex'), 'RDD_USER_T', 'RDD_USER_TOKEN', 'rdd-user@windmill.dev', 't', false);

GRANT ALL PRIVILEGES ON TABLE workspace_key TO windmill_admin;
GRANT ALL PRIVILEGES ON TABLE workspace_key TO windmill_user;