function FieldSqlStorageTestCase::testFieldAttachSaveMissingData in Drupal 7

Tests insert and update with missing or NULL fields.

File

modules/field/modules/field_sql_storage/field_sql_storage.test, line 192

Tests for field_sql_storage.module.

Class

FieldSqlStorageTestCase

Tests field storage.

Code

function testFieldAttachSaveMissingData() {
  $entity_type = 'test_entity';
  $entity = field_test_create_stub_entity(0, 0, $this->instance['bundle']);
  $langcode = LANGUAGE_NONE;

  // Insert: Field is missing
  field_attach_insert($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 0, 'Missing field results in no inserts');

  // Insert: Field is NULL
  $entity->{$this->field_name} = NULL;
  field_attach_insert($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 0, 'NULL field results in no inserts');

  // Add some real data
  $entity->{$this->field_name}[$langcode] = array(
    0 => array(
      'value' => 1,
    ),
  );
  field_attach_insert($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 1, 'Field data saved');

  // Update: Field is missing. Data should survive.
  unset($entity->{$this->field_name});
  field_attach_update($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 1, 'Missing field leaves data in table');

  // Update: Field is NULL. Data should be wiped.
  $entity->{$this->field_name} = NULL;
  field_attach_update($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 0, 'NULL field leaves no data in table');

  // Add a translation in an unavailable language.
  $unavailable_language = 'xx';
  db_insert($this->table)
    ->fields(array(
    'entity_type',
    'bundle',
    'deleted',
    'entity_id',
    'revision_id',
    'delta',
    'language',
  ))
    ->values(array(
    $entity_type,
    $this->instance['bundle'],
    0,
    0,
    0,
    0,
    $unavailable_language,
  ))
    ->execute();
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 1, 'Field translation in an unavailable language saved.');

  // Again add some real data.
  $entity->{$this->field_name}[$langcode] = array(
    0 => array(
      'value' => 1,
    ),
  );
  field_attach_insert($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 2, 'Field data saved.');

  // Update: Field translation is missing but field is not empty. Translation
  // data should survive.
  $entity->{$this->field_name}[$unavailable_language] = array(
    mt_rand(1, 127),
  );
  unset($entity->{$this->field_name}[$langcode]);
  field_attach_update($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 2, 'Missing field translation leaves data in table.');

  // Update: Field translation is NULL but field is not empty. Translation
  // data should be wiped.
  $entity->{$this->field_name}[$langcode] = NULL;
  field_attach_update($entity_type, $entity);
  $count = db_select($this->table)
    ->countQuery()
    ->execute()
    ->fetchField();
  $this
    ->assertEqual($count, 1, 'NULL field translation is wiped.');
}