<?php

namespace Limesharp\Stockists\Setup;

use Magento\Framework\App\State;
use Magento\Framework\Setup\InstallDataInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\ModuleDataSetupInterface;

/**
 * @codeCoverageIgnore
 */
class InstallData implements InstallDataInterface
{
    /**
     * {@inheritdoc}
     */
    public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
    {
        $setup->startSetup();

        $query = "INSERT INTO `". $setup->getTable('limesharp_stockists_stores') . "` (`stockist_id`, `store_id`, `name`, `address`, `city`, `country`, `postcode`, `region`, `email`, `phone`, `link`, `image`, `latitude`, `longitude`, `status`, `updated_at`, `created_at`, `schedule`, `station`, `description`, `intro`, `details_image`, `distance`, `external_link`) VALUES(1, '2,3,8', 'Test', 'Corso Umberto, I', 'Civitanova Marche', 'IT', '62012', 'Macerata', 'info@drop.it', '+39 0733 779539', 'http://www.drop.it', '/l/o/logo.png', '43.267433', '13.651622999999972', 1, '2018-07-20 12:46:45', '2018-07-20 09:38:50', NULL, 'Test Nearest Station', 'Test Description', 'Test Intro', '/l/o/logo_1.png', 'Test Distance', 'http://www.drop.it')";
        $setup->getConnection()->query($query);

        $setup->endSetup();
    }
}
