Method testDateTime00

tests/import_export/ASCII/AsciiFilterTest.cpp:2242–2282

! * read data containing only two characters for the year - 'yy'. The default year in * QDateTime is 1900 . When reading such two-characters DateTime values we want * to have the current centure after the import. */

 * to have the current centure after the import.
 */
void AsciiFilterTest::testDateTime00() {
	Spreadsheet spreadsheet(QStringLiteral("test"), false);

	AsciiFilter filter;
	auto p = filter.properties();
	p.automaticSeparatorDetection = false;
	p.separator = QStringLiteral(",");
	p.headerEnabled = true;
	p.headerLine = 1;
	p.intAsDouble = false;
	p.dateTimeFormat = QLatin1String("dd/MM/yy hh:mm:ss");
	p.baseYear = 2000;
	filter.setProperties(p);

	QString savePath;
	SAVE_FILE("testfile", dateTime01Content);
	filter.readDataFromFile(savePath, &spreadsheet, AbstractFileFilter::ImportMode::Replace);

	// spreadsheet size
	QCOMPARE(spreadsheet.columnCount(), 2);
	QCOMPARE(spreadsheet.rowCount(), 2);

	// column names
	QCOMPARE(spreadsheet.column(0)->name(), QLatin1String("Date"));
	QCOMPARE(spreadsheet.column(1)->name(), QLatin1String("Water Pressure"));

	// data types
	QCOMPARE(spreadsheet.column(0)->columnMode(), AbstractColumn::ColumnMode::DateTime);
	QCOMPARE(spreadsheet.column(1)->columnMode(), AbstractColumn::ColumnMode::Double);

	// values
	auto value = QDateTime::fromString(QLatin1String("01/01/2019 00:00:00"), QLatin1String("dd/MM/yyyy hh:mm:ss"));
	value.setTimeSpec(Qt::UTC);
	QCOMPARE(spreadsheet.column(0)->dateTimeAt(0), value);
	QCOMPARE(spreadsheet.column(1)->valueAt(0), 14.7982);

	value = QDateTime::fromString(QLatin1String("01/01/2019 00:30:00"), QLatin1String("dd/MM/yyyy hh:mm:ss"));
	value.setTimeSpec(Qt::UTC);
	QCOMPARE(spreadsheet.column(0)->dateTimeAt(1), value);
	QCOMPARE(spreadsheet.column(1)->valueAt(1), 14.8026);
}

void AsciiFilterTest::testDateTimeDefaultDateTimeFormat() {
	const QStringList content = {