from fixture.orm import ORMFixture
from model.project import Project
db = ORMFixture(host='127.0.0.1', name='bugtracker', user='******', password='')
try:
l = db.get_projects_list()
print(type(len(l)))
for item in l:
print(item)
print(len(l))
finally:
# connection.close()
pass
from model.contact import Contact
from model.group import Group
import random
from fixture.orm import ORMFixture
db = ORMFixture(host="127.0.0.1",
user="******",
password="",
database="addressbook")
def test_del_contact_from_group(app, check_ui):
if len(db.get_contact_list()) == 0:
app.contact.add_contact(Contact(firstname="thisContactWillBeDeleted"))
if len(db.get_group_list()) == 0:
app.group.create(Group(name="thisGroupWillBeDeleted"))
group = random.choice(db.get_group_list())
contact = random.choice(db.get_contact_not_in_group(group))
if contact not in db.get_contact_in_group(group):
app.contact.add_contact_to_group(contact, group)
number_contact_in_group = len(db.get_contact_in_group(group))
app.contact.del_contact_from_group(contact, group)
assert contact not in db.get_contact_in_group(group)
assert number_contact_in_group - 1 + len(
db.get_contact_not_in_group(group)) == len(db.get_contact_list())
if check_ui:
assert app.group.get_contact_in_group(
group) == db.get_contact_in_group(group)
def test_add_to_group(app, db, check_ui):
if len(db.get_contact_list()) == 0:
app.contact.add_new_contact(
Contact(firstname="Gleb",
middlename="Alex",
lastname="Kazarkin",
nickname="gkazarkin",
title="AccTitle",
company="TestCompany",
address="Yakovleva 5",
homephone="515232",
mobilephone="89539235812",
workphone="367412",
fax="89539234611",
email="*****@*****.**",
email2="*****@*****.**",
homepage="gkazarkin.com",
bday="11",
bmonth="April",
byear="1987",
aday="11",
amonth="April",
ayear="1987",
address2="Yakovleva 5",
secondaryphone="515232",
notes="Test Note"))
if len(db.get_group_list()) == 0:
app.group.create(Group(name="test"))
old_groups = db.get_group_list()
old_contacts = db.get_contact_list()
# l = ORMFixture.get_contacts_not_in_group(Group(id="330"))
try:
db = ORMFixture(host="127.0.0.1",
name="addressbook",
user="******",
password="")
l = db.get_contacts_not_in_group(Group(id="330"))
for item in l:
print(item)
print(len(l))
finally:
pass
app.contact.add_to_group(contact_id=l[0].id, group_id="330")
try:
l = db.get_contacts_in_group(Group(id="330"))
for item in l:
print(item)
assert (len(l)) > 0
print(len(l))
finally:
pass
new_contacts = db.get_contact_list()
assert len(old_contacts) == len(new_contacts)
"""Опциональный флаг проверки через UI
Прописать запуск можно или в консоли или справа вверху Edit_Configuration - Additional arguments (Options) --check_ui"""
if check_ui:
assert sorted(new_contacts, key=Contact.id_or_max) == sorted(
app.contact.get_contact_list(), key=Contact.id_or_max)
def test_del_random_contact_from_group(app, db):
orm = ORMFixture(host="127.0.0.1",
name="addressbook",
user="******",
password="")
groups = orm.get_group_list()
contacts = orm.get_contact_list()
if len(contacts) == 0:
app.contact.create((Contact(firstname="firstname",
middlename="middlename",
lastname="lastname",
nickname="nickname",
title="title",
company="company",
address="address",
homephone="home",
mobilephone="mobile",
workphone="work",
fax="fax",
email="email",
homepage="homepage",
address2="address2",
secondaryphone="phone2",
notes="notes")))
if len(groups) == 0:
app.group.create(Group(name="test"))
app.contact.open_contact_list_page()
# check contacts in group presence
contacts_in_group = db.get_all_contacts_in_group()
if len(contacts_in_group) == 0:
# add contact in group
contact = random.choice(contacts)
contact_id = contact.id
group = random.choice(groups)
group_name = group.name
group_id = group.id
# add contact to random group
old_contacts_in_groups = orm.get_contacts_in_group(Group(id=group_id))
app.contact.add_contact_to_group(contact_id, group_name)
# verified contact in group
new_contacts_in_groups = orm.get_contacts_in_group(Group(id=group_id))
if len(old_contacts_in_groups) == len(new_contacts_in_groups):
print("Contact wasnt' added, randomly choosed same group")
else:
assert len(old_contacts_in_groups) + 1 == len(
new_contacts_in_groups)
for contact_in_group in new_contacts_in_groups:
assert (contact_in_group.id == contact_id)
# delete random contact from group
contacts_in_group = db.get_all_contacts_in_group()
contact_in_group = random.choice(contacts_in_group)
contact_id = contact_in_group.id
group_id = contact_in_group.group_id
# get group name
group_name = None
for g in groups:
if str(g.id) == str(group_id):
group_name = g.name
if group_name == None:
raise ValueError("Can't find group_id")
print("-------> " + str(group_name))
app.contact.delete_contact_from_group(contact_id, group_name)
contacts_in_groups_after_deletion = db.get_all_contacts_in_group()
assert len(contacts_in_group) - 1 == len(contacts_in_groups_after_deletion)
from fixture.orm import ORMFixture
from model.group import Group
db = ORMFixture(host='127.0.0.1', name='addressbook', user='******', password='')
try:
l = db.get_contact_list()
for item in l:
print(item)
print(len(l))
finally:
pass
#import pymysql.cursors
from fixture.orm import ORMFixture
from model.group import Group
#connection = pymysql.connect(host="127.0.0.1", database="addressbook", user="******", password="")
db = ORMFixture(_host="127.0.0.1", _database="addressbook", _user="******", _password="")
try:
list = db.get_contacts_out_of_group(Group(_id=300))
for item in list:
print(item)
print(len(list))
finally:
pass #connection.close()
#try:
# cursor = connection.cursor()
# cursor.execute("select * from group_list")
# for row in cursor.fetchall(): #fetchall returns all info as list of rows(like in db)
#Скрипт который устанавливает соединение с БД и извлекаем данные из БД
#import mysql.connector
# import pymysql.cursors
import pymysql
from fixture.orm import ORMFixture
from model.group import Group
db = ORMFixture(host="127.0.0.1", name = "addressbook", user ="******", password = "") # будет создаваться новый объект типа DbFixture
#connection = pymysql.connect(host="127.0.0.1", database = "addressbook", user ="******", password = "") # устанавливаем соединение
try: # вывод инфы на консоль
l = db.get_contacts_not_in_group(Group(id="233"))
for item in l:
print(item)
print(len(l)) #печатаем длинну списка
finally:
pass # db.destroy()
"""try: # вывод инфы на консоль
l = db.get_contacts_in_group(Group(id="230"))
for item in l:
print(item)
print(len(l)) #печатаем длинну списка
finally:
pass # db.destroy()"""
"""try:
cursor = connection.cursor() # для создания запроса к бд нужно создать курсор, указатель на данные в бд
cursor.execute("select * from group_list") # запрос к бд на скл
from fixture.orm import ORMFixture
db = ORMFixture(host="127.0.0.1", name="bugtracker", user="******", password="")
try:
l = db.get_projects_list()
for item in l:
print(item)
print(len(l))
finally:
pass # db.destroy()
import pymysql
import pymysql.cursors
from model.group import Group
from fixture.orm import ORMFixture
db = ORMFixture(host="17.218.71.53", user="******", password="", name="addressbook")
# try:
# cursor = connection.cursor()
# cursor.execute("SELECT * FROM group_list")
# for row in cursor.fetchall():
# print(row)
# finally:
# connection.close()
try:
l = db.get_contacts_not_in_group(Group(id="318"))
for item in l:
print(item)
print(len(l))
finally:
pass
def orm(request):
db_config = load_config(request.config.getoption("--target"))['db']
db_fixture_orm = ORMFixture(host=db_config['host'], database=db_config['name'], user=db_config['user'], password=db_config['password'])
return db_fixture_orm
from fixture.orm import ORMFixture
from model.group import Group
db = ORMFixture(host="192.168.64.2",
name="addressbook",
user="******",
password="******")
try:
l = db.get_contacts_not_in_group(Group(id="411"))
for item in l:
print(item)
print(len(l))
finally:
pass
#db.destroy()
def orm(request):
orm_config = load_config(request.config.getoption("--target"))["orm"]
ormfixture = ORMFixture(host=orm_config["host"], database=orm_config["database"],
user=orm_config["user"], password=orm_config["password"])
return ormfixture
import pymysql.cursors
from fixture.orm import ORMFixture
db = ORMFixture(host='192.168.64.2',
name='addressbook',
user='******',
password='******')
try:
l = db.get_contact_list()
for i in range(len(l)):
print(l[i].address)
print(len(l))
finally:
pass # db.destroy()
from model.group import Group
from model.contact import Contact
from random import randrange
from fixture.orm import ORMFixture
orm = ORMFixture(host="localhost", name="addressbook", user="******", password="")
def test_add_contact_to_group(app, db):
if len(db.get_group_list()) == 0:
app.group.create(Group(name="test"))
if len(db.get_contact_list()) == 0:
app.contact.create(Contact(firstname="test"))
contacts = db.get_contact_list()
groups = db.get_group_list()
pair_found = False
for C in range(len(contacts)):
for G in range(len(groups)):
if contacts[C] not in orm.get_contacts_in_group(groups[G]):
pair_found = True
contact_id = contacts[C].id
group_id = groups[G].id
break
if pair_found:
break
if not pair_found:
app.group.create(Group(name="test"))
def orm(request):
orm_config = load_config(request.config.getoption("--target"))['db']
ormfixture = ORMFixture(host=orm_config['host'], name=orm_config['name'], user=orm_config['user'], password=orm_config['password'])
return ormfixture
def orm():
ORMfixture = ORMFixture(host="localhost",
name="addressbook",
user="******",
password="")
return ORMfixture
from fixture.orm import ORMFixture
from model.group import Group
db = ORMFixture(
host="localhost",
unix_socket="/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock",
name="addressbook",
user="******",
password="")
try:
l = db.get_contacts_in_group(Group(id='350'))
for item in l:
print(item)
print(len(l))
finally:
pass
try:
i = db.get_contact_list()
for item in i:
print(item)
print(len(i))
finally:
pass
def orm(request):
db_config = load_config(request.config.getoption("--target"))["db"]
ormfixture = ORMFixture(host=db_config["host"], name=db_config["name"], user=db_config["user"], password=db_config["password"])
return ormfixture
import random
from fixture.orm import ORMFixture
from model.group import Group
db = ORMFixture(host="localhost", database="addressbook", user="******", password="")
try:
if len(db.get_group_list()) > 0:
group = random.choice(db.create_groupid_list())
print("\n" + "-" * 10 + "Contacts" + "-" * 10)
l = db.get_contact_list()
for item in l:
print(item)
print("*** Total contacts count: " + str(len(l)) + " ***" + "\n" + "\n" + "-" * 10 + "Groups" + "-" * 10)
l = db.get_group_list()
for item in l:
print(item)
print("*** Total groups count: " + str(
len(l)) + " ***" + "\n" + "\n" + "-" * 10 + "Contacts in group" + "-" * 10)
if len(db.get_group_list()) > 0:
l = db.get_contacts_in_group(Group(id=group))
for item in l:
print(item)
print("*** Total contacts in group id " + group + " count: " + str(
len(l)) + " ***" + "\n" + "\n" + "-" * 10 + "Contacts not in group" + "-" * 10)
if len(db.get_group_list()) > 0:
l = db.get_contacts_not_in_group(Group(id=group))
for item in l:
print(item)
print("*** Total contacts not in group id " + group + " count: " + str(len(l)) + " ***" + "\n" + "\n" + "Контакты не состоящие в какай-либо группе")
def db(request):
db_config = load_config(request.config.getoption("--target"))['db']
dbfixture = ORMFixture(host=db_config['host'], name=db_config['name'], user=db_config['user'],
password=db_config['password'])
return dbfixture
from fixture.orm import ORMFixture
import random
from model.group import Group
from model.contact import Contact
db = ORMFixture(host='localhost', user='******', password='', name='addressbook')
try:
cnt = db.get_count_contacts_in_group(Group(id=49))
print('\ncnt = ' + str(cnt))
#l = db.get_contacts_in_group(Group(id=49))
#if db.get_count_groups_for_contact(Contact(id=83)) > 0:
#l = db.get_groups_for_contact(Contact(id=83))
#contacts = db.get_group_list()
#l = db.get_group_list()
#for item in l:
# print(item)
#print(len(l))
#group = random.choice(l)
#print("size: " + str(group))
#else:
# print('No groups')
finally:
pass
#db.destroy()
from fixture.orm import ORMFixture
from model.group import Group
db = ORMFixture(host="80.211.17.161",
port=3306,
name="addressbook",
user="******",
password="******")
l = db.get_contacts_not_in_group(Group(id=200))
for item in l:
print(item)
print(len(l))
json_config = None
def load_config(file):
global json_config
if json_config is None:
config_file_path = os.path.join(
os.path.dirname(os.path.abspath(__file__)), file)
with open(config_file_path) as config_file:
json_config = json.load(config_file)
return json_config
db_config = load_config("config.json")["db"]
dbfixture = ORMFixture(host=db_config["host"],
database=db_config["database"],
user=db_config["user"],
password=db_config["password"])
try:
groups = dbfixture.get_groups_list()
for group in groups:
print(group)
print(len(groups))
contacts = dbfixture.get_contacts_list()
for contact in contacts:
print(contact)
print(len(contacts))
gs = dbfixture.get_contacts_not_in_group(Group(id="331"))
for g in gs:
print(g)
print(len(gs))
from model.group import Group
from model.contact import Contact
from fixture.orm import ORMFixture
import random
db = ORMFixture(host="127.0.0.1", name="addressbook", user="******", password="")
def test_add_contact_in_group(app):
if len(db.get_contact_list()) == 0:
app.contact.add_contact(Contact(firstname="test"))
if len(db.get_group_list()) == 0:
app.group.create_g(Group(name="test"))
contacts = sorted(db.get_contact_list(), key=Contact.id_or_max)
groups = sorted(db.get_group_list(), key=Group.id_or_max)
c_list = []
for c in range(len(contacts)):
#get group list for each contact
g_list = db.get_not_groups_of_contact(Contact(id=contacts[c].id))
if len(g_list) != 0:
#if contact is in all groups it added's to new list
c_list.append(
Contact(lastname=contacts[c].lastname,
firstname=contacts[c].firstname,
id=contacts[c].id))
if len(c_list) == 0:
app.contact.add_contact(Contact(firstname="new added contact"))
c_list = db.get_contact_list()
rand_contact = random.choice(c_list)
rand_group = random.choice(groups)
app.group.get_contact_list_from_all_groups()
def orm(db):
ormFixture = ORMFixture(host=db.host,
name=db.name,
user=db.user,
password=db.password)
return ormFixture
