/** * Run the migrations. * * @return void */ public function up() { $last_user = ''; $users = SlackUser::all(); foreach ($users as $user) { if ($user->slack_id == $last_user) { $user->delete(); } $last_user = $user->slack_id; } Schema::table('slack_users', function (Blueprint $table) { $table->unique('slack_id'); }); }
public function testUserUpdate() { // pre test Seat::set('slack_token', getenv('slack_token')); $artifacts = [new SlackUser(['user_id' => 1, 'slack_id' => 'U1Z9LT9NM']), new SlackUser(['user_id' => 2, 'slack_id' => 'U1Z9QVCJW']), new SlackUser(['user_id' => 3, 'slack_id' => 'U1Z9LT9NK'])]; // test $job = new SlackUsersUpdate(); $job->handle(); $inDatabaseMember = SlackUser::all(['user_id', 'slack_id']); $result = []; foreach ($inDatabaseMember as $member) { $result[] = new SlackUser(['user_id' => $member->user_id, 'slack_id' => $member->slack_id]); } // compare both array $this->assertEquals($artifacts, $result); }