cx_Oracle and python to get query results as XML?

[caneflo]

I am using cx_Oracle and python 2.6 to get query results from oracle 10g database. Is there way using cx_Oracle or some other program to easily get resuls as XML. I presently take the python data structure and convert it json for use with javascripts. I now need to move to XML.
Any ideas or suggestions?

[bvdet]

The method of building your XML document would depend on your data structure and whether you want to save your data as text nodes, attributes, or a combination of the two. Following are examples that create XML documents from a simple dictionary.

'''
Dictionary to XML
The dictionary keys are XML tags and the values are text node values.
'''
 
from xml.dom import minidom
 
def createTextNodes(dd):
    xmldoc = minidom.Document()
    xmldoc.appendChild(xmldoc.createComment("This is a comment"))
 
    root = xmldoc.createElement('root')
    xmldoc.appendChild(root)
 
    for key in dd:
        a = xmldoc.createElement(key)
        b = xmldoc.createTextNode(str(dd[key]))
        root.appendChild(a)
        a.appendChild(b)
 
    return xmldoc
 
def createAttrs(dd):
    xmldoc = minidom.Document()
    xmldoc.appendChild(xmldoc.createComment("This is a comment"))
 
    root = xmldoc.createElement('root')
    xmldoc.appendChild(root)
 
    dataNode = xmldoc.createElement('data')
    root.appendChild(dataNode)
 
    for key in dd:
        dataNode.setAttribute(key, str(dd[key]))
 
    return xmldoc
 
dd = {'code_version': 4.02, 'version': 1}
 
x1 = createTextNodes(dd)
print x1.toprettyxml()
 
x2 = createAttrs(dd)
print x2.toprettyxml()

The results:

>>> <?xml version="1.0" ?>
<!--This is a comment-->
<root>
    <code_version>
        4.02
    </code_version>
    <version>
        1
    </version>
</root>
 
<?xml version="1.0" ?>
<!--This is a comment-->
<root>
    <data code_version="4.02" version="1"/>
</root>
 
>>> 

[caneflo]

Sweet! I will give this a go and let you how it turns out. I like how you incorporated the <root> and comment. I will use that to incorporate a time stamp to my xml output.