Example #1
0
 /**
  * @return mixed
  */
 public function run()
 {
     $companyIds = $this->companyRepository->getAll([Company::$columnPrimaryKey]);
     $vesselIds = $this->vesselRepository->getAll([Vessel::$columnPrimaryKey]);
     foreach (range(0, 33) as $index) {
         $companyId = $this->faker->randomElement($companyIds)[Company::$columnPrimaryKey];
         $vesselId = $this->faker->randomElement($vesselIds)[Vessel::$columnPrimaryKey];
         $query = "UPDATE `" . App::getDbName() . "`.`" . Vessel::$tableName . "` " . "SET `" . Vessel::$columnCompanyId . "`= :company_id " . "WHERE `" . Vessel::$columnPrimaryKey . "` = :vessel_id";
         $query = DbManager::getConnection()->prepare($query);
         $query->bindParam(':company_id', $companyId, PDO::PARAM_INT);
         $query->bindParam(':vessel_id', $vesselId, PDO::PARAM_INT);
         $query->execute();
     }
     echo "Seed for '" . Company::$tableName . "' and '" . Vessel::$tableName . "' tables complete.\n";
 }
Example #2
0
 /**
  * @return mixed
  */
 public function run()
 {
     $typeIds = $this->typeRepository->getAll([Type::$columnPrimaryKey]);
     $vesselIds = $this->vesselRepository->getAll([Vessel::$columnPrimaryKey]);
     foreach ($vesselIds as $vesselId) {
         $vesselId = $vesselId[Vessel::$columnPrimaryKey];
         $typeId = $this->faker->randomElement($typeIds)[Type::$columnPrimaryKey];
         $query = "UPDATE `" . App::getDbName() . "`.`" . Vessel::$tableName . "` " . "SET `" . Vessel::$columnTypeId . "`= :type_id " . "WHERE `" . Vessel::$columnPrimaryKey . "` = :vessel_id";
         $query = DbManager::getConnection()->prepare($query);
         $query->bindParam(':type_id', $typeId, PDO::PARAM_INT);
         $query->bindParam(':vessel_id', $vesselId, PDO::PARAM_INT);
         $query->execute();
     }
     echo "Seed for '" . Vessel::$tableName . "' and '" . Type::$tableName . "' tables complete.\n";
 }