[Wtr-general] call a method
Charley Baker
charley.baker at gmail.com
Wed Mar 21 16:37:28 EDT 2007
Hi Chitta,
I'm not quite sure what you're trying to do here, but it looks like your
checkcondition method is in the test case. And you're calling, based on this
code, your checkcondition method inside itself. It's a bit hard to even know
where to begin with this. Some more context might help, or maybe someone
else on the list wants to do more parsing of the code and work through it.
There's an excel interface class which I haven't used, but might help
simplify some of what you're doing here:
http://wiki.openqa.org/display/WTR/Excel+interface+class
Quick guesswork and of dubious value...
class TC_1 < Test::Unit::TestCase
def test_sign_up
# figure out what values you need here to call this method with all it's
parameters which are quite a few
checkcondition(checktext, cell1, cell2, messagepass, messagefail,
passcheck, failcheck)
end
end
checkcondition being a method in another class or module, which it may be
already.
-Charley
On 3/20/07, chitta <chitta.ranjan at globallogic.com> wrote:
>
> Hi All,
>
> Please Help me how can i declare a method here..
>
>
>
> # Test to automate Sign-up
> # Author : Chitta Ranjan
> # Verson : 0.2
>
> require 'watir'
> require 'test/unit'
>
> #Test Suite for Sign up verifications
> class TC_1 < Test::Unit::TestCase
> def test_sign_up
> def checkcondition(checktext, cell1, cell2, messagepass, messagefail,
> passcheck, failcheck)
> if ie.contains_text("#{checktext}")
> p 'messagepass'
> excel.Range("#{cell1}")['Value'] = "#{passcheck}";
> excel.Range("#{cell2}")['Value'] = "#{pass}";
> else
> p 'messagefail'
> excel.Range("#{cell1}")['Value'] = "#{failcheck}";
> excel.Range("#{cell2}")['Value'] = "#{fail}";
> end
>
>
>
>
>
>
>
>
>
>
>
> require 'win32ole'
> excel = WIN32OLE.new("excel.application")
> # Workbook holding the test data and test case
> workbook = excel.Workbooks.Open('C:\SetupData.xls')
> # Refernce to Test Data in the worksheet
> worksheet = workbook.Worksheets('Test Data')
> #Variable for handling null
> nullvariable = worksheet.Range('b1')['Value']
> # First Name
> firstname = worksheet.Range('b2')['Value']
> # Last Name
> lastname = worksheet.Range('b3')['Value']
> # Correct Email Address
> email1 = worksheet.Range('b4')['Value']
> #Invalid Email Address
> email2 = worksheet.Range('c4')['Value']
> # Correct Password
> password1 = worksheet.Range('b5')['Value']
> # Incorrect Password- invalid length
> password2 = worksheet.Range('c5')['Value']
> # Incorrect Password - invalid length
> password3 = worksheet.Range('d5')['Value']
> # Incorrect Password - invalid length
> password4 = worksheet.Range('e5')['Value']
> # Password Reminder - Correct
> passwordreminder1 = worksheet.Range('b6')['Value']
> # Password Reminder - Incorrect
> passwordreminder2 = worksheet.Range('c6')['Value']
> # Answer to password reminder
> answer = worksheet.Range("B#{1 + 6}")['Text'].strip.to_s
> # Contact Phone number
> contactphonenumber1 = worksheet.Range("B#{1 + 7}")['Text'].strip.to_s
> # Invalid Contact Phone Number - Invalid length
> contactphonenumber2 = worksheet.Range("C#{1 + 7}")['Text'].strip.to_s
> # Invalid Contact Phone Number - Invalid length
> contactphonenumber3 = worksheet.Range('d8')['Value']
> # Internet Provider
> internetprovider = worksheet.Range('b9')['Value']
> # Street Number
> streetno = worksheet.Range("B#{1 + 9}")['Text'].strip.to_s
> # Street Name
> streetname = worksheet.Range('b11')['Value']
> # City
> city = worksheet.Range('b12')['Value']
> # Valid State
> state1 = worksheet.Range('b13')['Value']
> # Invalid State - No Selection
> state2 = worksheet.Range('c13')['Value']
> # Zip Code
> zipcode1 = worksheet.Range("B#{1 + 13}")['Text'].strip.to_s
> # Invalid Zip Code
> zipcode2 = worksheet.Range("C#{1 + 13}")['Text'].strip.to_s
> # Invalid Zip Code
> zipcode3 = worksheet.Range("D#{1 + 13}")['Text'].strip.to_s
> # Invalid Zip Code
> zipcode4 = worksheet.Range("E#{1 + 13}")['Text'].strip.to_s
> #valid NPA
> npa = worksheet.Range("B#{1 + 14}")['Text'].strip.to_s
> #Valid NXX
> nxx = worksheet.Range("B#{1 + 15}")['Text'].strip.to_s
> #Valid Creditcard Name
> cardname = worksheet.Range('b17')['Value']
> #Credit Card Type
> cardtype1 = worksheet.Range('b18')['Value']
> #Credit Card Type
> cardtype2 = worksheet.Range('c18')['Value']
> #Invalid Credit Card Number
> creditcardnumber = worksheet.Range('b19')['Value']
> #Credit Card security code
> securitycode1 = worksheet.Range("B#{1 + 19}")['Text'].strip.to_s
> #invalid Security code
> securitycode2 = worksheet.Range("C#{1 + 19}")['Text'].strip.to_s
> #invalid Security code
> securitycode3 = worksheet.Range("D#{1 + 19}")['Text'].strip.to_s
> #invalid Security code
> securitycode4 = worksheet.Range("E#{1 + 19}")['Text'].strip.to_s
> #Credit Card exp. Month
> expirationmonth = worksheet.Range("B#{1 + 20}")['Text'].strip.to_s
> #Credit Card exp. year
> expirationyear1 = worksheet.Range("B#{1 + 21}")['Text'].strip.to_s
> #Credit Card exp. year invalid
> expirationyear2 = worksheet.Range("C#{1 + 21}")['Text'].strip.to_s
> #Test result If Passd
> pass = worksheet.Range('b24')['Value']
> #Test result If Faild
> fail = worksheet.Range('b25')['Value']
> #Sign-up URL
> url = worksheet.Range('b23')['Value']
>
>
>
> #get hold of the Second worksheet
> worksheet = workbook.Worksheets('Test Case')
>
> #call the testcases
> testcaseno = worksheet.Range('a1')['Value']#call the testcases
> description = worksheet.Range('b1')['Value']
> expectedresult = worksheet.Range('c1')['Value']
> actualresult = worksheet.Range('d1')['Value']
> passfail = worksheet.Range('f1')['Value']
>
> #Call the testcase no, test description, expected result from the
> testcase sheet
>
>
> urlverificationno = worksheet.Range('a3')['Value']
> urlverificationdescription = worksheet.Range('b3')['Value']
> urlverificationexpectedresult = worksheet.Range('c3')['Value']
> urlverificationactualpass = worksheet.Range('d3')['Value']
> urlverificationactualfail = worksheet.Range('e3')['Value']
>
>
>
>
> #write the test result in the BOOK1
> excel['Visible'] = TRUE;
> workbook = excel.Workbooks.Add();
> excel.Range("a1")['Value'] = testcaseno;
> excel.Range("b1")['Value'] = description;
> excel.Range("c1")['Value'] = expectedresult;
> excel.Range("d1")['Value'] = actualresult;
> excel.Range("e1")['Value'] = passfail;
>
>
> puts (urlverificationno)
> puts (urlverificationdescription)
> ie = Watir::IE.new
> test_site = url
> ie.goto(test_site)
> excel.Range("a3")['Value'] = urlverificationno;
> excel.Range("b3")['Value'] = urlverificationdescription;
> excel.Range("c3")['Value'] = urlverificationexpectedresult;
> checkcondition("Choose Plan", "d3", "e3", "Choose plan page is opening
> pass", "Choose plan page is not opening fail", "urlverificationactualpass",
> "urlverificationactualfail")
>
> ie.close
>
>
> #Verifies that the sign_up page opens if the user hits the URL -"
> http://192.168.4.169/sign_up/beginSignup.do"
>
>
>
>
> end
> end
> end
>
>
>
>
>
> _______________________________________________
> Wtr-general mailing list
> Wtr-general at rubyforge.org
> http://rubyforge.org/mailman/listinfo/wtr-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://rubyforge.org/pipermail/wtr-general/attachments/20070321/cfb93153/attachment-0001.html
More information about the Wtr-general
mailing list