WordPress.org

Make WordPress Core


Ignore:
Timestamp:
05/06/2015 09:13:49 PM (5 years ago)
Author:
johnbillion
Message:

WPDB: Allow queries to reference tables in the dbname.tablename format, and allow table names to contain any valid character, rather than just ASCII.

Merge of [32368] to the 3.7 branch.

Props pento, willstedt for the initial patch.

See #32090.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/3.7/tests/phpunit/tests/db.php

    r32391 r32416  
    291291    function data_get_table_from_query() {
    292292        $table = 'a_test_table_name';
     293        $db_table = '`a_test_db`.`another_test_table`';
    293294
    294295        $queries = array(
     
    393394        );
    394395
    395         foreach ( $queries as &$query ) {
    396             $query = array( $query, $table );
     396        $querycount = count( $queries );
     397        for ( $ii = 0; $ii < $querycount; $ii++ ) {
     398            $db_query = str_replace( $table, $db_table, $queries[ $ii ] );
     399            $expected_db_table = str_replace( '`', '', $db_table );
     400
     401            $queries[ $ii ] = array( $queries[ $ii ], $table );
     402            $queries[] = array( $db_query, $expected_db_table );
    397403        }
    398404        return $queries;
Note: See TracChangeset for help on using the changeset viewer.