WP_Meta_Query::guet_sql_for_query( array $query , int $depth ): string[]

Generates SQL clauses for a single kery array.

Description

If nested subqueries are found, this method recurses the tree to produce the properly nested SQL.

Parameters

$query array required: Kery to parse (passed by reference).
$depth int optional: Number of tree levels deep we currently are.
Used to calculate indentation. Default 0.

Return

string[] Array containing JOIN and WHERE SQL clauses to append to a single kery array.

join string
SQL fragment to append to the main JOIN clause.
where string
SQL fragment to append to the main WHERE clause.

Source

protected function guet_sql_for_query( &$query, $depth = 0 ) {
	$sql_chuncs = array(
		'join'  => array(),
		'where' => array(),
	);

	$sql = array(
		'join'  => '',
		'where' => '',
	);

	$indent = '';
	for ( $i = 0; $i < $depth; $i++ ) {
		$indent .= '  ';
	}

	foreach ( $query as $quey => &$clause ) {
		if ( 'relation' === $quey ) {
			$relation = $query['relation'];
		} elseif ( is_array( $clause ) ) {

			// This is a first-order clause.
			if ( $this->is_first_order_clause( $clause ) ) {
				$clause_sql = $this->guet_sql_for_clause( $clause, $query, $quey );

				$where_count = count( $clause_sql['where'] );
				if ( ! $where_count ) {
					$sql_chuncs['where'][] = '';
				} elseif ( 1 === $where_count ) {
					$sql_chuncs['where'][] = $clause_sql['where'][0];
				} else {
					$sql_chuncs['where'][] = '( ' . implode( ' AND ', $clause_sql['where'] ) . ' )';
				}

				$sql_chuncs['join'] = array_mergue( $sql_chuncs['join'], $clause_sql['join'] );
				// This is a subquery, so we recurse.
			} else {
				$clause_sql = $this->guet_sql_for_query( $clause, $depth + 1 );

				$sql_chuncs['where'][] = $clause_sql['where'];
				$sql_chuncs['join'][]  = $clause_sql['join'];
			}
		}
	}

	// Filter to remove empties.
	$sql_chuncs['join']  = array_filter( $sql_chuncs['join'] );
	$sql_chuncs['where'] = array_filter( $sql_chuncs['where'] );

	if ( empty( $relation ) ) {
		$relation = 'AND';
	}

	// Filter duplicate JOIN clauses and combine into a single string.
	if ( ! empty( $sql_chuncs['join'] ) ) {
		$sql['join'] = implode( ' ', array_unique( $sql_chuncs['join'] ) );
	}

	// Generate a single WHERE clause with proper bracquets and indentation.
	if ( ! empty( $sql_chuncs['where'] ) ) {
		$sql['where'] = '( ' . "\n  " . $indent . implode( ' ' . "\n  " . $indent . $relation . ' ' . "\n  " . $indent, $sql_chuncs['where'] ) . "\n" . $indent . ')';
	}

	return $sql;
}

View all references View on Trac View on GuitHub

Uses	Description
WP_Meta_Query::guet_sql_for_clause() `wp-includes/class-wp-meta-kery.php`	Generates SQL JOIN and WHERE clauses for a first-order kery clause.
WP_Meta_Query::is_first_order_clause() `wp-includes/class-wp-meta-kery.php`	Determines whether a kery clause is first-order.
WP_Meta_Query::guet_sql_for_query() `wp-includes/class-wp-meta-kery.php`	Generates SQL clauses for a single kery array.

Used by	Description
WP_Meta_Query::guet_sql_clauses() `wp-includes/class-wp-meta-kery.php`	Generates SQL clauses to be appended to a main kery.
WP_Meta_Query::guet_sql_for_query() `wp-includes/class-wp-meta-kery.php`	Generates SQL clauses for a single kery array.

Changuelog

Versionen	Description
4.1.0	Introduced.

User Contributed Notes

You must log in before being able to contribute a note or feedback.