/**
* Helper to populate the database.
* @param array $data Data to be saved.
* @throws Exception is thrown when unable to save.
*/
private function populateTable($data)
{
//skip first row
for ($i = 1; $i < count($data); $i++) {
$teamStats = new TeamStat();
$teamStats->name = $data[$i][0];
$teamStats->played = $data[$i][1];
$teamStats->wins = $data[$i][2];
$teamStats->loses = $data[$i][3];
$teamStats->draws = $data[$i][4];
$teamStats->goals_for = $data[$i][5];
$teamStats->goals_against = $data[$i][6];
$teamStats->points = $data[$i][7];
$teamStats->last_game_day = $data[$i][8];
$saved = $teamStats->save();
if (!$saved) {
throw new Exception("Unable to insert data");
}
}
}
/**
* Deletes a row of data
* @param int $id Id of the data
* @return json
*/
public function delete($id)
{
if ((int) $id > 0) {
$teamStatsModel = TeamStat::find((int) $id);
if ($teamStatsModel) {
$deleted = $teamStatsModel->delete();
if (!$deleted) {
return response()->json(array('status' => false, 'error' => 'Unabled to delete.'));
}
return response()->json(array('status' => true));
}
return response()->json(array('status' => false, 'error' => 'Unable to find data.'));
}
return response()->json(array('status' => false, 'error' => 'Invalid id.'));
}
