testing - Need to know how to test the output in database as stated below -
i need know way of testing or technique below scenario.
input.txt ---> processing module --> output in database tables
here how input.txt(it huge file 10k lines) looks like:
timestamp1,organisation1,data1,localtimestamp1,place1 timestamp2,organisation1,data2,localtimestamp2,place1 timestamp3,organisation1,data3,localtimestamp3,place1
i feed file processing module , output entered database tables in form (example:- table1 table10 & each table contains more 6 columns).
example :- table 1
column1 column2 ....... processeddata1 place1 processeddata2 place2
so output in db tables.
my question how test output. input in form of packets in .txt
file , processed data in huge rows of database
here have tried..
- process input (now processed data in db tables)
- export processed data tables .csv files.
- validate these
.csv
files manually (only first time). - keep these
.csv
files standard reference files(std). - for every release run process --> export o/p data tables
.csv
files(actual). - then compare these(actual)
.csv
files stored.csv
files(std)
if have other way of testing please suggest. please help.
Comments
Post a Comment