public function setChoices(array $choices)
{
$flatChoices = PoolType::flatten($choices);
$stringChoices = implode("','", $flatChoices);
// UPDATE pool_users SET choices = COLUMN_CREATE('color', 'blue', 'size', 'XL') WHERE id = 1;
\DB::table('pool_user')->where('pool_id', '=', $this->pool_id)->where('user_id', '=', $this->user_id)->update(['choices' => \DB::raw("COLUMN_CREATE('{$stringChoices}')")]);
}
public function run()
{
$poolTypes = PoolType::all();
factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]);
factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]);
factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]);
factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]);
factory(Nhlpool\Pool::class, 5)->create(['pool_type_id' => $poolTypes->random()->id]);
}
