Auto Testing Databases [modified]
-
I looked for a better place to put this but found none so here goes... I've struggled with how to do this effeciently for a long time some I thought someone here might know. I want to implement an automated testing system for our web site. The problem is it needs to do the things that the web site does so it needs to write to the database. But after the test I need to compare databases and see what changed and then put the database back where I found it. We have 10 or so databases. I suppose I could write a script to backup everything on the test starting and then restore it. Of course the site would need to be down during the test. Anyone have any better ideas? E=mc2 -> BOOM -- modified at 0:18 Saturday 10th June, 2006
-
I looked for a better place to put this but found none so here goes... I've struggled with how to do this effeciently for a long time some I thought someone here might know. I want to implement an automated testing system for our web site. The problem is it needs to do the things that the web site does so it needs to write to the database. But after the test I need to compare databases and see what changed and then put the database back where I found it. We have 10 or so databases. I suppose I could write a script to backup everything on the test starting and then restore it. Of course the site would need to be down during the test. Anyone have any better ideas? E=mc2 -> BOOM -- modified at 0:18 Saturday 10th June, 2006
Hi, You could possibly export the database to a flat file and compare versions.There is a tool that i made sometime back for the same purpose. To export the contents of a db to a CSV file and then use it to verify another database. If thats what you are looking for, give me a shout and i'll send u the exporting tool first.U can use it to generate CSV files one of each DB,then use Windiff or any other tool to compare them. Cheers, Girish -- modified at 0:52 Saturday 10th June, 2006
-
I looked for a better place to put this but found none so here goes... I've struggled with how to do this effeciently for a long time some I thought someone here might know. I want to implement an automated testing system for our web site. The problem is it needs to do the things that the web site does so it needs to write to the database. But after the test I need to compare databases and see what changed and then put the database back where I found it. We have 10 or so databases. I suppose I could write a script to backup everything on the test starting and then restore it. Of course the site would need to be down during the test. Anyone have any better ideas? E=mc2 -> BOOM -- modified at 0:18 Saturday 10th June, 2006
If you have a database abstraction layer, you can implement a drop-in replacement for the database that tracks what gets done. And/or you can use another database (e.g. SQLite, which is lightweight and embeddable) to do testing with.
0 bottles of beer on the wall, 0 bottles of beer, you take 1 down, pass it around, 4294967295 bottles of beer on the wall. Awasu 2.2.2 [^]: A free RSS/Atom feed reader with support for Code Project.
-
Hi, You could possibly export the database to a flat file and compare versions.There is a tool that i made sometime back for the same purpose. To export the contents of a db to a CSV file and then use it to verify another database. If thats what you are looking for, give me a shout and i'll send u the exporting tool first.U can use it to generate CSV files one of each DB,then use Windiff or any other tool to compare them. Cheers, Girish -- modified at 0:52 Saturday 10th June, 2006
Hello Girish, Would you please send me the exporting tool. Mehedi Hasan
-
Hi, You could possibly export the database to a flat file and compare versions.There is a tool that i made sometime back for the same purpose. To export the contents of a db to a CSV file and then use it to verify another database. If thats what you are looking for, give me a shout and i'll send u the exporting tool first.U can use it to generate CSV files one of each DB,then use Windiff or any other tool to compare them. Cheers, Girish -- modified at 0:52 Saturday 10th June, 2006
Look at the stuff from Red Gate[^] cheers, Chris Maunder
CodeProject.com : C++ MVP