Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» how to connect DB in selenium webriver
Fri Oct 06, 2017 4:09 pm by anbarasi

» How find any text in browser screen and click on it?
Thu Oct 05, 2017 2:02 pm by sandeepkommineni

» Selenium Webdriver
Tue Oct 03, 2017 1:35 pm by PiyushBiswas

» GRID setup tutorial.
Wed Sep 27, 2017 4:29 pm by johnyapp

» Drag & Drop Between Windows Using Selenium Driver
Wed Sep 27, 2017 2:10 pm by 26rondel

» Check if window is closed / verify input
Sat Sep 23, 2017 10:21 pm by brainstir

» How to work on pages with AJAX in selenium?
Mon Sep 18, 2017 6:08 pm by azharuddin

» pause test until user press a key like F2
Wed Aug 09, 2017 11:10 pm by djnforce

» Selecting the input for auto populating element
Sat Jul 29, 2017 7:53 pm by kdabbara

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

Testing database records

View previous topic View next topic Go down

Testing database records

Post by Archana on Mon Aug 31, 2009 9:52 pm

Hi,
In my web application, many times I come across database testing. First could you suggest any tools for this requirement. I have been testing my app with selenium RC PHP.

At all times, I couldn't write expected result. Suppose if a complete db record is shown on my webpage with different columns, I can't write expected result, as site grows up, many new records will come, So all the times we don't know expected result (it is such a case showing the db records in descending order with all the column values & it also might have an associated db field of other table.)

This problem is slurping me from too many days. Please help.
avatar
Archana
Regular Participant
Regular Participant

Posts : 33
Join date : 2009-08-21

Back to top Go down

Re: Testing database records

Post by Adviser on Tue Sep 01, 2009 11:35 am

hi,

For this you have to write your own function in PHP which verify your webtable

eg:

verifyWebtable(array ExpectedData , array ActualDataFromWebPage , boolean status)
{ }
You have to think what logic you write, so it will work according for your requirement. If you successfully create this fuction, then you can use anywhere in projec.

Selenium is not directly supporting any database testing except the following command:

storeTable ( tableCellAddress, variableName )
Gets the text from a cell of a table. The cellAddress syntax tableLocator.row.column, where row and column start at 0.

Arguments:

* tableCellAddress - a cell address, e.g. "foo.1.4"
* variableName - the name of a variable in which the result is to be stored.

Returns:
the text from the specified cell


If you want to do it with help of other tool, you can try SQLUnit or Builder AU.

Best of luck.

Bye
avatar
Adviser
------------------------
------------------------

Posts : 379
Join date : 2009-07-30
Location : India

http://seleniumforum.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum