/**
* 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');
});
}
}
}
