BulkWP\BulkDelete\Addon\QueryOverriders\DeleteCommentsQueryOverrider

Complexity

Total Complexity

5

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	filter_where()	0	6	1
A	parse_query()	0	6	2
A	load()	0	2	1
A	remove_where_filter()	0	2	1

<?php

namespace BulkWP\BulkDelete\Core\Comments\QueryOverriders;

use BulkWP\BulkDelete\Core\Base\BaseQueryOverrider;

/**
 * Overrides query that is used for retrieving comments.
 *
 * @since 6.1.0
 */
class DeleteCommentsQueryOverrider extends BaseQueryOverrider {
	/**
	 * DB column name. Mostly either `comment_author_IP` or `comment_author`.
	 *
	 * @var string
	 */
	protected $db_column_name;

	/**
	 * The value that should be compared.
	 *
	 * @var string
	 */
	protected $db_column_value;

	public function load() {
		add_action( 'parse_comment_query', array( $this, 'parse_query' ) );
	}

	/**
	 * Parse the query and retrieve the values.
	 *
	 * @param array $query WP_Comment_Query arguments.
	 */
	public function parse_query( $query ) {
		if ( isset( $query->query_vars['bd_db_column_name'], $query->query_vars['bd_db_column_value'] ) ) {
			$this->db_column_name  = $query->query_vars['bd_db_column_name'];
			$this->db_column_value = $query->query_vars['bd_db_column_value'];

			add_filter( 'comments_clauses', array( $this, 'filter_where' ) );
		}
	}

	/**
	 * Modify the where clause.
	 *
	 * @param array $clauses Comment clauses.
	 *
	 * @return array Modified comment clauses.
	 */
	public function filter_where( $clauses ) {
		$clauses['where'] .= sprintf( " AND %s = '%s' ", esc_sql( $this->db_column_name ), esc_sql( $this->db_column_value ) );

It seems like esc_sql($this->db_column_name) can also be of type array; however, parameter $args of sprintf() does only seem to accept string, maybe add an additional type check?

		$this->remove_where_filter();

		return $clauses;
	}

	/**
	 * Remove the `posts_where` filter.
	 */
	public function remove_where_filter() {
		remove_filter( 'comments_clauses', array( $this, 'filter_where' ) );
	}
}