function DateTimeFunctionalTest::testDateFormatStorage in Drupal 7

Test if the date formats are stored properly.

File

modules/system/system.test, line 1398

Tests for system.module.

Class

DateTimeFunctionalTest

Tests generic date and time handling capabilities of Drupal.

Code

function testDateFormatStorage() {
  $date_format = array(
    'type' => 'short',
    'format' => 'dmYHis',
    'locked' => 0,
    'is_new' => 1,
  );
  system_date_format_save($date_format);
  $format = db_select('date_formats', 'df')
    ->fields('df', array(
    'format',
  ))
    ->condition('type', 'short')
    ->condition('format', 'dmYHis')
    ->execute()
    ->fetchField();
  $this
    ->verbose($format);
  $this
    ->assertEqual('dmYHis', $format, 'Unlocalized date format resides in general table.');
  $format = db_select('date_format_locale', 'dfl')
    ->fields('dfl', array(
    'format',
  ))
    ->condition('type', 'short')
    ->condition('format', 'dmYHis')
    ->execute()
    ->fetchField();
  $this
    ->assertFalse($format, 'Unlocalized date format resides not in localized table.');

  // Enable German language
  locale_add_language('de', NULL, NULL, LANGUAGE_LTR, '', '', TRUE, 'en');
  $date_format = array(
    'type' => 'short',
    'format' => 'YMDHis',
    'locales' => array(
      'de',
      'tr',
    ),
    'locked' => 0,
    'is_new' => 1,
  );
  system_date_format_save($date_format);
  $format = db_select('date_format_locale', 'dfl')
    ->fields('dfl', array(
    'format',
  ))
    ->condition('type', 'short')
    ->condition('format', 'YMDHis')
    ->condition('language', 'de')
    ->execute()
    ->fetchField();
  $this
    ->assertEqual('YMDHis', $format, 'Localized date format resides in localized table.');
  $format = db_select('date_formats', 'df')
    ->fields('df', array(
    'format',
  ))
    ->condition('type', 'short')
    ->condition('format', 'YMDHis')
    ->execute()
    ->fetchField();
  $this
    ->assertEqual('YMDHis', $format, 'Localized date format resides in general table too.');
  $format = db_select('date_format_locale', 'dfl')
    ->fields('dfl', array(
    'format',
  ))
    ->condition('type', 'short')
    ->condition('format', 'YMDHis')
    ->condition('language', 'tr')
    ->execute()
    ->fetchColumn();
  $this
    ->assertFalse($format, 'Localized date format for disabled language is ignored.');
}