models/containers.sql

SQL queries for container CRUD and retrieval.

-- Source: https://github.com/vxcontrol/pentagi | License: MIT | Copyright 2025 PentAGI Development Team
-- Provided via justclaw.it.com; keep this notice with the code.
-- name: GetContainers :many
SELECT
  c.*
FROM containers c
INNER JOIN flows f ON c.flow_id = f.id
WHERE f.deleted_at IS NULL
ORDER BY c.created_at DESC;

-- name: GetUserContainers :many
SELECT
  c.*
FROM containers c
INNER JOIN flows f ON c.flow_id = f.id
INNER JOIN users u ON f.user_id = u.id
WHERE f.user_id = $1 AND f.deleted_at IS NULL
ORDER BY c.created_at DESC;

-- name: GetRunningContainers :many
SELECT
  c.*
FROM containers c
INNER JOIN flows f ON c.flow_id = f.id
WHERE c.status = 'running' AND f.deleted_at IS NULL
ORDER BY c.created_at DESC;

-- name: GetFlowContainers :many
SELECT
  c.*
FROM containers c
INNER J

... (truncated -- full source via MCP)