/** * 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); }
/** * 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); }