Club Drupal

  /**

   * Test handling multiple conditions on one column of a field.

   *

   * Tests both the result and the complexity of the query.

   */

  function testFieldSqlStorageMultipleConditionsSameColumn() {

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$this->field_name}[LANGUAGE_NONE][0] = array('value' => 1);

    field_test_entity_save($entity);

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$this->field_name}[LANGUAGE_NONE][0] = array('value' => 2);

    field_test_entity_save($entity);

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$this->field_name}[LANGUAGE_NONE][0] = array('value' => 3);

    field_test_entity_save($entity);

    $query = new EntityFieldQuery();

    // This tag causes field_test_query_store_global_test_query_alter() to be

    // invoked so that the query can be tested.

    $query->addTag('store_global_test_query');

    $query->entityCondition('entity_type', 'test_entity');

    $query->entityCondition('bundle', 'test_bundle');

    $query->fieldCondition($this->field_name, 'value', 1, '<>', 0, LANGUAGE_NONE);

    $query->fieldCondition($this->field_name, 'value', 2, '<>', 0, LANGUAGE_NONE);

    $result = field_sql_storage_field_storage_query($query);

    // Test the results.

    $this->assertEqual(1, count($result), format_string('One result should be returned, got @count', array('@count' => count($result))));

    // Test the complexity of the query.

    $query = $GLOBALS['test_query'];

    $this->assertNotNull($query, 'Precondition: the query should be available');

    $tables = $query->getTables();

    $this->assertEqual(1, count($tables), 'The query contains just one table.');

    // Clean up.

    unset($GLOBALS['test_query']);

  }

  /**

   * Test handling multiple conditions on multiple columns of one field.

   *

   * Tests both the result and the complexity of the query.

   */

  function testFieldSqlStorageMultipleConditionsDifferentColumns() {

    // Create the multi-column shape field

    $field_name = strtolower($this->randomName());

    $field = array('field_name' => $field_name, 'type' => 'shape', 'cardinality' => 4);

    $field = field_create_field($field);

    $instance = array(

      'field_name' => $field_name,

      'entity_type' => 'test_entity',

      'bundle' => 'test_bundle'

    );

    $instance = field_create_instance($instance);

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$field_name}[LANGUAGE_NONE][0] = array('shape' => 'A', 'color' => 'X');

    field_test_entity_save($entity);

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$field_name}[LANGUAGE_NONE][0] = array('shape' => 'B', 'color' => 'X');

    field_test_entity_save($entity);

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$field_name}[LANGUAGE_NONE][0] = array('shape' => 'A', 'color' => 'Y');

    field_test_entity_save($entity);

    $query = new EntityFieldQuery();

    // This tag causes field_test_query_store_global_test_query_alter() to be

    // invoked so that the query can be tested.

    $query->addTag('store_global_test_query');

    $query->entityCondition('entity_type', 'test_entity');

    $query->entityCondition('bundle', 'test_bundle');

    $query->fieldCondition($field_name, 'shape', 'B', '=', 'something', LANGUAGE_NONE);

    $query->fieldCondition($field_name, 'color', 'X', '=', 'something', LANGUAGE_NONE);

    $result = field_sql_storage_field_storage_query($query);

    // Test the results.

    $this->assertEqual(1, count($result), format_string('One result should be returned, got @count', array('@count' => count($result))));

    // Test the complexity of the query.

    $query = $GLOBALS['test_query'];

    $this->assertNotNull($query, 'Precondition: the query should be available');

    $tables = $query->getTables();

    $this->assertEqual(1, count($tables), 'The query contains just one table.');

    // Clean up.

    unset($GLOBALS['test_query']);

  }

  /**

   * Test handling multiple conditions on multiple columns of one field for multiple languages.

   *

   * Tests both the result and the complexity of the query.

   */

  function testFieldSqlStorageMultipleConditionsDifferentColumnsMultipleLanguages() {

    field_test_entity_info_translatable('test_entity', TRUE);

    // Create the multi-column shape field

    $field_name = strtolower($this->randomName());

    $field = array('field_name' => $field_name, 'type' => 'shape', 'cardinality' => 4, 'translatable' => TRUE);

    $field = field_create_field($field);

    $instance = array(

      'field_name' => $field_name,

      'entity_type' => 'test_entity',

      'bundle' => 'test_bundle',

      'settings' => array(

        // Prevent warning from field_test_field_load().

        'test_hook_field_load' => FALSE,

      ),

    );

    $instance = field_create_instance($instance);

    $entity = field_test_create_stub_entity(NULL, NULL);

    $entity->{$field_name}[LANGUAGE_NONE][0] = array('shape' => 'A', 'color' => 'X');

    $entity->{$field_name}['en'][0] = array('shape' => 'B', 'color' => 'Y');

    field_test_entity_save($entity);

    $entity = field_test_entity_test_load($entity->ftid);

    $query = new EntityFieldQuery();

    // This tag causes field_test_query_store_global_test_query_alter() to be

    // invoked so that the query can be tested.

    $query->addTag('store_global_test_query');

    $query->entityCondition('entity_type', 'test_entity');

    $query->entityCondition('bundle', 'test_bundle');

    $query->fieldCondition($field_name, 'color', 'X', '=', NULL, LANGUAGE_NONE);

    $query->fieldCondition($field_name, 'shape', 'B', '=', NULL, 'en');

    $result = field_sql_storage_field_storage_query($query);

    // Test the results.

    $this->assertEqual(1, count($result), format_string('One result should be returned, got @count', array('@count' => count($result))));

    // Test the complexity of the query.

    $query = $GLOBALS['test_query'];

    $this->assertNotNull($query, 'Precondition: the query should be available');

    $tables = $query->getTables();

    $this->assertEqual(2, count($tables), 'The query contains two tables.');

    // Clean up.

    unset($GLOBALS['test_query']);

  }