pook/compliancebot

Fork 0

Replace stale #275 — add Prisma generated_documents migration and model #316

New issue

Closed

opened 2026-04-10 07:33:26 -04:00 by pook · 1 comment

pook commented

2026-04-10 07:33:26 -04:00

Owner

Replaces stale #275 which was too broad. Scope narrowed to migration + model only.

Create Prisma migration:
sql
CREATE TABLE generated_documents (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
document_type VARCHAR(50) NOT NULL CHECK (document_type IN ('privacy_policy', 'terms_of_service', 'cookie_policy', 'dmca_policy', 'acceptable_use')),
content TEXT NOT NULL,
stripe_customer_id VARCHAR(255),
download_token VARCHAR(255),
download_token_expires_at TIMESTAMPTZ,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_generated_documents_customer ON generated_documents(stripe_customer_id);
CREATE INDEX idx_generated_documents_token ON generated_documents(download_token);

Add to prisma/schema.prisma:
prisma
model GeneratedDocument {
id String @id @default(uuid())
documentType String @map("document_type")
content String
stripeCustomerId String? @map("stripe_customer_id")
downloadToken String? @map("download_token")
downloadTokenExpiresAt DateTime? @map("download_token_expires_at")
createdAt DateTime @default(now()) @map("created_at")
@@map("generated_documents")
}

Acceptance criteria:

npx prisma migrate dev --name create_generated_documents succeeds
npx prisma generate succeeds
Model is queryable via Prisma client
TypeScript compiles without errors

Generated by CEO Planner (priority: 2)

Replaces stale #275 which was too broad. Scope narrowed to migration + model only. Create Prisma migration: sql CREATE TABLE generated_documents ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), document_type VARCHAR(50) NOT NULL CHECK (document_type IN ('privacy_policy', 'terms_of_service', 'cookie_policy', 'dmca_policy', 'acceptable_use')), content TEXT NOT NULL, stripe_customer_id VARCHAR(255), download_token VARCHAR(255), download_token_expires_at TIMESTAMPTZ, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW() ); CREATE INDEX idx_generated_documents_customer ON generated_documents(stripe_customer_id); CREATE INDEX idx_generated_documents_token ON generated_documents(download_token); Add to `prisma/schema.prisma`: prisma model GeneratedDocument { id String @id @default(uuid()) documentType String @map("document_type") content String stripeCustomerId String? @map("stripe_customer_id") downloadToken String? @map("download_token") downloadTokenExpiresAt DateTime? @map("download_token_expires_at") createdAt DateTime @default(now()) @map("created_at") @@map("generated_documents") } Acceptance criteria: - `npx prisma migrate dev --name create_generated_documents` succeeds - `npx prisma generate` succeeds - Model is queryable via Prisma client - TypeScript compiles without errors --- *Generated by CEO Planner (priority: 2)*

pook added the

agent-task

label

2026-04-10 07:33:26 -04:00

pook referenced this issue

2026-04-10 08:54:02 -04:00

Replace stale #291 — wire POST /api/generate to persist documents in generated_documents table #322

pook referenced this issue

2026-04-10 09:14:38 -04:00

Add Prisma seed script with sample generated compliance documents #326

pook commented

2026-04-10 14:47:45 -04:00

Author

Owner

Bulk-closed 2026-04-10 during pipeline triage.

Context: CEO agent had created 100 open agent-task issues against compliancebot, largely duplicates of each other and of the 50 currently-open PRs. Root cause traced to a git-push race in agent-worker executor (dispatch jobs collided on branch agent/dispatch/* because jobId prefix truncated to literal "dispatch"). Fix deployed: runId is now threaded from Paperclip shim through /dispatch → TaskJob → executor, and branches are keyed on a 12-char unique run key.

What to do next:

Triage the 50 open PRs at https://192.168.183.110:3000/pook/compliancebot/pulls — many are ready to merge
CEO should halt new task creation until open PRs drop below 10
Surviving kept issues: #313, #314, #315, #341, #342, #350, #351, #352 (PR review/merge tasks)

This issue was superseded, not abandoned. Reopen if still relevant after PR triage.

Bulk-closed 2026-04-10 during pipeline triage. **Context:** CEO agent had created 100 open agent-task issues against compliancebot, largely duplicates of each other and of the 50 currently-open PRs. Root cause traced to a git-push race in agent-worker executor (dispatch jobs collided on branch `agent/dispatch/*` because jobId prefix truncated to literal "dispatch"). Fix deployed: runId is now threaded from Paperclip shim through /dispatch → TaskJob → executor, and branches are keyed on a 12-char unique run key. **What to do next:** 1. Triage the 50 open PRs at https://192.168.183.110:3000/pook/compliancebot/pulls — many are ready to merge 2. CEO should halt new task creation until open PRs drop below 10 3. Surviving kept issues: #313, #314, #315, #341, #342, #350, #351, #352 (PR review/merge tasks) This issue was superseded, not abandoned. Reopen if still relevant after PR triage.

pook closed this issue

2026-04-10 14:47:45 -04:00

No labels

agent-task

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

pook/compliancebot#316

No description provided.

Rows
Columns