public function resolveFile($file)
{
if (!is_file($file)) {
throw new \yii\base\Exception('Source file not found.');
}
$data = json_decode(file_get_contents($file), true);
foreach (Countries::find(1)->all() as $country) {
$countryCode = strtoupper($country->iso_alpha2);
if (isset($data[$countryCode])) {
if (($message = $country->getAttribute($this->targetAttribute)) === null) {
throw new \yii\base\Exception('Bad target attribute value.');
}
Message::initDbMessage($this->category, $this->language, $message, $data[$countryCode]);
}
}
}
/**
* @see https://github.com/debuggable/php_arrays/tree/master/generators
* @param type $file
*/
protected function applyCsv($file)
{
$dataColumns = ['iso_alpha2', 'iso_alpha3', 'iso_numeric', 'fips_code', 'name', 'capital', 'areainsqkm', 'population', 'continent', 'tld', 'currency', 'currency_name', 'phone', 'postal_code_format', 'postal_code_regex', 'languages', 'geoname_id', 'neighbours', 'equivalent_fips_code', 'create_time', 'update_time'];
$dataDuplicates = ['iso_alpha2'];
$dataRows = [];
if (($handle = fopen($file, 'r')) !== false) {
while (($data = fgetcsv($handle, 0, "\t")) !== false) {
if (count($data) == 1 || preg_match('/^#/', $data[0])) {
continue;
}
$dataRows[] = array_values(['iso_alpha2' => $data[0], 'iso_alpha3' => $data[1], 'iso_numeric' => $data[2], 'fips_code' => $data[3], 'name' => $data[4], 'capital' => $data[5], 'areainsqkm' => $data[6], 'population' => $data[7], 'continent' => $data[8], 'tld' => $data[9], 'currency' => $data[10], 'currency_name' => $data[11], 'phone' => $data[12], 'postal_code_format' => $data[13], 'postal_code_regex' => $data[14], 'languages' => $data[15], 'geoname_id' => $data[16], 'neighbours' => $data[17], 'equivalent_fips_code' => $data[18], 'create_time' => time(), 'update_time' => time()]);
if (count($dataRows) === $this->maxExecuteRows) {
$this->batchInsertDuplicate(Countries::tableName(), $dataColumns, $dataRows, $dataDuplicates)->execute();
$dataRows = [];
}
}
if (count($dataRows) > 0) {
$this->batchInsertDuplicate(Countries::tableName(), $dataColumns, $dataRows, $dataDuplicates)->execute();
}
fclose($handle);
}
}
public function down()
{
$this->dropTable(Countries::tableName());
}