PHP Exercise TravelersRepository::getAllTravelersWithDestinations Examples

Example #1

File: TestTravelersRepository.php Project: bakl/exercise

 public function testAllTravelersWithDestination()
 {
     $repo = new TravelersRepository();
     $data = $repo->getAllTravelersWithDestinations();
     $this->assertContains(array('name' => 'Vasya', 'distinations' => 'Cuba, Sochi'), $data);
     $this->assertContains(array('name' => 'Maria', 'distinations' => 'Aruba'), $data);
     $this->assertContains(array('name' => 'George', 'distinations' => 'Cuba, Sochi'), $data);
     $this->assertContains(array('name' => 'Clark Kent', 'distinations' => 'Cuba, Krypton'), $data);
     $this->assertContains(array('name' => 'Traveler', 'distinations' => 'Aruba, Krypton, Cuba, Sochi'), $data);
 }

Example #2

File: sql_exercise.php Project: bakl/exercise

<?php

require_once 'vendor/autoload.php';
use Exercise\TravelersRepository;
$climate = new League\CLImate\CLImate();
$climate->clear();
$climate->red('Hello. This is SQL exercise script.');
$travelersRepo = new TravelersRepository();
$climate->table($travelersRepo->getAllTravelersWithDestinations());
$climate->table($travelersRepo->getTravelersByDestinations(array('Cuba', 'Sochi')));
$climate->table($travelersRepo->getTravelersByDestinations(array('Cuba', 'Sochi'), true));