DbFacade::bcdb() - Code Metrics - Inspection of "Execute select queries on views." - lagdo/jaxon-dbadmin - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( f332df...379075 )

by Thierry

created 2025-09-04 03:27 UTC

DbFacade::bcdb() A

↳ Parent: DbFacade

Complexity

Conditions	2
Paths	2

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	2
nc	2
nop	0
dl	0
loc	4
rs	10
c	0
b	0
f	0

<?php

namespace Lagdo\DbAdmin\Db;

use Jaxon\Di\Container;
use Lagdo\DbAdmin\Admin\Admin;
use Lagdo\DbAdmin\Db\Facades\AbstractFacade;
use Lagdo\DbAdmin\Driver\Utils\Utils;
use Lagdo\DbAdmin\Driver\DriverInterface;
use Lagdo\DbAdmin\Package;

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

    use Traits\UserTrait;

    use Traits\DatabaseTrait;

    use Traits\TableTrait;

    use Traits\SelectTrait;

    use Traits\QueryTrait;

    use Traits\ViewTrait;

    use Traits\CommandTrait;

    use Traits\ExportTrait;

    use Traits\ImportTrait;


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

    /**
     * @var Container
     */
    protected $di;

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

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

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

    /**
     * The constructor
     *
     * @param Container $di
     * @param Utils $utils
     * @param Package $package
     */
    public function __construct(Container $di, Utils $utils, Package $package)
    {
        $this->di = $di;
        $this->utils = $utils;
        $this->package = $package;
        // Make the translator available into views
        $this->package->view()->share('trans', $this->utils->trans);

        $this->breadcrumbs = new Breadcrumbs();
    }

    /**
     * @return Utils|null
     */
    public function utils(): Utils
    {
        return $this->utils;
    }

    /**
     * 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;
    }

    /**
     * Get the current server
     *
     * @return string
     */
    public function getCurrentServer(): string
    {
        return $this->dbServer;
    }

    /**
     * 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
     */
    public function connect(string $server, string $database = '', string $schema = '')
    {
        // Prevent multiple calls.
        if (!$this->driver) {
            // Save the selected server options in the di container.
            $this->di->val('dbadmin_config_driver', $this->package->getServerDriver($server));
            $this->di->val('dbadmin_config_options', $this->package->getServerOptions($server));
            $this->driver = $this->di->get(DriverInterface::class);
            $this->admin = $this->di->get(Admin::class);
        }
        // Open the selected database
        $this->driver->open($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);
    }

    /**
     * @return array
     */
    public function getServerOptions(): array
    {
        return $this->package->getServerOptions($this->dbServer);
    }

    /**
     * Get the remembered queries
     *
     * @return array
     */
    public function queries(): array
    {
        return $this->driver->queries();
    }
}


1			<?php
2
3			namespace Lagdo\DbAdmin\Db;
4
5			use Jaxon\Di\Container;
6			use Lagdo\DbAdmin\Admin\Admin;
7			use Lagdo\DbAdmin\Db\Facades\AbstractFacade;
8			use Lagdo\DbAdmin\Driver\Utils\Utils;
9			use Lagdo\DbAdmin\Driver\DriverInterface;
10			use Lagdo\DbAdmin\Package;
11
12			/**
13			* Facade to calls to the database functions
14			*/
15			class DbFacade extends AbstractFacade
16			{
17			use Traits\ServerTrait;
			0 ignored issues – show Bug introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\ServerTrait` requires the property `$trans` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
18			use Traits\UserTrait;
			0 ignored issues – show Bug introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\UserTrait` requires the property `$trans` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
19			use Traits\DatabaseTrait;
			0 ignored issues – show Bug introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\DatabaseTrait` requires the property `$trans` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
20			use Traits\TableTrait;
			0 ignored issues – show introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\TableTrait` requires some properties which are not provided by `Lagdo\DbAdmin\Db\DbFacade`: `$trans`, `$input` Loading history...
21			use Traits\SelectTrait;
			0 ignored issues – show Bug introduced 2025-09-04 03:30 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\SelectTrait` requires the property `$input` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
22			use Traits\QueryTrait;
			0 ignored issues – show introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\QueryTrait` requires some properties which are not provided by `Lagdo\DbAdmin\Db\DbFacade`: `$trans`, `$input` Loading history...
23			use Traits\ViewTrait;
			0 ignored issues – show introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\ViewTrait` requires some properties which are not provided by `Lagdo\DbAdmin\Db\DbFacade`: `$trans`, `$input` Loading history...
24			use Traits\CommandTrait;
			0 ignored issues – show Bug introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\CommandTrait` requires the property `$trans` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
25			use Traits\ExportTrait;
			0 ignored issues – show Bug introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\ExportTrait` requires the property `$trans` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
26			use Traits\ImportTrait;
			0 ignored issues – show Bug introduced 2025-07-23 17:20 UTC by Report Bug Copy Issue Report The trait `Lagdo\DbAdmin\Db\Traits\ImportTrait` requires the property `$trans` which is not provided by `Lagdo\DbAdmin\Db\DbFacade`. Loading history...
27
28			/**
29			* The breadcrumbs items
30			*
31			* @var Breadcrumbs
32			*/
33			protected $breadcrumbs;
34
35			/**
36			* @var Container
37			*/
38			protected $di;
39
40			/**
41			* @var string
42			*/
43			protected $dbServer;
44
45			/**
46			* @var string
47			*/
48			protected $dbName;
49
50			/**
51			* @var string
52			*/
53			protected $dbSchema;
54
55			/**
56			* The constructor
57			*
58			* @param Container $di
59			* @param Utils $utils
60			* @param Package $package
61			*/
62			public function __construct(Container $di, Utils $utils, Package $package)
63			{
64			$this->di = $di;
65			$this->utils = $utils;
66			$this->package = $package;
67			// Make the translator available into views
68			$this->package->view()->share('trans', $this->utils->trans);
69
70			$this->breadcrumbs = new Breadcrumbs();
71			}
72
73			/**
74			* @return Utils\|null
75			*/
76			public function utils(): Utils
77			{
78			return $this->utils;
79			}
80
81			/**
82			* Get the breadcrumbs object
83			*
84			* @param bool $withDb
85			*
86			* @return Breadcrumbs
87			*/
88			public function breadcrumbs(bool $withDb = false): Breadcrumbs
89			{
90			if ($withDb) {
91			$this->breadcrumbs->clear();
92			if ($this->dbName) {
93			$this->breadcrumbs->item("<i><b>$this->dbName</b></i>");
94			}
95			}
96			return $this->breadcrumbs;
97			}
98
99			/**
100			* @return Container
101			*/
102			public function di(): Container
103			{
104			return $this->di;
105			}
106
107			/**
108			* Set the current database
109			*
110			* @param string $server The selected server
111			* @param string $database The database name
112			* @param string $schema The database schema
113			*
114			* @return void
115			*/
116			public function selectDatabase(string $server, string $database = '', string $schema = '')
117			{
118			$this->dbServer = $server;
119			$this->dbName = $database;
120			$this->dbSchema = $schema;
121			}
122
123			/**
124			* Set the current database name
125			*
126			* @param string $database The database name
127			*
128			* @return void
129			*/
130			public function setCurrentDbName(string $database)
131			{
132			$this->dbName = $database;
133			}
134
135			/**
136			* Get the current server
137			*
138			* @return string
139			*/
140			public function getCurrentServer(): string
141			{
142			return $this->dbServer;
143			}
144
145			/**
146			* Connect to a database server
147			*
148			* @param string $server The selected server
149			* @param string $database The database name
150			* @param string $schema The database schema
151			*
152			* @return void
153			*/
154			public function connect(string $server, string $database = '', string $schema = '')
155			{
156			// Prevent multiple calls.
157			if (!$this->driver) {
158			// Save the selected server options in the di container.
159			$this->di->val('dbadmin_config_driver', $this->package->getServerDriver($server));
160			$this->di->val('dbadmin_config_options', $this->package->getServerOptions($server));
161			$this->driver = $this->di->get(DriverInterface::class);
162			$this->admin = $this->di->get(Admin::class);
163			}
164			// Open the selected database
165			$this->driver->open($database, $schema);
166			}
167
168			/**
169			* @return void
170			*/
171			public function connectToServer()
172			{
173			$this->connect($this->dbServer);
174			}
175
176			/**
177			* @return void
178			*/
179			public function connectToDatabase()
180			{
181			$this->connect($this->dbServer, $this->dbName);
182			}
183
184			/**
185			* @return void
186			*/
187			public function connectToSchema()
188			{
189			$this->connect($this->dbServer, $this->dbName, $this->dbSchema);
190			}
191
192			/**
193			* @return array
194			*/
195			public function getServerOptions(): array
196			{
197			return $this->package->getServerOptions($this->dbServer);
198			}
199
200			/**
201			* Get the remembered queries
202			*
203			* @return array
204			*/
205			public function queries(): array
206			{
207			return $this->driver->queries();
208			}
209			}
210

lagdo / jaxon-dbadmin

Push — main ( f332df...379075 )

DbFacade::bcdb() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like