warlof/seat-migrator

<?php
/**
 * Created by PhpStorm.
 * User: Warlof Tutsimo
 * Date: 21/04/2018
 * Time: 12:42
 */

namespace Warlof\Seat\Migrator\Models;


use Illuminate\Support\Facades\DB;
use Seat\Eveapi\Models\Character\PlanetaryRoute;
use Warlof\Seat\Migrator\Database\Eloquent\MappingCollection;

class CharacterPlanetRoute extends PlanetaryRoute implements ICoreUpgrade
{

    public function upgrade(string $target)
    {
        // TODO
        $sql = "INSERT IGNORE INTO character_planet_route_waypoints (character_id, planet_id, route_id, pin_id, created_at, updated_at) " .
               "VALUES (?, ?, ?, ?, ?, ?)";

        for ($i = 1; $i < 6; $i++)
            DB::connection($target)->insert($sql, [
                $this->ownerID,
                $this->planetID,
                $this->routeID,
                $this->waypoint{$i},
                $this->created_at,
                $this->updated_at,
            ]);

        $this->upgraded = true;
        $this->save();
    }

    public function getUpgradeMapping(): array
    {
        // TODO : implement closure for magic mapper
        return [
            'character_planet_routes' => [
                'ownerID'          => 'character_id',
                'planetID'         => 'planet_id',
                'routeID'          => 'route_id',
                'sourcePinID'      => 'source_pin_id',
                'destinationPinID' => 'destination_pin_id',
                'contentTypeID'    => 'content_type_id',
                'quantity'         => 'quantity',
                'created_at'       => 'created_at',
                'updated_at'       => 'updated_at',
            ],
        ];
    }

    public function newCollection(array $models = [])
    {
        return new MappingCollection($models);
    }
}