how to insert values to xml variable using python

Question

i have xml (template) file and i set variables in the xml using {$var}

and i have a list with values for the xml variables.

how can i open (set) my file and set the xml variable to the values from my list ?

<sut>
    <Cdu>
        <class>XXX</class>
        <conn>
            <class>XXX</class>
            <cli>
                <password>{$password}</password>
                <user>{$user}</user>
                <host>{$host}</host>
                <connectOnInit>false</connectOnInit>
            </cli>
        </conn>
        <basic>
            <class>XXX</class>
        </basic>
    </Cdu>

Have a look at the Mako template framework.

永劫回帰
– 永劫回帰

2021-07-13 09:15:59 +00:00
Commented Jul 13, 2021 at 9:15 — 永劫回帰
– 永劫回帰, Commented Jul 13, 2021 at 9:15

balderman · Accepted Answer · 2021-07-13 09:30:17Z

Why not just use f string?

password = 'secret'
user = 'jack'
host = '12.56.78.123'
xml = f'''<sut>
    <Cdu>
        <class>XXX</class>
        <conn>
            <class>XXX</class>
            <cli>
                <password>{password}</password>
                <user>{user}</user>
                <host>{host}</host>
                <connectOnInit>false</connectOnInit>
            </cli>
        </conn>
        <basic>
            <class>XXX</class>
        </basic>
    </Cdu>'''
print(xml)

output

<sut>
    <Cdu>
        <class>XXX</class>
        <conn>
            <class>XXX</class>
            <cli>
                <password>secret</password>
                <user>jack</user>
                <host>12.56.78.123</host>
                <connectOnInit>false</connectOnInit>
            </cli>
        </conn>
        <basic>
            <class>XXX</class>
        </basic>
    </Cdu>

He has <password>{$password}</password> in input not <password>{password}</password>
The question is - can he control the template and modify it. If he can - f string is a perfect win, else - we need more complex solution. @undertale - do you have control over the "template"?

Daweo · Accepted Answer · 2021-07-13 09:30:29Z

I would use re.sub for this task following way

import re
txt = '''<password>{$password}</password>
<user>{$user}</user>
<host>{$host}</host>'''
data = {"password": "SECRET", "user": "NAME", "host": "LOCAL"}
def replacement(x):
    return data[x.group(1)]
out = re.sub(r'\{\$([^\}]+)\}', replacement, txt)
print(out)

output

<password>SECRET</password>
<user>NAME</user>
<host>LOCAL</host>

Explanation: re.sub second argument might be function which accept Match object. I used regular expression with one capturing group, which content I then use to look up data dict. Note that { and $ and } need escaping as these have special meaning, but we need literal { and $ and }. Disclaimer: I used substring of original for brevity sake.

Fedor Soldatkin · Accepted Answer · 2021-07-13 10:13:31Z

You can use Template class from standard string module:

from string import Template


password = 'secret'
user = 'jack'
host = '12.56.78.123'

xml_template = '''<sut>
    <Cdu>
        <class>XXX</class>
        <conn>
            <class>XXX</class>
            <cli>
                <password>${password}</password>
                <user>${user}</user>
                <host>${host}</host>
                <connectOnInit>false</connectOnInit>
            </cli>
        </conn>
        <basic>
            <class>XXX</class>
        </basic>
    </Cdu>'''

xml = xml_template.substitute(password=password, user=user, host=host)
print(xml)

There are also safe_substitute method that may be used in case you are not sure about context variables.

Collectives™ on Stack Overflow

how to insert values to xml variable using python

3 Answers 3

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Linked

Related