protected function applyCsv($file)
{
$dataColumns = ['country', 'region', 'timezone', 'create_time', 'update_time'];
$dataDuplicates = ['country', 'region', 'timezone'];
$dataRows = [];
if (($handle = fopen($file, 'r')) !== false) {
while (($data = fgetcsv($handle, 1000, ',')) !== false) {
if (!isset($data[0]) || count($data) !== 3 || $data[0] === 'country') {
continue;
}
$dataRows[] = [trim($data[0]), trim($data[1]), trim($data[2]), time(), time()];
if (count($dataRows) === $this->maxExecuteRows) {
$this->batchInsertDuplicate(Timezones::tableName(), $dataColumns, $dataRows, $dataDuplicates)->execute();
$dataRows = [];
}
}
if (count($dataRows) > 0) {
$this->batchInsertDuplicate(Timezones::tableName(), $dataColumns, $dataRows, $dataDuplicates)->execute();
}
fclose($handle);
}
}
public function down()
{
$this->dropTable(Timezones::tableName());
}