<h2>File Contents: /home/planet5/www/wp-content/plugins/wordpress-seo/src/repositories/seo-links-repository.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/wp-content/plugins/wordpress-seo/src/repositories/seo-links-repository.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

namespace Yoast\WP\SEO\Repositories;

use Yoast\WP\Lib\Model;
use Yoast\WP\Lib\ORM;
use Yoast\WP\SEO\Models\SEO_Links;

/**
 * Class SEO_Links_Repository.
 */
class SEO_Links_Repository {

	/**
	 * Starts a query for this repository.
	 *
	 * @return ORM
	 */
	public function query() {
		return Model::of_type( &#039;SEO_Links&#039; );
	}

	/**
	 * Finds all SEO Links by post ID.
	 *
	 * @param int $post_id The post ID.
	 *
	 * @return SEO_Links[] The SEO Links.
	 */
	public function find_all_by_post_id( $post_id ) {
		return $this-&gt;query()
			-&gt;where( &#039;post_id&#039;, $post_id )
			-&gt;find_many();
	}

	/**
	 * Finds all SEO Links by indexable ID.
	 *
	 * @param int $indexable_id The indexable ID.
	 *
	 * @return SEO_Links[] The SEO Links.
	 */
	public function find_all_by_indexable_id( $indexable_id ) {
		return $this-&gt;query()
			-&gt;where( &#039;indexable_id&#039;, $indexable_id )
			-&gt;find_many();
	}

	/**
	 * Retrieves an SEO Link by url.
	 *
	 * @param string $url The SEO Link&#039;s url.
	 *
	 * @return SEO_Links|false The SEO Link, or false if none found.
	 */
	public function find_one_by_url( $url ) {
		return $this-&gt;query()
			-&gt;select( &#039;target_post_id&#039; )
			-&gt;where( &#039;url&#039;, $url )
			-&gt;find_one();
	}

	/**
	 * Retrieves all SEO Links by target post ID.
	 *
	 * @param string $target_post_id The SEO Link&#039;s target post ID.
	 *
	 * @return SEO_Links[] The SEO Links.
	 */
	public function find_all_by_target_post_id( $target_post_id ) {
		return $this-&gt;query()
			-&gt;where( &#039;target_post_id&#039;, $target_post_id )
			-&gt;find_many();
	}

	/**
	 * Updates the ID of the target indexable of a link.
	 *
	 * @param int $link_id             The ID of the link to be updated.
	 * @param int $target_indexable_id The ID of the target indexable.
	 *
	 * @return bool Whether or not the update was succeful.
	 */
	public function update_target_indexable_id( $link_id, $target_indexable_id ) {
		return (bool) $this-&gt;query()
			-&gt;set( &#039;target_indexable_id&#039;, $target_indexable_id )
			-&gt;where( &#039;id&#039;, $link_id )
			-&gt;update_many();
	}

	/**
	 * Clears all SEO Links by post ID.
	 *
	 * @param int $post_id The post ID.
	 *
	 * @return bool Whether or not the delete was successful.
	 */
	public function delete_all_by_post_id( $post_id ) {
		return $this-&gt;query()
			-&gt;where( &#039;post_id&#039;, $post_id )
			-&gt;delete_many();
	}

	/**
	 * Clears all SEO Links by post ID where the indexable id is null.
	 *
	 * @param int $post_id The post ID.
	 *
	 * @return bool Whether or not the delete was successful.
	 */
	public function delete_all_by_post_id_where_indexable_id_null( $post_id ) {
		return $this-&gt;query()
			-&gt;where( &#039;post_id&#039;, $post_id )
			-&gt;where_null( &#039;indexable_id&#039; )
			-&gt;delete_many();
	}

	/**
	 * Clears all SEO Links by indexable ID.
	 *
	 * @param int $indexable_id The indexable ID.
	 *
	 * @return bool Whether or not the delete was successful.
	 */
	public function delete_all_by_indexable_id( $indexable_id ) {
		return $this-&gt;query()
			-&gt;where( &#039;indexable_id&#039;, $indexable_id )
			-&gt;delete_many();
	}

	/**
	 * Returns incoming link counts for a number of posts.
	 *
	 * @param array $post_ids The post IDs.
	 *
	 * @return array An array of associative arrays, each containing a post id and incoming property.
	 */
	public function get_incoming_link_counts_for_post_ids( $post_ids ) {
		return $this-&gt;query()
			-&gt;select_expr( &#039;COUNT( id )&#039;, &#039;incoming&#039; )
			-&gt;select( &#039;target_post_id&#039;, &#039;post_id&#039; )
			-&gt;where_in( &#039;target_post_id&#039;, $post_ids )
			-&gt;group_by( &#039;target_post_id&#039; )
			-&gt;find_array();
	}

	/**
	 * Returns incoming link counts for a number of indexables.
	 *
	 * @param array $indexable_ids The indexable IDs.
	 *
	 * @return array An array of associative arrays, each containing a indexable id and incoming property.
	 */
	public function get_incoming_link_counts_for_indexable_ids( $indexable_ids ) {
		if ( empty( $indexable_ids ) ) {
			return [];
		}

		// This query only returns ID&#039;s with an incoming count &gt; 0. We need to restore any ID&#039;s with 0 incoming links later.
		$indexable_counts = $this-&gt;query()
			-&gt;select_expr( &#039;COUNT( id )&#039;, &#039;incoming&#039; )
			-&gt;select( &#039;target_indexable_id&#039; )
			-&gt;where_in( &#039;target_indexable_id&#039;, $indexable_ids )
			-&gt;group_by( &#039;target_indexable_id&#039; )
			-&gt;find_array();

		// If the above query fails, do not update anything.
		if ( ! \is_array( $indexable_counts ) ) {
			return [];
		}

		// Get all ID&#039;s returned from the query and set them as keys for easy access.
		$returned_ids = \array_flip( \array_column( $indexable_counts, &#039;target_indexable_id&#039; ) );

		// Loop over the original ID&#039;s and search them in the returned ID&#039;s. If they don&#039;t exist, add them with an incoming count of 0.
		foreach ( $indexable_ids as $id ) {
			// Cast the ID to string, as the arrays only contain stringified versions of the ID.
			$id = (string) $id;
			if ( isset( $returned_ids[ $id ] ) === false ) {
				$indexable_counts[] = [
					&#039;incoming&#039;            =&gt; &#039;0&#039;,
					&#039;target_indexable_id&#039; =&gt; $id,
				];
			}
		}

		return $indexable_counts;
	}

	/**
	 * Deletes all seo links for the given ids.
	 *
	 * @param int[] $ids The seo link ids.
	 *
	 * @return bool Whether or not the delete was successful.
	 */
	public function delete_many_by_id( $ids ) {
		return $this-&gt;query()
			-&gt;where_in( &#039;id&#039;, $ids )
			-&gt;delete_many();
	}

	/**
	 * Insert multiple seo links.
	 *
	 * @param SEO_Links[] $links The seo links to be inserted.
	 *
	 * @return bool Whether or not the insert was successful.
	 */
	public function insert_many( $links ) {
		return $this-&gt;query()
			-&gt;insert_many( $links );
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fwp-content%2Fplugins%2Fwordpress-seo%2Fsrc%2Frepositories'>⬅ Back to Directory</a>