Beispiel #1
0
 /**
  * Inserts data from a data migration file in a table
  *
  * @param string $tableName
  * @param string $fields
  */
 public function batchInsert($tableName, $fields)
 {
     $migrationData = self::$_migrationPath . '/' . $tableName . '.dat';
     if (file_exists($migrationData)) {
         self::$_connection->begin();
         self::$_connection->delete($tableName);
         $batchHandler = fopen($migrationData, 'r');
         while (($line = fgets($batchHandler)) !== false) {
             self::$_connection->insert($tableName, explode('|', rtrim($line)), $fields, false);
             unset($line);
         }
         fclose($batchHandler);
         self::$_connection->commit();
     }
 }