Ubuntu

table = $table; } /** * Sanitize a value for a given column before inserting it into the DB. * * @param string $column The column name. * @param mixed $value The value to sanitize. * * @return mixed The sanitized value. */ protected function sanitize_value( string $column, $value ) { return $value; } /** * Get count of products grouped by price_compared_with_benchmark value. * * @return array Returns an array with counts for each price comparison group. */ public function get_price_benchmark_counts(): array { // Get the raw SQL query with GROUP BY $column = 'price_compared_with_benchmark'; $this->validate_column( $column ); $query = "SELECT `{$column}`, COUNT(*) as count FROM `{$this->table->get_name()}` GROUP BY `{$column}`"; return $this->wpdb->get_results( $query, // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, No user input. ARRAY_A ); } /** * Reload merchant price benchmarks data. * * @return void */ public function reload_data(): void { if ( $this->table->exists() ) { $this->table->truncate(); } } }