def updateRows(data,tb,tbl,query,pk,wIndex): j=0 temp = [] while(j < len(pk)): i=0 while(i < wIndex): if(sqlUtils.isPrimary(tb,tbl,query[i])): temp = data[tbl][pk[j]] del data[tbl][pk[j]] data[tbl][query[i+2]] = temp else: data[tbl][pk[j]][query[i]] = convertValues(tb,tbl,query[i],query[i+2]) i+=4 j+=1
def getKeyListInTable(metadataTb, tableName, sourceData, columnName, valueToSearch, logicOp):
keyList=[]
dtype = determineColType(metadataTb,tableName,columnName)
convertedValueSearch = convertValue(dtype,valueToSearch)
# columnName is primary, check the outer k value in sourceData
if(sqlUtils.isPrimary(metadataTb,tableName,columnName)):
for k in sourceData:
if(logicOp == "="):
if(convertValue(dtype,k) == convertedValueSearch):
keyList.append(k)
elif(logicOp == "<"):
if( convertValue(dtype,k) < convertedValueSearch):
keyList.append(k)
elif(logicOp == ">"):
if( convertValue(dtype,k) > convertedValueSearch):
keyList.append(k)
else:
if(convertValue(dtype,k) != convertedValueSearch):
keyList.append(k)
else:
#else columnName is not primary
for k in sourceData:
for key,value in sourceData[k].items():
if(key == columnName):
if(logicOp == "="):
if( convertValue(dtype,value) == convertedValueSearch):
keyList.append(k)
# print(value)
elif(logicOp == "<"):
if( convertValue(dtype,value) < convertedValueSearch):
keyList.append(k)
# print(value)
elif(logicOp == ">"):
if( convertValue(dtype,value) > convertedValueSearch):
keyList.append(k)
# print(value)
else:
if( convertValue(dtype,value) != convertedValueSearch):
keyList.append(k)
# print(value)
# print(keyList)
return keyList
