function apiEventSave($list) { try { $eventCheck = calendar::where('event_id', '=', $list['event_id'])->firstOrFail(); //update saved event if no fail calendar::where('event_id', $list['event_id'])->update($list); } catch (\Illuminate\Database\Eloquent\ModelNotFoundException $e) { //create new event $event = calendar::firstOrCreate($list); } }
/** * Test to insert 3 new events * * @return void */ public function testAdd() { //clear user for testing DB::table('calendar')->where('event_id', '=', '19483726503')->delete(); DB::table('calendar')->where('event_id', '=', '64893021765')->delete(); DB::table('calendar')->where('event_id', '=', '83746284054')->delete(); $list1 = ['event_id' => '19483726503', 'title' => 'Metting - John Doe', 'start_time' => 'Wed Feb 26 2016 10:00:00 GMT+0000', 'end_time' => 'Wed Feb 26 2016 12:30:00 GMT+0000', 'client_id' => '*****@*****.**', 'client_name' => 'John Doe']; $list2 = ['event_id' => '64893021765', 'title' => 'More Meds', 'start_time' => 'Fri Mar 11 2016 10:00:00 GMT+0000', 'end_time' => 'Fri Mar 11 2016 10:30:00 GMT+0000', 'client_id' => '*****@*****.**', 'client_name' => 'Jane Doe']; $list3 = ['event_id' => '83746284054', 'title' => 'Meeting', 'start_time' => 'Wed Mar 02 2016 10:00:00 GMT+0000', 'end_time' => 'Wed Mar 02 2016 11:00:00 GMT+0000', 'client_id' => '*****@*****.**', 'client_name' => 'John Doe']; $testEvent = calendar::firstOrCreate($list1); $testEvent = calendar::firstOrCreate($list2); $testEvent = calendar::firstOrCreate($list3); $this->seeInDatabase('calendar', ['event_id' => '19483726503']); $this->seeInDatabase('calendar', ['event_id' => '64893021765']); $this->seeInDatabase('calendar', ['event_id' => '83746284054']); }