Shell Programming and Scripting

I want to automate test script on shell scripting.

There are 2 .csv files named account.csv and balance.csv.These files needs to passed as command line arguments and the following logic needs to applied further.

Any account with a balance that was due before Oct 23, 2007 has an overdue value of 1
Any account without an overdue balance has a NULL overdue value (empty in the csv files) or an overdue value of 0

Write an automated test script to verify that the data in the files is correct. Your script should take in 2 command line arguments - the name of the account file and the name of the balance file. The output should indicate any problem accounts and nothing for accounts that have their overdue value properly set.


Files with 2 sample accts

accounts.csv

id name date acctno overdue
1 A 9/13/2007 15.36 12345 1
2 B 11/24/2006 15.36 12346

balance.csv

id acctno balance balance_due
1 12345 482.69 11/28/2007 15.54
2 12356 226.69 10/9/2007 15.54

Thanks in advance

Can you please clarify the red fields:

Code:

accounts.csv

id	name	date		(balance???!)	acctno	overdue
1	A	9/13/2007	15.36		12345	1
2	B	11/24/2006	15.36		12346

balance.csv

id	acctno	balance		(date)	        balance_due
1	12345	482.69		11/28/2007	15.54
2	12356	226.69		10/9/2007	15.54

So you dont have the account numbers at the same location (line numbers) in the both files? Is that correct?

Yes the acctnos are not in same line in both the files.

i gave sample acctnos listed in the eg.

The actual acctnos are diff. u can try with diff acctno and balance. I just typed the acctnos and other fields for the structure of files

---------- Post updated at 10:09 AM ---------- Previous update was at 09:15 AM ----------

Both the files are having more than 100 records.

Thanks in advance

---------- Post updated at 03:53 PM ---------- Previous update was at 10:09 AM ----------

The application accesses these 2 tables and sets the values for overdue flag based on the logic. The application has been run and it sets the value. We are going to check in test script the values set are correct and if not the accts which are having problem has to be listed.

Thanks