AdamB7586 /
pdo-dbal
Complex classes like Database often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes. You can also have a look at the cohesion graph to spot any un-connected, or weakly-connected components.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use Database, and based on these observations, apply Extract Interface, too.
| 1 | <?php |
||
| 14 | final class Database implements DBInterface{
|
||
| 15 | protected $db; |
||
| 16 | public $sql; |
||
| 17 | private $key; |
||
| 18 | |||
| 19 | protected $logLocation; |
||
| 20 | public $logErrors = true; |
||
| 21 | public $logQueries = false; |
||
| 22 | public $displayErrors = false; |
||
| 23 | |||
| 24 | protected $database; |
||
| 25 | protected $cacheEnabled = false; |
||
| 26 | protected $cacheObj; |
||
| 27 | protected $cacheValue; |
||
| 28 | protected $modified = false; |
||
| 29 | |||
| 30 | private $query; |
||
| 31 | private $values = []; |
||
| 32 | private $prepare = []; |
||
| 33 | |||
| 34 | private static $connectors = array( |
||
| 35 | 'cubrid' => 'cubrid:host=%s;port=%d;dbname=%s', |
||
| 36 | 'dblib' => 'dblib:host=%s:%d;dbname=%s', |
||
| 37 | 'mssql' => 'sqlsrv:Server=%s,%d;Database=%s', |
||
| 38 | 'mysql' => 'mysql:host=%s;port=%d;dbname=%s', |
||
| 39 | 'pgsql' => 'pgsql:host=%s;port=%d;dbname=%s', |
||
| 40 | 'sqlite' => 'sqlite::memory:' |
||
| 41 | ); |
||
| 42 | |||
| 43 | /** |
||
| 44 | * Connect to database using PDO connection |
||
| 45 | * @param string $hostname This should be the host of the database e.g. 'localhost' |
||
| 46 | * @param string $username This should be the username for the chosen database |
||
| 47 | * @param string $password This should be the password for the chosen database |
||
| 48 | * @param string $database This should be the database that you wish to connect to |
||
| 49 | * @param string|false $backuphost If you have a replication server set up put the hostname or IP address incase the primary server goes down |
||
| 50 | * @param object|false $cache If you want to cache the queries with Memcache(d)/Redis/APC/Xcache This should be the object else set to false |
||
| 51 | * @param boolean $persistent If you want a persistent database connection set to true |
||
| 52 | * @param string $type The type of connection that you wish to make can be 'mysql', 'cubrid', 'dblib', 'mssql', 'odbc', 'pgsql, or 'sqlite' |
||
| 53 | * @param int $port This should be the port number of the MySQL database connection |
||
| 54 | */ |
||
| 55 | 1 | public function __construct($hostname, $username, $password, $database, $backuphost = false, $cache = false, $persistent = false, $type = 'mysql', $port = 3306) {
|
|
| 70 | |||
| 71 | /** |
||
| 72 | * Closes the PDO database connection when Database object unset |
||
| 73 | */ |
||
| 74 | 1 | public function __destruct() {
|
|
| 75 | 1 | $this->closeDatabase(); |
|
| 76 | 1 | } |
|
| 77 | |||
| 78 | /** |
||
| 79 | * Connect to the database using PDO connection |
||
| 80 | * @param string $username This should be the username for the chosen database |
||
| 81 | * @param string $password This should be the password for the chosen database |
||
| 82 | * @param string $database This should be the database that you wish to connect to |
||
| 83 | * @param string $hostname The hostname for the database |
||
| 84 | * @param boolean $persistent If you want a persistent database connection set to true |
||
| 85 | * @param string $type The type of connection that you wish to make can be 'mysql', 'cubrid', 'dblib', 'mssql', 'pgsql, or 'sqlite' |
||
| 86 | * @param int $port The port number to connect to the MySQL server |
||
| 87 | */ |
||
| 88 | 2 | protected function connectToServer($username, $password, $database, $hostname, $persistent = false, $type = 'mysql', $port = 3306) {
|
|
| 100 | |||
| 101 | /** |
||
| 102 | * Enables the caching and set the caching object to the one provided |
||
| 103 | * @param object $caching This should be class of the type of caching you are using |
||
| 104 | */ |
||
| 105 | 1 | public function setCaching($caching) {
|
|
| 112 | |||
| 113 | /** |
||
| 114 | * This query function is used for more advanced SQL queries for which non of the other methods fit |
||
| 115 | * @param string $sql This should be the SQL query which you wish to run |
||
| 116 | * @param array $variables This should be an array of values to execute as the values in a prepared statement |
||
| 117 | * @return array Returns array of results for the query that has just been run |
||
| 118 | */ |
||
| 119 | 1 | public function query($sql, $variables = array(), $cache = true) {
|
|
| 134 | |||
| 135 | /** |
||
| 136 | * Returns a single record for a select query for the chosen table |
||
| 137 | * @param string $table This should be the table you wish to select the values from |
||
| 138 | * @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
||
| 139 | * @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
||
| 140 | * @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC')
|
||
| 141 | * @param boolean $cache If the query should be cached or loaded from cache set to true else set to false |
||
| 142 | * @return array Returns a single table record as the standard array when running SQL queries |
||
| 143 | */ |
||
| 144 | 1 | public function select($table, $where = array(), $fields = '*', $order = array(), $cache = true) {
|
|
| 147 | |||
| 148 | /** |
||
| 149 | * Returns a multidimensional array of the results from the selected table given the given parameters |
||
| 150 | * @param string $table This should be the table you wish to select the values from |
||
| 151 | * @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
||
| 152 | * @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
||
| 153 | * @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC')
|
||
| 154 | * @param integer|array $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150) |
||
| 155 | * @param boolean $cache If the query should be cached or loaded from cache set to true else set to false |
||
| 156 | * @return array Returns a multidimensional array with the chosen fields from the table |
||
| 157 | */ |
||
| 158 | 3 | public function selectAll($table, $where = array(), $fields = '*', $order = array(), $limit = 0, $cache = true) {
|
|
| 168 | |||
| 169 | /** |
||
| 170 | * Returns a single column value for a given query |
||
| 171 | * @param string $table This should be the table you wish to select the values from |
||
| 172 | * @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
||
| 173 | * @param array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
||
| 174 | * @param int $colNum This should be the column number you wish to get (starts at 0) |
||
| 175 | * @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC') so it can be done in both directions
|
||
| 176 | * @param boolean $cache If the query should be cached or loaded from cache set to true else set to false |
||
| 177 | * @return mixed If a result is found will return the value of the colum given else will return false |
||
| 178 | */ |
||
| 179 | 2 | public function fetchColumn($table, $where = array(), $fields = '*', $colNum = 0, $order = array(), $cache = true) {
|
|
| 189 | |||
| 190 | /** |
||
| 191 | * Inserts into database using the prepared PDO statements |
||
| 192 | * @param string $table This should be the table you wish to insert the values into |
||
| 193 | * @param array $records This should be the field names and values in the format of array('fieldname' => 'value', 'fieldname2' => 'value2', etc.)
|
||
| 194 | * @return boolean If data is inserted returns true else returns false |
||
| 195 | */ |
||
| 196 | 2 | public function insert($table, $records) {
|
|
| 203 | |||
| 204 | /** |
||
| 205 | * Updates values in a database using the provide variables |
||
| 206 | * @param string $table This should be the table you wish to update the values for |
||
| 207 | * @param array $records This should be the field names and new values in the format of array('fieldname' => 'newvalue', 'fieldname2' => 'newvalue2', etc.)
|
||
| 208 | * @param array $where Should be the field names and values you wish to update in the form of an array e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
||
| 209 | * @param int $limit The number of results you want to return 0 is default and will update all results that match the query, else should be formated as a standard integer |
||
| 210 | * @return boolean Returns true if update is successful else returns false |
||
| 211 | */ |
||
| 212 | 2 | public function update($table, $records, $where = array(), $limit = 0) {
|
|
| 217 | |||
| 218 | /** |
||
| 219 | * Deletes records from the given table based on the variables given |
||
| 220 | * @param string $table This should be the table you wish to delete the records from |
||
| 221 | * @param array $where This should be an array of for the where statement |
||
| 222 | * @param int $limit The number of results you want to return 0 is default and will delete all results that match the query, else should be formated as a standard integer |
||
| 223 | */ |
||
| 224 | 2 | public function delete($table, $where, $limit = 0) {
|
|
| 229 | |||
| 230 | /** |
||
| 231 | * Count the number of return results |
||
| 232 | * @param string $table The table you wish to count the result of |
||
| 233 | * @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
||
| 234 | * @param boolean $cache If the query should be cached or loaded from cache set to true else set to false |
||
| 235 | * @return int Returns the number of results |
||
| 236 | */ |
||
| 237 | 1 | public function count($table, $where = array(), $cache = true) {
|
|
| 248 | |||
| 249 | /** |
||
| 250 | * Truncates a given table from the selected database so there are no values in the table |
||
| 251 | * @param string $table This should be the table you wish to truncate |
||
| 252 | * @return boolean If the table is emptied returns true else returns false |
||
| 253 | */ |
||
| 254 | 1 | public function truncate($table) {
|
|
| 264 | |||
| 265 | /** |
||
| 266 | * Returns the number of rows for the last query sent |
||
| 267 | * @return int Returns the number of rows for the last query |
||
| 268 | */ |
||
| 269 | 8 | public function numRows() {
|
|
| 275 | |||
| 276 | /** |
||
| 277 | * Returns the number of rows for the last query sent (Looks a the numRows() function just added incase of habbit) |
||
| 278 | * @return int Returns the number of rows for the last query |
||
| 279 | */ |
||
| 280 | 1 | public function rowCount() {
|
|
| 283 | |||
| 284 | /** |
||
| 285 | * Returns the ID of the last record last inserted |
||
| 286 | * @param string $name This should be the name of the sequence object you wish to retrieve |
||
| 287 | * @return int|string Returns the last inserted ID of the last insert item if $name is null else returns string with sequenced object |
||
| 288 | */ |
||
| 289 | 1 | public function lastInsertId($name = null) {
|
|
| 292 | |||
| 293 | /** |
||
| 294 | * Checks to see if a connection has been made to the server |
||
| 295 | * @return boolean |
||
| 296 | */ |
||
| 297 | 2 | public function isConnected() {
|
|
| 300 | |||
| 301 | /** |
||
| 302 | * Returns the server version information |
||
| 303 | */ |
||
| 304 | 1 | public function serverVersion() {
|
|
| 307 | |||
| 308 | /** |
||
| 309 | * Sets the location of the log files |
||
| 310 | * @param string $location This should be where you wish the logs to be stored |
||
| 311 | * @return $this |
||
| 312 | */ |
||
| 313 | 1 | public function setLogLocation($location = false) {
|
|
| 323 | |||
| 324 | /** |
||
| 325 | * Displays the error massage which occurs |
||
| 326 | * @param \Exception $error This should be an instance of Exception |
||
| 327 | */ |
||
| 328 | 4 | private function error($error) {
|
|
| 339 | |||
| 340 | /** |
||
| 341 | * Writes all queries to a log file |
||
| 342 | */ |
||
| 343 | public function writeQueryToLog() {
|
||
| 349 | |||
| 350 | /** |
||
| 351 | * Closes the PDO database connection by setting the connection to NULL |
||
| 352 | */ |
||
| 353 | 1 | public function closeDatabase() {
|
|
| 356 | |||
| 357 | /** |
||
| 358 | * Build the SQL query but doesn't execute it |
||
| 359 | * @param string $table This should be the table you wish to select the values from |
||
| 360 | * @param array $where Should be the field names and values you wish to use as the where query e.g. array('fieldname' => 'value', 'fieldname2' => 'value2', etc).
|
||
| 361 | * @param string|array $fields This should be the records you wis to select from the table. It should be either set as '*' which is the default or set as an array in the following format array('field', 'field2', 'field3', etc).
|
||
| 362 | * @param array $order This is the order you wish the results to be ordered in should be formatted as follows array('fieldname' => 'ASC') or array("'fieldname', 'fieldname2'" => 'DESC') so it can be done in both directions
|
||
| 363 | * @param integer|array $limit The number of results you want to return 0 is default and returns all results, else should be formated either as a standard integer or as an array as the start and end values e.g. array(0 => 150) |
||
| 364 | */ |
||
| 365 | 5 | protected function buildSelectQuery($table, $where = array(), $fields = '*', $order = array(), $limit = 0) {
|
|
| 378 | |||
| 379 | /** |
||
| 380 | * Execute the current query if no cache value is available |
||
| 381 | * @param boolean $cache If the cache should be checked for the checked for the values of the query set to true else set to false |
||
| 382 | * @return mixed If a cached value exists will be returned else if cache is not checked and query is executed will not return anything |
||
| 383 | */ |
||
| 384 | 13 | protected function executeQuery($cache = true) {
|
|
| 402 | |||
| 403 | /** |
||
| 404 | * This outputs the SQL where query based on a given array |
||
| 405 | * @param array $where This should be an array that you wish to create the where query for in the for array('field1' => 'test') or array('field1' => array('>=', 0))
|
||
| 406 | * @return string|false If the where query is an array will return the where string and set the values else returns false if no array sent |
||
| 407 | */ |
||
| 408 | 9 | private function where($where) {
|
|
| 420 | |||
| 421 | /** |
||
| 422 | * Sets the order sting for the SQL query based on an array or string |
||
| 423 | * @param array|string $order This should be either set to array('fieldname' => 'ASC/DESC') or RAND()
|
||
| 424 | * @return string|false If the SQL query has an valid order by will return a string else returns false |
||
| 425 | */ |
||
| 426 | 1 | private function orderBy($order) {
|
|
| 444 | |||
| 445 | /** |
||
| 446 | * Build the field list for the query |
||
| 447 | * @param array $records This should be an array listing all of the fields |
||
| 448 | * @param boolean $insert If this is an insert statement should be set to true to create the correct amount of queries for the prepared statement |
||
| 449 | * @return string The fields list will be returned as a string to insert into the SQL query |
||
| 450 | */ |
||
| 451 | 4 | private function fields($records, $insert = false) {
|
|
| 466 | |||
| 467 | /** |
||
| 468 | * Returns the limit SQL for the current query as a string |
||
| 469 | * @param integer|array $limit This should either be set as an integer or should be set as an array with a start and end value |
||
| 470 | * @return string|false Will return the LIMIT string for the current query if it is valid else returns false |
||
| 471 | */ |
||
| 472 | 1 | private function limit($limit = 0) {
|
|
| 483 | |||
| 484 | |||
| 485 | /** |
||
| 486 | * Set the cache with a key and value |
||
| 487 | * @param string $key The unique key to store the value against |
||
| 488 | * @param mixed $value The value of the MYSQL query |
||
| 489 | */ |
||
| 490 | 2 | public function setCache($key, $value) {
|
|
| 495 | |||
| 496 | /** |
||
| 497 | * Get the results for a given key |
||
| 498 | * @param string $key The unique key to check for stored variables |
||
| 499 | * @return mixed Returned the cached results from |
||
| 500 | */ |
||
| 501 | 2 | public function getCache($key) {
|
|
| 508 | |||
| 509 | /** |
||
| 510 | * Clears the cache |
||
| 511 | */ |
||
| 512 | public function flushDB() {
|
||
| 515 | |||
| 516 | /** |
||
| 517 | * Format the where queries and set the prepared values |
||
| 518 | * @param string $field This should be the field name in the database |
||
| 519 | * @param mixed $value This should be the value which should either be a string or an array if it contains an operator |
||
| 520 | * @return string This should be the string to add to the SQL query |
||
| 521 | */ |
||
| 522 | 8 | protected function formatValues($field, $value) {
|
|
| 545 | |||
| 546 | /** |
||
| 547 | * Band values to use in the query |
||
| 548 | * @param array $values This should be the values being used in the query |
||
| 549 | */ |
||
| 550 | 12 | protected function bindValues($values) {
|
|
| 561 | } |
||
| 562 |
