ifsnop / mysqldump-php

     * @param string $viewName  Name of view to export

     * @return null

     */

    private function getViewStructureTable($viewName)

    {

        if (!$this->dumpSettings['skip-comments']) {

            $ret = "--" . PHP_EOL .

                "-- Stand-In structure for view `${viewName}`" . PHP_EOL .

                "--" . PHP_EOL . PHP_EOL;

            $this->compressManager->write($ret);

        }

        $stmt = $this->typeAdapter->show_create_view($viewName);

        // create views as tables, to resolve dependencies

        foreach ($this->dbHandler->query($stmt) as $r) {

            if ($this->dumpSettings['add-drop-table']) {

                $this->compressManager->write(

                    $this->typeAdapter->drop_view($viewName)

                );

            }

            $this->compressManager->write(

                $this->createStandInTable($viewName)

            );

            break;

        }

    }

    /**

     * Write a create table statement for the table Stand-In, show create

     * @param string $viewName  Name of view to export

     * @return null

     */

    private function getViewStructureView($viewName)

    {

        if (!$this->dumpSettings['skip-comments']) {

            $ret = "--" . PHP_EOL .

                "-- View structure for view `${viewName}`" . PHP_EOL .

                "--" . PHP_EOL . PHP_EOL;

            $this->compressManager->write($ret);

        }

        $stmt = $this->typeAdapter->show_create_view($viewName);

        // create views, to resolve dependencies

        // replacing tables with views

        foreach ($this->dbHandler->query($stmt) as $r) {

            // because we must replace table with view, we should delete it

            $this->compressManager->write(

                $this->typeAdapter->drop_view($viewName)

            );

            $this->compressManager->write(

                $this->typeAdapter->create_view($r)

            );

            break;

        }

    }

    /**

     * Trigger structure extractor