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" + "Контакты не состоящие в какай-либо группе")
