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))