def get_contact_list(self):
    list = []
    cursor = self.connection.cursor()
    try:
        cursor.execute("select id,firstname,lastname from addressbook  where deprecated='0000-00-00 00:00:00'")
        for row in cursor:
            (id, firstname, lastname) = row
            list.append(Contact(id=str(id), firstname=firstname, lastname=lastname))
    finally:
        cursor.close()
    return list
def get_contact_list(self):
    list = []
    cursor = self.connection.cursor()
    try:
        cursor.execute("select id,firstname,lastname from addressbook  where deprecated='0000-00-00 00:00:00'")
        for row in cursor:
            (id, firstname, lastname) = row
            list.append(Contact(id=str(id), firstname=firstname, lastname=lastname))
    finally:
        cursor.close()
    return list