def execute_query1():
print 'inside execute query'
zn_nocache = ZnApi('universal', 'qa', use_cache=False)
date1 ='2015-05-19'
print date1
snapshot_id = zn_nocache.snapshot_id(date1, 'EOD')
select_fields = ['SOURCE','SUM("MTM")']
qzt_qa1 = zn_nocache.query(snapshot_id, select_fields)
return qzt_qa1
def val(self):
zn_nocache = ZnApi('universal', 'qa', use_cache=False)
date1 = self.Cobdate()
# date1 = '2014-08-14'
print date1
snapshot_id = zn_nocache.snapshot_id(date1, 'EOD')
select_fields = ['SOURCE','SUM("MTM")']
qzt_qa1 = zn_nocache.query(snapshot_id, select_fields)
return qzt_qa1
