function FieldSqlStorageTestCase::testFieldSqlStorageMultipleConditionsDifferentColumns

Test handling multiple conditions on multiple columns of one field.

Tests both the result and the complexity of the query.

File

drupal/modules/field/modules/field_sql_storage/field_sql_storage.test, line 488
Tests for field_sql_storage.module.

Class

FieldSqlStorageTestCase
Tests field storage.

Code

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']);
}