aviat4ion /
Query
| Conditions | 6 |
| Paths | 10 |
| Total Lines | 54 |
| Code Lines | 23 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 77 | public function backup_data($exclude=[]) |
||
| 78 | { |
||
| 79 | $tables = $this->get_driver()->get_tables(); |
||
| 80 | |||
| 81 | // Filter out the tables you don't want |
||
| 82 | if( ! empty($exclude)) |
||
| 83 | { |
||
| 84 | $tables = array_diff($tables, $exclude); |
||
| 85 | } |
||
| 86 | |||
| 87 | $output_sql = ''; |
||
| 88 | |||
| 89 | // Select the rows from each Table |
||
| 90 | foreach($tables as $t) |
||
| 91 | { |
||
| 92 | $sql = "SELECT * FROM `{$t}`"; |
||
| 93 | $res = $this->get_driver()->query($sql); |
||
|
|
|||
| 94 | $rows = $res->fetchAll(\PDO::FETCH_ASSOC); |
||
| 95 | |||
| 96 | // Skip empty tables |
||
| 97 | if (count($rows) < 1) |
||
| 98 | { |
||
| 99 | continue; |
||
| 100 | } |
||
| 101 | |||
| 102 | // Nab the column names by getting the keys of the first row |
||
| 103 | $columns = @array_keys($rows[0]); |
||
| 104 | |||
| 105 | $insert_rows = []; |
||
| 106 | |||
| 107 | // Create the insert statements |
||
| 108 | foreach($rows as $row) |
||
| 109 | { |
||
| 110 | $row = array_values($row); |
||
| 111 | |||
| 112 | // Workaround for Quercus |
||
| 113 | foreach($row as &$r) |
||
| 114 | { |
||
| 115 | $r = $this->get_driver()->quote($r); |
||
| 116 | } |
||
| 117 | $row = array_map('trim', $row); |
||
| 118 | |||
| 119 | $row_string = 'INSERT INTO `'.trim($t).'` (`'.implode('`,`', $columns).'`) VALUES ('.implode(',', $row).');'; |
||
| 120 | |||
| 121 | $row = NULL; |
||
| 122 | |||
| 123 | $insert_rows[] = $row_string; |
||
| 124 | } |
||
| 125 | |||
| 126 | $output_sql .= "\n\n".implode("\n", $insert_rows)."\n"; |
||
| 127 | } |
||
| 128 | |||
| 129 | return $output_sql; |
||
| 130 | } |
||
| 131 | } |
||
| 132 | // End of mysql_util.php |
This check compares calls to functions or methods with their respective definitions. If the call has more arguments than are defined, it raises an issue.
If a function is defined several times with a different number of parameters, the check may pick up the wrong definition and report false positives. One codebase where this has been known to happen is Wordpress.
In this case you can add the
@ignorePhpDoc annotation to the duplicate definition and it will be ignored.