list-all-faculty.py

#!/usr/bin/env python2
# -*- coding: utf-8 -*-

from google_group_lib import googLib
import log
logger = log.setup_custom_logger('root')
#
#  Mail List Shell. Use this file to create new lists.
#

# Name of mail list. This should  mirror Group email address in settings



listname = 'all-faculty@sbcc.edu'

logger.info(listname + ' Starting List processing')

# next is the sql. This should be a query that returns email address
# This should call a view in schema sbcc_listsrv
sql = """
select EMAIL_ADDRESS from GV_MASTER_LIST_GG where LIST_FACULTY_FT = 'Y' or  LIST_FACULTY_ADJ='Y' or LIST_FACULTY_NC = 'Y' or LIST_MANAGER = 'Y'
union
select 'online@pipeline.sbcc.edu' from dual
union
select 'lydecierdo@pipeline.sbcc.edu' from dual
union
select 'cmalsheimerb@pipeline.sbcc.edu' from dual
union
select 'gnjames@pipeline.sbcc.edu' from dual
union
select 'pljohnson3@pipeline.sbcc.edu' from dual
union
select 'cmmarquez3@pipeline.sbcc.edu' from dual
"""

#Inistate processing
_list = googLib(listname,sql)
logger.info(listname + ' List processing complete')