Yoast\WP\SEO\Repositories

Indexable_Cleanup_Repository::clean_indexables_for_non_publicly_viewable_taxonomies() │ public │ Yoast 1.0

Cleans up any indexables that belong to taxonomies that are not/no longer publicly viewable.

Метод класса: Indexable_Cleanup_Repository{}

Хуков нет.

Возвращает

true|false|int. The number of deleted rows, false if the query fails.

Использование

$Indexable_Cleanup_Repository = new Indexable_Cleanup_Repository();
$Indexable_Cleanup_Repository->clean_indexables_for_non_publicly_viewable_taxonomies( $limit );
$limit(int) (обязательный)
The limit we'll apply to the queries.

Код Indexable_Cleanup_Repository::clean_indexables_for_non_publicly_viewable_taxonomies() Yoast 23.5

yoast/src/repositories/indexable-cleanup-repository.php 
public function clean_indexables_for_non_publicly_viewable_taxonomies( $limit ) {
	global $wpdb;
	$indexable_table = Model::get_table_name( 'Indexable' );

	$included_taxonomies = $this->taxonomy->get_indexable_taxonomies();

	// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Reason: Too hard to fix.
	if ( empty( $included_taxonomies ) ) {
		$delete_query = $wpdb->prepare(
			"DELETE FROM $indexable_table
			WHERE object_type = 'term'
			AND object_sub_type IS NOT NULL
			LIMIT %d",
			$limit
		);
	}
	else {
		// phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber -- Reason: we're passing an array instead.
		$delete_query = $wpdb->prepare(
			"DELETE FROM $indexable_table
			WHERE object_type = 'term'
			AND object_sub_type IS NOT NULL
			AND object_sub_type NOT IN ( " . \implode( ', ', \array_fill( 0, \count( $included_taxonomies ), '%s' ) ) . ' )
			LIMIT %d',
			\array_merge( $included_taxonomies, [ $limit ] )
		);
	}
	// phpcs:enable

	// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- Reason: No relevant caches.
	// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- Reason: Most performant way.
	// phpcs:disable WordPress.DB.PreparedSQL.NotPrepared -- Reason: Is it prepared already.
	return $wpdb->query( $delete_query );
	// phpcs:enable
}