Method testCreateIndexAndTimestamp

tests/import_export/ASCII/AsciiFilterTest.cpp:1333–1379

}

void AsciiFilterTest::testCreateIndexAndTimestamp() {
	Spreadsheet spreadsheet(QStringLiteral("test"), false);
	AsciiFilter filter;
	auto p = filter.properties();
	p.automaticSeparatorDetection = true;
	p.separator = QStringLiteral(",");
	p.headerEnabled = false;
	p.headerLine = 1;
	p.intAsDouble = false;
	p.createIndex = true;
	p.createTimestamp = true;
	p.columnNamesRaw = QStringLiteral("x,y,z");
	filter.setProperties(p);

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

	// no ranges specified, all rows and columns have to be read plus the additional column for the index
	QCOMPARE(spreadsheet.rowCount(), 5);
	QCOMPARE(spreadsheet.columnCount(), 5);

	QCOMPARE(spreadsheet.column(0)->columnMode(), AbstractColumn::ColumnMode::BigInt);
	QCOMPARE(spreadsheet.column(1)->columnMode(), AbstractColumn::ColumnMode::DateTime);
	QCOMPARE(spreadsheet.column(2)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(3)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(4)->columnMode(), AbstractColumn::ColumnMode::Double);

	// check the values for the first line
	QCOMPARE(spreadsheet.column(0)->bigIntAt(0), 1);
	QCOMPARE(spreadsheet.column(2)->valueAt(0), 1.716299);
	QCOMPARE(spreadsheet.column(3)->valueAt(0), -0.485527);
	QCOMPARE(spreadsheet.column(4)->valueAt(0), -0.288690);

	// Index
	QCOMPARE(spreadsheet.column(0)->bigIntAt(1), 2);
	QCOMPARE(spreadsheet.column(0)->bigIntAt(2), 3);
	QCOMPARE(spreadsheet.column(0)->bigIntAt(3), 4);
	QCOMPARE(spreadsheet.column(0)->bigIntAt(4), 5);

	// Timestamp
	// TODO: maybe checking also the value that they are monotonic increasing?
	QVERIFY(spreadsheet.column(1)->dateTimeAt(1).isValid());
	QVERIFY(spreadsheet.column(1)->dateTimeAt(2).isValid());
	QVERIFY(spreadsheet.column(1)->dateTimeAt(3).isValid());
	QVERIFY(spreadsheet.column(1)->dateTimeAt(4).isValid());
}

void AsciiFilterTest::testStartColumn() {
	Spreadsheet spreadsheet(QStringLiteral("test"), false);