Changeset 37477 for trunk/src/wp-includes/ms-blogs.php

Timestamp:

05/20/2016 10:03:52 PM (10 years ago)

Author:

jeremyfelt

Message:

Multisite: Introduce WP_Site_Query

Provides a consistent way to query $wpdb->blogs for WP_Site objects based on domain, path, site ID, network ID, and more.

Introduces and uses update_site_cache() and _prime_site_caches() to maintain a cached list of WP_Site objects for use in multiple queries.

Props spacedmonkey, flixos90, DrewAPicture, jeremyfelt, ocean90.
See #35791.

File:

• trunk/src/wp-includes/ms-blogs.php (modified) (1 diff)

trunk/src/wp-includes/ms-blogs.php

@@ -521 +521 @@
 
 /**
+ * Adds any sites from the given ids to the cache that do not already exist in cache.
+ *
+ * @since 4.6.0
+ * @access private
+ *
+ * @see update_site_cache()
+ *
+ * @global wpdb $wpdb WordPress database abstraction object.
+ *
+ * @param array $ids ID list.
+ */
+function _prime_site_caches( $ids ) {
+        global $wpdb;
+
+        $non_cached_ids = _get_non_cached_ids( $ids, 'sites' );
+        if ( ! empty( $non_cached_ids ) ) {
+                $fresh_sites = $wpdb->get_results( sprintf( "SELECT * FROM $wpdb->blogs WHERE blog_id IN (%s)", join( ",", array_map( 'intval', $non_cached_ids ) ) ) );
+
+                update_site_cache( $fresh_sites );
+        }
+}
+
+/**
+ * Updates sites in cache.
+ *
+ * @since 4.6.0
+ *
+ * @param array $sites Array of site objects, passed by reference.
+ */
+function update_site_cache( &$sites ) {
+        if ( ! $sites ) {
+                return;
+        }
+
+        foreach ( $sites as $site ) {
+                wp_cache_add( $site->blog_id, $site, 'sites' );
+                wp_cache_add( $site->blog_id . 'short', $site, 'blog-details' );
+        }
+}
+
+/**
  * Retrieve option value for a given blog id based on name of option.
  *