Meta_Datastore::get_field_name() - Code Metrics - Inspection of "Merge pull request #20 from pkostadinov-2create/fi..." - htmlburger/carbon-fields - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( e3c09b...f54236 )

by Marin

created 2016-04-13 07:17 UTC

Meta_Datastore::get_field_name() A

↳ Parent: Meta_Datastore

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	1	Features	0

Metric	Value
c	1
b	1
f	0
dl	0
loc	5
ccs	0
cts	3
cp	0
rs	9.4285
cc	1
eloc	3
nc	1
nop	1
crap	2

<?php

namespace Carbon_Fields\Datastore;

use Carbon_Fields\Field\Field;

/**
 * Abstract meta datastore class.
 */
abstract class Meta_Datastore extends Datastore {
	/**
	 * Initialization tasks.
	 **/
	public function init() {}

	/**
	 * Save the field value(s) into the database.
	 *
	 * @param Field $field The field to save.
	 */
	public function save( Field $field ) {
		if ( ! update_metadata( $this->get_meta_type(), $this->get_id(), $this->get_field_name( $field ), $field->get_value() ) ) {
			add_metadata( $this->get_meta_type(), $this->get_id(), $this->get_field_name( $field ), $field->get_value(), true );
		}
	}

	/**
	 * Load the field value(s) from the database.
	 *
	 * @param Field $field The field to retrieve value for.
	 */
	public function load( Field $field ) {
		global $wpdb;

		$value = $wpdb->get_col( '

			SELECT `meta_value`
			FROM ' . $this->get_table_name() . '
			WHERE `' . $this->get_table_field_name() . '`=' . intval( $this->get_id() ) . '
			AND `meta_key`="' . $this->get_field_name( $field ) . '"
			LIMIT 1
		' );

		if ( ! is_array( $value ) || count( $value ) < 1 ) {
			$field->set_value( false );
			return;
		}

		$field->set_value( $value[0] );
	}

	/**
	 * Delete the field value(s) from the database.
	 *
	 * @param Field $field The field to delete.
	 */
	public function delete( Field $field ) {
		delete_metadata( $this->get_meta_type(), $this->get_id(), $this->get_field_name( $field ), $field->get_value() );
	}

	/**
	 * Load complex field value(s) from the database.
	 *
	 * @param mixed $field The field to load values for.
	 */
	public function load_values( $field ) {
		global $wpdb;

		if ( is_object( $field ) && is_subclass_of( $field, 'Carbon_Fields\\Field\\Field' ) ) {

			$meta_key = $this->get_field_name( $field );
		} else {
			$meta_key = $field;
		}

		return $wpdb->get_results( '

			SELECT meta_key AS field_key, meta_value AS field_value FROM ' . $this->get_table_name() . '
			WHERE `meta_key` LIKE "' . addslashes( $meta_key ) . '_%" AND `' . $this->get_table_field_name() . '`="' . intval( $this->get_id() ) . '"
		', ARRAY_A );
	}

	/**
	 * Delete complex field value(s) from the database.
	 *
	 * @param mixed $field The field to delete values for.
	 */
	public function delete_values( $field ) {
		global $wpdb;

		$group_names = $field->get_group_names();
		$field_name = $this->get_field_name( $field );

		$meta_key_constraint = '`meta_key` LIKE "' . $field_name . implode( '-%" OR `meta_key` LIKE "' . $field_name, $group_names ) . '-%"';

		return $wpdb->query( '

			DELETE FROM ' . $this->get_table_name() . '
			WHERE (' . $meta_key_constraint . ') AND `' . $this->get_table_field_name() . '`="' . intval( $this->get_id() ) . '"
		' );
	}

	/**
	 * Retrieve field name
	 */
	public function get_field_name( $field ) {
		$field_name = $field->get_name();

		return $field_name;
	}

	/**
	 * Retrieve the type of meta data.
	 */
	abstract public function get_meta_type();

	/**
	 * Retrieve the meta table name to query.
	 */
	abstract public function get_table_name();

	/**
	 * Retrieve the meta table field name to query by.
	 */
	abstract public function get_table_field_name();

	/**
	 * Set the ID of the datastore.
	 */
	abstract public function set_id( $id );

	/**
	 * Retrieve the ID of the datastore.
	 */
	abstract public function get_id();
}


1		<?php
2
3		namespace Carbon_Fields\Datastore;
4
5		use Carbon_Fields\Field\Field;
6
7		/**
8		* Abstract meta datastore class.
9		*/
10		abstract class Meta_Datastore extends Datastore {
11		/**
12		* Initialization tasks.
13		**/
14		public function init() {}
15
16		/**
17		* Save the field value(s) into the database.
18		*
19		* @param Field $field The field to save.
20		*/
21		public function save( Field $field ) {
22		if ( ! update_metadata( $this->get_meta_type(), $this->get_id(), $this->get_field_name( $field ), $field->get_value() ) ) {
23		add_metadata( $this->get_meta_type(), $this->get_id(), $this->get_field_name( $field ), $field->get_value(), true );
24		}
25		}
26
27		/**
28		* Load the field value(s) from the database.
29		*
30		* @param Field $field The field to retrieve value for.
31		*/
32		public function load( Field $field ) {
33		global $wpdb;
34
35		$value = $wpdb->get_col( '
		0 ignored issues – show introduced 2016-03-02 12:24 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2016-03-02 12:24 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...
36		SELECT `meta_value`
37		FROM ' . $this->get_table_name() . '
38		WHERE `' . $this->get_table_field_name() . '`=' . intval( $this->get_id() ) . '
39		AND `meta_key`="' . $this->get_field_name( $field ) . '"
40		LIMIT 1
41		' );
42
43		if ( ! is_array( $value ) \|\| count( $value ) < 1 ) {
44		$field->set_value( false );
45		return;
46		}
47
48		$field->set_value( $value[0] );
49		}
50
51		/**
52		* Delete the field value(s) from the database.
53		*
54		* @param Field $field The field to delete.
55		*/
56		public function delete( Field $field ) {
57		delete_metadata( $this->get_meta_type(), $this->get_id(), $this->get_field_name( $field ), $field->get_value() );
58		}
59
60		/**
61		* Load complex field value(s) from the database.
62		*
63		* @param mixed $field The field to load values for.
64		*/
65		public function load_values( $field ) {
66		global $wpdb;
67
68	View Code Duplication	if ( is_object( $field ) && is_subclass_of( $field, 'Carbon_Fields\\Field\\Field' ) ) {
		0 ignored issues – show Duplication introduced 2016-03-15 10:23 UTC by Report Bug Copy Issue Report This code seems to be duplicated across 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...
69		$meta_key = $this->get_field_name( $field );
70		} else {
71		$meta_key = $field;
72		}
73
74		return $wpdb->get_results( '
		0 ignored issues – show introduced 2016-03-02 12:24 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2016-03-02 12:24 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...
75		SELECT meta_key AS field_key, meta_value AS field_value FROM ' . $this->get_table_name() . '
76		WHERE `meta_key` LIKE "' . addslashes( $meta_key ) . '_%" AND `' . $this->get_table_field_name() . '`="' . intval( $this->get_id() ) . '"
77		', ARRAY_A );
78		}
79
80		/**
81		* Delete complex field value(s) from the database.
82		*
83		* @param mixed $field The field to delete values for.
84		*/
85		public function delete_values( $field ) {
86		global $wpdb;
87
88		$group_names = $field->get_group_names();
89		$field_name = $this->get_field_name( $field );
90
91		$meta_key_constraint = '`meta_key` LIKE "' . $field_name . implode( '-%" OR `meta_key` LIKE "' . $field_name, $group_names ) . '-%"';
92
93		return $wpdb->query( '
		0 ignored issues – show introduced 2016-03-02 12:24 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2016-03-02 12:24 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...
94		DELETE FROM ' . $this->get_table_name() . '
95		WHERE (' . $meta_key_constraint . ') AND `' . $this->get_table_field_name() . '`="' . intval( $this->get_id() ) . '"
96		' );
97		}
98
99		/**
100		* Retrieve field name
101		*/
102		public function get_field_name( $field ) {
103		$field_name = $field->get_name();
104
105		return $field_name;
106		}
107
108		/**
109		* Retrieve the type of meta data.
110		*/
111		abstract public function get_meta_type();
112
113		/**
114		* Retrieve the meta table name to query.
115		*/
116		abstract public function get_table_name();
117
118		/**
119		* Retrieve the meta table field name to query by.
120		*/
121		abstract public function get_table_field_name();
122
123		/**
124		* Set the ID of the datastore.
125		*/
126		abstract public function set_id( $id );
127
128		/**
129		* Retrieve the ID of the datastore.
130		*/
131		abstract public function get_id();
132		}
133

htmlburger / carbon-fields

Push — master ( e3c09b...f54236 )

Meta_Datastore::get_field_name() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like