本文整理汇总了PHP中DbHelper::runFile方法的典型用法代码示例。如果您正苦于以下问题:PHP DbHelper::runFile方法的具体用法?PHP DbHelper::runFile怎么用?PHP DbHelper::runFile使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbHelper
的用法示例。
在下文中一共展示了DbHelper::runFile方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: Directory
$path = $_SERVER['argv']['1'];
if (!is_dir($path)) {
$path = Dearchiver::extract($container->getFileDirectory(), $path);
}
$directory = new Directory($path);
} else {
$loader = $container->getInitLoader();
$directory = $loader->load();
}
// Получаем VersionId поскольку если его не окажется, то сообщение об этом мы получим только в самом конце 15-ти минутного процесса, что не очень приятно.
$versionId = $directory->getVersionId();
DbHelper::runFile($dataBaseName, $dbPath . '/01_tables.sql');
DbHelper::runFile($dataBaseName, $dbPath . '/02_system_data.sql');
$addressObjectsConfig = $container->getAddressObjectsImportConfig();
$addressObjects = new AddressObjectsImporter($db, $addressObjectsConfig['table_name'], $addressObjectsConfig['fields']);
$reader = new XmlReader($directory->getAddressObjectFile(), $addressObjectsConfig['node_name'], array_keys($addressObjectsConfig['fields']), $addressObjectsConfig['filters']);
$addressObjects->import($reader);
$housesConfig = $container->getHousesImportConfig();
if ($housesConfig) {
$houses = new HousesImporter($db, $housesConfig['table_name'], $housesConfig['fields']);
$reader = new XmlReader($directory->getHouseFile(), $housesConfig['node_name'], array_keys($housesConfig['fields']));
$houses->import($reader);
}
DbHelper::runFile($dataBaseName, $dbPath . '/03_indexes.sql');
$addressObjects->modifyDataAfterImport();
if ($housesConfig) {
$houses->modifyDataAfterImport();
}
DbHelper::runFile($dataBaseName, $dbPath . '/04_constraints.sql');
DbHelper::runFile($dataBaseName, $dbPath . '/05_clean_up.sql');
UpdateLogHelper::addVersionIdToLog($db, $versionId);
示例2: testRun
public function testRun()
{
DbHelper::runFile($this->container->getDatabaseName(), __DIR__ . '/resources/correctScript.sql');
$this->assertEquals(2, $this->db->execute('SELECT * FROM "correctTable"')->getNumRows());
}