<?php

exit;

require( dirname( __FILE__ ) . '/../wp-blog-header.php' );

global $wpdb;

$fh = fopen('PLZO_CSV_LV03.csv', 'r');
if (!$fh) {
    exit;
}

$titles = fgetcsv($fh, 0, ';');
if (!is_array($titles) || 9 != count($titles)) {
    exit;
}

while (false !== ($data = fgetcsv($fh, 0, ';'))) {
    if (9 != count($data)) {
        continue;
    }

    $res = $wpdb->insert('ma_swiss_zip', esc_sql([
        'zip_code'          => $data[1],
        'additional_number' => $data[2],
        'canton_ID'         => $data[5],
    ]));
    if (false === $res) {
        vdie($data, $wpdb->last_error, $wpdb->last_query);
    }
    $zip_ID = $wpdb->insert_id;

    $res = $wpdb->insert('ma_swiss_zip_data', esc_sql([
        'zip_ID' => $zip_ID,
        'lang'   => 'de',
        'city'   => iconv('Windows-1252', 'UTF-8', $data[0]),
    ]));
    if (false === $res) {
        vdie($data, $wpdb->last_error, $wpdb->last_query);
    }

    echo '. ';
    flush();
}