# |-----------------------------------------------------------------------------
# |            This source code is provided under the Apache 2.0 license      --
# |  and is provided AS IS with no warranty or guarantee of fit for purpose.  --
# |                See the project's LICENSE.md for details.                  --
# |           Copyright (C) 2021 Refinitiv. All rights reserved.              --
# |-----------------------------------------------------------------------------

# |-----------------------------------------------------------------------------
# | Please be informed, that this example uses python library win32com 		  --
# | that is not provided or supported by Refinitiv							  --
# |----------------------------------------------------------------------------- 

import win32com.client
import time
from win32com.client import pythoncom, VARIANT
from time import gmtime, strftime
 
q = win32com.client.Dispatch("REDI.Query")
 
# Prepare a variable which can handle returned values from submit method of the order object.
row = VARIANT(pythoncom.VT_BYREF | pythoncom.VT_VARIANT, 0)
cellVar = VARIANT(pythoncom.VT_BYREF | pythoncom.VT_VARIANT, 0)
cellVal = VARIANT(pythoncom.VT_BYREF | pythoncom.VT_VARIANT, 0)
retVar = VARIANT(pythoncom.VT_BYREF | pythoncom.VT_VARIANT, 0)
 
# Prepare the query
vTable = "Message"
vWhere = ""
tmpVal = q.Submit(vTable, vWhere, retVar)
print("Success="+str(tmpVal)+ ", result="+ str(retVar.value))

# Find out the number of available rows
rowCount = q.RowCount
print(strftime("%Y-%m-%d %H:%M:%S", gmtime()) + ": "+str(rowCount)+" rows present")
 
for i in range(0, rowCount):

	cellVar.value = "DisplaySymbol"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))

	cellVar.value = "MsgType"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))

	cellVar.value = "Status"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))

	cellVar.value  = "Quantity"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))

	cellVar.value  = "ExecPrice"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))
	
	cellVar.value = "ExecQuantity"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))

	cellVar.value = "OrderRefKey"
	ret = q.GetCell(i,  cellVar, cellVal, retVar)
	print(str(retVar.value) + ", "+ str(cellVal.value) + "=" + str(cellVar.value) + " success="+str(ret))

	print("===>");