Function createIllustration

server/src/db/illustration-db.ts:74–98

(data: {
  perspective_id: string;
  image_data?: Buffer;
  prompt_used?: string;
  author_description?: string;
  status?: 'pending' | 'generated' | 'approved';
  c2pa_signed_at?: Date;
  c2pa_manifest_digest?: string;
})

/** Create a new illustration record */
export async function createIllustration(data: {
  perspective_id: string;
  image_data?: Buffer;
  prompt_used?: string;
  author_description?: string;
  status?: 'pending' | 'generated' | 'approved';
  c2pa_signed_at?: Date;
  c2pa_manifest_digest?: string;
}): Promise<PerspectiveIllustration> {
  const result = await query<PerspectiveIllustration>(
    `INSERT INTO perspective_illustrations (perspective_id, image_data, prompt_used, author_description, status, c2pa_signed_at, c2pa_manifest_digest)
     VALUES ($1, decode($2, 'base64'), $3, $4, $5, $6, $7)
     RETURNING ${METADATA_COLUMNS}`,
    [
      data.perspective_id,
      data.image_data ? data.image_data.toString('base64') : null,
      data.prompt_used || null,
      data.author_description || null,
      data.status || 'generated',
      data.c2pa_signed_at ?? null,
      data.c2pa_manifest_digest ?? null,
    ]
  );
  return result.rows[0];
}

/** Approve an illustration and set it as the perspective's active illustration */
export async function approveIllustration(illustrationId: string, perspectiveId: string): Promise<IllustrationMetadata | null> {