| 408 | } |
| 409 | |
| 410 | async function migrateExistingWorkflows(userId: string, workspaceId: string) { |
| 411 | const orphanedWorkflows = await db |
| 412 | .select({ id: workflow.id }) |
| 413 | .from(workflow) |
| 414 | .where(and(eq(workflow.userId, userId), isNull(workflow.workspaceId))) |
| 415 | |
| 416 | if (orphanedWorkflows.length === 0) { |
| 417 | return // No orphaned workflows to migrate |
| 418 | } |
| 419 | |
| 420 | logger.info( |
| 421 | `Migrating ${orphanedWorkflows.length} workflows to workspace ${workspaceId} for user ${userId}` |
| 422 | ) |
| 423 | |
| 424 | await db |
| 425 | .update(workflow) |
| 426 | .set({ |
| 427 | workspaceId: workspaceId, |
| 428 | updatedAt: new Date(), |
| 429 | }) |
| 430 | .where(and(eq(workflow.userId, userId), isNull(workflow.workspaceId))) |
| 431 | } |
| 432 | |
| 433 | async function ensureWorkflowsHaveWorkspace(userId: string, defaultWorkspaceId: string) { |
| 434 | const orphanedWorkflows = await db |