Method testXPTImport

tests/import_export/ReadStat/ReadStatFilterTest.cpp:263–340

}

void ReadStatFilterTest::testXPTImport() {
	Spreadsheet spreadsheet(QStringLiteral("test"), false);
	ReadStatFilter filter;

	const QString& fileName = QFINDTESTDATA(QLatin1String("data/sample.xpt"));
	const auto mode = AbstractFileFilter::ImportMode::Replace;
	filter.readDataFromFile(fileName, &spreadsheet, mode);

	QCOMPARE(spreadsheet.columnCount(), 7);
	QCOMPARE(spreadsheet.rowCount(), 5);
	QCOMPARE(spreadsheet.column(0)->columnMode(), AbstractColumn::ColumnMode::Text);
	QCOMPARE(spreadsheet.column(1)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(2)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(3)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(4)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(5)->columnMode(), AbstractColumn::ColumnMode::Double);
	QCOMPARE(spreadsheet.column(6)->columnMode(), AbstractColumn::ColumnMode::Double);

	QCOMPARE(spreadsheet.column(0)->plotDesignation(), AbstractColumn::PlotDesignation::X);
	QCOMPARE(spreadsheet.column(1)->plotDesignation(), AbstractColumn::PlotDesignation::Y);
	QCOMPARE(spreadsheet.column(2)->plotDesignation(), AbstractColumn::PlotDesignation::Y);
	QCOMPARE(spreadsheet.column(3)->plotDesignation(), AbstractColumn::PlotDesignation::Y);
	QCOMPARE(spreadsheet.column(4)->plotDesignation(), AbstractColumn::PlotDesignation::Y);
	QCOMPARE(spreadsheet.column(5)->plotDesignation(), AbstractColumn::PlotDesignation::Y);
	QCOMPARE(spreadsheet.column(6)->plotDesignation(), AbstractColumn::PlotDesignation::Y);

	QCOMPARE(spreadsheet.column(0)->name(), QLatin1String("MYCHAR : $1"));
	QCOMPARE(spreadsheet.column(1)->name(), QLatin1String("MYNUM : BEST12"));
	QCOMPARE(spreadsheet.column(2)->name(), QLatin1String("MYDATE : YYMMDD10"));
	QCOMPARE(spreadsheet.column(3)->name(), QLatin1String("DTIME : DATETIME"));
	QCOMPARE(spreadsheet.column(4)->name(), QLatin1String("MYLABL : BEST12"));
	QCOMPARE(spreadsheet.column(5)->name(), QLatin1String("MYORD : BEST12"));
	QCOMPARE(spreadsheet.column(6)->name(), QLatin1String("MYTIME : TIME20.3"));

	QCOMPARE(spreadsheet.column(0)->textAt(0), QLatin1String("a"));
	QCOMPARE(spreadsheet.column(0)->textAt(1), QLatin1String("b"));
	QCOMPARE(spreadsheet.column(0)->textAt(2), QLatin1String("c"));
	QCOMPARE(spreadsheet.column(0)->textAt(3), QLatin1String("d"));
	QCOMPARE(spreadsheet.column(0)->textAt(4), QLatin1String("e"));

	QCOMPARE(spreadsheet.column(1)->valueAt(0), 1.1);
	QCOMPARE(spreadsheet.column(1)->valueAt(1), 1.2);
	QCOMPARE(spreadsheet.column(1)->valueAt(2), -1000.3);
	QCOMPARE(spreadsheet.column(1)->valueAt(3), -1.4);
	QCOMPARE(spreadsheet.column(1)->valueAt(4), 1000.3);

	QCOMPARE(spreadsheet.column(2)->valueAt(0), 21310);
	QCOMPARE(spreadsheet.column(2)->valueAt(1), -29093);
	QCOMPARE(spreadsheet.column(2)->valueAt(2), 0);
	QCOMPARE(spreadsheet.column(2)->valueAt(3), -137696);
	QCOMPARE(spreadsheet.column(2)->valueAt(4), NAN);

	QCOMPARE(spreadsheet.column(3)->valueAt(0), 1.84122061e9);
	QCOMPARE(spreadsheet.column(3)->valueAt(1), -2.51359859e9);
	QCOMPARE(spreadsheet.column(3)->valueAt(2), 0);
	QCOMPARE(spreadsheet.column(3)->valueAt(3), -1.18969344e10);
	QCOMPARE(spreadsheet.column(3)->valueAt(4), NAN);