+global\Wordlift_Install_3_28_0::install()

Complexity

Conditions	2
Paths	2

Size

Total Lines

22

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function install() {

		global $wpdb;

		$dataset_uri = Wordlift_Configuration_Service::get_instance()->get_dataset_uri();

		if ( ! $dataset_uri ) {
			// Dont run the query, running it would delete all the values.
			return;
		}
		$post_meta_table_name = $wpdb->postmeta;
		$meta_key = Wordlift_Schema_Service::FIELD_SAME_AS;

		$http        = $wpdb->esc_like( 'http://' ) . '%';
		$https       = $wpdb->esc_like( 'https://' ) . '%';
		$dataset_uri = $wpdb->esc_like( $dataset_uri ) . '%';
		$sql         = $wpdb->prepare( "DELETE FROM $post_meta_table_name WHERE meta_key='$meta_key' 
AND ( ( meta_value NOT LIKE %s AND meta_value NOT LIKE %s )
OR meta_value LIKE %s )", $http, $https, $dataset_uri );
		$wpdb->query( $sql );

	}