public function actionUpdateEntireWeapons()
{
$db = Yii::$app->db;
$transaction = $db->beginTransaction();
echo "Delete old data...\n";
StatWeapon::deleteAll();
StatWeaponBattleCount::deleteAll();
echo "INSERT stat_weapon...\n";
$select = $this->createSelectQueryForUpdateEntireWeapons();
$sql = sprintf('INSERT INTO %s (%s) %s', $db->quoteTableName(StatWeapon::tableName()), implode(', ', array_map(function ($k) use($db) {
return $db->quoteColumnName($k);
}, array_keys($select->select))), $select->createCommand()->rawSql);
$db->createCommand($sql)->execute();
echo "INSERT stat_weapon_battle_count..\n";
$select = $this->createSelectQueryForUpdateEntireWeaponsBattleCount();
$sql = sprintf('INSERT INTO %s (%s) %s', $db->quoteTableName(StatWeaponBattleCount::tableName()), implode(', ', array_map(function ($k) use($db) {
return $db->quoteColumnName($k);
}, array_keys($select->select))), $select->createCommand()->rawSql);
$db->createCommand($sql)->execute();
echo "done.\n";
$transaction->commit();
}
