/** * A basic test example. * * @return void */ public function testRemoveInDatabase() { $movie = new \App\Http\Models\Movies(); $movie->title = "Star Wars 3"; $movie->save(); $movie = \App\Http\Models\Movies::where("title", "=", "Star Wars 3")->first(); $movie->delete(); $this->dontSeeInDatabase('movies', ["title" => "Star Wars 3"]); }
/** * A basic test example. * * @return void */ public function testUpdateInDatabase() { $movie = \App\Http\Models\Movies::where("title", "=", "Star Wars 3")->first(); $this->seeInDatabase('movies', ["title" => "Star Wars 3"]); $movie->title = "Star Wars 4"; $movie->categories_id = 1; $movie->save(); $this->seeInDatabase('movies', ["title" => "Star Wars 4"]); }
/** * A basic test example. * * @return void */ public function testUpdateInDatabase() { $movie = \App\Http\Models\Movies::where('title', '=', 'Star Wars 3')->first(); $this->seeInDatabase('movies', ['title' => 'Star Wars 3']); $movie->title = 'Star Wars 4'; $movie->categories_id = 1; $movie->save(); $this->seeInDatabase('movies', ['title' => 'Star Wars 4']); }
/** * A basic test example. * * @return void */ public function testRemoveInDatabase() { $movie = new \App\Http\Models\Movies(); $movie->title = 'Star Wars 3'; $movie->save(); $movie = \App\Http\Models\Movies::where('title', '=', 'Star Wars 3')->first(); $movie->delete(); $this->dontSeeInDatabase('movies', ['title' => 'Star Wars 3']); }
/** * Execute the console command. * * @return mixed */ public function handle() { // SQL query $results = Movies::where('date_release', '>=', new Carbon('-1 month'))->where('date_release', '<=', new Carbon('now'))->get(); // je parcours mes films foreach ($results as $movie) { $users = $movie->actors(); foreach ($users as $user) { //send an email Mail::send('Emails/newsletter', [], function ($m) { $m->from('*****@*****.**', 'Florent Boyer'); $m->to("*****@*****.**", "Boyer Julien")->subject('Welcome to newsletter'); }); } } }