PHP Shopware\Components\Migrations\Manager示例

示例#1

文件： ApplyDeltas.php 项目： ClaudioThomas/shopware-4

        $config = (require $shopPath . '/engine/Shopware/Configs/Custom.php');
    } else {
        die('Could not find shopware config');
    }
    $dbConfig = $config['db'];
}
if (!isset($dbConfig['host']) || empty($dbConfig['host'])) {
    $dbConfig['host'] = 'localhost';
}
$password = isset($dbConfig['password']) ? $dbConfig['password'] : '';
$connectionSettings = array('host=' . $dbConfig['host'], 'dbname=' . $dbConfig['dbname']);
if (!empty($dbConfig['socket'])) {
    $connectionSettings[] = 'unix_socket=' . $dbConfig['socket'];
}
if (!empty($dbConfig['port'])) {
    $connectionSettings[] = 'port=' . $dbConfig['port'];
}
$connectionString = implode(';', $connectionSettings);
try {
    $conn = new PDO('mysql:' . $connectionString, $dbConfig['username'], $password, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'"));
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    echo 'Could not connect to database: ' . $e->getMessage();
    exit(1);
}
require $shopPath . '/engine/Shopware/Components/Migrations/AbstractMigration.php';
require $shopPath . '/engine/Shopware/Components/Migrations/Manager.php';
$migrationManger = new Shopware\Components\Migrations\Manager($conn, $shopPath . '/_sql/migrations');
$migrationManger->run();
exit(0);

示例#2

文件： ApplyDeltas.php 项目： BucherStoerzbachGbR/shopware

}
$password = isset($dbConfig['password']) ? $dbConfig['password'] : '';
$connectionSettings = array('host=' . $dbConfig['host'], 'dbname=' . $dbConfig['dbname']);
if (!empty($dbConfig['socket'])) {
    $connectionSettings[] = 'unix_socket=' . $dbConfig['socket'];
}
if (!empty($dbConfig['port'])) {
    $connectionSettings[] = 'port=' . $dbConfig['port'];
}
$connectionString = implode(';', $connectionSettings);
try {
    $conn = new PDO('mysql:' . $connectionString, $dbConfig['username'], $password, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'"));
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    // Reset sql_mode "STRICT_TRANS_TABLES" that will be default in MySQL 5.6
    $conn->exec('SET @@session.sql_mode = ""');
} catch (PDOException $e) {
    echo 'Could not connect to database: ' . $e->getMessage();
    exit(1);
}
require $shopPath . '/engine/Shopware/Components/Migrations/AbstractMigration.php';
require $shopPath . '/engine/Shopware/Components/Migrations/Manager.php';
$modeArg = getopt('', array('mode:'));
if (!isset($modeArg['mode']) || $modeArg['mode'] == 'install') {
    $mode = \Shopware\Components\Migrations\AbstractMigration::MODUS_INSTALL;
} else {
    $mode = \Shopware\Components\Migrations\AbstractMigration::MODUS_UPDATE;
}
$migrationManger = new Shopware\Components\Migrations\Manager($conn, $shopPath . '/_sql/migrations');
$migrationManger->run($mode);
exit(0);