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
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.27.0
// source: users.sql
package database
import (
"context"
"database/sql"
"github.com/lib/pq"
)
const createUser = `-- name: CreateUser :one
INSERT INTO users (
type,
mail,
name,
password,
status,
role_id,
password_change_required
)
VALUES (
$1, $2, $3, $4, $5, $6, $7
)
RETURNING id, hash, type, mail, name, password, status, role_id, password_change_required, provider, created_at, session_generation
`
type CreateUserParams struct {
Type UserType `json:"type"`
Mail string `json:"mail"`
Name string `json:"name"`
Password sql.NullString `json:"password"`
Status UserStatus `json:"status"`
RoleID int64 `json:"role_id"`
PasswordChangeRequired bool `json:"password_change_required"`
}
func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error) {
row := q.db.QueryRowContext(ctx, createUser,
arg.Type,
arg.Mail,
arg.Name,
arg.Password,
arg.Status,
arg.RoleID,
arg.PasswordChangeRequired,
)
var i User
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
)
return i, err
}
const deleteUser = `-- name: DeleteUser :exec
DELETE FROM users
WHERE id = $1
`
func (q *Queries) DeleteUser(ctx context.Context, id int64) error {
_, err := q.db.ExecContext(ctx, deleteUser, id)
return err
}
const getUser = `-- name: GetUser :one
SELECT
u.id, u.hash, u.type, u.mail, u.name, u.password, u.status, u.role_id, u.password_change_required, u.provider, u.created_at, u.session_generation,
r.name AS role_name,
(
SELECT ARRAY_AGG(p.name)
FROM privileges p
WHERE p.role_id = r.id
) AS privileges
FROM users u
INNER JOIN roles r ON u.role_id = r.id
WHERE u.id = $1
`
type GetUserRow struct {
ID int64 `json:"id"`
Hash string `json:"hash"`
Type UserType `json:"type"`
Mail string `json:"mail"`
Name string `json:"name"`
Password sql.NullString `json:"password"`
Status UserStatus `json:"status"`
RoleID int64 `json:"role_id"`
PasswordChangeRequired bool `json:"password_change_required"`
Provider sql.NullString `json:"provider"`
CreatedAt sql.NullTime `json:"created_at"`
SessionGeneration int64 `json:"session_generation"`
RoleName string `json:"role_name"`
Privileges []string `json:"privileges"`
}
func (q *Queries) GetUser(ctx context.Context, id int64) (GetUserRow, error) {
row := q.db.QueryRowContext(ctx, getUser, id)
var i GetUserRow
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
&i.RoleName,
pq.Array(&i.Privileges),
)
return i, err
}
const getUserByHash = `-- name: GetUserByHash :one
SELECT
u.id, u.hash, u.type, u.mail, u.name, u.password, u.status, u.role_id, u.password_change_required, u.provider, u.created_at, u.session_generation,
r.name AS role_name,
(
SELECT ARRAY_AGG(p.name)
FROM privileges p
WHERE p.role_id = r.id
) AS privileges
FROM users u
INNER JOIN roles r ON u.role_id = r.id
WHERE u.hash = $1
`
type GetUserByHashRow struct {
ID int64 `json:"id"`
Hash string `json:"hash"`
Type UserType `json:"type"`
Mail string `json:"mail"`
Name string `json:"name"`
Password sql.NullString `json:"password"`
Status UserStatus `json:"status"`
RoleID int64 `json:"role_id"`
PasswordChangeRequired bool `json:"password_change_required"`
Provider sql.NullString `json:"provider"`
CreatedAt sql.NullTime `json:"created_at"`
SessionGeneration int64 `json:"session_generation"`
RoleName string `json:"role_name"`
Privileges []string `json:"privileges"`
}
func (q *Queries) GetUserByHash(ctx context.Context, hash string) (GetUserByHashRow, error) {
row := q.db.QueryRowContext(ctx, getUserByHash, hash)
var i GetUserByHashRow
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
&i.RoleName,
pq.Array(&i.Privileges),
)
return i, err
}
const getUsers = `-- name: GetUsers :many
SELECT
u.id, u.hash, u.type, u.mail, u.name, u.password, u.status, u.role_id, u.password_change_required, u.provider, u.created_at, u.session_generation,
r.name AS role_name,
(
SELECT ARRAY_AGG(p.name)
FROM privileges p
WHERE p.role_id = r.id
) AS privileges
FROM users u
INNER JOIN roles r ON u.role_id = r.id
ORDER BY u.created_at DESC
`
type GetUsersRow struct {
ID int64 `json:"id"`
Hash string `json:"hash"`
Type UserType `json:"type"`
Mail string `json:"mail"`
Name string `json:"name"`
Password sql.NullString `json:"password"`
Status UserStatus `json:"status"`
RoleID int64 `json:"role_id"`
PasswordChangeRequired bool `json:"password_change_required"`
Provider sql.NullString `json:"provider"`
CreatedAt sql.NullTime `json:"created_at"`
SessionGeneration int64 `json:"session_generation"`
RoleName string `json:"role_name"`
Privileges []string `json:"privileges"`
}
func (q *Queries) GetUsers(ctx context.Context) ([]GetUsersRow, error) {
rows, err := q.db.QueryContext(ctx, getUsers)
if err != nil {
return nil, err
}
defer rows.Close()
var items []GetUsersRow
for rows.Next() {
var i GetUsersRow
if err := rows.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
&i.RoleName,
pq.Array(&i.Privileges),
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const updateUserName = `-- name: UpdateUserName :one
UPDATE users
SET name = $1
WHERE id = $2
RETURNING id, hash, type, mail, name, password, status, role_id, password_change_required, provider, created_at, session_generation
`
type UpdateUserNameParams struct {
Name string `json:"name"`
ID int64 `json:"id"`
}
func (q *Queries) UpdateUserName(ctx context.Context, arg UpdateUserNameParams) (User, error) {
row := q.db.QueryRowContext(ctx, updateUserName, arg.Name, arg.ID)
var i User
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
)
return i, err
}
const updateUserPassword = `-- name: UpdateUserPassword :one
UPDATE users
SET password = $1
WHERE id = $2
RETURNING id, hash, type, mail, name, password, status, role_id, password_change_required, provider, created_at, session_generation
`
type UpdateUserPasswordParams struct {
Password sql.NullString `json:"password"`
ID int64 `json:"id"`
}
func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) (User, error) {
row := q.db.QueryRowContext(ctx, updateUserPassword, arg.Password, arg.ID)
var i User
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
)
return i, err
}
const updateUserPasswordChangeRequired = `-- name: UpdateUserPasswordChangeRequired :one
UPDATE users
SET password_change_required = $1
WHERE id = $2
RETURNING id, hash, type, mail, name, password, status, role_id, password_change_required, provider, created_at, session_generation
`
type UpdateUserPasswordChangeRequiredParams struct {
PasswordChangeRequired bool `json:"password_change_required"`
ID int64 `json:"id"`
}
func (q *Queries) UpdateUserPasswordChangeRequired(ctx context.Context, arg UpdateUserPasswordChangeRequiredParams) (User, error) {
row := q.db.QueryRowContext(ctx, updateUserPasswordChangeRequired, arg.PasswordChangeRequired, arg.ID)
var i User
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
)
return i, err
}
const updateUserRole = `-- name: UpdateUserRole :one
UPDATE users
SET role_id = $1
WHERE id = $2
RETURNING id, hash, type, mail, name, password, status, role_id, password_change_required, provider, created_at, session_generation
`
type UpdateUserRoleParams struct {
RoleID int64 `json:"role_id"`
ID int64 `json:"id"`
}
func (q *Queries) UpdateUserRole(ctx context.Context, arg UpdateUserRoleParams) (User, error) {
row := q.db.QueryRowContext(ctx, updateUserRole, arg.RoleID, arg.ID)
var i User
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
)
return i, err
}
const updateUserStatus = `-- name: UpdateUserStatus :one
UPDATE users
SET status = $1
WHERE id = $2
RETURNING id, hash, type, mail, name, password, status, role_id, password_change_required, provider, created_at, session_generation
`
type UpdateUserStatusParams struct {
Status UserStatus `json:"status"`
ID int64 `json:"id"`
}
func (q *Queries) UpdateUserStatus(ctx context.Context, arg UpdateUserStatusParams) (User, error) {
row := q.db.QueryRowContext(ctx, updateUserStatus, arg.Status, arg.ID)
var i User
err := row.Scan(
&i.ID,
&i.Hash,
&i.Type,
&i.Mail,
&i.Name,
&i.Password,
&i.Status,
&i.RoleID,
&i.PasswordChangeRequired,
&i.Provider,
&i.CreatedAt,
&i.SessionGeneration,
)
return i, err
}