/**
  * Inserta datos desde un archivo de datos de migración en una tabla
  *
  * @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();
     }
 }
 /**
  * Delete All data from Relational Map Table
  *
  * @param string $conditions
  * @return boolean
  */
 public function delete_all($conditions = '')
 {
     $limit = '';
     if ($this->schema) {
         $table = $this->schema . "." . $this->source;
     } else {
         $table = $this->source;
     }
     if (func_num_args() > 1) {
         $params = Util::getParams(func_get_args());
         $limit_args = array($select);
         if (isset($params['limit'])) {
             array_push($limit_args, "limit: {$params['limit']}");
         }
         if (isset($params['offset'])) {
             array_push($limit_args, "offset: {$params['offset']}");
         }
         if (count($limit_args) > 1) {
             $select = call_user_func_array(array($this, 'limit'), $limit_args);
         }
     }
     return $this->db->delete($table, $conditions);
 }
Beispiel #3
0
 /**
  * Borra registros de una tabla!
  *
  * @param string $table
  * @param string $where_condition
  */
 public function delete($table, $where_condition)
 {
     $this->set_return_rows(false);
     return parent::delete($table, $where_condition);
 }