XML formating - White-Owl/nisql GitHub Wiki

Dump the resultset into a XML file.

Recognized formating options are:

• STREAM - boolean option which defines should we write the whole file as one string, or should we format the XML to be read by humans? By default - no.

• TAGS - boolean. Should each column be an element inside the record element or no? By default no and each record would be written as <row col1="value" col2="value2"/>

• ROOT - name of the root element for the entire XML. By default: "root"

• SETS - comma separated list of elements directly under the root. If SETS has fewer names then actual number of resultsets, when for each unexpected resultset the name would be constructed in the format "section-#".
  If the SETS key is omitted, then NISQL would expect just one resultset and all rows from it would be nested directly under root. The extra resulstes would become <section-#> elements under the root.

• ROWS - comma separated list of names for records. Each name on the list correspond to the name of set in SETS. If omitted (or ROWS has fewer names than SETS), then rows for undefined set would have name "row".

Example, assuming we have a table student with columns sname varchar(30) and age numeric(2):
nisql "DSN=MyDB" "select sname as Name, age as Age from student" out.xml
Can produce an out.xml with a contents:

<root>
    <row Name="Maria White" Age="21"/>
    <row Name="Charles Harris" Age="22"/>
    <row Name="Susan Martin" Age="20"/>
    <row Name="Joseph Thompson" Age="19"/>
    <row Name="Christopher Garcia" Age="20"/>
</root>

By defining ROOT and ROWS keys
nisql "DSN=MyDB" "select sname as Name, age as Age from student" out.xml -f"root=students;rows=student"
We can get:

<students>
    <student Name="Maria White" Age="21"/>
    <student Name="Charles Harris" Age="22"/>
    <student Name="Susan Martin" Age="20"/>
    <student Name="Joseph Thompson" Age="19"/>
    <student Name="Christopher Garcia" Age="20"/>
</students>

And if we add TAGS key:
nisql "DSN=MyDB" "select sname as Name, age as Age from student" out.xml -f"root=students;rows=student;tags=on"
We can get:

<students>
    <student>
        <Name>
            Maria White
        </Name>
        <Age>
            21
        </Age>
    </student>
    <student>
        <Name>
            Charles Harris
        </Name>
        <Age>
            22
        </Age>
    </student>
    <student>
        <Name>
            Susan Martin
        </Name>
        <Age>
            20
        </Age>
    </student>
    <student>
        <Name>
            Joseph Thompson
        </Name>
        <Age>
            19
        </Age>
    </student>
    <student>
        <Name>
            Christopher Garcia
        </Name>
        <Age>
            20
        </Age>
    </student>
</students>