本文整理匯總了PHP中tlObjectWithDB::getDBViews方法的典型用法代碼示例。如果您正苦於以下問題：PHP tlObjectWithDB::getDBViews方法的具體用法？PHP tlObjectWithDB::getDBViews怎麽用？PHP tlObjectWithDB::getDBViews使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類tlObjectWithDB的用法示例。
在下文中一共展示了tlObjectWithDB::getDBViews方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: drop_views
function drop_views(&$dbHandler, $dbItemPrefix, $dbType)
{
$schema = tlObjectWithDB::getDBViews();
// views present on target db
$my_ado = $dbHandler->get_dbmgr_object();
$itemsOnDB = $my_ado->MetaTables('VIEWS');
if (count($itemsOnDB) > 0 && isset($itemsOnDB[0])) {
echo "<br />Dropping all TL existent views:<br />";
foreach ($schema as $itemPlainName => $itemFullName) {
$target = $dbItemPrefix . $itemPlainName;
if (in_array($itemTable, $itemsOnDB)) {
// Need to add option (CASCADE ?) to delete dependent object
echo "Droping {$target}" . "<br />";
$sql = "DROP VIEW {$target}";
$sql .= $dbType != 'mssql' && $dbType != 'sqlsrv' ? " CASCADE " : ' ';
$dbHandler->exec_query($sql);
}
}
echo "<span class='ok'>Done!</span>";
}
}