SQL_Query Return Dict

[JFK344]

Wold be nice if SQL Query would return Dict and not unserialized Data. This makes it run:

This is a Function outside of the axl class:

def element_list_to_ordered_dict(elements):
    return [OrderedDict((element.tag, element.text) for element in row) for row in elements]

This replaces the existing function:

    def sql_query(self, query):
        axl_resp = self.client.executeSQLQuery(sql=query)
        try:
            value = element_list_to_ordered_dict(serialize_object(axl_resp)["return"]["rows"])
            jsonList = []    
            for i in range(len(value)):
                jsonList.append(json.loads(json.dumps(value[i])))
            return jsonList

        except KeyError:
            # single tuple response
            value = element_list_to_ordered_dict(serialize_object(axl_resp)["return"]["row"])
            jsonList = []   
            for i in range(len(value)):
                jsonList.append(json.loads(json.dumps(value[i])))
            return jsonList

        except TypeError:
            # no SQL tuples
            return serialize_object(axl_resp)["return"]

Required Libs:

from zeep.helpers import serialize_object
from collections import OrderedDict

[Yoxcy]

Input:

for sql in ucm.run_sql_query('run sql select * from device'):
print(sql.name)

Output:

print(sql.name)

AttributeError: 'str' object has no attribute 'name'

How to fix this?