Phalcon\Db\Dialect\Oracle::viewExists PHP 메소드

viewExists() 공개 메소드

Generates SQL checking for the existence of a schema.view
public viewExists ( string $viewName, string $schemaName = null ) : string
$viewName string
$schemaName string
리턴 string
    public function viewExists($viewName, $schemaName = null)
    {
        $view = $this->prepareTable($viewName, $schemaName);
        $baseSql = sprintf("SELECT CASE WHEN COUNT(*) > 0 THEN 1 ELSE 0 END RET FROM ALL_VIEWS WHERE VIEW_NAME = %s", Text::upper($view));
        if (!empty($schemaName)) {
            $schemaName = $this->escapeSchema($schemaName, $this->_escapeChar);
            $baseSql .= sprintf("AND OWNER = %s", Text::upper($schemaName));
        }
        return $baseSql;
    }