lagdo / jaxon-dbadmin

src/Driver/DbFacade.php

<?php

namespace Lagdo\DbAdmin\Db\Driver;

use Jaxon\App\View\ViewRenderer;
use Jaxon\Di\Container;
use Lagdo\DbAdmin\Db\Driver\Facades\AbstractFacade;
use Lagdo\DbAdmin\Db\Page\AppPage;
use Lagdo\DbAdmin\Db\Service\Breadcrumbs;
use Lagdo\DbAdmin\Driver\Utils\Utils;

/**
 * Facade to calls to the database functions
 */
class DbFacade extends AbstractFacade
{
    use Facades\ServerTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\ServerTrait requires the property $trans which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\UserTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\UserTrait requires the property $trans which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\DatabaseTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\DatabaseTrait requires the property $trans which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\TableTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\TableTrait requires some properties which are not provided by Lagdo\DbAdmin\Db\Driver\DbFacade: $trans, $input

    use Facades\SelectTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\SelectTrait requires the property $input which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\QueryTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\QueryTrait requires the property $input which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\ViewTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\ViewTrait requires some properties which are not provided by Lagdo\DbAdmin\Db\Driver\DbFacade: $trans, $input

    use Facades\CommandTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\CommandTrait requires the property $trans which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\ExportTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\ExportTrait requires the property $trans which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    use Facades\ImportTrait;

The trait Lagdo\DbAdmin\Db\Driver\Facades\ImportTrait requires the property $trans which is not provided by Lagdo\DbAdmin\Db\Driver\DbFacade.

    /**
     * The breadcrumbs items
     *
     * @var Breadcrumbs
     */
    protected $breadcrumbs;

    /**
     * @var string
     */
    protected $dbServer;

    /**
     * @var string
     */
    protected $dbName;

    /**
     * @var string
     */
    protected $dbSchema;

    /**
     * The constructor
     *
     * @param Container $di
     * @param Utils $utils
     * @param ViewRenderer $viewRenderer
     */
    public function __construct(protected Container $di, protected Utils $utils,
        protected ViewRenderer $viewRenderer)
    {
        // Make the translator available into views
        $viewRenderer->share('trans', $utils->trans);
        $this->breadcrumbs = new Breadcrumbs();
    }

    /**
     * @return string
     */
    public function getServerName(): string
    {
        return $this->dbServer;
    }

    /**
     * Get the breadcrumbs object
     *
     * @param bool $withDb
     *
     * @return Breadcrumbs
     */
    public function breadcrumbs(bool $withDb = false): Breadcrumbs
    {
        if ($withDb) {
            $this->breadcrumbs->clear();
            if ($this->dbName) {
                $this->breadcrumbs->item("<i><b>$this->dbName</b></i>");
            }
        }
        return $this->breadcrumbs;
    }

    /**
     * @return Container
     */
    public function di(): Container
    {
        return $this->di;
    }

    /**
     * Set the current database
     *
     * @param string $server    The selected server
     * @param string $database  The database name
     * @param string $schema    The database schema
     *
     * @return void
     */
    public function selectDatabase(string $server, string $database = '', string $schema = '')
    {
        $this->dbServer = $server;
        $this->dbName = $database;
        $this->dbSchema = $schema;
    }

    /**
     * Set the current database name
     *
     * @param string $database  The database name
     *
     * @return void
     */
    public function setCurrentDbName(string $database)
    {
        $this->dbName = $database;
    }

    /**
     * Connect to a database server
     *
     * @param string $server    The selected server
     * @param string $database  The database name
     * @param string $schema    The database schema
     *
     * @return void
     */
    private function connect(string $server, string $database = '', string $schema = '')
    {
        // Prevent multiple calls.
        if (!$this->driver) {
            // Save the selected server in the di container.
            $this->di->val('dbadmin_config_server', $server);
            // The DI is now able to return the corresponding driver.
            $this->driver = $this->di->get(AppDriver::class);
            $this->page = $this->di->get(AppPage::class);
        }
        // Open the selected database
        $this->driver->openConnection($database, $schema);
    }

    /**
     * @return void
     */
    public function connectToServer()
    {
        $this->connect($this->dbServer);
    }

    /**
     * @return void
     */
    public function connectToDatabase()
    {
        $this->connect($this->dbServer, $this->dbName);
    }

    /**
     * @return void
     */
    public function connectToSchema()
    {
        $this->connect($this->dbServer, $this->dbName, $this->dbSchema);
    }

    /**
     * @param array $options
     *
     * @return array
     */
    public function getDatabaseOptions(array $options): array
    {
        if ($this->dbName !== '') {
            $options['database'] = $this->dbName;
        }
        if ($this->dbSchema !== '') {
            $options['schema'] = $this->dbSchema;
        }
        return $options;
    }
}