Method testDTAImport

tests/import_export/ReadStat/ReadStatFilterTest.cpp:17–63

#include <KLocalizedString>

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

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

	QCOMPARE(spreadsheet.columnCount(), 5);
	QCOMPARE(spreadsheet.rowCount(), 150);
	QCOMPARE(spreadsheet.column(0)->columnMode(), AbstractColumn::ColumnMode::Double);
	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::Text);

	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(0)->name(), QLatin1String("sepallength"));
	QCOMPARE(spreadsheet.column(1)->name(), QLatin1String("sepalwidth"));
	QCOMPARE(spreadsheet.column(2)->name(), QLatin1String("petallength"));
	QCOMPARE(spreadsheet.column(3)->name(), QLatin1String("petalwidth"));
	QCOMPARE(spreadsheet.column(4)->name(), QLatin1String("species"));

	FuzzyCompare(spreadsheet.column(0)->valueAt(0), 5.1, 1.e-6); // 5.09999990463
	FuzzyCompare(spreadsheet.column(0)->valueAt(1), 4.9, 1.e-7); // 4.90000009537
	FuzzyCompare(spreadsheet.column(0)->valueAt(2), 4.7, 1.e-7); // 4.69999980927

	QCOMPARE(spreadsheet.column(1)->valueAt(0), 3.5);
	FuzzyCompare(spreadsheet.column(2)->valueAt(0), 1.4, 1.e-7); // 1.39999997616
	FuzzyCompare(spreadsheet.column(3)->valueAt(0), 0.2, 1.e-7); // 0.20000000298
	QCOMPARE(spreadsheet.column(4)->textAt(0), QLatin1String("setosa"));

	DEBUG(Q_FUNC_INFO << ", value = " << spreadsheet.column(0)->valueAt(149))
	DEBUG(Q_FUNC_INFO << ", value = " << spreadsheet.column(2)->valueAt(149))
	DEBUG(Q_FUNC_INFO << ", value = " << spreadsheet.column(3)->valueAt(149))

	FuzzyCompare(spreadsheet.column(0)->valueAt(149), 5.9, 1.e-7); // 5.90000009536743
	QCOMPARE(spreadsheet.column(1)->valueAt(149), 3.);
	FuzzyCompare(spreadsheet.column(2)->valueAt(149), 5.1, 1.e-7); // 5.09999990463257
	FuzzyCompare(spreadsheet.column(3)->valueAt(149), 1.8, 1.e-7); // 1.79999995231628
	QCOMPARE(spreadsheet.column(4)->textAt(149), QLatin1String("virginica"));
}

void ReadStatFilterTest::testSASImport() {
	Spreadsheet spreadsheet(QStringLiteral("test"), false);