Method testSASImport

tests/import_export/ReadStat/ReadStatFilterTest.cpp:65–107

}

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

	const QString& fileName = QFINDTESTDATA(QLatin1String("data/iris.sas7bdat"));
	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("Sepal_Length : BEST"));
	QCOMPARE(spreadsheet.column(1)->name(), QLatin1String("Sepal_Width : BEST"));
	QCOMPARE(spreadsheet.column(2)->name(), QLatin1String("Petal_Length : BEST"));
	QCOMPARE(spreadsheet.column(3)->name(), QLatin1String("Petal_Width : BEST"));
	QCOMPARE(spreadsheet.column(4)->name(), QLatin1String("Species : $"));

	QCOMPARE(spreadsheet.column(0)->valueAt(0), 5.1);
	QCOMPARE(spreadsheet.column(0)->valueAt(1), 4.9);
	QCOMPARE(spreadsheet.column(0)->valueAt(2), 4.7);

	QCOMPARE(spreadsheet.column(1)->valueAt(0), 3.5);
	QCOMPARE(spreadsheet.column(2)->valueAt(0), 1.4);
	QCOMPARE(spreadsheet.column(3)->valueAt(0), 0.2);
	QCOMPARE(spreadsheet.column(4)->textAt(0), QLatin1String("setosa"));

	QCOMPARE(spreadsheet.column(0)->valueAt(149), 5.9);
	QCOMPARE(spreadsheet.column(1)->valueAt(149), 3.);
	QCOMPARE(spreadsheet.column(2)->valueAt(149), 5.1);
	QCOMPARE(spreadsheet.column(3)->valueAt(149), 1.8);
	QCOMPARE(spreadsheet.column(4)->textAt(149), QLatin1String("virgin"));
}

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