public function moveBudgets() { Component::where('class', 'Budget')->get()->each(function (Component $c) { $entry = ['user_id' => $c->user_id, 'name' => $c->name]; $budget = Budget::firstOrCreate($entry); Log::debug('Migrated budget #' . $budget->id . ': ' . $budget->name); // create entry in budget_transaction_journal $connections = DB::table('component_transaction_journal')->where('component_id', $c->id)->get(); foreach ($connections as $connection) { DB::table('budget_transaction_journal')->insert(['budget_id' => $budget->id, 'transaction_journal_id' => $connection->transaction_journal_id]); } }); }