python - How to control test case run through an excel sheet? -


my question design problem. using python + selenium automation. pyunit unit framework used. have sheet in excel have 2 columns- testcaseid , run. testcaseid have testcase id in , run have either y or n signifying whether test case should runnable or not. trying read particular test case id sheet , see have it's run value, y or n. if y, test case executed unit framework else not run.

here excerpt of test case have written:

`class test_id_94017(unittest.testcase):

ex = excel() def setup(self):     self.ex.setupasheetinexcel('select_test_cases_to_run')     if self.ex.gettestcaserunstatusfromexcel("94017") == "y":         self.driver = browser().createbrowserdriver()         self.driver.maximize_window()         self.driver.implicitly_wait(15)         self.ex.setupasheetinexcel('login')     else:         return  def test_ccpd_regression001_per_custom_check(self):     //do

the definition gettestcaserunstatusfromexcel(testcaseid) method is:

`def gettestcaserunstatusfromexcel(self, testcaseid):

    i=1     while self.worksheet.cell_value(i,0).value != testcaseid:         i+=1     return self.worksheet.cell_value(i,1).value

here problems facing:

  1. how should give condition in existing code y, test case executes? should give if condition in setup method test case class have mentioned in code above?

  2. is way in trying iterate on rows in column (of excel sheet) correct until find testcase id , corresponding run value (y or n)?

please help!

i implemented similar design selenium+testng suite. after reading execution flags excel, create testng.xml dynamically , run same xml. testng provides features xml created , executed dynamically. not sure if have similar in pyunit. hope gives ideas.


Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more