Issues in eccube_install.php - New Issues - Inspection of "Merge pull request #2199 from chihiro-adachi/csv-d..." - EC-CUBE/ec-cube - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — experimental/3.1 ( 76ccda...aa3e4c )

by Kiyotaka

created 2017-03-24 00:20 UTC

eccube_install.php (6 issues)

Labels

Coding Style 2

Severity

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

<?php

if (php_sapi_name() !== 'cli') {
    exit(1);
}

set_time_limit(0);
ini_set('display_errors', 1);

define('COMPOSER_FILE', 'composer.phar');
define('COMPOSER_SETUP_FILE', 'composer-setup.php');

setUseAnsi($argv);

$argv = is_array($argv) ? $argv : array();

$argv[1] = isset($argv[1]) ? $argv[1] : null;
$argv[2] = isset($argv[2]) ? $argv[2] : null;

if (in_array('--help', $argv) || empty($argv[1])) {
    displayHelp($argv);
    exit(0);
}

if (in_array('-v', $argv) || in_array('--version', $argv)) {
    require __DIR__.'/src/Eccube/Common/Constant.php';
    echo 'EC-CUBE '.Eccube\Common\Constant::VERSION.PHP_EOL;
    exit(0);
}

out('EC-CUBE3 installer use database driver of ', null, false);

$database_driver = 'pdo_sqlite';
switch($argv[1]) {
    case 'mysql':
        $database_driver = 'pdo_mysql';
        break;
    case 'pgsql':
        $database_driver = 'pdo_pgsql';
        break;
    default:
    case 'sqlite':
    case 'sqlite3':
    case 'sqlite3-in-memory':
        $database_driver = 'pdo_sqlite';
}
out($database_driver);

initializeDefaultVariables($database_driver);

if (in_array('-V', $argv) || in_array('--verbose', $argv)) {
    displayEnvironmentVariables();
}

$database = getDatabaseConfig($database_driver);
$connectionParams = $database['database'];

if ($argv[2] != 'none') {
    composerSetup();
    composerInstall();
}

require __DIR__.'/autoload.php';

out('update permissions...');
updatePermissions($argv);

createConfigFiles($database_driver);

if (!in_array('--skip-createdb', $argv)) {
    createDatabase($connectionParams);
}

if (!in_array('--skip-initdb', $argv)) {
    $app = createApplication();
    initializeDatabase($app);
}

out('EC-CUBE3 install finished successfully!', 'success');
$root_urlpath = getenv('ROOT_URLPATH');
if (PHP_VERSION_ID >= 50400 && empty($root_urlpath)) {
    out('PHP built-in web server to run applications, `php -S localhost:8080 -t html`', 'info');
    out('Open your browser and access the http://localhost:8080/', 'info');
}
exit(0);

function displayHelp($argv)
{
    echo <<<EOF
EC-CUBE3 Installer
------------------
Usage:
${argv[0]} [mysql|pgsql|sqlite3] [none] [options]

Arguments[1]:
Specify database types

Arguments[2]:
Specifying the "none" to skip the installation of Composer

Options:
-v, --version        print ec-cube version
-V, --verbose        enable verbose output
--skip-createdb      skip to create database
--skip-initdb        skip to initialize database
--help               this help
--ansi               force ANSI color output
--no-ansi            disable ANSI color output

Environment variables:

EOF;
    foreach (getExampleVariables() as $name => $value) {
        echo $name.'='.$value.PHP_EOL;
    }
}

function initializeDefaultVariables($database_driver)
{
    $database_url = getenv('DATABASE_URL');
    if ($database_url) {
        $url = parse_url($database_url);
        putenv('DBSERVER='.$url['host']);
        putenv('DBNAME='.substr($url['path'], 1));
        putenv('DBUSER='.$url['user']);
        putenv('DBPORT='.$url['port']);
        putenv('DBPASS='.$url['pass']);
    }
    switch ($database_driver) {
        case 'pdo_pgsql':
            putenv('ROOTUSER='.(getenv('ROOTUSER') ? getenv('ROOTUSER') : (getenv('DBUSER') ? getenv('DBUSER') : 'postgres')));
            putenv('ROOTPASS='.(getenv('ROOTPASS') ? getenv('ROOTPASS') : (getenv('DBPASS') ? getenv('DBPASS') : 'password')));
            putenv('DBSERVER='.(getenv('DBSERVER') ? getenv('DBSERVER') : 'localhost'));
            putenv('DBNAME='.(getenv('DBNAME') ? getenv('DBNAME') : 'cube3_dev'));
            putenv('DBUSER='.(getenv('DBUSER') ? getenv('DBUSER') : 'cube3_dev_user'));
            putenv('DBPORT='.(getenv('DBPORT') ? getenv('DBPORT') : '5432'));
            putenv('DBPASS='.(getenv('DBPASS') ? getenv('DBPASS') : 'password'));
            break;
        case 'pdo_mysql':
            putenv('ROOTUSER='.(getenv('ROOTUSER') ? getenv('ROOTUSER') : (getenv('DBUSER') ? getenv('DBUSER') : 'root')));
            putenv('DBSERVER='.(getenv('DBSERVER') ? getenv('DBSERVER') : 'localhost'));
            putenv('DBNAME='.(getenv('DBNAME') ? getenv('DBNAME') : 'cube3_dev'));
            putenv('DBUSER='.(getenv('DBUSER') ? getenv('DBUSER') : 'cube3_dev_user'));
            putenv('DBPORT='.(getenv('DBPORT') ? getenv('DBPORT') : '3306'));
            putenv('DBPASS='.(getenv('DBPASS') ? getenv('DBPASS') : 'password'));
            if (getenv('TRAVIS')) {
                putenv('DBPASS=');
                putenv('ROOTPASS=');
            } else {
                putenv('DBPASS='.(getenv('DBPASS') ? getenv('DBPASS') : 'password'));
                putenv('ROOTPASS='.(getenv('ROOTPASS') ? getenv('ROOTPASS') : (getenv('DBPASS') ? getenv('DBPASS') : 'password')));
            }
            break;
        default:
        case 'pdo_sqlite':
            break;
    }
    putenv('SHOP_NAME='.(getenv('SHOP_NAME') ? getenv('SHOP_NAME') : 'EC-CUBE SHOP'));
    putenv('ADMIN_MAIL='.(getenv('ADMIN_MAIL') ? getenv('ADMIN_MAIL') : '[email protected]'));
    putenv('ADMIN_USER='.(getenv('ADMIN_USER') ? getenv('ADMIN_USER') : 'admin'));
    putenv('ADMIN_PASS='.(getenv('ADMIN_PASS') ? getenv('ADMIN_PASS') : 'password'));
    putenv('MAIL_BACKEND='.(getenv('MAIL_BACKEND') ? getenv('MAIL_BACKEND') : 'smtp'));
    putenv('MAIL_HOST='.(getenv('MAIL_HOST') ? getenv('MAIL_HOST') : 'localhost'));
    putenv('MAIL_PORT='.(getenv('MAIL_PORT') ? getenv('MAIL_PORT') : 25));
    putenv('MAIL_USER='.(getenv('MAIL_USER') ? getenv('MAIL_USER') : null));
    putenv('MAIL_PASS='.(getenv('MAIL_PASS') ? getenv('MAIL_PASS') : null));
    putenv('ADMIN_ROUTE='.(getenv('ADMIN_ROUTE') ? getenv('ADMIN_ROUTE') : 'admin'));
    putenv('ROOT_URLPATH='.(getenv('ROOT_URLPATH') ? getenv('ROOT_URLPATH') : null));
    putenv('AUTH_MAGIC='.(getenv('AUTH_MAGIC') ? getenv('AUTH_MAGIC') :
                          substr(str_replace(array('/', '+', '='), '', base64_encode(openssl_random_pseudo_bytes(32 * 2))), 0, 32)));
}

function getExampleVariables()
{
    return array(
        'ADMIN_USER' => 'admin',
        'ADMIN_MAIL' => '[email protected]',
        'SHOP_NAME' => 'EC-CUBE SHOP',
        'ADMIN_ROUTE' => 'admin',
        'ROOT_URLPATH' => '<ec-cube install path>',
        'DBSERVER' => '127.0.0.1',
        'DBNAME' => 'cube3_dev',
        'DBUSER' => 'cube3_dev_user',
        'DBPASS' => 'password',
        'DBPORT' => '<database port>',
        'ROOTUSER' => 'root|postgres',
        'ROOTPASS' => 'password',
        'MAIL_BACKEND' => 'smtp',
        'MAIL_HOST' => 'localhost',
        'MAIL_PORT' => '25',
        'MAIL_USER' => '<SMTP AUTH user>',
        'MAIL_PASS' => '<SMTP AUTH password>',
        'AUTH_MAGIC' => '<auth_magic>'
    );
}


function displayEnvironmentVariables()
{
    echo 'Environment variables:'.PHP_EOL;
    foreach (array_keys(getExampleVariables()) as $name) {
        echo $name.'='.getenv($name).PHP_EOL;
    }
}

function composerSetup()
{
    if (!file_exists(__DIR__.'/'.COMPOSER_FILE)) {
        if (!file_exists(__DIR__.'/'.COMPOSER_SETUP_FILE)) {
            copy('https://getcomposer.org/installer', COMPOSER_SETUP_FILE);
        }

        $sha = hash_file('SHA384', COMPOSER_SETUP_FILE).PHP_EOL;
        out(COMPOSER_SETUP_FILE.': '.$sha);

        $command = 'php '.COMPOSER_SETUP_FILE;
        out("execute: $command", 'info');
        passthru($command);
        unlink(COMPOSER_SETUP_FILE);
    } else {
        $command = 'php '.COMPOSER_FILE.' self-update';
        passthru($command);
    }
}

function composerInstall()
{
    $command = 'php '.COMPOSER_FILE.' install --dev --no-interaction';
    passthru($command);
}

function createDatabase(array $connectionParams)
{
    $dbname = $connectionParams['dbname'];
    switch ($connectionParams['driver']) {
        case 'pdo_pgsql':
            $connectionParams['dbname'] = 'postgres';
            $connectionParams['user'] = getenv('ROOTUSER');
            $connectionParams['password'] = getenv('ROOTPASS');
            break;
        case 'pdo_mysql':
            $connectionParams['dbname'] = 'mysql';
            $connectionParams['user'] = getenv('ROOTUSER');
            $connectionParams['password'] = getenv('ROOTPASS');
            break;
        default:
        case 'pdo_sqlite':
            $connectionParams['dbname'] = '';
            if (file_exists($dbname)) {
                out('remove database to '.$dbname, 'info');
                unlink($dbname);
            }
            break;
    }

    $config = new \Doctrine\DBAL\Configuration();
    $conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
    $sm = $conn->getSchemaManager();
    out('Created database connection...', 'info');

    if ($connectionParams['driver'] != 'pdo_sqlite') {
        $databases = $sm->listDatabases();
        if (in_array($dbname, $databases)) {
            out('database exists '.$dbname, 'info');
            out('drop database to '.$dbname, 'info');
            $sm->dropDatabase($dbname);
        }
    }
    out('create database to '.$dbname, 'info');
    $sm->createDatabase($dbname);
}

/**
 * @return \Eccube\Application
 */
function createApplication()
{
    $app = \Eccube\Application::getInstance();
    $app['debug'] = true;
    $app->initDoctrine();
    $app->initSecurity();
    $app->register(new \Silex\Provider\FormServiceProvider());
    $app->register(new \Eccube\ServiceProvider\EccubeServiceProvider());
    $app->boot();
    return $app;
}

function initializeDatabase(\Eccube\Application $app)
{
    // Get an instance of your entity manager
    $entityManager = $app['orm.em'];

    // Clear Doctrine to be safe
    $entityManager->getConnection()->getConfiguration()->setSQLLogger(null);
    $entityManager->clear();
    gc_collect_cycles();

    // Schema Tool to process our entities
    $tool = new \Doctrine\ORM\Tools\SchemaTool($entityManager);
    $classes = $entityManager->getMetaDataFactory()->getAllMetaData();

    // Drop all classes and re-build them for each test case
    out('Dropping database schema...', 'info');
    $tool->dropSchema($classes);
    out('Creating database schema...', 'info');
    $tool->createSchema($classes);
    out('Database schema created successfully!', 'success');
    $config = new \Doctrine\DBAL\Migrations\Configuration\Configuration($app['db']);
    $config->setMigrationsNamespace('DoctrineMigrations');

    $loader = new \Eccube\Doctrine\Common\CsvDataFixtures\Loader();
    $loader->loadFromDirectory(__DIR__.'/src/Eccube/Resource/doctrine/import_csv');
    $Executor = new \Eccube\Doctrine\Common\CsvDataFixtures\Executor\DbalExecutor($entityManager);
    $fixtures = $loader->getFixtures();
    $Executor->execute($fixtures);

    $migrationDir = __DIR__.'/src/Eccube/Resource/doctrine/migration';
    $config->setMigrationsDirectory($migrationDir);
    $config->registerMigrationsFromDirectory($migrationDir);

    $migration = new \Doctrine\DBAL\Migrations\Migration($config);
    $migration->setNoMigrationException(true);
    $migration->migrate();
    out('Database migration successfully!', 'success');

    $login_id = getenv('ADMIN_USER');
    $login_password = getenv('ADMIN_PASS');
    $passwordEncoder = new \Eccube\Security\Core\Encoder\PasswordEncoder($app['config']);
    $salt = \Eccube\Util\Str::random(32);
    $encodedPassword = $passwordEncoder->encodePassword($login_password, $salt);

    out('Creating admin accounts...', 'info');
    $member_id = ('postgresql' === $app['db']->getDatabasePlatform()->getName())
        ? $app['db']->fetchColumn("select nextval('dtb_member_member_id_seq')")
        : null;

    $app['db']->insert('dtb_member', [

        'member_id' => $member_id,
        'login_id' => $login_id,
        'password' => $encodedPassword,
        'salt' => $salt,
        'work' => 1,
        'del_flg' => 0,
        'authority' => 0,
        'creator_id' => 1,
        'rank' => 1,
        'update_date' => new \DateTime(),
        'create_date' => new \DateTime(),
        'name' => '管理者',
        'department' => 'EC-CUBE SHOP',
        'discriminator_type' => 'member'
    ], [

        'update_date' => Doctrine\DBAL\Types\Type::DATETIME,
        'create_date' => Doctrine\DBAL\Types\Type::DATETIME,
    ]);

    $shop_name = getenv('SHOP_NAME');
    $admin_mail = getenv('ADMIN_MAIL');

    $id = ('postgresql' === $app['db']->getDatabasePlatform()->getName())
        ? $app['db']->fetchColumn("select nextval('dtb_base_info_id_seq')")
        : null;

    $app['db']->insert('dtb_base_info', [

        'id' => $id,
        'shop_name' => $shop_name,
        'email01' => $admin_mail,
        'email02' => $admin_mail,
        'email03' => $admin_mail,
        'email04' => $admin_mail,
        'update_date' => new \DateTime(),
        'discriminator_type' => 'baseinfo'
    ], [

        'update_date' => \Doctrine\DBAL\Types\Type::DATETIME
    ]);
}

function updatePermissions($argv)
{
    $finder = \Symfony\Component\Finder\Finder::create();
    $finder
        ->in('html')->notName('.htaccess')
        ->in('app')->notName('console');

    $verbose = false;
    if (in_array('-V', $argv) || in_array('--verbose', $argv)) {
        $verbose = true;
    }
    foreach ($finder as $content) {
        $permission = $content->getPerms();
        // see also http://www.php.net/fileperms
        if (!($permission & 0x0010) || !($permission & 0x0002)) {
            $realPath = $content->getRealPath();
            if ($verbose) {
                out(sprintf('%s %s to ', $realPath, substr(sprintf('%o', $permission), -4)), 'info', false);
            }
            $permission = !($permission & 0x0020) ? $permission += 040 : $permission; // g+r
            $permission = !($permission & 0x0010) ? $permission += 020 : $permission; // g+w
            $permission = !($permission & 0x0004) ? $permission += 04 : $permission;  // o+r
            $permission = !($permission & 0x0002) ? $permission += 02 : $permission;  // o+w
            $result = chmod($realPath, $permission);
            if ($verbose) {
                if ($result) {
                    out(substr(sprintf('%o', $permission), -4), 'info');
                } else {
                    out('failure', 'error');
                }
            }
        }
    }
}

function createConfigFiles($database_driver)
{
    $config_path = __DIR__.'/app/config/eccube';
    createYaml(getConfig(), $config_path.'/config.yml');
    createYaml(getDatabaseConfig($database_driver), $config_path.'/database.yml');
    createYaml(getMailConfig(), $config_path.'/mail.yml');
    createYaml(getPathConfig(), $config_path.'/path.yml');
}

function createYaml($config, $path)
{
    $content = \Symfony\Component\Yaml\Yaml::dump($config);
    $fs = new \Symfony\Component\Filesystem\Filesystem();
    $fs->dumpFile($path, $content);
}

function getConfig()
{
    $config = array (
        'auth_magic' => getenv('AUTH_MAGIC'),
        'password_hash_algos' => 'sha256',
        'shop_name' => getenv('SHOP_NAME'),
        'force_ssl' => NULL,
        'admin_allow_host' =>
        array (

        ),
        'cookie_lifetime' => 0,
        'locale' => 'ja',
        'timezone' => 'Asia/Tokyo',
        'eccube_install' => 1,
    );
    return $config;
}

function getDatabaseConfig($database_driver)
{
    $database = array (
        'database' =>
        array (
            'driver' => $database_driver,
        )
    );

    switch ($database_driver) {
        case 'pdo_sqlite':
            $database['database']['dbname'] = $database['database']['path'] = __DIR__.'/app/config/eccube/eccube.db';

            break;
        case 'pdo_pgsql':
        case 'pdo_mysql':
            $database['database']['host'] = getenv('DBSERVER');
            $database['database']['dbname'] = getenv('DBNAME');
            $database['database']['user'] = getenv('DBUSER');
            $database['database']['port'] = getenv('DBPORT');
            $database['database']['password'] = getenv('DBPASS');
            $database['database']['port'] = getenv('DBPORT');
            break;
    }
    $database['database']['charset'] = 'utf8';
    $database['database']['defaultTableOptions'] = array('collate' => 'utf8_general_ci');
    return $database;
}

function getMailConfig()
{
    $mail = array (
        'mail' =>
        array (
            'transport' => getenv('MAIL_BACKEND'),
            'host' => getenv('MAIL_HOST'),
            'port' => getenv('MAIL_PORT'),
            'username' => getenv('MAIL_USER'),
            'password' => getenv('MAIL_PASS'),
            'encryption' => NULL,
            'auth_mode' => NULL,
            'charset_iso_2022_jp' => false,
        ),
    );
    return $mail;
}

/**
 * @see \Eccube\Controller\Install\InstallController::createPathYamlFile()
 */
function getPathConfig()
{
    $ADMIN_ROUTE = getenv('ADMIN_ROUTE');
    $TEMPLATE_CODE = 'default';
    $USER_DATA_ROUTE = 'user_data';
    $ROOT_DIR = realpath(__DIR__);
    $ROOT_URLPATH = getenv('ROOT_URLPATH');
    $ROOT_PUBLIC_URLPATH = $ROOT_URLPATH.RELATIVE_PUBLIC_DIR_PATH;

    $target = array('${ADMIN_ROUTE}', '${TEMPLATE_CODE}', '${USER_DATA_ROUTE}', '${ROOT_DIR}', '${ROOT_URLPATH}', '${ROOT_PUBLIC_URLPATH}');
    $replace = array($ADMIN_ROUTE, $TEMPLATE_CODE, $USER_DATA_ROUTE, $ROOT_DIR, $ROOT_URLPATH, $ROOT_PUBLIC_URLPATH);
    $content = str_replace(
        $target,
        $replace,
        file_get_contents(__DIR__.'/src/Eccube/Resource/config/path.yml.dist')
    );
    return \Symfony\Component\Yaml\Yaml::parse($content);
}

/**
 * @link https://github.com/composer/windows-setup/blob/master/src/php/installer.php
 */
function setUseAnsi($argv)
{
    // --no-ansi wins over --ansi
    if (in_array('--no-ansi', $argv)) {
        define('USE_ANSI', false);
    } elseif (in_array('--ansi', $argv)) {
        define('USE_ANSI', true);
    } else {
        // On Windows, default to no ANSI, except in ANSICON and ConEmu.
        // Everywhere else, default to ANSI if stdout is a terminal.
        define(
            'USE_ANSI',
            (DIRECTORY_SEPARATOR == '\\')
                ? (false !== getenv('ANSICON') || 'ON' === getenv('ConEmuANSI'))
                : (function_exists('posix_isatty') && posix_isatty(1))
        );
    }
}

/**
 * @link https://github.com/composer/windows-setup/blob/master/src/php/installer.php
 */
function out($text, $color = null, $newLine = true)
{
    $styles = array(
        'success' => "\033[0;32m%s\033[0m",
        'error' => "\033[31;31m%s\033[0m",
        'info' => "\033[33;33m%s\033[0m"
    );
    $format = '%s';
    if (isset($styles[$color]) && USE_ANSI) {
        $format = $styles[$color];
    }
    if ($newLine) {
        $format .= PHP_EOL;
    }
    printf($format, $text);
}


1		<?php
2
3		if (php_sapi_name() !== 'cli') {
4		exit(1);
5		}
6
7		set_time_limit(0);
8		ini_set('display_errors', 1);
9
10		define('COMPOSER_FILE', 'composer.phar');
11		define('COMPOSER_SETUP_FILE', 'composer-setup.php');
12
13		setUseAnsi($argv);
14
15		$argv = is_array($argv) ? $argv : array();
16
17		$argv[1] = isset($argv[1]) ? $argv[1] : null;
18		$argv[2] = isset($argv[2]) ? $argv[2] : null;
19
20		if (in_array('--help', $argv) \|\| empty($argv[1])) {
21		displayHelp($argv);
22		exit(0);
23		}
24
25		if (in_array('-v', $argv) \|\| in_array('--version', $argv)) {
26		require __DIR__.'/src/Eccube/Common/Constant.php';
27		echo 'EC-CUBE '.Eccube\Common\Constant::VERSION.PHP_EOL;
28		exit(0);
29		}
30
31		out('EC-CUBE3 installer use database driver of ', null, false);
32
33		$database_driver = 'pdo_sqlite';
34		switch($argv[1]) {
35		case 'mysql':
36		$database_driver = 'pdo_mysql';
37		break;
38		case 'pgsql':
39		$database_driver = 'pdo_pgsql';
40		break;
41		default:
42		case 'sqlite':
43		case 'sqlite3':
44		case 'sqlite3-in-memory':
45		$database_driver = 'pdo_sqlite';
46		}
47		out($database_driver);
48
49		initializeDefaultVariables($database_driver);
50
51		if (in_array('-V', $argv) \|\| in_array('--verbose', $argv)) {
52		displayEnvironmentVariables();
53		}
54
55		$database = getDatabaseConfig($database_driver);
56		$connectionParams = $database['database'];
57
58		if ($argv[2] != 'none') {
59		composerSetup();
60		composerInstall();
61		}
62
63		require __DIR__.'/autoload.php';
64
65		out('update permissions...');
66		updatePermissions($argv);
67
68		createConfigFiles($database_driver);
69
70		if (!in_array('--skip-createdb', $argv)) {
71		createDatabase($connectionParams);
72		}
73
74		if (!in_array('--skip-initdb', $argv)) {
75		$app = createApplication();
76		initializeDatabase($app);
77		}
78
79		out('EC-CUBE3 install finished successfully!', 'success');
80		$root_urlpath = getenv('ROOT_URLPATH');
81		if (PHP_VERSION_ID >= 50400 && empty($root_urlpath)) {
82		out('PHP built-in web server to run applications, `php -S localhost:8080 -t html`', 'info');
83		out('Open your browser and access the http://localhost:8080/', 'info');
84		}
85		exit(0);
86
87		function displayHelp($argv)
88		{
89		echo <<<EOF
90		EC-CUBE3 Installer
91		------------------
92		Usage:
93		${argv[0]} [mysql\|pgsql\|sqlite3] [none] [options]
94
95		Arguments[1]:
96		Specify database types
97
98		Arguments[2]:
99		Specifying the "none" to skip the installation of Composer
100
101		Options:
102		-v, --version print ec-cube version
103		-V, --verbose enable verbose output
104		--skip-createdb skip to create database
105		--skip-initdb skip to initialize database
106		--help this help
107		--ansi force ANSI color output
108		--no-ansi disable ANSI color output
109
110		Environment variables:
111
112		EOF;
113		foreach (getExampleVariables() as $name => $value) {
114		echo $name.'='.$value.PHP_EOL;
115		}
116		}
117
118		function initializeDefaultVariables($database_driver)
119		{
120		$database_url = getenv('DATABASE_URL');
121		if ($database_url) {
122		$url = parse_url($database_url);
123		putenv('DBSERVER='.$url['host']);
124		putenv('DBNAME='.substr($url['path'], 1));
125		putenv('DBUSER='.$url['user']);
126		putenv('DBPORT='.$url['port']);
127		putenv('DBPASS='.$url['pass']);
128		}
129		switch ($database_driver) {
130		case 'pdo_pgsql':
131		putenv('ROOTUSER='.(getenv('ROOTUSER') ? getenv('ROOTUSER') : (getenv('DBUSER') ? getenv('DBUSER') : 'postgres')));
132		putenv('ROOTPASS='.(getenv('ROOTPASS') ? getenv('ROOTPASS') : (getenv('DBPASS') ? getenv('DBPASS') : 'password')));
133		putenv('DBSERVER='.(getenv('DBSERVER') ? getenv('DBSERVER') : 'localhost'));
134		putenv('DBNAME='.(getenv('DBNAME') ? getenv('DBNAME') : 'cube3_dev'));
135		putenv('DBUSER='.(getenv('DBUSER') ? getenv('DBUSER') : 'cube3_dev_user'));
136		putenv('DBPORT='.(getenv('DBPORT') ? getenv('DBPORT') : '5432'));
137		putenv('DBPASS='.(getenv('DBPASS') ? getenv('DBPASS') : 'password'));
138		break;
139		case 'pdo_mysql':
140		putenv('ROOTUSER='.(getenv('ROOTUSER') ? getenv('ROOTUSER') : (getenv('DBUSER') ? getenv('DBUSER') : 'root')));
141		putenv('DBSERVER='.(getenv('DBSERVER') ? getenv('DBSERVER') : 'localhost'));
142		putenv('DBNAME='.(getenv('DBNAME') ? getenv('DBNAME') : 'cube3_dev'));
143		putenv('DBUSER='.(getenv('DBUSER') ? getenv('DBUSER') : 'cube3_dev_user'));
144		putenv('DBPORT='.(getenv('DBPORT') ? getenv('DBPORT') : '3306'));
145		putenv('DBPASS='.(getenv('DBPASS') ? getenv('DBPASS') : 'password'));
146		if (getenv('TRAVIS')) {
147		putenv('DBPASS=');
148		putenv('ROOTPASS=');
149		} else {
150		putenv('DBPASS='.(getenv('DBPASS') ? getenv('DBPASS') : 'password'));
151		putenv('ROOTPASS='.(getenv('ROOTPASS') ? getenv('ROOTPASS') : (getenv('DBPASS') ? getenv('DBPASS') : 'password')));
152		}
153		break;
154		default:
155		case 'pdo_sqlite':
156		break;
157		}
158		putenv('SHOP_NAME='.(getenv('SHOP_NAME') ? getenv('SHOP_NAME') : 'EC-CUBE SHOP'));
159		putenv('ADMIN_MAIL='.(getenv('ADMIN_MAIL') ? getenv('ADMIN_MAIL') : '[email protected]'));
160		putenv('ADMIN_USER='.(getenv('ADMIN_USER') ? getenv('ADMIN_USER') : 'admin'));
161		putenv('ADMIN_PASS='.(getenv('ADMIN_PASS') ? getenv('ADMIN_PASS') : 'password'));
162		putenv('MAIL_BACKEND='.(getenv('MAIL_BACKEND') ? getenv('MAIL_BACKEND') : 'smtp'));
163		putenv('MAIL_HOST='.(getenv('MAIL_HOST') ? getenv('MAIL_HOST') : 'localhost'));
164		putenv('MAIL_PORT='.(getenv('MAIL_PORT') ? getenv('MAIL_PORT') : 25));
165		putenv('MAIL_USER='.(getenv('MAIL_USER') ? getenv('MAIL_USER') : null));
166		putenv('MAIL_PASS='.(getenv('MAIL_PASS') ? getenv('MAIL_PASS') : null));
167		putenv('ADMIN_ROUTE='.(getenv('ADMIN_ROUTE') ? getenv('ADMIN_ROUTE') : 'admin'));
168		putenv('ROOT_URLPATH='.(getenv('ROOT_URLPATH') ? getenv('ROOT_URLPATH') : null));
169		putenv('AUTH_MAGIC='.(getenv('AUTH_MAGIC') ? getenv('AUTH_MAGIC') :
170		substr(str_replace(array('/', '+', '='), '', base64_encode(openssl_random_pseudo_bytes(32 * 2))), 0, 32)));
171		}
172
173		function getExampleVariables()
174		{
175		return array(
176		'ADMIN_USER' => 'admin',
177		'ADMIN_MAIL' => '[email protected]',
178		'SHOP_NAME' => 'EC-CUBE SHOP',
179		'ADMIN_ROUTE' => 'admin',
180		'ROOT_URLPATH' => '<ec-cube install path>',
181		'DBSERVER' => '127.0.0.1',
182		'DBNAME' => 'cube3_dev',
183		'DBUSER' => 'cube3_dev_user',
184		'DBPASS' => 'password',
185		'DBPORT' => '<database port>',
186		'ROOTUSER' => 'root\|postgres',
187		'ROOTPASS' => 'password',
188		'MAIL_BACKEND' => 'smtp',
189		'MAIL_HOST' => 'localhost',
190		'MAIL_PORT' => '25',
191		'MAIL_USER' => '<SMTP AUTH user>',
192		'MAIL_PASS' => '<SMTP AUTH password>',
193		'AUTH_MAGIC' => '<auth_magic>'
194		);
195		}
196
197
198		function displayEnvironmentVariables()
199		{
200		echo 'Environment variables:'.PHP_EOL;
201		foreach (array_keys(getExampleVariables()) as $name) {
202		echo $name.'='.getenv($name).PHP_EOL;
203		}
204		}
205
206		function composerSetup()
207		{
208		if (!file_exists(__DIR__.'/'.COMPOSER_FILE)) {
209		if (!file_exists(__DIR__.'/'.COMPOSER_SETUP_FILE)) {
210		copy('https://getcomposer.org/installer', COMPOSER_SETUP_FILE);
211		}
212
213		$sha = hash_file('SHA384', COMPOSER_SETUP_FILE).PHP_EOL;
214		out(COMPOSER_SETUP_FILE.': '.$sha);
215
216		$command = 'php '.COMPOSER_SETUP_FILE;
217		out("execute: $command", 'info');
218		passthru($command);
219		unlink(COMPOSER_SETUP_FILE);
220		} else {
221		$command = 'php '.COMPOSER_FILE.' self-update';
222		passthru($command);
223		}
224		}
225
226		function composerInstall()
227		{
228		$command = 'php '.COMPOSER_FILE.' install --dev --no-interaction';
229		passthru($command);
230		}
231
232		function createDatabase(array $connectionParams)
233		{
234		$dbname = $connectionParams['dbname'];
235		switch ($connectionParams['driver']) {
236	View Code Duplication	case 'pdo_pgsql':
237		$connectionParams['dbname'] = 'postgres';
238		$connectionParams['user'] = getenv('ROOTUSER');
239		$connectionParams['password'] = getenv('ROOTPASS');
240		break;
241	View Code Duplication	case 'pdo_mysql':
242		$connectionParams['dbname'] = 'mysql';
243		$connectionParams['user'] = getenv('ROOTUSER');
244		$connectionParams['password'] = getenv('ROOTPASS');
245		break;
246		default:
247		case 'pdo_sqlite':
248		$connectionParams['dbname'] = '';
249		if (file_exists($dbname)) {
250		out('remove database to '.$dbname, 'info');
251		unlink($dbname);
252		}
253		break;
254		}
255
256		$config = new \Doctrine\DBAL\Configuration();
257		$conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
258		$sm = $conn->getSchemaManager();
259		out('Created database connection...', 'info');
260
261		if ($connectionParams['driver'] != 'pdo_sqlite') {
262		$databases = $sm->listDatabases();
263		if (in_array($dbname, $databases)) {
264		out('database exists '.$dbname, 'info');
265		out('drop database to '.$dbname, 'info');
266		$sm->dropDatabase($dbname);
267		}
268		}
269		out('create database to '.$dbname, 'info');
270		$sm->createDatabase($dbname);
271		}
272
273		/**
274		* @return \Eccube\Application
275		*/
276		function createApplication()
277		{
278		$app = \Eccube\Application::getInstance();
279		$app['debug'] = true;
280		$app->initDoctrine();
281		$app->initSecurity();
282		$app->register(new \Silex\Provider\FormServiceProvider());
283		$app->register(new \Eccube\ServiceProvider\EccubeServiceProvider());
284		$app->boot();
285		return $app;
286		}
287
288		function initializeDatabase(\Eccube\Application $app)
289		{
290		// Get an instance of your entity manager
291		$entityManager = $app['orm.em'];
292
293		// Clear Doctrine to be safe
294		$entityManager->getConnection()->getConfiguration()->setSQLLogger(null);
295		$entityManager->clear();
296		gc_collect_cycles();
297
298		// Schema Tool to process our entities
299		$tool = new \Doctrine\ORM\Tools\SchemaTool($entityManager);
300		$classes = $entityManager->getMetaDataFactory()->getAllMetaData();
301
302		// Drop all classes and re-build them for each test case
303		out('Dropping database schema...', 'info');
304		$tool->dropSchema($classes);
305		out('Creating database schema...', 'info');
306		$tool->createSchema($classes);
307		out('Database schema created successfully!', 'success');
308		$config = new \Doctrine\DBAL\Migrations\Configuration\Configuration($app['db']);
309		$config->setMigrationsNamespace('DoctrineMigrations');
310
311		$loader = new \Eccube\Doctrine\Common\CsvDataFixtures\Loader();
312		$loader->loadFromDirectory(__DIR__.'/src/Eccube/Resource/doctrine/import_csv');
313		$Executor = new \Eccube\Doctrine\Common\CsvDataFixtures\Executor\DbalExecutor($entityManager);
314		$fixtures = $loader->getFixtures();
315		$Executor->execute($fixtures);
316
317		$migrationDir = __DIR__.'/src/Eccube/Resource/doctrine/migration';
318		$config->setMigrationsDirectory($migrationDir);
319		$config->registerMigrationsFromDirectory($migrationDir);
320
321		$migration = new \Doctrine\DBAL\Migrations\Migration($config);
322		$migration->setNoMigrationException(true);
323		$migration->migrate();
324		out('Database migration successfully!', 'success');
325
326		$login_id = getenv('ADMIN_USER');
327		$login_password = getenv('ADMIN_PASS');
328		$passwordEncoder = new \Eccube\Security\Core\Encoder\PasswordEncoder($app['config']);
329		$salt = \Eccube\Util\Str::random(32);
330		$encodedPassword = $passwordEncoder->encodePassword($login_password, $salt);
331
332		out('Creating admin accounts...', 'info');
333		$member_id = ('postgresql' === $app['db']->getDatabasePlatform()->getName())
334		? $app['db']->fetchColumn("select nextval('dtb_member_member_id_seq')")
335		: null;
336
337		$app['db']->insert('dtb_member', [
		0 ignored issues – show introduced 2017-03-10 13:42 UTC by Report Bug Copy Issue Report Show Similar Issues like this Add a comma after each item in a multi-line array Loading history...
338		'member_id' => $member_id,
339		'login_id' => $login_id,
340		'password' => $encodedPassword,
341		'salt' => $salt,
342		'work' => 1,
343		'del_flg' => 0,
344		'authority' => 0,
345		'creator_id' => 1,
346		'rank' => 1,
347		'update_date' => new \DateTime(),
348		'create_date' => new \DateTime(),
349		'name' => '管理者',
350		'department' => 'EC-CUBE SHOP',
351		'discriminator_type' => 'member'
352		], [
		0 ignored issues – show Coding Style introduced 2017-03-23 10:08 UTC by Report Bug Copy Issue Report Show Similar Issues like this This line of the multi-line function call does not seem to be indented correctly. Expected `8` spaces, but found `4`. Loading history...
353		'update_date' => Doctrine\DBAL\Types\Type::DATETIME,
354		'create_date' => Doctrine\DBAL\Types\Type::DATETIME,
355		]);
356
357		$shop_name = getenv('SHOP_NAME');
358		$admin_mail = getenv('ADMIN_MAIL');
359
360		$id = ('postgresql' === $app['db']->getDatabasePlatform()->getName())
361		? $app['db']->fetchColumn("select nextval('dtb_base_info_id_seq')")
362		: null;
363
364		$app['db']->insert('dtb_base_info', [
		0 ignored issues – show introduced 2017-03-10 13:42 UTC by Report Bug Copy Issue Report Show Similar Issues like this Add a comma after each item in a multi-line array Loading history...
365		'id' => $id,
366		'shop_name' => $shop_name,
367		'email01' => $admin_mail,
368		'email02' => $admin_mail,
369		'email03' => $admin_mail,
370		'email04' => $admin_mail,
371		'update_date' => new \DateTime(),
372		'discriminator_type' => 'baseinfo'
373		], [
		0 ignored issues – show introduced 2017-03-10 13:42 UTC by Report Bug Copy Issue Report Show Similar Issues like this Add a comma after each item in a multi-line array Loading history... Coding Style introduced 2017-03-23 10:08 UTC by Report Bug Copy Issue Report Show Similar Issues like this This line of the multi-line function call does not seem to be indented correctly. Expected `8` spaces, but found `4`. Loading history...
374		'update_date' => \Doctrine\DBAL\Types\Type::DATETIME
375		]);
376		}
377
378		function updatePermissions($argv)
379		{
380		$finder = \Symfony\Component\Finder\Finder::create();
381		$finder
382		->in('html')->notName('.htaccess')
383		->in('app')->notName('console');
384
385		$verbose = false;
386		if (in_array('-V', $argv) \|\| in_array('--verbose', $argv)) {
387		$verbose = true;
388		}
389		foreach ($finder as $content) {
390		$permission = $content->getPerms();
391		// see also http://www.php.net/fileperms
392		if (!($permission & 0x0010) \|\| !($permission & 0x0002)) {
393		$realPath = $content->getRealPath();
394		if ($verbose) {
395		out(sprintf('%s %s to ', $realPath, substr(sprintf('%o', $permission), -4)), 'info', false);
396		}
397		$permission = !($permission & 0x0020) ? $permission += 040 : $permission; // g+r
398		$permission = !($permission & 0x0010) ? $permission += 020 : $permission; // g+w
399		$permission = !($permission & 0x0004) ? $permission += 04 : $permission; // o+r
400		$permission = !($permission & 0x0002) ? $permission += 02 : $permission; // o+w
401		$result = chmod($realPath, $permission);
402		if ($verbose) {
403		if ($result) {
404		out(substr(sprintf('%o', $permission), -4), 'info');
405		} else {
406		out('failure', 'error');
407		}
408		}
409		}
410		}
411		}
412
413		function createConfigFiles($database_driver)
414		{
415		$config_path = __DIR__.'/app/config/eccube';
416		createYaml(getConfig(), $config_path.'/config.yml');
417		createYaml(getDatabaseConfig($database_driver), $config_path.'/database.yml');
418		createYaml(getMailConfig(), $config_path.'/mail.yml');
419		createYaml(getPathConfig(), $config_path.'/path.yml');
420		}
421
422		function createYaml($config, $path)
423		{
424		$content = \Symfony\Component\Yaml\Yaml::dump($config);
425		$fs = new \Symfony\Component\Filesystem\Filesystem();
426		$fs->dumpFile($path, $content);
427		}
428
429		function getConfig()
430		{
431		$config = array (
432		'auth_magic' => getenv('AUTH_MAGIC'),
433		'password_hash_algos' => 'sha256',
434		'shop_name' => getenv('SHOP_NAME'),
435		'force_ssl' => NULL,
436		'admin_allow_host' =>
437		array (
		0 ignored issues – show introduced 2017-03-23 10:08 UTC by Report Bug Copy Issue Report Show Similar Issues like this Add a comma after each item in a multi-line array Loading history...
438		),
439		'cookie_lifetime' => 0,
440		'locale' => 'ja',
441		'timezone' => 'Asia/Tokyo',
442		'eccube_install' => 1,
443		);
444		return $config;
445		}
446
447		function getDatabaseConfig($database_driver)
448		{
449		$database = array (
450		'database' =>
451		array (
452		'driver' => $database_driver,
453		)
454		);
455
456		switch ($database_driver) {
457		case 'pdo_sqlite':
458		$database['database']['dbname'] = $database['database']['path'] = __DIR__.'/app/config/eccube/eccube.db';
459
460		break;
461		case 'pdo_pgsql':
462		case 'pdo_mysql':
463		$database['database']['host'] = getenv('DBSERVER');
464		$database['database']['dbname'] = getenv('DBNAME');
465		$database['database']['user'] = getenv('DBUSER');
466		$database['database']['port'] = getenv('DBPORT');
467		$database['database']['password'] = getenv('DBPASS');
468		$database['database']['port'] = getenv('DBPORT');
469		break;
470		}
471		$database['database']['charset'] = 'utf8';
472		$database['database']['defaultTableOptions'] = array('collate' => 'utf8_general_ci');
473		return $database;
474		}
475
476		function getMailConfig()
477		{
478		$mail = array (
479		'mail' =>
480		array (
481		'transport' => getenv('MAIL_BACKEND'),
482		'host' => getenv('MAIL_HOST'),
483		'port' => getenv('MAIL_PORT'),
484		'username' => getenv('MAIL_USER'),
485		'password' => getenv('MAIL_PASS'),
486		'encryption' => NULL,
487		'auth_mode' => NULL,
488		'charset_iso_2022_jp' => false,
489		),
490		);
491		return $mail;
492		}
493
494		/**
495		* @see \Eccube\Controller\Install\InstallController::createPathYamlFile()
496		*/
497		function getPathConfig()
498		{
499		$ADMIN_ROUTE = getenv('ADMIN_ROUTE');
500		$TEMPLATE_CODE = 'default';
501		$USER_DATA_ROUTE = 'user_data';
502		$ROOT_DIR = realpath(__DIR__);
503		$ROOT_URLPATH = getenv('ROOT_URLPATH');
504		$ROOT_PUBLIC_URLPATH = $ROOT_URLPATH.RELATIVE_PUBLIC_DIR_PATH;
505
506		$target = array('${ADMIN_ROUTE}', '${TEMPLATE_CODE}', '${USER_DATA_ROUTE}', '${ROOT_DIR}', '${ROOT_URLPATH}', '${ROOT_PUBLIC_URLPATH}');
507		$replace = array($ADMIN_ROUTE, $TEMPLATE_CODE, $USER_DATA_ROUTE, $ROOT_DIR, $ROOT_URLPATH, $ROOT_PUBLIC_URLPATH);
508		$content = str_replace(
509		$target,
510		$replace,
511		file_get_contents(__DIR__.'/src/Eccube/Resource/config/path.yml.dist')
512		);
513		return \Symfony\Component\Yaml\Yaml::parse($content);
514		}
515
516		/**
517		* @link https://github.com/composer/windows-setup/blob/master/src/php/installer.php
518		*/
519		function setUseAnsi($argv)
520		{
521		// --no-ansi wins over --ansi
522		if (in_array('--no-ansi', $argv)) {
523		define('USE_ANSI', false);
524		} elseif (in_array('--ansi', $argv)) {
525		define('USE_ANSI', true);
526		} else {
527		// On Windows, default to no ANSI, except in ANSICON and ConEmu.
528		// Everywhere else, default to ANSI if stdout is a terminal.
529		define(
530		'USE_ANSI',
531		(DIRECTORY_SEPARATOR == '\\')
532		? (false !== getenv('ANSICON') \|\| 'ON' === getenv('ConEmuANSI'))
533		: (function_exists('posix_isatty') && posix_isatty(1))
534		);
535		}
536		}
537
538		/**
539		* @link https://github.com/composer/windows-setup/blob/master/src/php/installer.php
540		*/
541		function out($text, $color = null, $newLine = true)
542		{
543		$styles = array(
544		'success' => "\033[0;32m%s\033[0m",
545		'error' => "\033[31;31m%s\033[0m",
546		'info' => "\033[33;33m%s\033[0m"
547		);
548		$format = '%s';
549		if (isset($styles[$color]) && USE_ANSI) {
550		$format = $styles[$color];
551		}
552		if ($newLine) {
553		$format .= PHP_EOL;
554		}
555		printf($format, $text);
556		}
557

EC-CUBE / ec-cube

Push — experimental/3.1 ( 76ccda...aa3e4c )

eccube_install.php (6 issues)

Labels

Severity

Introduced By

Upgrade to new PHP Analysis Engine

Duplication Side-by-Side

Filter issues like