UKTowns\Console\ImportPostcodesToDatabase::handle()

Complexity

Conditions	4
Paths	8

Size

Total Lines	48
Code Lines	22

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	22
CRAP Score	4

Importance

Changes

0

<?php
    public function handle(): int
    {
        $tableName = (new GeoPostcode())->getTable();

        if (!Schema::hasTable($tableName)) {
            Schema::create($tableName, function (Blueprint $table) {
                $table->string('postcode', 50)->primary();
                $table->string('postcode_compact', 50)->index();
                $table->string('description', 255);
                $table->string('place', 200)->nullable();
                $table->string('country', 200)->nullable();
                $table->decimal('latitude', 10, 7)->index();
                $table->decimal('longitude', 10, 7)->index();
                $table->timestamps();
            });
        }

        if (!$this->option('no-truncate')) {
            DB::table($tableName)->truncate();
        }

        for ($i = 0; $i <= 3; $i++) {
            $filePath  = __DIR__."/../../storage/uk-postcodes-{$i}.csv";
            $sqlScript = "LOAD DATA LOCAL INFILE '{$filePath}'
            INTO TABLE `{$tableName}`
            CHARACTER SET  '{$this->character()}'
            FIELDS TERMINATED BY ','
            OPTIONALLY ENCLOSED BY '\"'
            LINES TERMINATED BY '\n'
            IGNORE 1 LINES
            (
            postcode,
            postcode_compact,
            description,
            place,
            country,
            latitude,
            longitude,
            created_at,
            updated_at
            )";

            DB::statement('SET FOREIGN_KEY_CHECKS=0;');
            DB::statement(trim($sqlScript));
            DB::statement('SET FOREIGN_KEY_CHECKS=1;');
        }

        return 0;
    }