from selenium import webdriver

driver=webdriver.Chrome()

driver.implicitly_wait(30)
driver.maximize_window()

driver.get('https://www.douban.com')

search_field=driver.find_element_by_name("q")

search_field.clear()

search_field.send_keys("Phones")
search_field.submit()

products=driver.find_element_by_xpath('//*[@id="content"]/div/div[1]/div[3]')

print("Found"+str(products)+"products:")

driver.quit()

import unittest
from selenium import webdriver

class SearchTest(unittest.TestCase):
    def setUp(self):
        self.driver=webdriver.Chrome()
        self.driver.implicitly_wait(30)
        self.driver.maximize_window()

        self.driver.get("https://www.douban.com")

    def test_search_by_category(self):
        self.search_field=self.driver.find_element_by_name("q")

        self.search_field.clear()

        self.search_field.send_keys("phones")
        self.search_field.submit()

        products=self.driver.find_element_by_xpath('//*[@id="content"]/div/div[1]/div[3]/div[2]/div[1]/div[2]/div/h3/a')
        print(products)

if __name__=='__main__':
    unittest.main(verbosity=2)

import unittest
from selenium import webdriver

class SearchTest (unittest.TestCase)：

def setUp(self):

	# create a new Firefox session
	self.driver = webdriver.Firefox()
	self.driver.implicitly_wait(30)
	self.driver.maximize_window()
	
	# navigate to the application home page
	self.driver.get("http://demo.magentocommerce.com/")

def test_search_by_category(self):

	# get the search textbox
	self.search_field = self.driver.find_element_by_name("q")
	self.search_field.clear()

	# enter search keyword and submit
	self.search_field.send_keys("phones")
	self.search_field.submit()

	# get all the anchor elements which have product names
	# displayed currently on result page using
	# find_elements_by_xpath method
	products = self.driver.find_elements_by_xpath("//h2[@class='product-name']/a")
	self.assertEqual(2, len(products))

def tearDown(self):
	# close the browser window
	self.driver.quit()

if __name__ == '__main__':
	unittest.main(verbosity=2)

import unittest
from selenium import webdriver

class SearchTest(unittest.TestCase):
    def setUp(self):
        self.driver=webdriver.Chrome()
        self.driver.implicitly_wait(30)
        # self.driver.maximize_window()

        self.driver.get("https://www.douban.com")

    def test_search_by_category(self):
        self.search_field=self.driver.find_element_by_name("q")

        self.search_field.clear()

        self.search_field.send_keys("phones")
        self.search_field.submit()

        products=self.driver.find_element_by_xpath('//*[@id="content"]/div/div[1]/div[3]/div[2]/div[1]/div[2]/div/h3/a')
        print(products)

    def test_search_by_name(self):
        self.search_field=self.driver.find_element_by_name("q")
        self.search_field.clear()

        self.search_field.send_keys("地球")
        self.search_field.submit()

        products2=self.driver.find_element_by_xpath('//*[@id="content"]/div/div[1]/div[3]/div[2]/div[1]/div[2]/div/h3/a')

if __name__=='__main__':
    unittest.main(verbosity=2)

# searchtest.py

import unittest
from selenium import webdriver

class SearchTest(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        cls.driver=webdriver.Chrome()
        cls.driver.implicitly_wait(30)
        # cls.driver.maximize_window()

        cls.driver.get("https://www.douban.com")

    def test_search_by_category(self):
        self.search_field=self.driver.find_element_by_name("q")

        self.search_field.clear()

        self.search_field.send_keys("phones")
        self.search_field.submit()

        products=self.driver.find_element_by_xpath('//*[@id="content"]/div/div[1]/div[3]/div[2]/div[1]/div[2]/div/h3/a')
        print(products)

    def test_search_by_name(self):
        self.search_field=self.driver.find_element_by_name("q")
        self.search_field.clear()

        self.search_field.send_keys("地球")
        self.search_field.submit()

        products2=self.driver.find_element_by_xpath('//*[@id="content"]/div/div[1]/div[3]/div[2]/div[1]/div[2]/div/h3/a')

    @classmethod
    def tearDownClass(cls):
        cls.driver.quit()

if __name__=='__main__':
    unittest.main(verbosity=2)

# homepagetests.py

import unittest
from selenium import webdriver
from selenium.common.exceptions import  NoSuchFrameException
from selenium.webdriver.common.by import  By
from builtins import  classmethod

class HomePageTest(unittest.TestCase):
    @classmethod
    def setUp(cls):
        cls.driver=webdriver.Chrome()
        cls.driver.implicitly_wait(30)
        cls.driver.get("http://demo.magentocommerce.com/")

    def test_search_field(self):
        self.assertTrue(self.is_element_present(By.NAME,'q'))

    def test_language_option(self):
        self.assertTrue(self.is_element_present(By.ID,"select-language"))

    def test_shopping_cart_empty_message(self):
        shopping_cart_icon=self.driver.find_element_by_css_selector("div.header-minicart span.icon")
        shopping_cart_icon.click()

        shopping_cart_status=self.driver.find_element_by_css_selector("p.empty").text
        self.assertEqual("You have no items in your shopping cart.",shopping_cart_status)

        close_button=self.driver.find_element_by_css_selector("div.minicart-wrapper a.close")
        close_button.click()

    @classmethod
    def tearDown(cls):
        cls.driver.quit()

    # def is_element_present(self,how,what):
    #     """
    #     Utility method to check presence of an element on page
    #
    #     :param how: By locator type
    #     :param what: locator value
    #     """
    #     try:self.driver.find_element(by=how,value=what)
    #
    #     except NoSuchFrameException,e:return False
    #     return True

if __name__=='__main__':
    unittest.main(verbosity=2)

import unittest

# 从自己写的python程序searchtest.py 导入类SearchTest，
# 从 homepagetests.py 导入 类 HomePageTest
from searchtest import SearchTest
from homepagetests import HomePageTest

# 首先获取所有的测试test，使用TestLoader()方法
search_tests=unittest.TestLoader().loadTestsFromTestCase(SearchTest)
home_page_tests=unittest.TestLoader().loadTestsFromTestCase(HomePageTest)

# 然后生成一个test suite，通过将测试方法：home_page_tests 和 SearchTest 结合。 
smoke_tests=unittest.TestSuite([home_page_tests,search_tests])

# 最后，运行suite
unittest.TextTestRunner(verbosity=2).run(smoke_tests)

# user_info.txt
#
# username,passwrd123
# user2,password
###########################

# user_info.py

user_file=open('user_info.txt','r')
lines=user_file.readlines()
user_file.close()

for line in lines:
    username=line.split(',')[0]
    password=line.split(',')[1]
    print(username,password)

# info.csv
# testing,12345@outlook.com,23,man
#################################

#csv_read.py

import csv

data=csv.reader(open('info.csv','r'))

for user in data:
    print(user)

import xlrd

book=xlrd.open_workbook("myfile.xlsx")
sheet=book.sheet_by_index(0)

for rx in range(sheet.nrows):
    print(sheet.row(rx))

# 若报错：Excel xlsx file; not supported，表明xlrd不支持xlsx文件格式，
# （1）可以将myfile.xlsx 另存为“myfile.xls”。
# （2）重新安装xlrd，更改为支持xlsx格式的xlrd版本。
# 如：pip install xlrd==1.2.0

import pandas as pd

pd.read_excel('myfile.xlsx')

self.driver.back()
self.driver.forward()