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