Changes

The {{Function|Database|db:add}} and {{Function|Database|db:put}} functions can also be used to add new XML documents to the database. The following example query uses the internal XML parser and adds all files to the database <code>DB</code> that are found in the directory <code>2Bimported</code>:

for $file in file:list("2Bimported")

return db:add('DB', $file, '', map { 'intparse': true() })

=HTML Parser=

3. On the first tab, you can see an XML snippet like this:

<dependency>

<groupId>org.ccil.cowan.tagsoup</groupId>

<version>1.2.1</version>

</dependency>

4. Insert the XML fragment into the <code><dependencies></code> element of your project’s <code>pom.xml</code> file.

* '''reuse''', '''help''': not supported.

Go to Menu ''Database'' → ''New'' and select "HTML" in the input format combo box. There's an info in the "Parsing" tab about whether TagSoup is available or not. The same applies to the "Resources" tab in the "Database Properties" dialog.

These two dialogs come with an input field 'Parameters' where TagSoup options can be entered. Keys and values are separated by the equal sign, multiple options are separated by commas, e.g.: <code>method=xml,nons=true</code>.

Turn on the HTML Parser before parsing documents, set a file filter and optional parsing options:

SET {{Option|HTMLPARSER}} method=xml,nons=true

The [[HTML Module]] provides XQuery functions for converting HTML to XML. In addition, all functions that accept [[Options#Parsing|Parsing Options]] can be used as well to convert HTML:

fetch:doc("index.html", map {

'parser': 'html',

'htmlparser': map { 'method': 'xml', 'nons': true() }

})

=JSON Parser=

In addition, all functions that accept [[Options#Parsing|Parsing Options]] can be used as well to convert JSON. The following query converts a JSON string to an XML document, using the conversion format {{Code|[[JSON Module#Basic|basic]]}}:

db:create('json-db', '{ "key": "value" }', 'example.json', map {

'parser': 'json',

'jsonparser': map { 'format': 'basic' }

})

=CSV Parser=

In addition, all functions that accept [[Options#Parsing|Parsing Options]] can be used as well to convert CSV. In the following, all CSV files from a directory are added to a database, with the first line of each file interpreted as column header:

for $file in file:list("2Bimported", false(), "*.csv")

return db:add("csv-db", $file, "", map {

'csvparser': map { 'header': true() }

})

=Changelog=