from silo_common.database import local_db
import silo_common.snippets as em7_snippets
from em7_api_support.session import Session


dbc = local_db()
api_session = Session.build(dbc)

#Get 3G aligned devices
sql = 'select did from master.map_dynamic_app_device_cred where app_id = 1669'
threeG = dbc.autofetch_column(sql)

#Get 4G aligned devices
sql = 'select * from master.map_dynamic_app_device_cred where app_id = 1677'
fourG = dbc.autofetch_column(sql)

did_list = [i for i in threeG if i not in fourG]