PostgresqlDatabase::shutdown() - Code Metrics - horros/agavi2 - Measure and Improve Code Quality continuously with Scrutinizer

PostgresqlDatabase::shutdown() A
last analyzed 2017-05-30 13:20 UTC

↳ Parent: PostgresqlDatabase

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php
namespace Agavi\Database;

// +---------------------------------------------------------------------------+
// | This file is part of the Agavi package.                                   |
// | Copyright (c) 2005-2011 the Agavi Project.                                |
// | Based on the Mojavi3 MVC Framework, Copyright (c) 2003-2005 Sean Kerr.    |
// |                                                                           |
// | For the full copyright and license information, please view the LICENSE   |
// | file that was distributed with this source code. You can also view the    |
// | LICENSE file online at http://www.agavi.org/LICENSE.txt                   |
// |   vi: set noexpandtab:                                                    |
// |   Local Variables:                                                        |
// |   indent-tabs-mode: t                                                     |
// |   End:                                                                    |
// +---------------------------------------------------------------------------+
use Agavi\Exception\DatabaseException;

/**
 * PostgresqlDatabase provides connectivity for the PostgreSQL brand
 * database.
 *
 * <b>Optional parameters:</b>
 *
 * # <b>database</b>   - [none]      - The database name.
 * # <b>host</b>       - [localhost] - The database host.
 * # <b>method</b>     - [normal]    - How to read connection parameters.
 *                                     Possible values are normal, server, and
 *                                     env. The normal method reads them from
 *                                     the specified values. server reads them
 *                                     from $_SERVER where the keys to retrieve
 *                                     the values are what you specify the value
 *                                     as in the settings. env reads them from
 *                                     $_ENV and works like $_SERVER.
 * # <b>password</b>   - [none]      - The database password.
 * # <b>persistent</b> - [No]        - Indicates that the connection should be
 *                                     persistent.
 * # <b>port</b>       - [none]      - TCP/IP port on which PostgreSQL is
 *                                     listening.
 * # <b>username</b>   - [none]      - The database user.
 *
 * @package    agavi
 * @subpackage database
 *
 * @author     Sean Kerr <[email protected]>
 * @copyright  Authors
 * @copyright  The Agavi Project
 *
 * @since      0.9.0
 *
 * @version    $Id$
 */
class PostgresqlDatabase extends Database
{
    /**
     * Connect to the database.
     *
     * @throws     <b>AgaviDatabaseException</b> If a connection could not be
     *                                           created.
     *
     * @author     Sean Kerr <[email protected]>
     * @since      0.9.0
     */
    protected function connect()
// Bad
class Router
{
    public function generate($path)
    {
        return $_SERVER['HOST'].$path;
    }
}

// Better
class Router
{
    private $host;

    public function __construct($host)
    {
        $this->host = $host;
    }

    public function generate($path)
    {
        return $this->host.$path;
    }
}

class Controller
{
    public function myAction(Request $request)
    {
        // Instead of
        $page = isset($_GET['page']) ? intval($_GET['page']) : 1;

        // Better (assuming you use the Symfony2 request)
        $page = $request->query->get('page', 1);
    }
}
    {
        // determine how to get our parameters
        $method = $this->getParameter('method', 'normal');

        // get parameters
        switch ($method) {
            case 'normal':
                // get parameters normally
                $database = $this->getParameter('database');
                $host     = $this->getParameter('host');
                $password = $this->getParameter('password');
                $port     = $this->getParameter('port');
                $user     = $this->getParameter('username');
                // construct connection string
                $string = (($database != null) ? (' dbname='   . $database) : '') .
                                    (($host != null)     ? (' host='     . $host)     : '') .
                                    (($password != null) ? (' password=' . $password) : '') .
                                    (($port != null)     ? (' port='     . $port)     : '') .
                                    (($user != null)     ? (' user='     . $user)     : '');
                break;

            case 'server':
                // construct a connection string from existing $_SERVER values
                $string = $this->loadParameters($_SERVER);
                break;

            case 'env':
                // construct a connection string from existing $_ENV values
                $string = $this->loadParameters($_ENV);
                break;

            default:
                // who knows what the user wants...
                $error = 'Invalid AgaviPostgreSQLDatabase parameter retrieval method "%s"';
                $error = sprintf($error, $method);
                throw new DatabaseException($error);
        }

        // let's see if we need a persistent connection
        $persistent = $this->getParameter('persistent', false);

        if ($persistent) {
            $this->connection = pg_pconnect($string);
        } else {
            $this->connection = pg_connect($string, PGSQL_CONNECT_FORCE_NEW);
        }

        // make sure the connection went through
        if ($this->connection === false) {
            // the connection's foobar'd
            $error = 'Failed to create a AgaviPostgreSQLDatabase connection';

            throw new DatabaseException($error);
        }

        // since we're not an abstraction layer, we copy the connection
        // to the resource
        $this->resource =& $this->connection;
        
        
        foreach ((array)$this->getParameter('init_queries') as $query) {
            pg_query($this->connection, $query);
        }
    }

    /**
     * Load connection parameters from an existing array.
     *
     * @param      array  $array An array containing the connection information.
     *
     * @return     string A connection string.
     *
     * @author     Sean Kerr <[email protected]>
     * @since      0.9.0
     */
    protected function loadParameters(array $array)
    {
        $database = $this->getParameter('database');
        $host     = $this->getParameter('host');
        $password = $this->getParameter('password');
        $port     = $this->getParameter('port');
        $user     = $this->getParameter('username');

        // construct connection string
        $string = (($database != null) ? (' dbname='   . $array[$database]) : '') .
                            (($host != null)     ? (' host='     . $array[$host])     : '') .
                            (($password != null) ? (' password=' . $array[$password]) : '') .
                            (($port != null)     ? (' port='     . $array[$port])     : '') .
                            (($user != null)     ? (' user='     . $array[$user])     : '');

        return $string;
    }

    /**
     * Execute the shutdown procedure.
     *
     * @throws     <b>AgaviDatabaseException</b> If an error occurs while shutting
     *                                           down this database.
     *
     * @author     Sean Kerr <[email protected]>
     * @since      0.9.0
     */
    public function shutdown()
    {
        if ($this->connection != null) {
            @pg_close($this->connection);
// For example instead of
@mkdir($dir);

// Better use
if (@mkdir($dir) === false) {
    throw new \RuntimeException('The directory '.$dir.' could not be created.');
}
            $this->connection = $this->resource = null;
        }
    }
}


1			<?php
2			namespace Agavi\Database;
3
4			// +---------------------------------------------------------------------------+
5			// \| This file is part of the Agavi package. \|
6			// \| Copyright (c) 2005-2011 the Agavi Project. \|
7			// \| Based on the Mojavi3 MVC Framework, Copyright (c) 2003-2005 Sean Kerr. \|
8			// \| \|
9			// \| For the full copyright and license information, please view the LICENSE \|
10			// \| file that was distributed with this source code. You can also view the \|
11			// \| LICENSE file online at http://www.agavi.org/LICENSE.txt \|
12			// \| vi: set noexpandtab: \|
13			// \| Local Variables: \|
14			// \| indent-tabs-mode: t \|
15			// \| End: \|
16			// +---------------------------------------------------------------------------+
17			use Agavi\Exception\DatabaseException;
18
19			/**
20			* PostgresqlDatabase provides connectivity for the PostgreSQL brand
21			* database.
22			*
23			* <b>Optional parameters:</b>
24			*
25			* # <b>database</b> - [none] - The database name.
26			* # <b>host</b> - [localhost] - The database host.
27			* # <b>method</b> - [normal] - How to read connection parameters.
28			* Possible values are normal, server, and
29			* env. The normal method reads them from
30			* the specified values. server reads them
31			* from $_SERVER where the keys to retrieve
32			* the values are what you specify the value
33			* as in the settings. env reads them from
34			* $_ENV and works like $_SERVER.
35			* # <b>password</b> - [none] - The database password.
36			* # <b>persistent</b> - [No] - Indicates that the connection should be
37			* persistent.
38			* # <b>port</b> - [none] - TCP/IP port on which PostgreSQL is
39			* listening.
40			* # <b>username</b> - [none] - The database user.
41			*
42			* @package agavi
43			* @subpackage database
44			*
45			* @author Sean Kerr <[email protected]>
46			* @copyright Authors
47			* @copyright The Agavi Project
48			*
49			* @since 0.9.0
50			*
51			* @version $Id$
52			*/
53			class PostgresqlDatabase extends Database
54			{
55			/**
56			* Connect to the database.
57			*
58			* @throws <b>AgaviDatabaseException</b> If a connection could not be
59			* created.
60			*
61			* @author Sean Kerr <[email protected]>
62			* @since 0.9.0
63			*/
64			protected function connect()
			0 ignored issues – show Coding Style introduced 2016-11-27 20:51 UTC by Report Bug Copy Issue Report `connect` uses the super-global variable `$_SERVER` which is generally not recommended. Instead of super-globals, we recommend to explicitly inject the dependencies of your class. This makes your code less dependent on global state and it becomes generally more testable: // Bad class Router { public function generate($path) { return $_SERVER['HOST'].$path; } } // Better class Router { private $host; public function __construct($host) { $this->host = $host; } public function generate($path) { return $this->host.$path; } } class Controller { public function myAction(Request $request) { // Instead of $page = isset($_GET['page']) ? intval($_GET['page']) : 1; // Better (assuming you use the Symfony2 request) $page = $request->query->get('page', 1); } } Loading history... Coding Style introduced 2016-11-27 20:51 UTC by Report Bug Copy Issue Report `connect` uses the super-global variable `$_ENV` which is generally not recommended. Instead of super-globals, we recommend to explicitly inject the dependencies of your class. This makes your code less dependent on global state and it becomes generally more testable: // Bad class Router { public function generate($path) { return $_SERVER['HOST'].$path; } } // Better class Router { private $host; public function __construct($host) { $this->host = $host; } public function generate($path) { return $this->host.$path; } } class Controller { public function myAction(Request $request) { // Instead of $page = isset($_GET['page']) ? intval($_GET['page']) : 1; // Better (assuming you use the Symfony2 request) $page = $request->query->get('page', 1); } } Loading history...
65			{
66			// determine how to get our parameters
67			$method = $this->getParameter('method', 'normal');
68
69			// get parameters
70			switch ($method) {
71			case 'normal':
72			// get parameters normally
73			$database = $this->getParameter('database');
74			$host = $this->getParameter('host');
75			$password = $this->getParameter('password');
76			$port = $this->getParameter('port');
77			$user = $this->getParameter('username');
78			// construct connection string
79			$string = (($database != null) ? (' dbname=' . $database) : '') .
80			(($host != null) ? (' host=' . $host) : '') .
81			(($password != null) ? (' password=' . $password) : '') .
82			(($port != null) ? (' port=' . $port) : '') .
83			(($user != null) ? (' user=' . $user) : '');
84			break;
85
86			case 'server':
87			// construct a connection string from existing $_SERVER values
88			$string = $this->loadParameters($_SERVER);
89			break;
90
91			case 'env':
92			// construct a connection string from existing $_ENV values
93			$string = $this->loadParameters($_ENV);
94			break;
95
96			default:
97			// who knows what the user wants...
98			$error = 'Invalid AgaviPostgreSQLDatabase parameter retrieval method "%s"';
99			$error = sprintf($error, $method);
100			throw new DatabaseException($error);
101			}
102
103			// let's see if we need a persistent connection
104			$persistent = $this->getParameter('persistent', false);
105
106			if ($persistent) {
107			$this->connection = pg_pconnect($string);
108			} else {
109			$this->connection = pg_connect($string, PGSQL_CONNECT_FORCE_NEW);
110			}
111
112			// make sure the connection went through
113			if ($this->connection === false) {
114			// the connection's foobar'd
115			$error = 'Failed to create a AgaviPostgreSQLDatabase connection';
116
117			throw new DatabaseException($error);
118			}
119
120			// since we're not an abstraction layer, we copy the connection
121			// to the resource
122			$this->resource =& $this->connection;
123
124
125			foreach ((array)$this->getParameter('init_queries') as $query) {
126			pg_query($this->connection, $query);
127			}
128			}
129
130			/**
131			* Load connection parameters from an existing array.
132			*
133			* @param array $array An array containing the connection information.
134			*
135			* @return string A connection string.
136			*
137			* @author Sean Kerr <[email protected]>
138			* @since 0.9.0
139			*/
140			protected function loadParameters(array $array)
141			{
142			$database = $this->getParameter('database');
143			$host = $this->getParameter('host');
144			$password = $this->getParameter('password');
145			$port = $this->getParameter('port');
146			$user = $this->getParameter('username');
147
148			// construct connection string
149			$string = (($database != null) ? (' dbname=' . $array[$database]) : '') .
150			(($host != null) ? (' host=' . $array[$host]) : '') .
151			(($password != null) ? (' password=' . $array[$password]) : '') .
152			(($port != null) ? (' port=' . $array[$port]) : '') .
153			(($user != null) ? (' user=' . $array[$user]) : '');
154
155			return $string;
156			}
157
158			/**
159			* Execute the shutdown procedure.
160			*
161			* @throws <b>AgaviDatabaseException</b> If an error occurs while shutting
162			* down this database.
163			*
164			* @author Sean Kerr <[email protected]>
165			* @since 0.9.0
166			*/
167			public function shutdown()
168			{
169			if ($this->connection != null) {
170			@pg_close($this->connection);
			0 ignored issues – show Security Best Practice introduced 2016-11-27 20:51 UTC by Report Bug Copy Issue Report It seems like you do not handle an error condition here. This can introduce security issues, and is generally not recommended. If you suppress an error, we recommend checking for the error condition explicitly: // For example instead of @mkdir($dir); // Better use if (@mkdir($dir) === false) { throw new \RuntimeException('The directory '.$dir.' could not be created.'); } Loading history...
171			$this->connection = $this->resource = null;
172			}
173			}
174			}
175

horros / agavi2

PostgresqlDatabase::shutdown() A last analyzed 2017-05-30 13:20 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

PostgresqlDatabase::shutdown() A
last analyzed 2017-05-30 13:20 UTC