test.js

import test from 'ava';
import CSVFileValidator from './src/csv-file-validator';

const requiredError = (headerName, rowNumber, columnNumber) => (
	`<div class="red">${headerName} is required in the <strong>${rowNumber} row</strong> / <strong>${columnNumber} column</strong></div>`
)

const validateError = (headerName, rowNumber, columnNumber) => (
	`<div class="red">${headerName} is not valid in the <strong>${rowNumber} row</strong> / <strong>${columnNumber} column</strong></div>`
)

const dependentValidateError = (headerName, rowNumber, columnNumber) => (
	`<div class="red">${headerName} is not valid. Country should be set to Ukraine. <strong>${rowNumber} row</strong> / <strong>${columnNumber} column</strong></div>`
)

const isEmailValid = (email) => {
	const reqExp = /[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,3}$/
	return reqExp.test(email)
}

const isRoleForCountryValid = (country, row) => {
	const role = row[5];
	return country === 'Ukraine' && role === 'user';
}

const isPasswordValid = (password) => (password.length >= 4)
const uniqueError = (headerName, rowNumber) => (`<div class="red">${headerName} is not unique at the <strong>${rowNumber} row</strong></div>`)

const CSVConfig = {
	headers: [
		{ name: 'First Name', inputName: 'firstName', required: true, requiredError },
		{ name: 'Last Name', inputName: 'lastName', required: true, requiredError },
		{ name: 'Email', inputName: 'email', required: true, requiredError, unique: true, uniqueError, validate: isEmailValid, validateError },
		{ name: 'Password', inputName: 'password', required: true, requiredError, validate: isPasswordValid, validateError },
		{ name: 'Roles', inputName: 'roles', required: true, requiredError, isArray: true },
		{ name: 'Country', inputName: 'country', optional: true, dependentValidate: isRoleForCountryValid, dependentValidateError }
	]
}

const CSVHeader = CSVConfig.headers.map(i => i.name).join(';');

const CSVConfig_1 = {
	...CSVConfig,
	parserConfig: {
		dynamicTyping: true
	},
	isColumnIndexAlphabetic: true
}

const CSVInvalidFile = [
	CSVHeader,
	'Vasyl;Stokolosa;v.stokol@gmail.com;123;admin,manager;',
	'Vasyl_2;"";v.stokol@gmail.com;123123123;user;',
].join('\n');

const CSVValidFile = [
	CSVHeader,
	'Vasyl;Stokolosa;v.stokol@gmail.com;123123;user;Ukraine',
	'Vasyl;Stokolosa;fake@test.com;123123123;user;Ukraine',
].join('\n');

const CSVValidFileWithoutHeaders = [
	'Vasyl;Stokolosa;v.stokol@gmail.com;123123;admin,manager',
	'Vasyl;Stokolosa;fake@test.com;123123123;user;Ukraine',
].join('\n');

const CSVInvalidFileWithDuplicates = [
	CSVHeader,
	'Vasyl;Stokolosa;fake@test.com;123123;admin,manager;',
	'Vasyl;Stokolosa;fake@test.com;123123123;user;Ukraine',
	'Vasyl;Stokolosa;fake@test.com;123123123;user;Ukraine',
].join('\n');

const CSVInvalidFileTooManyFields = [
	'First Name;',
	'Vasyl;Stokolosa;',
].join('\n');

const CSVInvalidFileNotEnoughFields = [
	'Country;First Name;Last Name;',
	'"";Vasyl',
	'"";Vasyl;Stokolosa',
].join('\n');

test('module should be a function', t => {
	t.is(typeof CSVFileValidator, 'function');
});

test('should return the message "config headers are required"', async t => {
	const csvData = await CSVFileValidator('');

	t.is(typeof csvData, 'object');
	t.deepEqual(csvData.inValidData, [{ message: 'config headers are required' }]);
	t.deepEqual(csvData.data, []);
});

test('should return no data if the file is empty', async t => {
	const csvData = await CSVFileValidator('', CSVConfig);

	t.is(typeof csvData, 'object');
	t.deepEqual(csvData.inValidData, []);
	t.deepEqual(csvData.data, []);
});

test('should return invalid messages with data', async t => {
	const csvData = await CSVFileValidator(CSVInvalidFile, CSVConfig);

	t.is(csvData.inValidData.length, 5);
	t.is(csvData.data.length, 2);
	t.is(csvData.inValidData[3].message,
		'<div class="red">Country is not valid. Country should be set to Ukraine. <strong>3 row</strong> / <strong>6 column</strong></div>'
	);
});

test('should return data, the file is valid', async t => {
	const csvData = await CSVFileValidator(CSVValidFile, CSVConfig);

	t.is(csvData.inValidData.length, 2);
	t.is(csvData.data.length, 2);
});

test('file without headers, the file is valid and headers are optional', async t => {
	const csvData = await CSVFileValidator(CSVValidFileWithoutHeaders, { ...CSVConfig, isHeaderNameOptional: true });

	t.is(csvData.inValidData.length, 1);
	t.is(csvData.data.length, 2);
});

test('file with headers, the file is valid and headers are optional', async t => {
	const csvData = await CSVFileValidator(CSVValidFile, { ...CSVConfig, isHeaderNameOptional: true });

	t.is(csvData.inValidData.length, 2);
	t.is(csvData.data.length, 2);
});

test('file is valid and headers are missed', async t => {
	const csvData = await CSVFileValidator(CSVValidFileWithoutHeaders, CSVConfig);

	t.is(csvData.inValidData.length, 12);
	t.is(csvData.data.length, 1);
});

test('should return alphabetic columns', async t => {
	const csvData = await CSVFileValidator(CSVInvalidFile, CSVConfig_1);

	t.is(csvData.inValidData.length, 6);
	t.is(csvData.data.length, 2);
	t.is(csvData.inValidData[0].message,
		'<div class="red">Password is not valid in the <strong>2 row</strong> / <strong>D column</strong></div>'
	);
});

test('should return optional column', async t => {
	const csvData = await CSVFileValidator(CSVValidFile, CSVConfig);

	t.is(csvData.data[1].country, 'Ukraine');
});

test('file is valid and Email is not unique at the ... row', async t => {
	const csvData = await CSVFileValidator(CSVInvalidFileWithDuplicates, CSVConfig);

	t.is(csvData.inValidData.length, 5);
	t.is(csvData.data.length, 3);
});

test('fields are mismatch: too many fields', async t => {
	const csvData = await CSVFileValidator(CSVInvalidFileTooManyFields, { headers: [CSVConfig.headers[0]] });

	t.is(csvData.inValidData.length, 1);
	t.is(csvData.inValidData[0].message, 'Number of fields mismatch: expected 1 fields but parsed 3. In the row 1')
	t.is(csvData.inValidData[0].rowIndex, 1)
	t.is(csvData.data.length, 1);
});

test('fields are mismatch: not enough fields', async t => {
	const csvData = await CSVFileValidator(CSVInvalidFileNotEnoughFields, { headers: [CSVConfig.headers[5], CSVConfig.headers[0], CSVConfig.headers[1]] });

	t.is(csvData.inValidData.length, 3);
	t.is(csvData.inValidData[0].message, 'Number of fields mismatch: expected 3 fields but parsed 2. In the row 1');
	t.is(csvData.inValidData[0].rowIndex, 1)
	t.is(csvData.data.length, 2);
});