Automattic\WooCommerce\Blueprint\Importers

ImportRunSql::affects_user_capabilities │ private │ WC 1.0

Check if the SQL query affects user capabilities in wp_options.

Method of the class: ImportRunSql{}

No Hooks.

Returns

true|false. True if the query affects user capabilities, false otherwise.

Usage

// private - for code of main (parent) class only
$result = $this->affects_user_capabilities( $sql_content ): bool;
$sql_content(string) (required)
The SQL query to check.

ImportRunSql::affects_user_capabilities() code WC 9.9.5

woocommerce/packages/blueprint/src/Importers/ImportRunSql.php 
private function affects_user_capabilities( string $sql_content ): bool {
	global $wpdb;

	// Check if the query affects user capabilities in wp_options.
	if ( stripos( $sql_content, $wpdb->prefix . 'options' ) !== false ) {
		$option_patterns = array(
			'user_roles',
			'capabilities',
			'wp_user_',
			'role_',
			'administrator',
		);

		foreach ( $option_patterns as $pattern ) {
			if ( stripos( $sql_content, $pattern ) !== false ) {
				return true;
			}
		}
	}
	return false;
}