import mysql.connector
from tests_contract.contact_lib import Contact
from fixture.orm import ORMFixture
db = ORMFixture(host='127.0.0.1', name='addressbook', user='******', password='')
try:
groups = db.get_contacts_in_groups()
for group in groups:
print group
print len(groups)
finally:
pass
#db.destroy()
'''
try:
cursor = connection.cursor()
cursor.execute('select id, firstname, middlename, lastname, nickname, title, company, address, home, '
'mobile, work, fax, email, email2, email3, homepage, address2, phone2, notes '
'from addressbook')
for row in cursor:
print (row)
(id, firstname, middlename, lastname, nickname, title, company, address, home, mobile, work, fax,
email, email2, email3, homepage, address2, phone2, notes) = row
list.append(Contact(first_name=firstname, last_name=lastname,
middle_name=middlename, nickname=nickname,
