how to verify a huge amount of data

how to verify a huge amount of data

Post by Sand » Sat, 30 Aug 2003 12:36:58


I need someone to share the testing experience.
I am writing an email client application which downloads emails from mail
server and stored in an Access database.
The mail server is accessible from Outlook Express as well as web-base
application like IE.
I am going to do some large amount data testing, let say, 1000 emails with
different formats.
How can I verify the emails downloaded and stored in Access database are
exactly match with the emails in mail server?
I have tried to verify them manually, that is, read and verify them one by
one, and it seems impossible to repeat this 1000 times.
Thanx a lot.
 
 
 

how to verify a huge amount of data

Post by Andrew Fau » Sat, 30 Aug 2003 13:12:31


This kind of depends on how you are sending the emails. One thing you can
try is to take an MD5 hash of the e-mail before sending it, and then compare
that hash to a hash generated from the e-mail after downloading it from your
client. If they are the same, then it was transferred properly.

Where are we going and why am I in this handbasket?

 
 
 

how to verify a huge amount of data

Post by Michael Cu » Sat, 30 Aug 2003 14:02:24


Could you download everything twice and compare it.
 
 
 

how to verify a huge amount of data

Post by Sand » Sat, 30 Aug 2003 19:10:57

Is it possible to use the OutLook Express to compare?
My application will not delete the emails in the mail server. So I can
compare the emails received by my application with the emails downloaded by
OutLook Express. If this is possible, this will be the best way, because my
application will not generate multipart email.

For my learning purpose, how to generate MD5 hash of the emails?
Thanx

"Andrew Faust" < XXXX@XXXXX.COM >
: XXXX@XXXXX.COM ...


mail
with
by
compare
your
 
 
 

how to verify a huge amount of data

Post by Andrew Fau » Sun, 31 Aug 2003 00:59:38


Someone may be able to tlel you how to actually automate outlook to
retrieve e-mails, but I don't know how. However, I did find these two sites:

http://www.yqcomputer.com/
http://www.yqcomputer.com/

They both have products with trial downloads which they say can export
the e-mails to plain text files. You can then compare the e-mails from
outlook with the ones from your program.

When you do the comparison, whether you hash them or compare byte-by-byte
you may want to do it for the body of the message only otherwise you need
to worry about comparing the e-mail headers as well.

NOTE: I have not used either of the programs. I merely found them after a
quick Google search, and am taking what they say on their websites at face
value.


From a post earlier in the week.

http://www.yqcomputer.com/

or

http://www.yqcomputer.com/


Where are we going and why am I in this handbasket?