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..

  1. process input (now processed data in db tables)
  2. export processed data tables .csv files.
  3. validate these .csv files manually (only first time).
  4. keep these .csv files standard reference files(std).
  5. for every release run process --> export o/p data tables .csv files(actual).
  6. then compare these(actual) .csv files stored .csv files(std)

if have other way of testing please suggest. please help.


Comments

Popular posts from this blog

qt - Using float or double for own QML classes -

Create Outlook appointment via C# .Net -

ios - Swift Array Resetting Itself -