/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$connection = Config::get('ab::connection');
// Create experiments table.
if (!Schema::connection($connection)->hasTable('experiments')) {
Schema::connection($connection)->create('experiments', function ($table) {
$table->increments('id');
$table->string('group');
$table->string('name');
$table->integer('visitors')->unsigned()->default(0);
$table->integer('engagement')->unsigned()->default(0);
$table->timestamps();
});
}
// Create goals table.
if (!Schema::connection($connection)->hasTable('goals')) {
Schema::connection($connection)->create('goals', function ($table) {
$table->increments('id');
$table->string('name');
$table->string('experiment');
$table->integer('count')->unsigned()->default(0);
$table->timestamps();
});
}
$this->info('Database schema initialized.');
$experimentGroups = Config::get('ab')['experiments'];
if (!$experimentGroups or empty($experimentGroups)) {
return $this->error('No experiments configured.');
}
$goals = Config::get('ab')['goals'];
if (!$goals or empty($goals)) {
return $this->error('No goals configured.');
}
// Populate experiments and goals.
$experimentCount = 0;
foreach ($experimentGroups as $groupName => $experimentGroup) {
foreach ($experimentGroup as $experiment) {
Experiment::firstOrCreate(['name' => $experiment, 'group' => $groupName]);
foreach ($goals as $goal) {
Goal::firstOrCreate(['name' => $goal, 'experiment' => $experiment]);
}
$experimentCount += count($experimentGroups);
}
}
$this->info('Added ' . $experimentCount . ' experiments.');
}
/**
* Add experiments to the database.
*
* @return void
*/
protected function checkExperiments()
{
// Check if the database contains all experiments.
if (Experiment::active()->count() != count($this->getExperiments())) {
// Insert all experiments.
foreach ($this->getExperiments() as $experiment) {
Experiment::firstOrCreate(['name' => $experiment]);
}
}
}
