def get_group_list(self):
    list = []
    cursor = self.connection.cursor()
    try:
        cursor.execute("select group_id,group_name,group_header,group_footer from group_list  where deprecated='0000-00-00 00:00:00'")
        for row in cursor:
            (id, name, header, footer) = row
            list.append(Group(id=str(id), name=name, header=header, footer=footer))
    finally:
        cursor.close()
    return list
def get_group_list(self):
    list = []
    cursor = self.connection.cursor()
    try:
        cursor.execute("select group_id,group_name,group_header,group_footer from group_list  where deprecated='0000-00-00 00:00:00'")
        for row in cursor:
            (id, name, header, footer) = row
            list.append(Group(id=str(id), name=name, header=header, footer=footer))
    finally:
        cursor.close()
    return list