Exemple #1
0
 public function execute($params)
 {
     $movie = new \Engine\Movie();
     $movie->setTitle($params['title']);
     $movie->setYear($params['year']);
     $movie->setFormat($params['format']);
     $actors = [];
     foreach ($params['actor_name'] as $key => $name) {
         $actor = new \Engine\Actor();
         $actor->setName($name);
         $actor->setSurname($params['actor_surname'][$key]);
         $actors[] = $actor;
     }
     $con = \Propel\Runtime\Propel::getWriteConnection(\Engine\Map\MovieTableMap::DATABASE_NAME);
     $con->beginTransaction();
     try {
         $movie->save($con);
         foreach ($actors as $actor) {
             $actor->setMovieId($movie->getId());
             $actor->save($con);
         }
         $con->commit();
     } catch (Exception $e) {
         $con->rollback();
         throw $e;
     }
     return ['Message' => 'Movie has beed added successfully.', 'Status' => 1];
 }
Exemple #2
0
 private function parseRows($file)
 {
     //read file using generators
     $handle = fopen($file['tmp_name'], "r");
     if ($handle) {
         $title = $this->getCheckedRow(fgets($handle));
         //read title
         $con = \Propel\Runtime\Propel::getWriteConnection(\Engine\Map\MovieTableMap::DATABASE_NAME);
         try {
             while (!empty($title)) {
                 $year = $this->getCheckedRow(fgets($handle));
                 //read year
                 $format = $this->getCheckedRow(fgets($handle));
                 //read format
                 //create new movie
                 $movie = new \Engine\Movie();
                 $movie->setTitle($title);
                 $movie->setYear($year);
                 $movie->setFormat($format);
                 $movie->save($con);
                 $actors_row = $this->getCheckedRow(fgets($handle));
                 // read actors
                 $actors_arr = explode(',', $actors_row);
                 //split line by ','
                 foreach ($actors_arr as $actorInitials) {
                     $actorInitialsKV = explode(' ', trim($actorInitials));
                     //split actor by [name,surname] Key-Value pair
                     //create new actor
                     $actor = new \Engine\Actor();
                     $actor->setMovieId($movie->getId());
                     $actor->setName($actorInitialsKV[0]);
                     $actor->setSurname($actorInitialsKV[1]);
                     $actor->save($con);
                 }
                 fgets($handle);
                 //pass whitespace
                 //set new title
                 $title = $this->getCheckedRow(fgets($handle));
             }
         } catch (Exception $e) {
             fclose($handle);
             $con->rollback();
             throw new \Service\X(['Message' => 'Error during database transaction', 'Fields' => '$row', 'Type' => "{$e}"]);
         }
         fclose($handle);
     } else {
         throw new \Service\X(['Message' => 'Error - file could not be opened', 'Fields' => '$handle', 'Type' => 'Stream error']);
     }
 }