def get_contacts_in_group(self,id_group): list = [] cursor = self.connection.cursor() try: cursor.execute(""" select id,firstname,lastname,middlename,nickname,title,company,address, home,mobile,work,fax,email,email2,email3,homepage,bday,bmonth,byear, aday,amonth,ayear,address2,phone2,notes from addressbook where deprecated='0000-00-00 00:00:00' and group_id='%s' """%id_group) for row in cursor: (id, firstname, lastname, middlename, nickname, title, company, address, homephone, mobilephone, workphone, fax, email, email2, email3, homepage, bday, bmonth, byear, aday, amonth, ayear, address2, secondaryphone, notes) = row list.append(ContactProperties(id=str(id), firstname=firstname, lastname=lastname, middlename=middlename, nickname=nickname, title=title, company=company, address=address, homephone=homephone, mobilephone=mobilephone, workphone=workphone, fax=fax, email=email, email2=email2, email3=email3, homepage=homepage, bday=bday, bmonth=bmonth, byear=byear, aday=aday, amonth=amonth, ayear=ayear, address2=address2, secondaryphone=secondaryphone, notes=notes )) finally: cursor.close() return list
def get_contact_from_view_page(self, index): wd = self.app.wd self.open_contact_view_by_index(index) text = wd.find_element_by_id("content").text homephone = re.search("H: (.*)", text).group(1) workphone = re.search("W: (.*)", text).group(1) mobilephone = re.search("M: (.*)", text).group(1) # fax=re.search("F: (.*)",text).group(1) secondaryphone = re.search("P: (.*)", text).group(1) return ContactProperties( homephone=homephone, mobilephone=mobilephone, workphone=workphone, # fax=fax, secondaryphone=secondaryphone)
def test_delete_contact(app, check_ui, db): # photo path # p= os.path.abspath('C:\Users\hh\Pictures\Git.jpeg') if app.contact.count() == 0: app.contact.create( ContactProperties(firstname="delete check", middlename="delete check", lastname="delete check", nickname="delete check", photo="", title="delete check", company="delete check", address="Adress2 Company2", homephone="89776000000", mobilephone="89776000001", workphone="89776000002", fax="89776000003", email="*****@*****.**", email2="*****@*****.**", email3="*****@*****.**", homepage="lev.tt.ru", address2="New Secondary Adress", secondaryphone=" New Secondary Home", notes=" some new notes ver 2", ayear="1999", amonth="February", aday="5", byear="2001", bmonth="June", bday="17")) old_contacts = db.get_contact_list() contact = random.choice(old_contacts) app.contact.delete_contact_by_id(contact.id) new_contacts = db.get_contact_list() assert len(old_contacts) - 1 == len(new_contacts) old_contacts.remove(contact) assert old_contacts == new_contacts if check_ui: assert sorted(old_contacts, key=ContactProperties.id_or_max) == sorted( new_contacts, key=ContactProperties.id_or_max)
def test_add_contact_to_group(db, app, orm): if len(db.get_group_list()) == 0: app.group.create(Group(name="test group")) if app.contact.count() == 0: app.contact.create( ContactProperties(firstname="delete check", middlename="delete check", lastname="delete check", nickname="delete check", photo="", title="delete check", company="delete check", address="Adress2 Company2", homephone="89776000000", mobilephone="89776000001", workphone="89776000002", fax="89776000003", email="*****@*****.**", email2="*****@*****.**", email3="*****@*****.**", homepage="lev.tt.ru", address2="New Secondary Adress", secondaryphone=" New Secondary Home", notes=" some new notes ver 2", ayear="1999", amonth="February", aday="5", byear="2001", bmonth="June", bday="17")) groups = db.get_group_list() old_contacts = db.get_contact_list() contact_id = random.choice(old_contacts).id group_id = random.choice(groups).id app.contact.add_contact_to_group(contact_id, group_id) # не работает assert assert db.get_contact_by_id(contact_id) in orm.get_contacts_in_group( Group(id=group_id))
def get_contact_info_from_edit_page(self, index): wd = self.app.wd for row in wd.find_elements_by_xpath("//tr[@name='entry']"): self.open_contact_to_edit_by_index(index) firstname = wd.find_element_by_name("firstname").get_attribute( "value") lastname = wd.find_element_by_name("lastname").get_attribute( "value") id = wd.find_element_by_name("id").get_attribute("value") homephone = wd.find_element_by_name("home").get_attribute("value") workphone = wd.find_element_by_name("work").get_attribute("value") mobilephone = wd.find_element_by_name("mobile").get_attribute( "value") fax = wd.find_element_by_name("fax").get_attribute("value") secondaryphone = wd.find_element_by_name("phone2").get_attribute( "value") address = wd.find_element_by_name("address").get_attribute("value") email = wd.find_element_by_name("email").get_attribute("value") email2 = wd.find_element_by_name("email2").get_attribute("value") email3 = wd.find_element_by_name("email3").get_attribute("value") # homepage = wd.find_element_by_name("homepage").get_attribute("value") return ContactProperties( firstname=firstname, lastname=lastname, id=id, address=address, email=email, email2=email2, email3=email3, homephone=homephone, mobilephone=mobilephone, workphone=workphone, fax=fax, secondaryphone=secondaryphone, # homepage=homepage )
def get_contact_list(self): if self.contact_cashe is None: wd = self.app.wd self.return_to_home_page() self.contact_cashe = [] for row in wd.find_elements_by_xpath("//tr[@name='entry']"): container = row.find_elements_by_tag_name("td") lastname = container[1].text firstname = container[2].text address = container[3].text all_emails = container[4].text id = container[0].find_element_by_tag_name( "input").get_attribute("value") all_phones = container[5].text # homepage = container[9]. self.contact_cashe.append( ContactProperties(lastname=lastname, firstname=firstname, id=id, address=address, all_emails=all_emails, all_phones_from_home_page=all_phones)) return list(self.contact_cashe)
testdata = [ ContactProperties(firstname=random_string("firstname", 20), middlename=random_string("middlename", 20), lastname=random_string("lastname", 20), nickname=random_string("nickname", 10), photo="", title=random_string("title", 30), company=random_string("company", 30), address=random_string("address", 30), homephone=random_phones("", 11), mobilephone=random_phones("", 11), workphone=random_phones("", 11), fax=random_phones("", 11), email=random_string("email@", 10), email2=random_string("email@", 10), email3=random_string("email@", 10), homepage=random_string("http://", 15), address2=random_string("address2", 30), secondaryphone=random_phones("", 11), notes=random_string("Notes", 40), ayear=random.randint(1945, 2019), amonth=random_month(), aday=random.randint(1, 31), byear=random.randint(1945, 2019), bmonth=random_month(), bday=random.randint(1, 31)) for i in range(n) ] file = os.path.join(os.path.dirname(os.path.abspath(__file__)), "..", f)
def convert(contact): return ContactProperties(id = str(contact.id), firstname=contact.firstname,lastname= contact.lastname)
def test_edit_contact(app, check_ui, db): if app.contact.count() == 0: app.contact.create( ContactProperties(firstname="edit check", middlename="edit check", lastname="edit check", nickname="edit check", photo="", title="edit check", company="edit check", address="Adress2 Company2", homephone="89776000000", mobilephone="89776000001", workphone="89776000002", fax="89776000003", email="*****@*****.**", email2="*****@*****.**", email3="*****@*****.**", homepage="lev.tt.ru", address2="New Secondary Adress", secondaryphone=" New Secondary Home", notes=" some new notes ver 2", ayear="1999", amonth="February", aday="5", byear="2001", bmonth="June", bday="17")) old_contacts = db.get_contact_list() contact = ContactProperties(firstname="Lev", middlename="Radeon", lastname="Akatiev", nickname="kiriill", photo="", title="Title2", company="Company2", address="Adress2 Company2", homephone="89776000000", mobilephone="89776000001", workphone="89776000002", fax="89776000003", email="*****@*****.**", email2="*****@*****.**", email3="*****@*****.**", homepage="lev.tt.ru", address2="edit", secondaryphone=" edit Secondary Home", notes=" some new notes ver 2", ayear="2002", amonth="February", aday="8", byear="2004", bmonth="June", bday="16") contact_to_edit = random.choice(old_contacts) app.contact.edit_contact_by_id(contact_to_edit.id, contact) new_contacts = db.get_contact_list() assert len(old_contacts) == len(new_contacts) if check_ui: assert sorted(app.contact.get_contact_list(), key=ContactProperties.id_or_max) == sorted( new_contacts, key=ContactProperties.id_or_max)