def _get_new_and_updated_people(self, family_id):
'''
Gets a list of dicts of person_id and person_name of updated people and
list of dicts of person_id and person_name of new people
'''
new_query = ( "SELECT person_id, person_name "
"FROM emailer_familynewsletterevents "
"WHERE family_id = {0} AND new_member = 1;").format(family_id)
new_people = list(query_to_dicts(new_query))
updated_query = ( "SELECT person_id, person_name "
"FROM emailer_familynewsletterevents "
"WHERE family_id = {0} AND new_member = 0;").format(family_id)
updated_people = list(query_to_dicts(updated_query))
return new_people, updated_people
def _get_distinct_families_and_languages(self):
'''
Gets all the languages currently used by the families who are
receiving the news emails
'''
#http://maxivak.com/executing-raw-sql-in-django/
query = ( "SELECT DISTINCT custom_user_user.family_id, custom_user_user.language "
"FROM emailer_familynewsletterevents "
"INNER JOIN custom_user_user ON emailer_familynewsletterevents.family_id = custom_user_user.family_id "
"ORDER BY custom_user_user.family_id;")
return list(query_to_dicts(query))