How to insert a new element under another with xmlstarlet?

by

I had a similar problem: I had a Tomcat configuration file (server.xml), and had to insert a <Resource> tag with pre-defined attributes into the <GlobalNamingResources> section.

Here is how it looked before:

<GlobalNamingResources>
    <!-- Editable user database that can also be used
         by UserDatabaseRealm to authenticate users
    -->
    <Resource name="UserDatabase"
              auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml" />
</GlobalNamingResources>

Here is what I wanted to achieve:

<GlobalNamingResources>
    <!-- Editable user database that can also be used
         by UserDatabaseRealm to authenticate users
    -->
    <Resource name="UserDatabase"
              auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml" />
    <Resource name="jdbc/templateassets"
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://DBHOST:DBPORT/DBNAME?createDatabaseIfNotExist=false&amp;useUnicode=true&amp;characterEncoding=utf-8"
              username="DBUSER"
              password="DBPASS"
              maxActive="150"
              maxIdle="10"
              initialSize="10"
              validationQuery="SELECT 1"
              testOnBorrow="true" />
</GlobalNamingResources>

Here is how I did it (snippet from a shell script):

if [ -n "$(xmlstarlet sel -T -t -v "/Server/GlobalNamingResources/Resource[@name="jdbc/templateassets"]/@name" server.xml)" ]; then
  echo "Resource jdbc/templateassets already defined in server.xml"
else
  echo "Adding resource jdbc/templateassets to <GlobalNamingResources> in server.xml"
  xmlstarlet ed -P -S -L -s /Server/GlobalNamingResources -t elem -n ResourceTMP -v "" \
    -i //ResourceTMP -t attr -n "name" -v "jdbc/templateassets" \
    -i //ResourceTMP -t attr -n "auth" -v "Container" \
    -i //ResourceTMP -t attr -n "type" -v "javax.sql.DataSource" \
    -i //ResourceTMP -t attr -n "driverClassName" -v "com.mysql.jdbc.Driver" \
    -i //ResourceTMP -t attr -n "url" -v "jdbc:mysql://DBHOST:DBPORT/DBNAME?createDatabaseIfNotExist=false&useUnicode=true&characterEncoding=utf-8" \
    -i //ResourceTMP -t attr -n "username" -v "DBUSER" \
    -i //ResourceTMP -t attr -n "password" -v "DBPASS" \
    -i //ResourceTMP -t attr -n "maxActive" -v "150" \
    -i //ResourceTMP -t attr -n "maxIdle" -v "10" \
    -i //ResourceTMP -t attr -n "initialSize" -v "10" \
    -i //ResourceTMP -t attr -n "validationQuery" -v "SELECT 1" \
    -i //ResourceTMP -t attr -n "testOnBorrow" -v "true" \
    -r //ResourceTMP -v Resource \
    server.xml
fi

The trick is to temporarily give a unique name to the new element, so that it can be found later with an XPATH expression. After all attributes have been added, the name is changed back to Resource (with -r).

The meaning of the other xmlstarlet options:

-P (or --pf)        - preserve original formatting
-S (or --ps)        - preserve non-significant spaces
-L (or --inplace)   - edit file inplace

More Related Contents:

  1. How to declare XPath namespaces in xmlstarlet?
  2. How to execute XPath one-liners from shell?
  3. XPath query to get nth instance of an element
  4. Getting attribute using XPath
  5. xmllint failing to properly query with xpath
  6. Grep and Sed Equivalent for XML Command Line Processing
  7. POST XML file using cURL command line
  8. Xml Namespace breaking my xpath!
  9. XPath to select multiple tags
  10. XPath to select Element by attribute value
  11. How can I use XPath to find the minimum value of an attribute in a set of elements?
  12. XSLT: How to convert XML Node to String
  13. XPath with multiple conditions
  14. How to ignore namespace when selecting XML nodes with XPath
  15. How to find the max attribute from an XML document using Xpath 1.0
  16. Finding the difference between two dateTimes in XSLT
  17. Get nodes where child node contains an attribute
  18. If double slash (//) is used 2 times in XPath, what does it mean?
  19. XSLT Replace function not found
  20. How do you identify duplicate values in a numerical sequence using XPath 2.0?
  21. What is the difference between ‘or’ and ‘|’ when programming in xslt?
  22. Using XPath, How do I select a node based on its text content and value of an attribute?
  23. XPath to get all child nodes (elements, comments, and text) without parent
  24. How to apply the XPath function ‘substring-after’
  25. XPath to return only elements containing the text, and not its parents
  26. distinct in Xpath?
  27. How can I select an element with multiple classes with Xpath?
  28. WiX Installer: using xslt with heat.exe to update attributes
  29. xpath expression from xml with namespace prefix
  30. Is it possible to apply normalize-space to all nodes XPath expression finds?

Leave a Comment