Method extractContentJson

src/durable-objects/user-notes.ts:1020–1030

(noteId: string)

            this.sql.exec(
                `INSERT INTO media (id, type, filename, r2_key, mime_type, size, width, height) VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,
                body.id, body.type, body.filename, body.r2_key, body.mime_type, body.size, body.width ?? null, body.height ?? null
            );
            const rows = this.sql.exec("SELECT * FROM media WHERE id = ?", body.id).toArray();
            this.broadcastJson({ type: "media-added", media: rows[0] });
            return Response.json(rows[0]);
        }
        if (request.method === "DELETE" && path.startsWith("/media/")) {
            const id = path.slice("/media/".length);
            const rows = this.sql.exec("SELECT r2_key FROM media WHERE id = ?", id).toArray();
            this.sql.exec("DELETE FROM media WHERE id = ?", id);
            this.broadcastJson({ type: "media-deleted", id });
            return Response.json({ ok: true, r2_key: rows[0]?.r2_key });
        }
        if (request.method === "PATCH" && path.match(/^\/media\/[^/]+\/published$/)) {