/** * Run the migrations. * * @return void */ public function up() { Schema::table('accounts', function (Blueprint $table) { $table->string('destiny_membershipId', 64); $table->dropIndex('accounts_id_index'); $table->index('destiny_membershipId'); }); \Onyx\Account::chunk(100, function ($accounts) { foreach ($accounts as $account) { $data = \Onyx\Destiny\Objects\Data::where('account_id', $account->id)->first(); $account->destiny_membershipId = $data->membershipId; $account->save(); } }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('comments', function (Blueprint $table) { $table->integer('account_id', false, true); }); // Loop all comments, find account_id via membershipId \Onyx\Objects\Comment::chunk(100, function ($comments) { foreach ($comments as $comment) { $data = \Onyx\Destiny\Objects\Data::where('membershipId', $comment->membershipId)->first(); if ($data instanceof \Onyx\Destiny\Objects\Data) { $comment->account_id = $data->account_id; $comment->save(); } } }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('game_players', function (Blueprint $table) { $table->integer('account_id', false, true); }); // Loop all game_players, find the account_id via membershipId on DestinyData \Onyx\Destiny\Objects\GamePlayer::chunk(100, function ($players) { foreach ($players as $player) { $data = \Onyx\Destiny\Objects\Data::where('membershipId', $player->membershipId)->first(); if ($data instanceof \Onyx\Destiny\Objects\Data) { $player->account_id = $data->account_id; $player->save(); } } }); }