Give_DB_Sequential_Ordering::__construct() - Code Metrics - ravinderk/Give - Measure and Improve Code Quality continuously with Scrutinizer

Give_DB_Sequential_Ordering::__construct() A
last analyzed 2019-03-08 02:52 UTC

↳ Parent: Give_DB_Sequential_Ordering

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
nc	1
nop	0
dl	0
loc	10
rs	9.9332
c	0
b	0
f	0

<?php
/**
 * Sequential Donation DB
 *
 * @package     Give
 * @subpackage  Classes/Give_DB_Sequential_Ordering
 * @copyright   Copyright (c) 2018, GiveWP
 * @license     https://opensource.org/licenses/gpl-license GNU Public License
 * @since       2.1.0
 */

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

/**
 * Give_DB_Sequential_Ordering Class
 *
 * This class is for interacting with the sequential donation database table.
 *
 * @since 2.1.0
 */
class Give_DB_Sequential_Ordering extends Give_DB {

	/**
	 * Give_DB_Sequential_Ordering constructor.
	 *
	 * Set up the Give DB Donor class.
	 *
	 * @since  2.1.0
	 * @access public
	 */
	public function __construct() {
		/* @var WPDB $wpdb */
		global $wpdb;

		$this->table_name  = $wpdb->prefix . 'give_sequential_ordering';
		$this->primary_key = 'id';
		$this->version     = '1.0';

		parent::__construct();
	}

	/**
	 * Get columns and formats
	 *
	 * @since  2.1.0
	 * @access public
	 *
	 * @return array  Columns and formats.
	 */
	public function get_columns() {
		return array(
			'id'         => '%d',
			'payment_id' => '%s',
		);
	}

	/**
	 * Get default column values
	 *
	 * @since  2.1.0
	 * @access public
	 *
	 * @return array  Default column values.
	 */
	public function get_column_defaults() {
		return array(
			'id'         => 0,
			'payment_id' => '',
		);
	}


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

		// Calculate auto increment number.
		$payment_ID = $wpdb->get_var(

			$wpdb->prepare(
				"
				SELECT ID
				FROM $wpdb->posts
				WHERE post_type=%s
				ORDER By ID desc
				LIMIT 1
				",
				'give_payment'
			)
		);

		$sql = "CREATE TABLE {$this->table_name} (
        id bigint(20) NOT NULL AUTO_INCREMENT,
        payment_id bigint(20) NOT NULL,
        PRIMARY KEY  (id)
        ) {$charset_collate};";

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

		if ( ! empty( $payment_ID ) ) {
			$auto_increment = $payment_ID + 1;
			$wpdb->query( "ALTER TABLE {$this->table_name} AUTO_INCREMENT={$auto_increment};" );

			give_update_option( 'sequential-ordering_number', $auto_increment );
		} else {
			give_update_option( 'sequential-ordering_number', 1 );
		}

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


	/**
	 * Get id auto increment next value.
	 *
	 * @since 2.1.0
	 * @return null|string
	 */
	public function get_id_auto_increment_val() {
		global $wpdb;

		return $wpdb->get_var(

			$wpdb->prepare(
				"
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				SELECT AUTO_INCREMENT
				FROM  INFORMATION_SCHEMA.TABLES
				WHERE TABLE_SCHEMA=%s
				AND TABLE_NAME=%s
				",
				DB_NAME,
				$this->table_name
			)
		);
	}
}


1			<?php
2			/**
3			* Sequential Donation DB
4			*
5			* @package Give
6			* @subpackage Classes/Give_DB_Sequential_Ordering
7			* @copyright Copyright (c) 2018, GiveWP
8			* @license https://opensource.org/licenses/gpl-license GNU Public License
9			* @since 2.1.0
10			*/
11
12			// Exit if accessed directly.
13			if ( ! defined( 'ABSPATH' ) ) {
14			exit;
15			}
16
17			/**
18			* Give_DB_Sequential_Ordering Class
19			*
20			* This class is for interacting with the sequential donation database table.
21			*
22			* @since 2.1.0
23			*/
24			class Give_DB_Sequential_Ordering extends Give_DB {
25
26			/**
27			* Give_DB_Sequential_Ordering constructor.
28			*
29			* Set up the Give DB Donor class.
30			*
31			* @since 2.1.0
32			* @access public
33			*/
34			public function __construct() {
35			/* @var WPDB $wpdb */
36			global $wpdb;
37
38			$this->table_name = $wpdb->prefix . 'give_sequential_ordering';
39			$this->primary_key = 'id';
40			$this->version = '1.0';
41
42			parent::__construct();
43			}
44
45			/**
46			* Get columns and formats
47			*
48			* @since 2.1.0
49			* @access public
50			*
51			* @return array Columns and formats.
52			*/
53			public function get_columns() {
54			return array(
55			'id' => '%d',
56			'payment_id' => '%s',
57			);
58			}
59
60			/**
61			* Get default column values
62			*
63			* @since 2.1.0
64			* @access public
65			*
66			* @return array Default column values.
67			*/
68			public function get_column_defaults() {
69			return array(
70			'id' => 0,
71			'payment_id' => '',
72			);
73			}
74
75
76			/**
77			* Create the table
78			*
79			* @since 2.1.0
80			* @access public
81			*
82			* @return void
83			*/
84			public function create_table() {
85			global $wpdb;
86			$charset_collate = $wpdb->get_charset_collate();
87
88			// Calculate auto increment number.
89			$payment_ID = $wpdb->get_var(
			0 ignored issues – show introduced 2018-04-03 03:49 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2018-04-03 03:49 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...
90			$wpdb->prepare(
91			"
92			SELECT ID
93			FROM $wpdb->posts
94			WHERE post_type=%s
95			ORDER By ID desc
96			LIMIT 1
97			",
98			'give_payment'
99			)
100			);
101
102			$sql = "CREATE TABLE {$this->table_name} (
103			id bigint(20) NOT NULL AUTO_INCREMENT,
104			payment_id bigint(20) NOT NULL,
105			PRIMARY KEY (id)
106			) {$charset_collate};";
107
108			require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
109			dbDelta( $sql );
110
111			if ( ! empty( $payment_ID ) ) {
112			$auto_increment = $payment_ID + 1;
113			$wpdb->query( "ALTER TABLE {$this->table_name} AUTO_INCREMENT={$auto_increment};" );
			0 ignored issues – show introduced 2018-04-03 03:49 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2018-04-03 03:49 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... introduced 2018-04-03 03:49 UTC by Report Bug Copy Issue Report Attempting a database schema change is highly discouraged. Loading history...
114			give_update_option( 'sequential-ordering_number', $auto_increment );
115			} else {
116			give_update_option( 'sequential-ordering_number', 1 );
117			}
118
119			update_option( $this->table_name . '_db_version', $this->version, false );
120			}
121
122
123			/**
124			* Get id auto increment next value.
125			*
126			* @since 2.1.0
127			* @return null\|string
128			*/
129			public function get_id_auto_increment_val() {
130			global $wpdb;
131
132			return $wpdb->get_var(
			0 ignored issues – show introduced 2018-04-03 03:49 UTC by Report Bug Copy Issue Report Usage of a direct database call is discouraged. Loading history... introduced 2018-04-03 03:49 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...
133			$wpdb->prepare(
134			"
			0 ignored issues – show Coding Style Comprehensibility introduced 2018-04-03 03:49 UTC by Report Bug Copy Issue Report The string literal `\n SELECT...ME=%s\n` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
135			SELECT AUTO_INCREMENT
136			FROM INFORMATION_SCHEMA.TABLES
137			WHERE TABLE_SCHEMA=%s
138			AND TABLE_NAME=%s
139			",
140			DB_NAME,
141			$this->table_name
142			)
143			);
144			}
145			}
146

ravinderk / Give

Give_DB_Sequential_Ordering::__construct() A last analyzed 2019-03-08 02:52 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Give_DB_Sequential_Ordering::__construct() A
last analyzed 2019-03-08 02:52 UTC