$db->exec('GRANT SELECT ON ALL TABLES IN SCHEMA ' . $CONFIG['DB_SCHEMA'] . ' TO ' . $CONFIG['DB_USER']);
$db->commit();
echo 'Finished creating tables/views.' . PHP_EOL;
}
if (promptYesNo('Do you want to load metadata?', true)) {
$db->beginTransaction();
foreach ($imts as $imt) {
$imtFactory->set($imt);
}
foreach ($vs30s as $vs30) {
$vs30Factory->set($vs30);
}
foreach ($editions as $edition) {
$editionFactory->set($edition);
}
foreach ($regions as $region) {
$regionFactory->set($region);
}
$db->commit();
echo 'Finished loading metadata.' . PHP_EOL;
}
if (promptYesNo('Do you want to load static curve data?', true)) {
include_once './load.php';
}
} catch (Exception $e) {
if ($db->inTransaction()) {
$db->rollBack();
}
print $e->getMessage();
}
chdir($oldDir);
