function FieldSqlStorageTestCase::testFieldAttachSaveMissingData

Tests insert and update with missing or NULL fields.

File

core/modules/field/modules/field_sql_storage/tests/field_sql_storage.test, line 209

Tests for field_sql_storage.module.

Class

FieldSqlStorageTestCase

Tests field storage.

Code

function testFieldAttachSaveMissingData() {
  $entity_type = 'test_entity';
  $entity = field_test_create_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.');
}