RuleMapper::populate() - Code Metrics - Inspection of "Fix query, catch and log fs exception" - owncloud/files_antivirus - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — antivirus-update ( fcda38...b6d85d )

by Victor

created 2016-06-09 17:22 UTC

RuleMapper::populate() B

↳ Parent: RuleMapper

Complexity

Conditions	2
Paths	2

Size

Total Lines	179
Code Lines	138

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	138
c	1
b	0
f	0
nc	2
nop	0
dl	0
loc	179
rs	8.2857

How to fix Long Method

<?php
/**
 * Copyright (c) 2015 Victor Dubiniuk <[email protected]>
 * This file is licensed under the Affero General Public License version 3 or
 * later.
 * See the COPYING-README file.
 */

namespace OCA\Files_Antivirus\Db;

use OCP\IDb;
use OCP\AppFramework\Db\Mapper;

use OCA\Files_Antivirus\Db\Rule;

class RuleMapper extends Mapper {
	public function __construct(IDb $db) {
		parent::__construct($db, 'files_avir_status', '\OCA\Files_Antivirus\Db\Rule');
	}
	
	/**
	 * Empty the table
	 * @return bool
	 */
	public function deleteAll(){
		$sql = 'DELETE FROM `*PREFIX*files_avir_status`';
		return $this->execute($sql);
	}
	
	/**
	 * Find rule by id
	 * @param int $id
	 * @return Rule
	 */
	public function find($id){
        $sql = 'SELECT * FROM *PREFIX*files_avir_status WHERE id = ?';
        return $this->findEntity($sql, array($id));
	}
	
	/**
	 * Get all rules
	 */
	public function findAll(){
		$sql = 'SELECT * FROM `*PREFIX*files_avir_status`';
        return $this->findEntities($sql);
	}

	/**
	 * Get collection of rules by given exit code
	 * @param int $result
	 * @return array
	 */
	public function findByResult($result){
		$sql = 'SELECT * FROM `*PREFIX*files_avir_status` WHERE `status_type`=? and `result`=?';
		return $this->findEntities($sql, array(Rule::RULE_TYPE_CODE, $result));
	}
	
	/**
	 * Get collection of rules of type Match
	 * @param int $status
	 * @return array
	 */
	public function findAllMatchedByStatus($status){
		$sql = 'SELECT * FROM `*PREFIX*files_avir_status` WHERE `status_type`=? and `status`=?';
		return $this->findEntities($sql, array(Rule::RULE_TYPE_MATCH, $status));
	}
	
	/**
	 * Fill the table with rules used with clamav
	 */
	public function populate(){
		$descriptions = array(
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 0,
				'match' => '',
				'description' => "",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_CLEAN
			),

			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 1,
				'match' => '',
				'description' => "",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_INFECTED
			),
		
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 40,
				'match' => '',
				'description' => "Unknown option passed.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 50,
				'match' => '',
				'description' => "Database initialization error.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 52,
				'match' => '',
				'description' => "Not supported file type.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 53,
				'match' => '',
				'description' => "Can't open directory.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 54,
				'match' => '',
				'description' => "Can't open file. (ofm)",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 55,
				'match' => '',
				'description' => "Error reading file. (ofm)",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 56,
				'match' => '',
				'description' => "Can't stat input file / directory.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 57,
				'match' => '',
				'description' => "Can't get absolute path name of current working directory.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 58,
				'match' => '',
				'description' => "I/O error, please check your file system.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 62,
				'match' => '',
				'description' => "Can't initialize logger.",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 63,
				'match' => '',
				'description' => "Can't create temporary files/directories (check permissions).",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 64,
				'match' => '',
				'description' => "Can't write to temporary directory (please specify another one).",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 70,
				'match' => '',
				'description' => "Can't allocate memory (calloc).",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_CODE,
				'result' => 71,
				'match' => '',
				'description' => "Can't allocate memory (malloc).",
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_MATCH,
				'result' => 0,
				'match' => '/.*: OK$/',
				'description' => '',
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_CLEAN
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_MATCH,
				'result' => 0,
				'match' => '/.*: (.*) FOUND$/',
				'description' => '',
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_INFECTED
			),
			
			array(
				'groupId' => 0,
				'statusType' => Rule::RULE_TYPE_MATCH,
				'result' => 0,
				'match' => '/.*: (.*) ERROR$/',
				'description' => '',
				'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
			),
		);
		
		foreach ($descriptions as $description){
			$rule = Rule::fromParams($description);
			$this->insert($rule);
		}
	}
}


1			<?php
2			/**
3			* Copyright (c) 2015 Victor Dubiniuk <[email protected]>
4			* This file is licensed under the Affero General Public License version 3 or
5			* later.
6			* See the COPYING-README file.
7			*/
8
9			namespace OCA\Files_Antivirus\Db;
10
11			use OCP\IDb;
12			use OCP\AppFramework\Db\Mapper;
13
14			use OCA\Files_Antivirus\Db\Rule;
15
16			class RuleMapper extends Mapper {
17			public function __construct(IDb $db) {
18			parent::__construct($db, 'files_avir_status', '\OCA\Files_Antivirus\Db\Rule');
19			}
20
21			/**
22			* Empty the table
23			* @return bool
24			*/
25			public function deleteAll(){
26			$sql = 'DELETE FROM `PREFIXfiles_avir_status`';
27			return $this->execute($sql);
28			}
29
30			/**
31			* Find rule by id
32			* @param int $id
33			* @return Rule
34			*/
35			public function find($id){
36			$sql = 'SELECT * FROM PREFIXfiles_avir_status WHERE id = ?';
37			return $this->findEntity($sql, array($id));
38			}
39
40			/**
41			* Get all rules
42			*/
43			public function findAll(){
44			$sql = 'SELECT * FROM `PREFIXfiles_avir_status`';
45			return $this->findEntities($sql);
46			}
47
48			/**
49			* Get collection of rules by given exit code
50			* @param int $result
51			* @return array
52			*/
53			public function findByResult($result){
54			$sql = 'SELECT * FROM `PREFIXfiles_avir_status` WHERE `status_type`=? and `result`=?';
55			return $this->findEntities($sql, array(Rule::RULE_TYPE_CODE, $result));
56			}
57
58			/**
59			* Get collection of rules of type Match
60			* @param int $status
61			* @return array
62			*/
63			public function findAllMatchedByStatus($status){
64			$sql = 'SELECT * FROM `PREFIXfiles_avir_status` WHERE `status_type`=? and `status`=?';
65			return $this->findEntities($sql, array(Rule::RULE_TYPE_MATCH, $status));
66			}
67
68			/**
69			* Fill the table with rules used with clamav
70			*/
71			public function populate(){
72			$descriptions = array(
73			array(
74			'groupId' => 0,
75			'statusType' => Rule::RULE_TYPE_CODE,
76			'result' => 0,
77			'match' => '',
78			'description' => "",
79			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_CLEAN
80			),
81
82			array(
83			'groupId' => 0,
84			'statusType' => Rule::RULE_TYPE_CODE,
85			'result' => 1,
86			'match' => '',
87			'description' => "",
88			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_INFECTED
89			),
90
91			array(
92			'groupId' => 0,
93			'statusType' => Rule::RULE_TYPE_CODE,
94			'result' => 40,
95			'match' => '',
96			'description' => "Unknown option passed.",
97			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
98			),
99
100			array(
101			'groupId' => 0,
102			'statusType' => Rule::RULE_TYPE_CODE,
103			'result' => 50,
104			'match' => '',
105			'description' => "Database initialization error.",
106			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
107			),
108
109			array(
110			'groupId' => 0,
111			'statusType' => Rule::RULE_TYPE_CODE,
112			'result' => 52,
113			'match' => '',
114			'description' => "Not supported file type.",
115			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
116			),
117
118			array(
119			'groupId' => 0,
120			'statusType' => Rule::RULE_TYPE_CODE,
121			'result' => 53,
122			'match' => '',
123			'description' => "Can't open directory.",
124			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
125			),
126
127			array(
128			'groupId' => 0,
129			'statusType' => Rule::RULE_TYPE_CODE,
130			'result' => 54,
131			'match' => '',
132			'description' => "Can't open file. (ofm)",
133			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
134			),
135
136			array(
137			'groupId' => 0,
138			'statusType' => Rule::RULE_TYPE_CODE,
139			'result' => 55,
140			'match' => '',
141			'description' => "Error reading file. (ofm)",
142			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
143			),
144
145			array(
146			'groupId' => 0,
147			'statusType' => Rule::RULE_TYPE_CODE,
148			'result' => 56,
149			'match' => '',
150			'description' => "Can't stat input file / directory.",
151			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
152			),
153
154			array(
155			'groupId' => 0,
156			'statusType' => Rule::RULE_TYPE_CODE,
157			'result' => 57,
158			'match' => '',
159			'description' => "Can't get absolute path name of current working directory.",
160			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
161			),
162
163			array(
164			'groupId' => 0,
165			'statusType' => Rule::RULE_TYPE_CODE,
166			'result' => 58,
167			'match' => '',
168			'description' => "I/O error, please check your file system.",
169			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
170			),
171
172			array(
173			'groupId' => 0,
174			'statusType' => Rule::RULE_TYPE_CODE,
175			'result' => 62,
176			'match' => '',
177			'description' => "Can't initialize logger.",
178			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
179			),
180
181			array(
182			'groupId' => 0,
183			'statusType' => Rule::RULE_TYPE_CODE,
184			'result' => 63,
185			'match' => '',
186			'description' => "Can't create temporary files/directories (check permissions).",
187			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
188			),
189
190			array(
191			'groupId' => 0,
192			'statusType' => Rule::RULE_TYPE_CODE,
193			'result' => 64,
194			'match' => '',
195			'description' => "Can't write to temporary directory (please specify another one).",
196			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
197			),
198
199			array(
200			'groupId' => 0,
201			'statusType' => Rule::RULE_TYPE_CODE,
202			'result' => 70,
203			'match' => '',
204			'description' => "Can't allocate memory (calloc).",
205			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
206			),
207
208			array(
209			'groupId' => 0,
210			'statusType' => Rule::RULE_TYPE_CODE,
211			'result' => 71,
212			'match' => '',
213			'description' => "Can't allocate memory (malloc).",
214			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
215			),
216
217			array(
218			'groupId' => 0,
219			'statusType' => Rule::RULE_TYPE_MATCH,
220			'result' => 0,
221			'match' => '/.*: OK$/',
222			'description' => '',
223			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_CLEAN
224			),
225
226			array(
227			'groupId' => 0,
228			'statusType' => Rule::RULE_TYPE_MATCH,
229			'result' => 0,
230			'match' => '/.: (.) FOUND$/',
231			'description' => '',
232			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_INFECTED
233			),
234
235			array(
236			'groupId' => 0,
237			'statusType' => Rule::RULE_TYPE_MATCH,
238			'result' => 0,
239			'match' => '/.: (.) ERROR$/',
240			'description' => '',
241			'status' => \OCA\Files_Antivirus\Status::SCANRESULT_UNCHECKED
242			),
243			);
244
245			foreach ($descriptions as $description){
246			$rule = Rule::fromParams($description);
247			$this->insert($rule);
248			}
249			}
250			}
251

owncloud / files_antivirus

Push — antivirus-update ( fcda38...b6d85d )

RuleMapper::populate() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like