Fully autonomous AI Agents system capable of performing complex penetration testing tasks
Go ai-agentsai-security-toolanthropicautonomous-agentsgolanggptgraphqlmulti-agent-systemoffensive-securityopen-sourceopenaipenetration-testingpenetration-testing-toolsreactsecurity-automationsecurity-testingsecurity-toolsself-hosted
-- name: GetRoles :many
SELECT
r.id,
r.name,
(
SELECT ARRAY_AGG(p.name)
FROM privileges p
WHERE p.role_id = r.id
) AS privileges
FROM roles r
ORDER BY r.id ASC;
-- name: GetRole :one
SELECT
r.id,
r.name,
(
SELECT ARRAY_AGG(p.name)
FROM privileges p
WHERE p.role_id = r.id
) AS privileges
FROM roles r
WHERE r.id = $1;
-- name: GetRoleByName :one
SELECT
r.id,
r.name,
(
SELECT ARRAY_AGG(p.name)
FROM privileges p
WHERE p.role_id = r.id
) AS privileges
FROM roles r
WHERE r.name = $1;