def findStringOrderbyAttributes(queryobj):
orderbyAttr = ""
if(queryobj is not None):
orderbyIdent = queryobj.getOrderbyIdent()
if (orderbyIdent is not None):
for oid in orderbyIdent:
# print oid
if (myhelper.isAggregate(oid)):
# print"agg"
orderbyAttr+= str(oid)
elif (myhelper.isOrderbyOperator(oid)):
# print "ops"
orderbyAttr = orderbyAttr.strip(", ")
orderbyAttr+= " " + myhelper.remAggregate(str(oid)) + ", "
elif(myhelper.isMathOperator(str(oid))):
# print "myops %s" %oid
orderbyAttr+=str(oid)
else:
# print "else"
orderbyAttr+= str(oid) + ", "
orderbyAttr = orderbyAttr.strip("_")
orderbyAttr = orderbyAttr.strip(", ")
# print "orderbyAttr: %s" %orderbyAttr
return orderbyAttr
def findStringSelectAttributes(queryobj):
selectAttr = ""
selectIdent = queryobj.getSelectIdent()
if (selectIdent is not None):
if (myhelper.checkIfList(selectIdent)):
for sid in selectIdent:
if (myhelper.isAggregate(sid)):
selectAttr+=str(sid)
selectAttr= selectAttr.strip()
elif(myhelper.isMathOperator(sid)):
selectAttr = selectAttr.rstrip(", ")
selectAttr+=str(sid)
selectAttr= selectAttr.strip()
else:
selectAttr+= str(sid) + ", "
selectAttr= selectAttr.strip()
else:
selectAttr+= str(selectIdent)
selectAttr= selectAttr.strip()
selectAttr = selectAttr.strip(", ")
return selectAttr
