Give_DB_Log_Meta::get_meta() - Code Metrics - Inspection of "Implement Give_DB_Meta class with payment, form an..." - ravinderk/Give - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — feature/meta-tables ( 709186...4c8cbd )

by Ravinder

created 2017-08-03 15:25 UTC

Give_DB_Log_Meta::get_meta() B

↳ Parent: Give_DB_Log_Meta

Complexity

Conditions	4
Paths	4

Size

Total Lines	22
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	4
eloc	11
nc	4
nop	3
dl	0
loc	22
rs	8.9197
c	0
b	0
f	0

<?php
/**
 * Logs Meta DB class
 *
 * @package     Give
 * @subpackage  Classes/DB Log Meta
 * @copyright   Copyright (c) 2016, WordImpress
 * @license     https://opensource.org/licenses/gpl-license GNU Public License
 * @since       2.0
 */

// Exit if accessed directly.
if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/**
 * Class Give_DB_Log_Meta
 *
 * This class is for interacting with the log meta database table.
 *
 * @since 2.0
 */
class Give_DB_Log_Meta extends Give_DB_Meta {
	/**
	 * Meta supports.
	 *
	 * @since  2.0
	 * @access protected
	 * @var array
	 */
	protected $supports = array(
		'add_post_metadata',
		'get_post_metadata',
		'update_post_metadata',
		'delete_post_metadata',
	);

	/**
	 * Post type
	 *
	 * @since  2.0
	 * @access protected
	 * @var bool
	 */
	protected $post_type = 'give_log';

	/**
	 * Meta type
	 *
	 * @since  2.0
	 * @access protected
	 * @var bool
	 */
	protected $meta_type = 'log';

	/**
	 * Give_DB_Log_Meta constructor.
	 *
	 * @access  public
	 * @since   2.0
	 */
	public function __construct() {

		/* @var WPDB $wpdb */
		global $wpdb;

		$wpdb->logmeta     = $this->table_name = $wpdb->prefix . 'give_logmeta';
		$this->primary_key = 'meta_id';
		$this->version     = '1.0';

		$this->register_table();

		parent::__construct();
	}

	/**
	 * Get table columns and data types.
	 *
	 * @access  public
	 * @since   2.0
	 *
	 * @return  array  Columns and formats.
	 */
	public function get_columns() {
		return array(
			'meta_id'    => '%d',
			'log_id'     => '%d',
			'meta_key'   => '%s',

			'meta_value' => '%s',

		);
	}

	/**
	 * Delete all log meta
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param int $log_id
	 *
	 * @return bool
	 */
	public function delete_row( $log_id = 0 ) {

		/* @var WPDB $wpdb */
		global $wpdb;

		// Row ID must be positive integer
		$log_id = absint( $log_id );

		if ( empty( $log_id ) ) {
			return false;
		}

		if ( false === $wpdb->query( $wpdb->prepare( "DELETE FROM $this->table_name WHERE log_id = %d", $log_id ) ) ) {

			return false;
		}

		return true;
	}

	/**
	 * Create the table
	 *
	 * @access public
	 * @since  2.0
	 *
	 * @return void
	 */
	public function create_table() {
		global $wpdb;
		$charset_collate = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE {$wpdb->logmeta} (
			meta_id bigint(20) NOT NULL AUTO_INCREMENT,
			log_id bigint(20) NOT NULL,
			meta_key varchar(255) DEFAULT NULL,
			meta_value longtext,
			PRIMARY KEY  (meta_id),
			KEY log_id (log_id),
			KEY meta_key (meta_key)
			) {$charset_collate};";

		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
		dbDelta( $sql );

		update_option( $this->table_name . '_db_version', $this->version );
	}


	/**
	 * Add support for hidden functions.
	 *
	 * @since  2.0
	 * @access public
	 *
	 * @param $name
	 * @param $arguments
	 *
	 * @return mixed
	 */
	public function __call( $name, $arguments ) {

		if ( ! give_has_upgrade_completed( 'v20_logs_upgrades' ) ) {
			return;
		}

		switch ( $name ) {
			case '__add_meta':
				$this->check = $arguments[0];
				$log_id      = $arguments[1];
				$meta_key    = $arguments[2];
				$meta_value  = $arguments[3];
				$unique      = $arguments[4];

				return $this->add_meta( $log_id, $meta_key, $meta_value, $unique );

			case '__get_meta':
				$this->check = $arguments[0];
				$log_id      = $arguments[1];
				$meta_key    = $arguments[2];
				$single      = $arguments[3];

				$this->raw_result = true;

				return $this->get_meta( $log_id, $meta_key, $single );

			case '__update_meta':
				$this->check = $arguments[0];
				$log_id      = $arguments[1];
				$meta_key    = $arguments[2];
				$meta_value  = $arguments[3];

				return $this->update_meta( $log_id, $meta_key, $meta_value );

			case '__delete_meta':
				$this->check = $arguments[0];
				$log_id      = $arguments[1];
				$meta_key    = $arguments[2];
				$meta_value  = $arguments[3];
				$delete_all  = $arguments[4];

				return $this->delete_meta( $log_id, $meta_key, $meta_value, $delete_all );

		}
	}
}


1		<?php
2		/**
3		* Logs Meta DB class
4		*
5		* @package Give
6		* @subpackage Classes/DB Log Meta
7		* @copyright Copyright (c) 2016, WordImpress
8		* @license https://opensource.org/licenses/gpl-license GNU Public License
9		* @since 2.0
10		*/
11
12		// Exit if accessed directly.
13		if ( ! defined( 'ABSPATH' ) ) {
14		exit;
15		}
16
17		/**
18		* Class Give_DB_Log_Meta
19		*
20		* This class is for interacting with the log meta database table.
21		*
22		* @since 2.0
23		*/
24		class Give_DB_Log_Meta extends Give_DB_Meta {
25		/**
26		* Meta supports.
27		*
28		* @since 2.0
29		* @access protected
30		* @var array
31		*/
32		protected $supports = array(
33		'add_post_metadata',
34		'get_post_metadata',
35		'update_post_metadata',
36		'delete_post_metadata',
37		);
38
39		/**
40		* Post type
41		*
42		* @since 2.0
43		* @access protected
44		* @var bool
45		*/
46		protected $post_type = 'give_log';
47
48		/**
49		* Meta type
50		*
51		* @since 2.0
52		* @access protected
53		* @var bool
54		*/
55		protected $meta_type = 'log';
56
57		/**
58		* Give_DB_Log_Meta constructor.
59		*
60		* @access public
61		* @since 2.0
62		*/
63	View Code Duplication	public function __construct() {
		0 ignored issues – show Duplication introduced 2017-07-31 10:46 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
64		/* @var WPDB $wpdb */
65		global $wpdb;
66
67		$wpdb->logmeta = $this->table_name = $wpdb->prefix . 'give_logmeta';
68		$this->primary_key = 'meta_id';
69		$this->version = '1.0';
70
71		$this->register_table();
72
73		parent::__construct();
74		}
75
76		/**
77		* Get table columns and data types.
78		*
79		* @access public
80		* @since 2.0
81		*
82		* @return array Columns and formats.
83		*/
84		public function get_columns() {
85		return array(
86		'meta_id' => '%d',
87		'log_id' => '%d',
88		'meta_key' => '%s',
		0 ignored issues – show introduced 2017-07-29 03:17 UTC by Report Bug Copy Issue Report Detected usage of meta_key, possible slow query. Loading history...
89		'meta_value' => '%s',
		0 ignored issues – show introduced 2017-07-29 03:17 UTC by Report Bug Copy Issue Report Detected usage of meta_value, possible slow query. Loading history...
90		);
91		}
92
93		/**
94		* Delete all log meta
95		*
96		* @since 2.0
97		* @access public
98		*
99		* @param int $log_id
100		*
101		* @return bool
102		*/
103	View Code Duplication	public function delete_row( $log_id = 0 ) {
		0 ignored issues – show Duplication introduced 2017-07-31 10:46 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
104		/* @var WPDB $wpdb */
105		global $wpdb;
106
107		// Row ID must be positive integer
108		$log_id = absint( $log_id );
109
110		if ( empty( $log_id ) ) {
111		return false;
112		}
113
114		if ( false === $wpdb->query( $wpdb->prepare( "DELETE FROM $this->table_name WHERE log_id = %d", $log_id ) ) ) {
		0 ignored issues – show introduced 2017-07-31 10:46 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2017-07-31 10:46 UTC by Report Bug Copy Issue Report Usage of a direct database call without caching is prohibited. Use wp_cache_get / wp_cache_set. Loading history...
115		return false;
116		}
117
118		return true;
119		}
120
121		/**
122		* Create the table
123		*
124		* @access public
125		* @since 2.0
126		*
127		* @return void
128		*/
129		public function create_table() {
130		global $wpdb;
131		$charset_collate = $wpdb->get_charset_collate();
132
133		$sql = "CREATE TABLE {$wpdb->logmeta} (
134		meta_id bigint(20) NOT NULL AUTO_INCREMENT,
135		log_id bigint(20) NOT NULL,
136		meta_key varchar(255) DEFAULT NULL,
137		meta_value longtext,
138		PRIMARY KEY (meta_id),
139		KEY log_id (log_id),
140		KEY meta_key (meta_key)
141		) {$charset_collate};";
142
143		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
144		dbDelta( $sql );
145
146		update_option( $this->table_name . '_db_version', $this->version );
147		}
148
149
150		/**
151		* Add support for hidden functions.
152		*
153		* @since 2.0
154		* @access public
155		*
156		* @param $name
157		* @param $arguments
158		*
159		* @return mixed
160		*/
161	View Code Duplication	public function __call( $name, $arguments ) {
		0 ignored issues – show Duplication introduced 2017-08-03 15:30 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
162		if ( ! give_has_upgrade_completed( 'v20_logs_upgrades' ) ) {
163		return;
164		}
165
166		switch ( $name ) {
167		case '__add_meta':
168		$this->check = $arguments[0];
169		$log_id = $arguments[1];
170		$meta_key = $arguments[2];
171		$meta_value = $arguments[3];
172		$unique = $arguments[4];
173
174		return $this->add_meta( $log_id, $meta_key, $meta_value, $unique );
175
176		case '__get_meta':
177		$this->check = $arguments[0];
178		$log_id = $arguments[1];
179		$meta_key = $arguments[2];
180		$single = $arguments[3];
181
182		$this->raw_result = true;
183
184		return $this->get_meta( $log_id, $meta_key, $single );
185
186		case '__update_meta':
187		$this->check = $arguments[0];
188		$log_id = $arguments[1];
189		$meta_key = $arguments[2];
190		$meta_value = $arguments[3];
191
192		return $this->update_meta( $log_id, $meta_key, $meta_value );
193
194		case '__delete_meta':
195		$this->check = $arguments[0];
196		$log_id = $arguments[1];
197		$meta_key = $arguments[2];
198		$meta_value = $arguments[3];
199		$delete_all = $arguments[4];
200
201		return $this->delete_meta( $log_id, $meta_key, $meta_value, $delete_all );
		0 ignored issues – show Unused Code introduced 2017-08-01 13:00 UTC by Report Bug Copy Issue Report The call to `Give_DB_Log_Meta::delete_meta()` has too many arguments starting with `$delete_all`. 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 `@ignore` PhpDoc annotation to the duplicate definition and it will be ignored. Loading history...
202		}
203		}
204		}
205

ravinderk / Give

Push — feature/meta-tables ( 709186...4c8cbd )

Give_DB_Log_Meta::get_meta() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like