Function backfillUserDefaultOrgIds

packages/database/migrations/orgid_backfill.ts:57–74

()

}

async function backfillUserDefaultOrgIds() {
	console.log("👤 Starting user defaultOrgId backfill...");

	let updated = 0;

	const updateResult = await db()
		.update(users)
		.set({
			defaultOrgId: users.activeOrganizationId.getSQL(),
		})
		.where(
			and(isNull(users.defaultOrgId), isNotNull(users.activeOrganizationId)),
		);
	const rowsUpdated = updateResult[0].affectedRows || 0;
	updated += rowsUpdated;

	console.log(`👥 Assigned defaultOrgId to ${updated} users`);
}

async function validateBackfill(): Promise<void> {
	console.log("🔍 Validating backfill results...");