Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» Selenium WebDriver Integration
Tue Nov 21, 2017 1:06 pm by azharuddin

» 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

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

database connectivity

View previous topic View next topic Go down

database connectivity

Post by Archana on Sat Aug 22, 2009 2:35 pm

Hi,
I'm submitting a form through my test suite. As per my test plan, form should be submitted & if insert query goes smooth, a row should be added in my db. How can I test whether a row is really added or not? How can I check the error, if query is failed?

Also in my form, I'm getting options of a dropdown from db, How can I test whether correct options are loaded or not? If these are not possible, learning this stuff would be useless for me.

Please kindly help,

Thanks for your quick replies.
avatar
Archana
Regular Participant
Regular Participant

Posts : 33
Join date : 2009-08-21

Back to top Go down

Re: database connectivity

Post by Adviser on Sat Aug 22, 2009 6:39 pm

hi,

For checking the db query is successfully executing, you have to verify it on web page. After inserting it should be shown somewhere so verify text on that page by using command like verifyText or verifyTable if it appear in table.

If your query is failed, the data will not shown in UI. so by this way you can verify it.

For dropdown list use following command :

storeSelectedLabels ( selectLocator, variableName )

Gets all option labels (visible text) for selected options in the specified select or multi-select element.

Arguments:

* selectLocator - an element locator identifying a drop-down menu
* variableName - the name of a variable in which the result is to be stored.

Returns:
an array of all selected option labels in the specified select drop-down

For more database testing use user-extensions created in javascript. You have to write as per your requirement.Search for already created by someone.

check out this link for more details:
http://seleniumhq.org/docs/05_selenium_rc.html#database-validations

Hope this will help you. 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