Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
// The narrow slice of the Cloudflare D1 API we use, declared locally so this
// worker doesn't need `@cloudflare/workers-types` wired into its tsconfig.
export interface D1Database {
prepare(query: string): D1PreparedStatement;
}
interface D1PreparedStatement {
bind(...values: unknown[]): D1PreparedStatement;
run(): Promise<unknown>;
all<T>(): Promise<{ results: T[] }>;
}
export type EditTrace = {
id: string;
document_id: string;
created_at: number;
/** Serialized TraceSession (see trace-log.ts). */
trace_json: string;
};
export async function insertEditTrace(
db: D1Database,
trace: EditTrace
): Promise<void> {
await db
.prepare(
'INSERT INTO edit_traces (id, document_id, created_at, trace_json) VALUES (?, ?, ?, ?)'
)
.bind(trace.id, trace.document_id, trace.created_at, trace.trace_json)
.run();
}
/** Delete every trace for a document. Returns silently if there are none. */
export async function deleteEditTracesByDocumentId(
db: D1Database,
documentId: string
): Promise<void> {
await db
.prepare('DELETE FROM edit_traces WHERE document_id = ?')
.bind(documentId)
.run();
}
/** All traces for a document, newest first. */
export async function listEditTraces(
db: D1Database,
documentId: string
): Promise<EditTrace[]> {
const { results } = await db
.prepare(
'SELECT id, document_id, created_at, trace_json FROM edit_traces WHERE document_id = ? ORDER BY created_at DESC'
)
.bind(documentId)
.all<EditTrace>();
return results;
}