spreadsheets = project.get_last_10m_activity()
logger.info('total %s sheets' % spreadsheets['hits']['total'])
for item in spreadsheets['hits']['hits']:
spreadsheetId = item['_source']['sheet_id']
owner = item['_source']['update_by']
flow = item['_source']['flow']
contract = item['_source']['contract']
logger.info('starting %s' % spreadsheetId)
logger.info('=> loading sheet knowledge_map')
try:
project = knowledge.load_spreadsheet_knowledge_map(
spreadsheet_api,
service,
item,
notify
)
logger.info('=> loading stack')
stack.load_stack(project)
except errors.HttpError, err:
if err.resp.status in [404, 500]:
# delete sheet_id from index project and knowledge index
q = "sheet_id:"+spreadsheetId
project.delete_by_query(q)
knowledge.delete_by_query(q)
logger.warning("==> Spreadsheet %s doesn't exists: %s" % (spreadsheetId, err))
else:
# send email to owner
logger.error("==> exception on %s : %s" % (spreadsheetId, err))
