public function execute()
{
$fileIterator = new \SplFileObject($this->sourceFile);
$fileIterator->setCsvControl($this->delimitter);
$fileIterator->setFlags(\SplFileObject::READ_CSV | \SplFileObject::DROP_NEW_LINE);
$columns = [];
$data = [];
foreach ($fileIterator as $values) {
$row = [];
foreach ($values as $val) {
$row[] = trim($val);
}
$data[] = $row;
}
if ($this->columnsFromFirstLine) {
$columns = array_shift($data);
}
$this->connection->getTable($this->tableName)->upsert($data, $columns);
}
public function execute()
{
$this->destinationConnection->disableForeignKeyChecks();
foreach ($this->config["tables"] as $table => $params) {
// fix variables if the table has no params and is just a string
if (is_int($table)) {
$table = $this->config["tables"][$table];
$params = [];
}
$sourceTable = $this->sourceConnection->getTable($table);
if (!$sourceTable) {
$this->sourceConnection->warning("{$table} not found on source connection. Skipping.");
continue;
}
if (isset($params["destination_table"])) {
$destinationTableName = $params["destination_table"];
} else {
$destinationTableName = $table;
}
$destinationTable = $this->destinationConnection->getTable($destinationTableName);
if (!$destinationTable) {
$this->destinationConnection->warning("{$table} not found on destination connection. Skipping.");
continue;
}
$destinationTable->truncate();
$sourceColumns = $sourceTable->getColumns();
$destinationColumns = $destinationTable->getColumns();
$columnsToSelect = [];
foreach ($sourceColumns as $sourceColumnName => $sourceColumnDefiniton) {
if (isset($destinationColumns[$sourceColumnName])) {
$destinationColumnDefinition = $destinationColumns[$sourceColumnName];
if ($sourceColumnDefiniton != $destinationColumns[$sourceColumnName]) {
$this->destinationConnection->warning("source and destination mistmatch: source is {$sourceColumnDefiniton}, destination is {$destinationColumnDefinition}");
}
$columnsToSelect[] = $sourceColumnName;
} else {
$this->destinationConnection->warning("{$sourceColumnName} missing from {$table} on destination");
}
}
$sourceRows = $sourceTable->select($columnsToSelect);
$destinationTable->bulkInsert($sourceRows);
}
}