/**
* Execute the command.
*
* @return void
*/
public function handle()
{
\Log::info('[' . $this->job->getJobId() . ':' . $this->attempts() . '] Fetch datasource columns started.');
$datasource = DataSource::find($this->datasource_id);
if (!$datasource) {
return;
}
if ($this->attempts() > 3) {
$datasource->config_status = 0;
$datasource->save();
\Log::info('[' . $this->job->getJobId() . ':' . $this->attempts() . '] Fetch datasource columns failed.');
return;
}
// TODO: Rename fetch function
$ds_data = $datasource->fetch();
if (!$ds_data) {
$datasource->config_status = 0;
$datasource->save();
} else {
$datasource->columns = array_keys($ds_data[0]);
$datasource->config_status = 2;
$datasource->save();
}
\Log::info('[' . $this->job->getJobId() . ':' . $this->attempts() . '] Fetch datasource columns successful.');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
*
* @return Response
*/
public function destroy($id)
{
DataSource::find($id)->delete();
return response()->json(array('error' => false, 'message' => 'Datasource deleted.'), 200);
}
