function DateTimeFunctionalTest::testDateFormatStorage

Test if the date formats are stored properly.

File

modules/system/system.test, line 1462

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