QueryBuilderFilter - Code Metrics - Inspection of "Device groups" - librenms/librenmsv2 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — develop (#143)

by Tony

created 2016-06-23 01:40 UTC

QueryBuilderFilter A

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	95
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
wmc	20
c	1
b	0
f	0
lcom	0
cbo	0
dl	0
loc	95
rs	10

1 Method

Rating	Name	Duplication	Size	Complexity
D	generateFilter()	0	89	20

<?php
/**
 * QueryBuilderFilter.php
 *
 * -Description-
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @package    LibreNMS
 * @link       http://librenms.org
 * @copyright  2016 Tony Murray
 * @author     Tony Murray <[email protected]>
 */

namespace app;


use Cache;
use DB;

class QueryBuilderFilter
{
    /**
     *
     */
    public static function generateFilter()
    {
        //TODO use variable for cache time or check if it should be invalidated
//        Cache::forget('query_builder_filter');

        return Cache::remember('query_builder_filter', 30, function() {
            $filter = [];
            $schema = DB::getDoctrineSchemaManager();

            // Doctrine DBAL has issues with enums, pretend they are strings
            $schema->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');

            $validTypes = ['string', 'integer', 'double', 'date', 'time', 'datetime', 'boolean'];
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
            $ignoreTypes = ['blob', 'binary'];

            $tables = $schema->listTables();
            foreach ($tables as $table) {
                $columns = $schema->listTableColumns($table->getName());
                $tableName = $table->getName();

                // only allow tables with direct association to device_id for now
                if (!$table->hasColumn('device_id')) {
                    continue;
                }

                foreach ($columns as $column) {
                    $item = [];
                    $type = $column->getType()->getName();
                    $name = $column->getName();

                    switch ($type) {
                        case 'text':
//                            $item['input'] = 'textarea';

                        case 'string':
                            $item['type'] = 'string';
                            break;

                        case 'integer':
                        case 'smallint':
                        case 'bigint':
                            $item['type'] = 'integer';
                            break;

                        case 'double':
                        case 'float':
                        case 'decimal':
                            $item['type'] = 'double';
                            break;

                        case 'date':
                            $item['type'] = 'date';
                            break;

                        case 'time':
                            $item['type'] = 'time';
                            break;

                        case 'datetime':
                            $item['type'] = 'datetime';
                            break;

                        case 'boolean':
                            $item['type'] = 'boolean';
                            break;

                    }

                    if (!isset($item['type'])) {
                        if (!in_array($type, $ignoreTypes)) {
                            dd($type);
                        }
                        continue;
                    }


                    // ignore device id columns, except in the devices table
                    if ($name == 'device_id') {
                        if ($tableName != 'devices') {
                            continue;
                        }
                    }

                    $item['id'] = $tableName.'.'.$name;
                    $filter[] = $item;
                }
            }
            return json_encode($filter);
        });
    }
}

1			<?php
2			/**
3			* QueryBuilderFilter.php
4			*
5			* -Description-
6			*
7			* This program is free software: you can redistribute it and/or modify
8			* it under the terms of the GNU General Public License as published by
9			* the Free Software Foundation, either version 3 of the License, or
10			* (at your option) any later version.
11			*
12			* This program is distributed in the hope that it will be useful,
13			* but WITHOUT ANY WARRANTY; without even the implied warranty of
14			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.See the
15			* GNU General Public License for more details.
16			*
17			* You should have received a copy of the GNU General Public License
18			* along with this program. If not, see <http://www.gnu.org/licenses/>.
19			*
20			* @package LibreNMS
21			* @link http://librenms.org
22			* @copyright 2016 Tony Murray
23			* @author Tony Murray <[email protected]>
24			*/
25
26			namespace app;
27
28
29			use Cache;
30			use DB;
31
32			class QueryBuilderFilter
33			{
34			/**
35			*
36			*/
37			public static function generateFilter()
38			{
39			//TODO use variable for cache time or check if it should be invalidated
40			// Cache::forget('query_builder_filter');
41
42			return Cache::remember('query_builder_filter', 30, function() {
43			$filter = [];
44			$schema = DB::getDoctrineSchemaManager();
45
46			// Doctrine DBAL has issues with enums, pretend they are strings
47			$schema->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
48
49			$validTypes = ['string', 'integer', 'double', 'date', 'time', 'datetime', 'boolean'];
			0 ignored issues – show Unused Code introduced 2016-06-21 19:12 UTC by Report Bug Copy Issue Report `$validTypes` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
50			$ignoreTypes = ['blob', 'binary'];
51
52			$tables = $schema->listTables();
53			foreach ($tables as $table) {
54			$columns = $schema->listTableColumns($table->getName());
55			$tableName = $table->getName();
56
57			// only allow tables with direct association to device_id for now
58			if (!$table->hasColumn('device_id')) {
59			continue;
60			}
61
62			foreach ($columns as $column) {
63			$item = [];
64			$type = $column->getType()->getName();
65			$name = $column->getName();
66
67			switch ($type) {
68			case 'text':
69			// $item['input'] = 'textarea';
			0 ignored issues – show Unused Code Comprehensibility introduced 2016-06-21 19:12 UTC by Report Bug Copy Issue Report `60%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
70			case 'string':
71			$item['type'] = 'string';
72			break;
73
74			case 'integer':
75			case 'smallint':
76			case 'bigint':
77			$item['type'] = 'integer';
78			break;
79
80			case 'double':
81			case 'float':
82			case 'decimal':
83			$item['type'] = 'double';
84			break;
85
86			case 'date':
87			$item['type'] = 'date';
88			break;
89
90			case 'time':
91			$item['type'] = 'time';
92			break;
93
94			case 'datetime':
95			$item['type'] = 'datetime';
96			break;
97
98			case 'boolean':
99			$item['type'] = 'boolean';
100			break;
101
102			}
103
104			if (!isset($item['type'])) {
105			if (!in_array($type, $ignoreTypes)) {
106			dd($type);
107			}
108			continue;
109			}
110
111
112			// ignore device id columns, except in the devices table
113			if ($name == 'device_id') {
114			if ($tableName != 'devices') {
115			continue;
116			}
117			}
118
119			$item['id'] = $tableName.'.'.$name;
120			$filter[] = $item;
121			}
122			}
123			return json_encode($filter);
124			});
125			}
126			}

librenms / librenmsv2

Pull Request — develop (#143)

QueryBuilderFilter A

Complexity

Size/Duplication

Coupling/Cohesion

Importance

1 Method

Duplication Side-by-Side

Filter issues like