Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed1a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.003 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'automate': 0.07; 'notice,': 0.07; 'subject:query': 0.07; 'subject:two': 0.07; 'subject:help': 0.08; '-multiple': 0.09; 'received:65.55.34.11': 0.09; 'subject:test': 0.09; 'def': 0.12; 'code?': 0.16; 'different,': 0.16; 'elem': 0.16; 'skip:d 60': 0.16; 'trying': 0.19; 'basically': 0.19; 'select': 0.22; 'to:name:python- list@python.org': 0.22; 'print': 0.22; 'driver': 0.24; 'skip:e 30': 0.24; 'order.': 0.26; 'query': 0.26; 'second': 0.26; 'skip:_ 20': 0.27; 'skip:( 40': 0.30; 'skip:( 20': 0.30; "i'm": 0.30; 'skip:q 20': 0.31; 'class': 0.32; 'run': 0.32; 'url:non-standard http port': 0.33; 'skip:d 20': 0.34; 'subject:with': 0.35; 'something': 0.35; 'test': 0.35; 'like,': 0.36; 'sequence': 0.36; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'skip:p 20': 0.39; 'how': 0.40; 'skip:o 30': 0.61; 'subject:Need': 0.64; 'submission': 0.64; 'different': 0.65; 'price': 0.69; 'verification': 0.83; 'received:65.55.34.7': 0.91 X-TMN: [hcj6vUsYs6bzim4foOqyM6WRPqPOw5yh] X-Originating-Email: [sunitha_byju@hotmail.com] Content-Type: multipart/alternative; boundary="_4fa92ac4-ff40-4eb0-8957-c776a4556b55_" From: Sunitha Byju To: "python-list@python.org" Subject: Need help with executing DB query in two different places in a test Date: Mon, 19 May 2014 16:46:44 -0400 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 19 May 2014 20:46:44.0819 (UTC) FILETIME=[7219CA30:01CF73A3] X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 363 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1400532473 news.xs4all.nl 2962 [2001:888:2000:d::a6]:38154 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:71776 --_4fa92ac4-ff40-4eb0-8957-c776a4556b55_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to automate an ecom website. I need to run DB query after placi= ng each order. I don't know how to run different queries after each order.= Can someone help me out with having queries after each order submission o= r test? =20 If you notice=2C I'm calling self.database_verification() after test 1. So= for the second test the query would be different=2C something like=2C Sele= ct * from PORTFOLIO_ORDER where MEMBER =3D 'USA' AND SYMBOL =3D 'TOP' OR SY= MBOL =3D 'Sweater. Basically for the sequence of orders=2C i would have di= fferent queries. So what is the best way to write the code? class OrderInputScreen(unittest.TestCase): def setUp(self): self.driver =3D webdriver.Firefox() driv= er =3D self.driver driver.get("http://testserver:8080/OrderInputScre= en/login#/") driver.maximize_window() def database_verification(self): con =3D cx_Oracle.connect('user/user@t= estDB123') cur =3D con.cursor() cur.execute("Select * from US_ORDER where = SYMBOL =3D 'TOP' and SIZE =3D 'M'") for result in cur: print result[2:8= ] cur.close() #USA single Order and verification def __test_single_order(self): driver =3D self.driver ele= m =3D driver.find_element_by_name("username") elem.send_keys("TEST") elemPa= ssword =3D driver.find_element_by_name("password") elemPassword.send_keys("= TEST") elem.submit() member =3D driver.find_element_by_xpath("//form= /div/dl/dd[1]/input") member.click() member.send_keys("USA") = PayType =3D driver.find_element_by_xpath ("//form/div/dl/dd[2]/input= ") PayType.click() PayType.send_keys("USD") clickPayTy= pe =3D driver.find_element_by_xpath ("//form/div/dl/dd/ul/li/a") cli= ckPayType.click() Symbol =3D driver.find_element_by_xpath ("//form/= div/dl/dd[3]/input") Symbol.click() Symbol.send_keys("TOP") = Quantity =3D driver.find_element_by_name ("quantity") Quantity= .click() Quantity.send_keys("10") Price =3D driver.find_eleme= nt_by_name ("price") Price.click() Price.send_keys("56.99") = Size =3D driver.find_element_by_xpath ("//form/div/dl/dd[6]/select/op= tion[text()=3D'M']") Size.click() SubmitButton =3D driver.fin= d_element_by_xpath ("//form/div/dl/dd[11]/div[2]") SubmitButton.clic= k() ActualOrderMsg =3D driver.find_element_by_xpath ("//span/p").text = print ActualOrderMsg textPresent =3D driver.find_element_by_xpath ("//s= pan/p[contains(text()=2C 'Successfuly added to processing!')]") self= .database_verification()=09 #USA -multiple orders and verification def test_Multiple_order(self): #Order0 driver =3D self.driver elem =3D driver.find_element_by_name("userna= me") elem.send_keys("TEST") elemPassword =3D driver.find_element_by_name("p= assword") elemPassword.send_keys("TEST") elem.submit() member =3D dr= iver.find_element_by_xpath("//form/div/dl/dd[1]/input") member.click= () member.send_keys("USA") PayType =3D driver.find_element_by= _xpath ("//form/div/dl/dd[2]/input") PayType.click() PayType.= send_keys("USD") clickPayType =3D driver.find_element_by_xpath ("//f= orm/div/dl/dd/ul/li/a") clickPayType.click() Symbol =3D driv= er.find_element_by_xpath ("//form/div/dl/dd[3]/input") Symbol.click(= ) Symbol.send_keys("TOP") Quantity =3D driver.find_element_by= _name ("quantity") Quantity.click() Quantity.send_keys("1") = Price =3D driver.find_element_by_name ("price") Price.click() = Price.send_keys("16.99") Size =3D driver.find_element_by_xpat= h ("//form/div/dl/dd[6]/select/option[text()=3D'S']") Size.click() = SubmitButton =3D driver.find_element_by_xpath ("//form/div/dl/dd[11]/= div[2]") SubmitButton.click() ActualOrderMsg =3D driver.find_elem= ent_by_xpath ("//span/p").text print ActualOrderMsg textPresent =3D d= river.find_element_by_xpath ("//span/p[contains(text()=2C 'Successfuly adde= d to processing!')]" #Order1 AddOrder1 =3D driver.find_elemen= t_by_xpath("//div/div[2]/form/div[2]/button[1]") AddOrder1.click() m= ember =3D driver.find_element_by_xpath("//form/div/dl/dd[1]/input") = member.click() member.send_keys("USA") PayType =3D driver.fin= d_element_by_xpath ("//form/div/dl/dd[2]/input") PayType.click() = PayType.send_keys("USD") clickPayType =3D driver.find_element_by= _xpath ("//form/div/dl/dd/ul/li/a") clickPayType.click() Symb= ol =3D driver.find_element_by_xpath ("//form/div/dl/dd[3]/input") S= ymbol.click() Symbol.send_keys("Sweater") Quantity =3D driver= .find_element_by_name ("quantity") Quantity.click() Quantity.= send_keys("2") Price =3D driver.find_element_by_name ("price") = Price.click() Price.send_keys("26.99") Size =3D driver.find= _element_by_xpath ("//form/div/dl/dd[6]/select/option[text()=3D'M']") = Size.click() SubmitButton =3D driver.find_element_by_xpath ("//for= m/div/dl/dd[11]/div[2]") SubmitButton.click() ActualOrderMsg =3D = driver.find_element_by_xpath ("//span/p").text print ActualOrderMsg t= extPresent =3D driver.find_element_by_xpath ("//span/p[contains(text()=2C '= Successfuly added to processing!')]" #Order2 AddOrder2 =3D driver.fin= d_element_by_xpath("//div/div[2]/form/div[3]/button[1]") AddOrder2.click() = member =3D driver.find_element_by_xpath("//form/div/dl/dd[1]/input")= member.click() member.send_keys("USA") PayType =3D dr= iver.find_element_by_xpath ("//form/div/dl/dd[2]/input") PayType.cli= ck() PayType.send_keys("USD") clickPayType =3D driver.find_el= ement_by_xpath ("//form/div/dl/dd/ul/li/a") clickPayType.click() = Symbol =3D driver.find_element_by_xpath ("//form/div/dl/dd[3]/input") = Symbol.click() Symbol.send_keys("Sweater") Quantity = =3D driver.find_element_by_name ("quantity") Quantity.click() = Quantity.send_keys("1") Price =3D driver.find_element_by_name ("pri= ce") Price.click() Price.send_keys("26.99") Size =3D d= river.find_element_by_xpath ("//form/div/dl/dd[6]/select/option[text()=3D'S= ']") Size.click() SubmitButton =3D driver.find_element_by_xpa= th ("//form/div/dl/dd[11]/div[2]") SubmitButton.click() ActualOrd= erMsg =3D driver.find_element_by_xpath ("//span/p").text print ActualOrd= erMsg textPresent =3D driver.find_element_by_xpath ("//span/p[contains(t= ext()=2C 'Successfuly added to processing!')]") Thanks=2CSB = --_4fa92ac4-ff40-4eb0-8957-c776a4556b55_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I am tryin= g to automate an ecom website. I need to run DB query after placing each or= der.  =3BI don't know how to run different queries after each order. &n= bsp=3BCan someone help me out with having queries after each order submissi= on or test?  =3B

If you notice=2C I'm calling =3Bself.database_verification() after test 1.  =3B= So for the second test the query would be different=2C something like=2C&nb= sp=3BSelect * from PORTFOLIO_ORDER where MEMBER =3D 'USA' AND SYMBOL= =3D 'TOP' OR SYMBOL =3D 'Sweater.  =3BBasically for the sequence of or= ders=2C i would have different queries.  =3BSo what is the best way to = write the code?


=

class OrderInp= utScreen(unittest.TestCase):

<= /div>
 =3B  =3B def setUp(self):
<= div> =3B  =3B  =3B  =3B self.driver =3D we= bdriver.Firefox()
 =3B  =3B  = =3B  =3B driver =3D self.driver
 = =3B  =3B  =3B  =3B driver.get("http://testserver:8080/OrderInpu= tScreen/login#/")
 =3B  =3B  = =3B  =3B driver.maximize_window()
 =3B  =3B def database_verifica= tion(self):
con =3D cx_Oracle.connect('user/user@te= stDB123')
cur =3D con.cursor() =3B
=
cur.execute("Select * from US_ORDER where SYMBOL =3D 'TOP' and = SIZE =3D 'M'")
for result in cur:
= =  =3B  =3Bprint result[2:8]
cur.clos= e()
 =3B  =3B #USA single Order and verification

 =3B &n= bsp=3B def __test_single_order(self):
&nb= sp=3B  =3B  =3B  =3B driver =3D self.driver
 =3B  =3B  =3B  =3B elem =3D driver.find_ele= ment_by_name("username")
elem.send_keys("TEST")
elemPassword =3D driver.find_element_by_name("password= ")
elemPassword.send_keys("TEST")
elem.submit()
 =3B  =3B =  =3B  =3B member =3D driver.find_element_by_xpath("//form/div/dl/dd= [1]/input")
 =3B  =3B  =3B &n= bsp=3B member.click()
 =3B  =3B &= nbsp=3B  =3B member.send_keys("USA")
=  =3B  =3B  =3B  =3B PayType =3D driver.find_element_by_xpat= h ("//form/div/dl/dd[2]/input")
 =3B =  =3B  =3B  =3B PayType.click()
 =3B  =3B  =3B  =3B PayType.send_keys("USD")
=
 =3B  =3B  =3B  =3B clickPayType =3D = driver.find_element_by_xpath ("//form/div/dl/dd/ul/li/a")
=  =3B  =3B  =3B  =3B clickPayType.click()
 =3B  =3B  =3B  =3B Symbol= =3D  =3Bdriver.find_element_by_xpath ("//form/div/dl/dd[3]/input")
 =3B  =3B  =3B  =3B Symbol.c= lick()
 =3B  =3B  =3B  = =3B Symbol.send_keys("TOP")
 =3B &nbs= p=3B  =3B  =3B Quantity =3D driver.find_element_by_name ("quantity"= )
 =3B  =3B  =3B  =3B Qua= ntity.click()
 =3B  =3B  =3B =  =3B Quantity.send_keys("10")
 = =3B  =3B  =3B  =3B Price =3D driver.find_element_by_name ("pric= e")
 =3B  =3B  =3B  =3B P= rice.click()
 =3B  =3B  =3B &= nbsp=3B Price.send_keys("56.99")
 =3B=  =3B  =3B  =3B Size =3D driver.find_element_by_xpath ("//form/= div/dl/dd[6]/select/option[text()=3D'M']")
 =3B  =3B  =3B  =3B Size.click()
 =3B  =3B  =3B  =3B SubmitButton =3D driver.find_= element_by_xpath ("//form/div/dl/dd[11]/div[2]")
 =3B  =3B  =3B  =3B SubmitButton.click()
 =3B  =3B ActualOrderMsg =3D driver.find_element_by_xp= ath ("//span/p").text
 =3B  =3B print Actual= OrderMsg
 =3B  =3B textPresent =3D driver.fi= nd_element_by_xpath ("//span/p[contains(text()=2C 'Successfuly added to pro= cessing!')]")
 =3B  =3B  =3B =  =3B self.database_verification()
=

 =3B  =3B #USA -multiple orders and verification<= /div>

 =3B =  =3B def test_Multiple_order(self):
&= nbsp=3B  =3B =3B
#Order0
<= font size=3D"3">
driver =3D self.driver
 = =3B  =3B  =3B  =3B elem =3D driver.find_element_by_name("userna= me")
elem.send_keys("TEST")
elemPassword =3D driver.find_element_by_name("password")
= = elemPassword.send_keys("TEST")
elem.submit()=
 =3B  =3B  =3B  =3B memb= er =3D driver.find_element_by_xpath("//form/div/dl/dd[1]/input")
 =3B  =3B  =3B  =3B member.click()<= /font>
 =3B  =3B  =3B  =3B membe= r.send_keys("USA")
 =3B  =3B &nbs= p=3B  =3B PayType =3D driver.find_element_by_xpath ("//form/div/dl/dd[2= ]/input")
 =3B  =3B  =3B &nbs= p=3B PayType.click()
 =3B  =3B &n= bsp=3B  =3B PayType.send_keys("USD")
=  =3B  =3B  =3B  =3B clickPayType =3D driver.find_element_by= _xpath ("//form/div/dl/dd/ul/li/a")
 = =3B  =3B  =3B  =3B clickPayType.click()
 =3B  =3B  =3B  =3B Symbol =3D  =3Bdriver.fi= nd_element_by_xpath ("//form/div/dl/dd[3]/input")
 =3B  =3B  =3B  =3B Symbol.click()
 =3B  =3B  =3B  =3B Symbol.send_keys("TO= P")
 =3B  =3B  =3B  =3B Q= uantity =3D driver.find_element_by_name ("quantity")
 =3B  =3B  =3B  =3B Quantity.click()
 =3B  =3B  =3B  =3B Quantity.send_k= eys("1")
 =3B  =3B  =3B  = =3B Price =3D driver.find_element_by_name ("price")
 =3B  =3B  =3B  =3B Price.click()
 =3B  =3B  =3B  =3B Price.send_keys("16= .99")
 =3B  =3B  =3B  =3B= Size =3D driver.find_element_by_xpath ("//form/div/dl/dd[6]/select/option[= text()=3D'S']")
 =3B  =3B  = =3B  =3B Size.click()
 =3B  = =3B  =3B  =3B SubmitButton =3D driver.find_element_by_xpath ("//for= m/div/dl/dd[11]/div[2]")
 =3B  = =3B  =3B  =3B SubmitButton.click()
 =3B  =3B ActualOrderMsg =3D driver.find_element_by_xpath ("//span/p").text<= /font>
 =3B  =3B print ActualOrderMsg
<= div> =3B  =3B textPresent =3D driver.find_element_by_xpath (= "//span/p[contains(text()=2C 'Successfuly added to processing!')]" =3B  =3B  =3B =3B<= /div>
 =3B  =3B  =3B  =3B =3B
#Order1
AddOrder1 =3D driver.= find_element_by_xpath("//div/div[2]/form/div[2]/button[1]")
AddOrder1.click()
 =3B  = =3B  =3B  =3B member =3D driver.find_element_by_xpath("//form/div/d= l/dd[1]/input")
 =3B  =3B  = =3B  =3B member.click()
 =3B &nbs= p=3B  =3B  =3B member.send_keys("USA")
 =3B  =3B  =3B  =3B PayType =3D driver.find_element_= by_xpath ("//form/div/dl/dd[2]/input")
&n= bsp=3B  =3B  =3B  =3B PayType.click()
 =3B  =3B  =3B  =3B PayType.send_keys("USD")
 =3B  =3B  =3B  =3B clickPayTy= pe =3D driver.find_element_by_xpath ("//form/div/dl/dd/ul/li/a")
 =3B  =3B  =3B  =3B clickPayType.cl= ick()
 =3B  =3B  =3B  =3B= Symbol =3D  =3Bdriver.find_element_by_xpath ("//form/div/dl/dd[3]/inpu= t")
 =3B  =3B  =3B  =3B S= ymbol.click()
 =3B  =3B  =3B =  =3B Symbol.send_keys("Sweater")
&nbs= p=3B  =3B  =3B  =3B Quantity =3D driver.find_element_by_name ("= quantity")
 =3B  =3B  =3B &nb= sp=3B Quantity.click()
 =3B  =3B =  =3B  =3B Quantity.send_keys("2")
 =3B  =3B  =3B  =3B Price =3D driver.find_element_by_name = ("price")
 =3B  =3B  =3B &nbs= p=3B Price.click()
 =3B  =3B &nbs= p=3B  =3B Price.send_keys("26.99")
&n= bsp=3B  =3B  =3B  =3B Size =3D driver.find_element_by_xpath ("/= /form/div/dl/dd[6]/select/option[text()=3D'M']")
 =3B  =3B  =3B  =3B Size.click()
<= font size=3D"3"> =3B  =3B  =3B  =3B SubmitButton =3D driver= .find_element_by_xpath ("//form/div/dl/dd[11]/div[2]")
 =3B  =3B  =3B  =3B SubmitButton.click()
 =3B  =3B ActualOrderMsg =3D driver.find_element= _by_xpath ("//span/p").text
 =3B &nbs= p=3B print = ActualOrderMsg
 =3B  =3B textPresent =3D dri= ver.find_element_by_xpath ("//span/p[contains(text()=2C 'Successfuly added = to processing!')]" =3B  = =3B =3B
#Order2=
AddOrder2 =3D driver.find_elemen= t_by_xpath("//div/div[2]/form/div[3]/button[1]")
Ad= dOrder2.click()
 =3B  =3B  = =3B  =3B member =3D driver.find_element_by_xpath("//form/div/dl/dd[1]/i= nput")
 =3B  =3B  =3B  = =3B member.click()
 =3B  =3B &nbs= p=3B  =3B member.send_keys("USA")
&nb= sp=3B  =3B  =3B  =3B PayType =3D driver.find_element_by_xpath (= "//form/div/dl/dd[2]/input")
 =3B &nb= sp=3B  =3B  =3B PayType.click()
&= nbsp=3B  =3B  =3B  =3B PayType.send_keys("USD")
 =3B  =3B  =3B  =3B clickPayType =3D dri= ver.find_element_by_xpath ("//form/div/dl/dd/ul/li/a")
 =3B  =3B  =3B  =3B clickPayType.click()
 =3B  =3B  =3B  =3B Symbol = =3D  =3Bdriver.find_element_by_xpath ("//form/div/dl/dd[3]/input")
 =3B  =3B  =3B  =3B Symbol.cl= ick()
 =3B  =3B  =3B  =3B= Symbol.send_keys("Sweater")
 =3B &nb= sp=3B  =3B  =3B Quantity =3D driver.find_element_by_name ("quantity= ")
 =3B  =3B  =3B  =3B Qu= antity.click()
 =3B  =3B  =3B=  =3B Quantity.send_keys("1")
 = =3B  =3B  =3B  =3B Price =3D driver.find_element_by_name ("pric= e")
 =3B  =3B  =3B  =3B P= rice.click()
 =3B  =3B  =3B &= nbsp=3B Price.send_keys("26.99")
 =3B=  =3B  =3B  =3B Size =3D driver.find_element_by_xpath ("//form/= div/dl/dd[6]/select/option[text()=3D'S']")
 =3B  =3B  =3B  =3B Size.click()
 =3B  =3B  =3B  =3B SubmitButton =3D driver.find_= element_by_xpath ("//form/div/dl/dd[11]/div[2]")
 =3B  =3B  =3B  =3B SubmitButton.click()
 =3B  =3B ActualOrderMsg =3D driver.find_element_by_xp= ath ("//span/p").text
 =3B  =3B print Actual= OrderMsg
 =3B  =3B textPresent =3D driver.fi= nd_element_by_xpath ("//span/p[contains(text()=2C 'Successfuly added to pro= cessing!')]")


Thanks=2C
SB

= --_4fa92ac4-ff40-4eb0-8957-c776a4556b55_--