Difference between revisions of "Database Module"

From BaseX Documentation
Jump to navigation Jump to search
 
(217 intermediate revisions by 7 users not shown)
Line 3: Line 3:
 
=Conventions=
 
=Conventions=
  
All functions in this module are assigned to the {{Code|http://basex.org/modules/db}} namespace, which is statically bound to the {{Code|db}} prefix.<br/>
+
All functions and errors in this module are assigned to the <code><nowiki>http://basex.org/modules/db</nowiki></code> namespace, which is statically bound to the {{Code|db}} prefix.<br/>
All errors are assigned to the {{Code|http://basex.org/errors}} namespace, which is statically bound to the {{Code|bxerr}} prefix.
 
  
 
==Database Nodes==
 
==Database Nodes==
  
Database nodes are XML nodes which are either stored in a persistent database or part of a so-called ''database fragment''. All XML fragments can be converted to database fragments by e. g. applying the [[XQuery_Update#transform|transform]] expression on an XML fragment:
+
In BaseX, two internal representations exist for XML nodes:
  
<pre class="brush:xquery">
+
1. Database nodes are:
copy $c := element hello { 'world' } modify () return $c
+
* stored in a persistent database on disk;
 +
* nodes of a document that has been generated temporarily with {{Code|fn:doc}}, {{Code|fn:parse-xml}} and other functions; or
 +
* the result of a [[XQuery Update#Main-Memory Updates|main-memory update]].
 +
2. Fragments are similar to DOM structures. They are created when XQuery node constructors are used (<code><a/></code>, <code>element a { }</code>, etc.).
 +
 
 +
Fragments require less memory for small XML structures, but database nodes are more efficient for larger amounts of data. Fragments nodes can be converted to database nodes by applying a [[XQuery_Update#Main-Memory Updates|main-memory update]] with an empty body to a node:
 +
 
 +
<pre lang='xquery'>
 +
<xml>hello world</xml> update { }
 
</pre>
 
</pre>
 +
 +
==Updating Functions==
 +
 +
Various functions in this module are ''updating''. Updating functions will not be immediately executed, but queued on the [[XQuery Update#Pending Update List|Pending Update List]], and processed after the remaining query has been evaluated. This means that the order in which the functions are specified in the query often does not reflect the order in which they will eventually be executed.
  
 
=General Functions=
 
=General Functions=
  
 
==db:system==
 
==db:system==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:system||element(system)}}
+
|<pre>db:system() as element(system)</pre>
|-
+
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns information on the database system, such as the database path and current database settings. The output is similar to the [[Commands#INFO|INFO]] command.
+
|Returns general information on the database system the current values of all global and local [[Options]]. The {{Command|INFO}} command returns similar output.
 +
|}
 +
 
 +
==db:option==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:option(
 +
  $name  as xs:string
 +
) as xs:string</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Returns the current value (string, integer, boolean, map) of a global or local [[Options|Option]] with the specified {{Code|$name}}. The {{Command|SHOW OPTIONS}} command returns similar output.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|option|#Errors}} the specified option is unknown.
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* <code>db:option('dbpath')</code> returns the database path string.
 +
* <code>db:option('serializer')</code> returns a map with the current serialization parameters.
 +
* <code>declare option db:stripws 'true'; db:option('stripws')</code> returns the locally assigned value.
 
|}
 
|}
  
 
==db:info==
 
==db:info==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:info|$db as xs:string|element(database)}}
+
|<pre>db:info(
|-
+
  $database  as xs:string
 +
) as element(database)</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns meta information on the database {{Code|$db}}. The output is similar to the [[Commands#INFO DB|INFO DB]] command.
+
|Returns meta information on the specified {{Code|$database}}. The output is similar to the {{Command|INFO DB}} command.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
 
|}
 
|}
  
==db:list==
+
==db:property==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:list||xs:string*}}<br/>{{Func|db:list|$db as xs:string|xs:string*}}<br/>{{Func|db:list|$db as xs:string, $path as xs:string|xs:string*}}
+
|<pre>db:property(
|-
+
  $database  as xs:string,
 +
  $name      as xs:string
 +
) as xs:anyAtomicType</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns a string sequence with the names of all databases:
+
|Returns the value (string, boolean, integer) of a property with the specified {{Code|$name}} in the specified {{Code|$database}}. The available properties are the ones returned by {{Function||db:info}}.
* If a database {{Code|$db}} is specified, all documents and raw files of the specified database are returned.
+
|- valign="top"
* The list of resources can be further restricted by the {{Code|$path}} argument.
 
|-
 
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|property|#Errors}} the specified property is unknown.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:list("docs")}} returns the names of all documents from the database named {{Code|docs}}.
+
* <code>db:property('db', 'size')</code> returns the number of bytes occupied by the database <code>db</code>.
 +
* <code>db:property('xmark', 'textindex')</code> indicates if the <code>xmark</code> database has a text index.
 +
* <code>db:property('discogs', 'uptodate')</code> indicates if the database statistics and index structures of the <code>discogs</code> database are up-to-date.
 
|}
 
|}
  
==db:list-details==
+
==db:list==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:list-details||element(database)*}}<br/>{{Func|db:list-details|$db as xs:string|element(resource)*}}<br/>{{Func|db:list-details|$db as xs:string, $path as xs:string|element(resource)*}}
+
|<pre>db:list(
|-
+
  $database  as xs:string := (),
 +
  $path      as xs:string := ()
 +
) as xs:string*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns an element sequence with the names of all databases together with their database path, the number of stored resources and the date of modification:
+
|Without arguments, the names of all databases are returned that are accessible to the current user. If {{Code|$database}} is specified, paths to all resources of this database are returned. The results can be restricted to resources starting with the specified {{Code|$path}}.
* If a database {{Code|$db}} is specified, all documents and raw files of the specified database together with their content-type, the modification date and the resource type are returned.
+
|- valign="top"
* The list of resources can be further restricted by the {{Code|$path}} argument.
 
|-
 
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:list-details("docs")}} returns the names plus additional data of all documents from the database named {{Code|docs}}.
+
* {{Code|db:list("docs")}} returns the names of all documents of a database named {{Code|docs}}.
 
|}
 
|}
  
==db:backups==
+
==db:list-details==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:backups||element(backup)*}}<br/>{{Func|db:backups|$db as xs:string|element(backup)*}}
+
|<pre>db:list-details(
|-
+
  $database  as xs:string  := (),
 +
  $path      as xs:string := ()
 +
) as element()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns an element sequence containing all available database backups.<br/>If a database {{Code|$db}} is specified, the sequence will be restricted to the backups matching this database.
+
|Without arguments, an element is returned for each database that is accessible to the current user:
|-
+
* An element has a value, which is the name of the database, and several attributes, which contain the number of stored resources, the modification date, the database size on disk (measured in bytes), and a path to the original database input.
 +
If {{Code|$database}} is specified, an element for each resource in this database is returned:
 +
* An element has a value, which is the name of the resource, and several attributes, which contain the content type, the modification date, the raw flag (which indicates if the resource is binary or XML), and the size of a resource.
 +
* The value of the size attribute depends on the resource type: for documents, it represents the number of nodes; for binary data, it represents the file size (measured in bytes).
 +
* The results can be restricted to resources starting with the specified {{Code|$path}}.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
 +
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:backups("factbook")}} returns all backups that have been made from the {{Code|factbook}} database.
+
* {{Code|db:list-details("shop")}} returns the names plus additional info on all resources of a database named {{Code|shop}}.
 
|}
 
|}
  
==db:event==
+
==db:dir==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:event|$name as xs:string, $query as item()|empty-sequence()}}
+
|<pre>db:dir(
|-
+
  $database  as xs:string,
 +
  $path      as xs:string
 +
) as element()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Executes a {{Code|$query}} and sends the resulting value to all clients watching the [[Events|Event]] with the specified {{Code|$name}}. The query may also perform updates; no event will be sent to the client that fired the event.
+
|Returns metadata on all directories and resources of a {{Code|$database}} in the specified {{Code|$path}}. Two types of elements are returned:
|-
+
* {{Code|resource}} represents a resource. The element value is the directory path; content type, modification date, raw flag (which indicates if the resource is binary or XML), and size of the resource are returned as attributes.
 +
* {{Code|dir}} represents a directory. The element value is the directory path; the modification date is returned in an attribute.
 +
The directories are not stored in the internal database layout. Instead, they result implicitly from the paths of stored resources.
 +
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0010|XQuery Errors#BaseX Errors}} the specified event is unknown.<br/>{{Error|SEPM0016|XQuery_Errors#Serialization_Errors}} serialization errors occurred while sending the value.<br/>
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified path is invalid.
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* {{Code|db:dir('shop', 'books')}} returns all entries of the {{Code|books}} directory of a {{Code|shop}} database.
 
|}
 
|}
  
 
=Read Operations=
 
=Read Operations=
  
==db:open==
+
==db:get==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:open|$db as xs:string|document-node()*}}<br />{{Func|db:open|$db as xs:string, $path as xs:string|document-node()*}}
+
|<pre>db:get(
|-
+
  $database  as xs:string,
 +
  $path     as xs:string := ()
 +
) as document-node()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns a sequence with all document nodes contained in the database {{Code|$db}}.<br/>The document nodes to be returned can be restricted by the {{Code|$path}} argument.
+
|Returns all documents from the specified {{Code|$database}}, or only documents matching the specified {{Code|$path}}.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:open("docs")}} returns all documents from the database named {{Code|docs}}.
+
* {{Code|db:get('docs')}} returns all documents from the database named {{Code|docs}}.
* {{Code|db:open("docs", "one")}} returns all documents from the database named {{Code|docs}} in the subpath {{Code|one}}.
+
* {{Code|db:get('db', 'one')}} returns all documents from the database named {{Code|db}} located in the path {{Code|one}}.
 +
* <code>for $i in 1 to 3 return db:get('db' || $i)//item</code> returns all item elements from the databases {{Code|db1}}, {{Code|db2}} and {{Code|db3}}.
 
|}
 
|}
  
==db:open-pre==
+
==db:get-pre==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:open-pre|$db as xs:string, $pre as xs:integer|node()}}
+
|<pre>db:get-pre(
|-
+
  $database  as xs:string,
 +
  $values    as xs:integer*
 +
) as node()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Opens the database {{Code|$db}} and returns the node with the specified {{Code|$pre}} value.<br/>The [[Node Storage#PRE Value|PRE value]] provides very fast access to an existing database node, but it will change whenever a node with a smaller ''pre'' values is added to or deleted from a database.
+
|Returns all nodes from a {{Code|$database}} with the specified PRE {{Code|values}} in [[Utility Module#util:ddo|distinct document order]].<br/>The [[Node Storage#PRE Value|PRE value]] provides very fast access to an existing database node, but it will change whenever a node with a smaller ''pre'' values is added to or deleted from a database.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0009|XQuery Errors#BaseX Errors}} the specified pre value does not exist in the database.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|range|#Errors}} the specified PRE value does not exist in the database.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:open-pre("docs", 0)}} returns the first database node from the database named {{Code|docs}}.
+
* {{Code|db:get-pre("docs", 0)}} returns the first database node from the database named {{Code|docs}}.
 
|}
 
|}
  
==db:open-id==
+
==db:get-id==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:open-id|$db as xs:string, $id as xs:integer|node()}}
+
|<pre>db:get-id(
|-
+
  $database  as xs:string,
 +
  $values    as xs:integer*
 +
) as node()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Opens the database {{Code|$db}} and returns the node with the specified {{Code|$id}} value.<br />Each database node has a ''persistent'' [[Node Storage#ID Value|ID value]]. Access to the node id can be sped up by turning on the [[Options#UPDINDEX|UPDINDEX]] option.
+
|Returns all nodes from a {{Code|$database}} with the specified ID {{Code|$values}} in [[Utility Module#util:ddo|distinct document order]].<br/>Each database node has a ''persistent'' [[Node Storage#ID Value|ID value]]. Access to the node ID can be sped up by turning on the {{Option|UPDINDEX}} option.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0009|XQuery Errors#BaseX Errors}} the specified id value does not exist in the database.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|range|#Errors}} the specified ID value does not exist in the database.
 
|}
 
|}
  
==db:node-pre==
+
==db:get-binary==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:node-pre|$nodes as node()*|xs:integer*}}
+
|<pre>db:get-binary(
|-
+
  $database  as xs:string,
 +
  $path      as xs:string
 +
) as item()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns the ''pre'' values of the nodes supplied by {{Code|$nodes}}, which must all be [[#Database Nodes|database nodes]].<br/>The [[Node Storage#PRE Value|PRE value]] provides very fast access to an existing database node, but it will change whenever a node with a smaller ''pre'' values is added to or deleted from a database.
+
|Returns a map with the paths and binary items of all resources in the specified {{Code|$database}}. A single {{Code|xs:base64Binary}} item is returned if a {{Code|$path}} is specified. All items are [[Lazy Module|lazy]], i.e., the actual data will only be retrieved if it is processed.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0001|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|mainmem|#Errors}} the database is not ''persistent'' (stored on disk).
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:node-pre(doc("input"))}} returns {{Code|0}} if the database {{Code|input}} contains a single document.
+
* {{Code|db:get-binary('DB', 'music/01.mp3')}} returns the specified audio file as raw data.
 +
* <code><nowiki>stream:materialize(db:get-binary('DB', 'music/01.mp3'))</nowiki></code> materializes the streamable result in main-memory before returning it.
 +
* <code><nowiki>convert:binary-to-string(db:get-binary('DB', 'info.txt'), 'UTF-8')</nowiki></code> converts a binary database resource as UTF-8 text and returns a string.
 
|}
 
|}
  
==db:node-id==
+
==db:get-value==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:node-id|$nodes as node()*|xs:integer*}}
+
|<pre>db:get-value(
|-
+
  $database  as xs:string,
 +
  $path      as xs:string
 +
) as item()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns the ''id'' values of the nodes supplied by {{Code|$nodes}}, which must all be [[#Database Nodes|database nodes]].<br/>Each database node has a ''persistent'' [[Node Storage#ID Value|ID value]]. Access to the node id can be sped up by turning on the [[Options#UPDINDEX|UPDINDEX]] option.
+
|Returns a map with the paths and values of all resources in the specified {{Code|$database}}. A single value is returned if a {{Code|$path}} is specified.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0001|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|mainmem|#Errors}} the database is not ''persistent'' (stored on disk).
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* {{Code|db:get-value('DB', 'sequence')}} returns the specified sequence.
 
|}
 
|}
  
==db:retrieve==
+
==db:node-pre==
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:retrieve|$db as xs:string, $path as xs:string|xs:base64Binary}}
+
|<pre>db:node-pre(
|-
+
  $nodes  as node()*
 +
) as xs:integer*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns a [[Binary Data|binary resource]] addressed by the database {{Code|$db}} and {{Code|$path}} as [[Streaming Module|streamable]] {{Code|xs:base64Binary}}.
+
|Returns the PRE values of the specified {{Code|$nodes}}, which must all be [[#Database Nodes|database nodes]].<br/>The [[Node Storage#PRE Value|PRE value]] provides very fast access to an existing database node, but it will change whenever a node with a smaller ''pre'' values is added to or deleted from a database.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0003|#Errors}} the database is not ''persistent'' (stored on disk).<br/>{{Error|FODC0002|XQuery Errors#Functions Errors}} the addressed resource cannot be retrieved.<br/>{{Error|FODC0007|XQuery Errors#Functions Errors}} the specified path is invalid.
+
|{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|declare option output:method 'raw';<br/>db:retrieve("DB", "music/01.mp3")}} returns the specified audio file as raw data.
+
* {{Code|db:node-pre(doc("input"))}} returns {{Code|0}} if the database {{Code|input}} contains a single document.
* <code><nowiki>stream:materialize(db:retrieve("DB", "music/01.mp3"))</nowiki></code> returns a materialized representation of the streamable result.
+
|}
 +
 
 +
==db:node-id==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:node-id(
 +
  $nodes  as node()*
 +
) as xs:integer*</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Returns the ID values of the specified {{Code|$nodes}}, which must all be [[#Database Nodes|database nodes]].<br/>Each database node has a ''persistent'' [[Node Storage#ID Value|ID value]]. Access to the node id can be sped up by turning on the {{Option|UPDINDEX}} option.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
 
|}
 
|}
  
Line 206: Line 316:
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:export|$db as xs:string, $path as xs:string|empty-sequence()}}<br />{{Func|db:export|$db as xs:string, $path as xs:string, $params as item()|empty-sequence()}}<br />
+
|<pre>db:export(
|-
+
  $database  as xs:string,
 +
  $path     as xs:string,
 +
  $options  as map(*)?    := map { }
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Exports the specified database {{Code|$db}} to the specified file {{Code|$path}}. Existing files will be overwritten. The {{Code|$params}} argument contains serialization parameters (see [[Serialization]] for more details), which can either be specified<br />
+
|Exports the specified {{Code|$database}} to the specified file {{Code|$path}}. Existing files will be overwritten.<br/>The {{Code|$options}} argument contains [[Serialization|serialization parameters]] (see [https://www.w3.org/TR/xpath-functions-31/#func-serialize fn:serialize]).
* as children of an {{Code|&lt;output:serialization-parameters/&gt;}} element, as defined for the [http://www.w3.org/TR/xpath-functions-30/#func-serialize fn:serialize()] function; e.g.:
+
|- valign="top"
<pre class="brush:xml">
+
| '''Errors'''
<output:serialization-parameters>
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
  <output:method value='xml'/>
+
|- valign="top"
  <output:cdata-section-elements value="div"/>
+
| '''Examples'''
  ...
+
| Export all files as text:<br/>
</output:serialization-parameters>
+
<pre lang='xquery'>
 +
db:export("DB", "/home/john/xml/texts", map { 'method': 'text' })
 
</pre>
 
</pre>
* as map, which contains all key/value pairs:
+
The following code can be used to export parts of the database:
<pre class="brush:xml">
+
<pre lang='xquery'>
map { "method" := "xml", "cdata-section-elements" := "div", ... }
+
let $target := '/home/john/xml/target'
 +
for $doc in db:get('DB', 'collection')
 +
let $path := $target || db:path($doc)
 +
return (
 +
  file:create-dir(file:parent($path)),
 +
  file:write($path, $doc)
 +
)
 
</pre>
 
</pre>
|-
 
| '''Errors'''
 
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
 
 
|}
 
|}
  
=Contents=
+
=Value Indexes=
  
 
==db:text==
 
==db:text==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:text|$db as xs:string, $string as item()|text()*}}
+
|<pre>db:text(
|-
+
  $database  as xs:string,
 +
  $values    as xs:string*
 +
) as text()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns all text nodes of the database {{Code|$db}} that have {{Code|$string}} as their string value. If available, the value index is used to speed up evaluation.
+
|Returns all text nodes of a {{Code|$database}} that match one of the specified {{Code|$values}} and that are stored in the text index.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/>
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
Line 249: Line 371:
  
 
==db:text-range==
 
==db:text-range==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:text-range|$db as xs:string, $min as xs:string, $max as xs:string|text()*}}
+
|<pre>db:text-range(
|-
+
  $database  as xs:string,
 +
  $min       as xs:string,
 +
  $max       as xs:string
 +
) as text()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns all text nodes of the database {{Code|$db}} that are located in between the {{Code|$min}} and {{Code|$max}} strings. If available, the value index is used to speed up evaluation.
+
|Returns all text nodes of a {{Code|$database}} whose values are larger than or equal to {{Code|$min}} and smaller than or equal to {{Code|$max}} and that are stored in the text index.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/>
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
Line 266: Line 393:
  
 
==db:attribute==
 
==db:attribute==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:attribute|$db as xs:string, $string as item()|attribute()*}}<br/>{{Func|db:attribute|$db as xs:string, $string as item(), $attname as xs:string|attribute()*}}
+
|<pre>db:attribute(
|-
+
  $database  as xs:string,
 +
  $values    as xs:string*,
 +
  $name      as xs:string   := ()
 +
) as attribute()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns all attribute nodes of the database {{Code|$db}} that have {{Code|$string}} as string value. If available, the value index is used to speed up evaluation.<br />If {{Code|$attname}} is specified, the resulting attribute nodes are filtered by their attribute name.
+
|Returns all attribute nodes of a {{Code|$database}} that match one of the specified {{Code|$values}} and that are stored in the attribute index.<br/>If {{Code|$name}} is specified, the resulting attribute nodes are filtered by their attribute name.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/>
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
Line 283: Line 415:
  
 
==db:attribute-range==
 
==db:attribute-range==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:attribute-range|$db as xs:string, $min as xs:string, $max as xs:string|attribute()*}}<br/>{{Func|db:attribute-range|$db as xs:string, $min as xs:string, $max as xs:string, $attname as xs:string|attribute()*}}
+
|<pre>db:attribute-range(
|-
+
  $database  as xs:string,
 +
  $min       as xs:string,
 +
  $max       as xs:string,
 +
  $name      as xs:string := ()
 +
) as attribute()*</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Returns all attributes of the database {{Code|$db}}, the string values of which are larger than or equal to {{Code|$min}} and smaller than or equal to {{Code|$max}}. If available, the value index is used to speed up evaluation.
+
|Returns all attributes of a {{Code|$database}} whose values are larger than or equal to {{Code|$min}} and smaller than or equal to {{Code|$max}} and that are stored in the attribute index.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/>
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
 
* {{Code|db:attribute-range("DB", "id456", "id473", 'id')}} returns all {{Code|@id}} attributes of the database {{Code|DB}} that have a string value in between {{Code|id456}} and {{Code|id473}}.
 
* {{Code|db:attribute-range("DB", "id456", "id473", 'id')}} returns all {{Code|@id}} attributes of the database {{Code|DB}} that have a string value in between {{Code|id456}} and {{Code|id473}}.
 +
|}
 +
 +
==db:token==
 +
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:token(
 +
  $database  as xs:string,
 +
  $tokens    as xs:string*,
 +
  $name      as xs:string  := ()
 +
) as attribute()*</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Returns all attribute nodes of a {{Code|$database}} the values of which contain one of the specified {{Code|$tokens}}.<br/>If {{Code|$name}} is specified, the resulting attribute nodes are filtered by their attribute name.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/>
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* {{Code|db:token("DB", "row", "class")/parent::div}} returns all {{Code|div}} nodes of database {{Code|DB}} with a {{Code|class}} attribute that contains the token {{Code|row}}.
 
|}
 
|}
  
 
=Updates=
 
=Updates=
  
'''Important note:''' All functions in this section are ''updating functions'': they will not be immediately executed, but queued on the [[XQuery Update#Pending Update List|Pending Update List]], which will be processed after the actual query has been evaluated. This means that the order in which the functions are specified in the query does usually not reflect the order in which the code will be evaluated.
+
All functions in this section are [[#Updating Functions|Updating Functions]].
  
 
==db:create==
 
==db:create==
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:create|$db as xs:string|empty-sequence()}}<br/>{{Func|db:create|$db as xs:string, $inputs as item()*|empty-sequence()}}<br/>{{Func|db:create|$db as xs:string, $inputs as item()*, $paths as xs:string*|empty-sequence()}}<br/>{{Func|db:create|$db as xs:string, $inputs as item()*, $paths as xs:string*, $options as item()|empty-sequence()}}
+
|<pre>db:create(
|-
+
  $database  as xs:string,
 +
  $inputs   as item()*     := (),
 +
  $paths     as xs:string* := (),
 +
  $options  as map(*)?    := map { }
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Creates a new database with name {{Code|$db}} and adds initial documents specified via {{Code|$inputs}} to the specified {{Code|$paths}}. An existing database will be overwritten.<br/>{{Code|$inputs}} may be strings or nodes different than attributes. If the {{Code|$input}} source is not a file or a folder, the {{Code|$paths}} argument is mandatory.<br/>Please note that {{Code|db:create}} will be placed last on the [[XQuery Update#Pending Update List|Pending Update List]]. As a consequence, a newly created database cannot be addressed in the same query.<br/>
+
|Creates a new {{Code|$database}} and adds the supplied {{Code|$inputs}} to the specified {{Code|$paths}}:
The {{Code|$options}} argument can be used to change the indexing behavior. Allowed options are all [[Options#Indexing|Indexing Options]] and [[Options#Full-Text|Full-Text Options]] in lower case. Options can be specified either...<br />
+
* The inputs may be strings or nodes:
* as children of an {{Code|<options/>}} element, e.g.
+
** nodes may be of any type except for attributes
<pre class="brush:xml">
+
** strings can be a URI pointing to a file/directory or an XML string (which is detected by the leading <code>&lt;</code> character)
<options>
+
** a path must be specified if the input is not a file or directory reference
  <textindex value='true'/>
+
* The parsing and indexing behavior can be controlled via {{Code|$options}}:
  <maxcats value='128'/>
+
** allowed options are {{Option|ADDCACHE}} and the [[Options#Indexing|indexing]], [[Options#Full-Text Indexing|full-text indexing]], [[Options#Parsing|parsing]] and [[Options#XML Parsing|XML parsing]] options, all in lower case
</options>
+
** parsing options will only impact string input (URIs, XML strings) because nodes have already been parsed.
</pre>
+
* An existing database will be overwritten.
* or as map, which contains all key/value pairs:
+
* Database creation takes place after most other update operations (see [[XQuery Update#Pending Update List|Pending Update List]]). As a consequence, a newly created database cannot be addressed in the same query.
<pre class="brush:xquery">
+
|- valign="top"
map { "textindex" := true(), "maxcats" = 128 }
 
</pre>
 
|-
 
 
| '''Errors'''
 
| '''Errors'''
|{{Error|FODC0002|XQuery Errors#Functions Errors}} {{Code|$inputs}} points to an unknown resource.<br/>{{Error|FOUP0001|XQuery Errors#Update Errors}} {{Code|$inputs}} is neither string nor a document node.<br/>{{Error|BXDB0007|#Errors}} {{Code|$db}} is opened by another process.<br/>{{Error|BXDB0011|#Errors}} {{Code|$db}} is not a [[Commands#Valid_Names|valid database name]].<br/>{{Error|BXDB0012|#Errors}} two {{Code|db:create}} statements with the same database name were specified.<br/>{{Error|BXDB0013|#Errors}} the number of specified inputs and paths differs.
+
|{{Error|lock|#Errors}} a database is opened by another process.<br/>{{Error|name|#Errors}} the specified name is not a [[Commands#Valid_Names|valid database name]].<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.<br/>{{Error|args|#Errors}} the number of specified inputs and paths differs.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
Line 334: Line 496:
 
* {{Code|db:create("DB", <a/>, "doc.xml")}} creates the database {{Code|DB}} and adds the document with content {{Code|&lt;a/&gt;}} under the name {{Code|doc.xml}}.
 
* {{Code|db:create("DB", <a/>, "doc.xml")}} creates the database {{Code|DB}} and adds the document with content {{Code|&lt;a/&gt;}} under the name {{Code|doc.xml}}.
 
* {{Code|db:create("DB", "/home/dir/", "docs/dir")}} creates the database {{Code|DB}} and adds the documents in {{Code|/home/dir}} to the database under the path {{Code|docs/dir}}.
 
* {{Code|db:create("DB", "/home/dir/", "docs/dir")}} creates the database {{Code|DB}} and adds the documents in {{Code|/home/dir}} to the database under the path {{Code|docs/dir}}.
* <code>db:create("DB", file:list('.'), map { 'ftindex' := true() })</code> adds all files of the current working directory to a new database and creates a full-text index.
+
* <code>db:create("DB", file:list('.'), (), map { 'ftindex': true() })</code> adds all files of the current working directory to a new database, preserving relative filesystem paths and creating a full-text index.
 
|}
 
|}
  
==db:drop==
+
==db:add==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:drop|$db as xs:string|empty-sequence()}}
+
|<pre>db:add(
|-
+
  $database  as xs:string,
 +
  $input    as item(),
 +
  $path      as xs:string?  := (),
 +
  $options  as map(*)?    := map { }
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Drops the database {{Code|$db}} and all connected resources.
+
|Adds the specified {{Code|$input}} to a {{Code|$database}} with the specified {{Code|$path}}:
|-
+
* A document with the same path may occur more than once in a database. If you want to enforce single instances, use {{Function||db:put}} instead.
 +
* See {{Function||db:create}} for more details on the input and path arguments.
 +
* The parsing behavior can be controlled via {{Code|$options}}:
 +
** allowed options are {{Option|ADDCACHE}} and the [[Options#Parsing|parsing]] and [[Options#XML Parsing|XML parsing]] options, all in lower case
 +
** parsing options will only impact string input (URIs, XML strings) because nodes have already been parsed
 +
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0007|#Errors}} {{Code|$db}} is opened by another process.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:drop("DB")}} drops the database {{Code|DB}}.
+
* <code>db:add("DB", "/home/dir/doc.xml")</code> adds the file {{Code|/home/dir/doc.xml}} to the database {{Code|DB}}.
 +
* <code>db:add("DB", <a/>, "doc.xml")</code> adds a document node to the database {{Code|DB}} under the name {{Code|doc.xml}}.
 +
* <code>db:add("DB", "/home/dir", "docs/dir", map { 'addcache': true() })</code> adds all documents in {{Code|/home/dir}} to the database {{Code|DB}} under the path {{Code|docs/dir}}. To reduce memory consumption, the files will be cached before being added to the database.
 
|}
 
|}
  
==db:add==
+
==db:put==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:add|$db as xs:string, $input as item()|empty-sequence()}}<br/>{{Func|db:add|$db as xs:string, $input as item(), $path as xs:string|empty-sequence()}}
+
|<pre>db:put(
|-
+
  $database  as xs:string,
 +
  $input     as item(),
 +
  $path      as xs:string,
 +
  $options  as map(*)?    := map { }
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Adds documents specified by {{Code|$input}} to the database {{Code|$db}} and the specified {{Code|$path}}. A document with the same path may occur than once in a database. If this is unwanted, [[#db:replace|db:replace]] can be used.<br/>{{Code|$input}} may be a string or a node different than attribute. If the {{Code|$input}} source is not a file or a folder, {{Code|$path}} must be specified.
+
|Replaces a resource, specified by {{Code|$path}}, in a {{Code|$database}} with the contents of {{Code|$input}}, or adds it as a new resource:
|-
+
* The parsing behavior can be controlled via {{Code|$options}}:
 +
** Allowed options are {{Option|ADDCACHE}} and the [[Options#Parsing|parsing]] and [[Options#XML Parsing|XML parsing]] options, all in lower case.
 +
** Parsing options will only impact string input (URIs, XML strings), because nodes have already been parsed.
 +
* See {{Function||db:create}} for more details on the input argument.
 +
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|FODC0002|XQuery Errors#Functions Errors}} {{Code|$input}} points to an unknown resource.<br/>{{Error|FOUP0001|XQuery Errors#Update Errors}} {{Code|$input}} is neither string nor a document node.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|target|#Errors}} the path points to a directory.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:add("DB", "/home/dir/doc.xml")}} adds the file {{Code|/home/dir/doc.xml}} to the database {{Code|DB}}.
+
* {{Code|db:put("DB", "/home/dir/doc.xml", "docs/dir/doc.xml")}} replaces the content of the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}} with the content of the file {{Code|/home/dir/doc.xml}}.
* {{Code|db:add("DB", <a/>, "doc.xml")}} adds a document node to the database {{Code|DB}} under the name {{Code|doc.xml}}.
+
* {{Code|db:put("DB", "<a/>", "docs/dir/doc.xml")}} replaces the content of the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}} with {{Code|&lt;a/&gt;}}.
* {{Code|db:add("DB", "/home/dir", "docs/dir")}} adds all documents in {{Code|/home/dir}} to the database {{Code|DB}} under the path {{Code|docs/dir}}.
+
* {{Code|db:put("DB", document { <a/> }, "docs/dir/doc.xml")}} replaces the content of the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}} with the specified document node.
 +
The following query can be used to import files from a directory to a database:
 +
<pre lang='xquery'>
 +
let $source := '/home/john/xml/source'
 +
for $file in file:list($source, true())
 +
let $path := $source || $file
 +
where not(file:is-dir($path))
 +
return db:put('db', doc($path), $file)
 +
</pre>
 
|}
 
|}
  
==db:delete==
+
==db:put-binary==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:delete|$db as xs:string, $path as xs:string|empty-sequence()}}
+
|<pre>db:put-binary(
|-
+
  $database  as xs:string,
 +
  $input    as item(),
 +
  $path     as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Deletes document(s), specified by {{Code|$path}}, from the database {{Code|$db}}.
+
|Stores a binary resource specified by {{Code|$input}} in a {{Code|$database}} at the specified {{Code|$path}}. Existing resources are overwritten.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|mainmem|#Errors}} the database is not ''persistent'' (stored on disk).
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:delete("DB", "docs/dir/doc.xml")}} deletes the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}}.
+
* {{Code|db:put-binary('DB', file:read-binary('video.mov'), 'video/sample.mov')}} stores the addressed video file at the specified location.
* {{Code|db:delete("DB", "docs/dir")}} deletes all documents with paths beginning with {{Code|docs/dir}} in the database {{Code|DB}}.
+
* With the following query, you can copy the binary resources of one database into another:
 +
<pre lang='xquery'>
 +
let $db := 'db'
 +
let $src-path := 'src/'
 +
let $trg-path := 'trg/'
 +
for $src in db:list($db, $src-path)
 +
where db:type($db, $src) = 'binary'
 +
let $trg := $trg-path || substring-after($src, $src-path)
 +
return db:put-binary($db, db:get-binary($db, $src), $trg)
 +
</pre>
 
|}
 
|}
  
==db:create-backup==
+
==db:put-value==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:create-backup|$db as xs:string|empty-sequence()}}
+
|<pre>db:put-value(
|-
+
  $database  as xs:string,
 +
  $input    as item()*,
 +
  $path      as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Creates a backup of the database {{Code|$db}}.
+
|Stores an {{Code|$input}} value in a {{Code|$database}} at the specified {{Code|$path}}. Existing resources are overwritten. The value can be an arbitrary sequence of atomic items, nodes, maps, and arrays.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0011|XQuery Errors#BaseX Errors}} Invalid database name.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|mainmem|#Errors}} the database is not ''persistent'' (stored on disk).
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:create-backup("DB")}} creates a backup of the database {{Code|DB}}.
+
* {{Code|db:put-value('DB', 1 to 10000, 'sequence')}} stores a numeric range in the database.
 +
* With the following query, a map with countries and associated cities is stored in a database. The value resource can e.g. be used as index in future queries:
 +
<pre lang='xquery'>
 +
db:put-value(
 +
  'factbook',
 +
  map:merge(
 +
    for $country in db:get('factbook')//country
 +
    return map:entry($country/@name, $country//city/name ! string())
 +
  ),
 +
  'cities'
 +
)</pre>
 
|}
 
|}
  
==db:drop-backup==
+
==db:delete==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:drop-backup|$name as xs:string|empty-sequence()}}
+
|<pre>db:delete(
|-
+
  $database  as xs:string,
 +
  $path      as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Drops all backups of the database with the specified {{Code|$name}}. If the given {{Code|$name}} points to a specific backup file, only this specific backup file is deleted. As {{Code|$name}} can be a prefix of an existing backup file, it is also possible to drop, for instance, only backups created on a specific day.
+
|Deletes resource(s), specified by {{Code|$path}}, from the specified {{Code|$database}}.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} No backup file found.<br/>{{Error|BXDB0011|XQuery Errors#BaseX Errors}} Invalid database name.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified path is invalid.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:drop-backup("DB")}} drops all backups of the database {{Code|DB}}.
+
* {{Code|db:delete("DB", "docs/dir/doc.xml")}} deletes the resource {{Code|docs/dir/doc.xml}} from {{Code|DB}}.
* {{Code|db:drop-backup("DB-2014-03-13")}} drops all backups of the database {{Code|DB}} created on March 13th 2014.
+
* {{Code|db:delete("DB", "docs/dir")}} deletes all resources from {{Code|DB}} in the specified path {{Code|docs/dir}}.
* {{Code|db:drop-backup("DB-2014-03-13-17-36-44")}} drops the specific backup file {{Code|DB-2014-03-13-17-36-44.zip}} of the database {{Code|DB}}.
+
|}
 +
 
 +
==db:copy==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:copy(
 +
  $database  as xs:string,
 +
  $new-name  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Creates a copy of {{Code|$database}}, which will be called {{Code|$new-name}}.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|lock|#Errors}} a database is opened by another process.<br/>{{Error|name|#Errors}} invalid database name.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
 +
|}
 +
 
 +
==db:alter==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:alter(
 +
  $database  as xs:string,
 +
  $new-name  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Renames a {{Code|$database}} to {{Code|$new-name}}.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|lock|#Errors}} a database is opened by another process.<br/>{{Error|name|#Errors}} invalid database name.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
 
|}
 
|}
  
Line 430: Line 689:
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:optimize|$db as xs:string|empty-sequence()}}<br/>{{Func|db:optimize|$db as xs:string, $all as xs:boolean|empty-sequence()}}<br/>{{Func|db:optimize|$db as xs:string, $all as xs:boolean, $options as item()|empty-sequence()}}
+
|<pre>db:optimize(
|-
+
  $database  as xs:string,
 +
  $all       as xs:boolean?  := false(),
 +
  $options   as map(*)?      := map { }
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Optimizes the meta data and indexes of the database {{Code|$db}}.<br/>If {{Code|$all}} is set to {{Code|true()}}, the complete database will be rebuilt.<br/>The usage of the {{Code|$options}} argument is identical to the [[#db:create|db:create]] function, except that the [[Options#UPDINDEX|UPDINDEX]] option is not supported.
+
|Optimizes the metadata and indexes of a {{Code|$database}}.<br/>If {{Code|$all}} is {{Code|true}}, the complete database will be rebuilt.<br/>The {{Code|$options}} argument can be used to control indexing. The syntax is identical to the {{Function||db:create}} function: Allowed options are all [[Options#Indexing|indexing]] and [[Options#Full-Text|full-text]] options. {{Option|UPDINDEX}} is only supported if {{Code|$all}} is {{Code|true}}.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|FOUP0002|XQuery Errors#Update Errors}} an error occurred while optimizing the database.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
 
* {{Code|db:optimize("DB")}} optimizes the database structures of the database {{Code|DB}}.
 
* {{Code|db:optimize("DB")}} optimizes the database structures of the database {{Code|DB}}.
* <code>db:optimize("DB", true(), map { 'ftindex' := true() })</code> optimizes all database structures of the database {{Code|DB}} and creates a full-text index.
+
* <code>db:optimize("DB", true(), map { 'ftindex': true() })</code> optimizes all database structures of the database {{Code|DB}} and creates a full-text index.
 
|}
 
|}
  
 
==db:rename==
 
==db:rename==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:rename|$db as xs:string, $path as xs:string, $newpath as xs:string|empty-sequence()}}
+
|<pre>db:rename(
|-
+
  $database  as xs:string,
 +
  $source    as xs:string,
 +
  $target    as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Renames document(s), specified by {{Code|$path}} to {{Code|$newpath}} in the database {{Code|$db}}.
+
|Moves all resources(s) of a {{Code|$database}}, which are found in the supplied {{Code|$source}} path, to the supplied {{Code|$target}} path. The paths may point to single resources or directories. No updates will take place if a non-existing source path is supplied.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0008|#Errors}} new document names would be empty.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified source or target path, or one of its descendants, is invalid.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:rename("DB", "docs/dir/doc.xml", "docs/dir/newdoc.xml")}} renames the document {{Code|docs/dir/doc.xml}} to {{Code|docs/dir/newdoc.xml}} in the database {{Code|DB}}.
+
* {{Code|db:rename("DB", "docs/dir/doc.xml", "docs/dir/newdoc.xml")}} renames the resource {{Code|docs/dir/doc.xml}} to {{Code|docs/dir/newdoc.xml}} in the database {{Code|DB}}.
* {{Code|db:rename("DB", "docs/dir", "docs/newdir")}} renames all documents with paths beginning with {{Code|docs/dir}} to paths beginning with {{Code|docs/newdir}} in the database {{Code|DB}}.
+
* {{Code|db:rename("DB", "docs/dir", "docs/newdir")}} moves all resources in the database {{Code|DB}} from {{Code|docs/dir}} to {{Code|docs/newdir}}.
 +
|}
 +
 
 +
==db:flush==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:flush(
 +
  $database  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Explicitly flushes the buffers of a {{Code|$database}}. This command is only useful if {{Option|AUTOFLUSH}} has been set to {{Code|false}}.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
 
|}
 
|}
  
==db:replace==
+
==db:drop==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:replace|$db as xs:string, $path as xs:string, $input as item()|empty-sequence()}}
+
|<pre>db:drop(
|-
+
  $database  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Replaces a document, specified by {{Code|$path}}, in the database {{Code|$db}} with the content of {{Code|$input}}, or adds it as a new document.
+
|Drops a {{Code|$database}} and all connected resources.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0014|#Errors}} {{Code|$path}} points to a directory.<br/>{{Error|FODC0002|XQuery Errors#Functions Errors}} {{Code|$input}} is a string representing a path, which cannot be read.<br/>{{Error|FOUP0001|XQuery Errors#Update Errors}} {{Code|$input}} is neither a string nor a document node.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|lock|#Errors}} a database is opened by another process.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:replace("DB", "docs/dir/doc.xml", "/home/dir/doc.xml")}} replaces the content of the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}} with the content of the file {{Code|/home/dir/doc.xml}}.
+
* {{Code|db:drop("DB")}} drops the database {{Code|DB}}.
* {{Code|db:replace("DB", "docs/dir/doc.xml", "<a/>")}} replaces the content of the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}} with {{Code|&lt;a/&gt;}}.
 
* {{Code|db:replace("DB", "docs/dir/doc.xml", document { <a/> })}} replaces the content of the document {{Code|docs/dir/doc.xml}} in the database {{Code|DB}} with the specified document node.
 
 
|}
 
|}
  
==db:store==
+
=Backups=
 +
 
 +
All functions in this section except for {{Function||db:backups}} are {{Function|Database|Updating Functions}}.
 +
 
 +
==db:create-backup==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:store|$db as xs:string, $path as xs:string, $input as item()|empty-sequence()}}
+
|<pre>db:create-backup(
|-
+
  $database  as xs:string,
 +
  $options  as map(*)?    := map { }
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Stores a binary resource specified by {{Code|$input}} in the database {{Code|$db}} and the location specified by {{Code|$path}}.
+
|Creates a backup of a {{Code|$database}}. If no name is supplied, general data will be backed up. The following {{Code|$options}} are available:
|-
+
* With {{Code|comment}}, a comment string can be attached to the backup.
 +
* By setting {{Code|compress}} to false, the backup will be created faster, but it will take more space on disk.
 +
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|BXDB0003|#Errors}} the database is not ''persistent'' (stored on disk).<br/>{{Error|FODC0007|XQuery Errors#Functions Errors}} the specified path is invalid.<br/>{{Error|FOUP0002|XQuery Errors#Update Errors}} the resource cannot be stored at the specified location.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|name|#Errors}} invalid database name.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:store("DB", "video/sample.mov", file:read-binary('video.mov'))}} stores the addressed video file at the specified location.
+
* {{Code|db:create-backup('DB', map { 'compress': false() })}} creates a backup of the database {{Code|DB}} without compressing its entries.
 
|}
 
|}
  
==db:output==
+
==db:drop-backup==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:output|$result as item()*|empty-sequence()}}
+
|<pre>db:drop-backup(
|-
+
  $name  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|This function can be used to both perform updates and return results in a single query. The argument of the function will be evaluated, and the resulting items will be cached and returned after the updates on the ''pending update list'' have been processed. As nodes may be updated, they will be copied before being cached.<br/>The function can only be used together with [[XQuery Update#Updating Expressions|updating expressions]]; if the function is called within a transform expression, its results will be discarded.
+
|Drops all backups of the database with the specified {{Code|$name}}. If the name ends with a timestamp, only the specified backup file will be deleted. If no name is supplied, backups with general data are addressed.
|-
+
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|backup|#Errors}} No backup file found.<br/>{{Error|name|#Errors}} invalid database name.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
 +
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:output("Prices have been deleted."), delete node //price}} deletes all {{Code|price}} elements in a database and returns an info message.
+
* {{Code|db:drop-backup("DB")}} drops all backups of the database {{Code|DB}}.
 +
* {{Code|db:drop-backup("DB-2014-03-13-17-36-44")}} drops the specific backup file {{Code|DB-2014-03-13-17-36-44.zip}} of the database {{Code|DB}}.
 
|}
 
|}
  
==db:flush==
+
==db:alter-backup==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:alter-backup(
 +
  $name      as xs:string,
 +
  $new-name  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Renames all backups of the database with the specified {{Code|$name}} to {{Code|$new-name}}. If the name ends with a date, only the specified backup file will be renamed.
 +
|- valign="top"
 +
| '''Errors'''
 +
|{{Error|backup|#Errors}} No backup file found.<br/>{{Error|name|#Errors}} invalid database name.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* {{Code|db:alter-backup("DB", "DB2)}} renames all backups of the database {{Code|DB}} to {{Code|DB2}}.
 +
|}
 +
 
 +
==db:restore==
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:flush|$db as xs:string|empty-sequence()}}
+
|<pre>db:restore(
|-
+
  $name  as xs:string
 +
) as empty-sequence()</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Explicitly flushes the buffers of the database {{Code|$db}}. This command is only useful if [[Options#AUTOFLUSH|AUTOFLUSH]] has been set to {{Code|false}}.
+
|Restores the database with the specified {{Code|$name}}. The {{Code|$name}} may include the timestamp of the backup file. If no name is supplied, general data will be restored. If general data is restored, it will only be available after BaseX has been restarted.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|lock|#Errors}} a database is opened by another process.<br/>{{Error|name|#Errors}} invalid database name.<br/>{{Error|no-backup|#Errors}} No backup found.<br/>{{Error|conflict|#Errors}} the same database was addressed more than once.
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* {{Code|db:restore("DB")}} restores the database {{Code|DB}}.
 +
* {{Code|db:restore("DB-2014-03-13-18-05-45")}} restores the database {{Code|DB}} from the backup file with the given timestamp.
 +
|}
 +
 
 +
==db:backups==
 +
 
 +
{| width='100%'
 +
|- valign="top"
 +
| width='120' | '''Signature'''
 +
|<pre>db:backups(
 +
  $database  as xs:string  := ()
 +
) as element(backup)*</pre>
 +
|- valign="top"
 +
| '''Summary'''
 +
|Returns an element sequence containing all available database backups with timestamp, file size and comment.<br/>If a {{Code|$database}} is specified, the sequence will be restricted to the backups matching this database.
 +
|- valign="top"
 +
| '''Examples'''
 +
|
 +
* {{Code|db:backups("factbook")}} returns all backups that have been made from the {{Code|factbook}} database.
 
|}
 
|}
  
Line 533: Line 880:
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:name|$node as node()|xs:string}}
+
|<pre>db:name(
|-
+
  $node as node()
 +
) as xs:string</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
 
|Returns the name of the database in which the specified [[#Database Nodes|database node]] {{Code|$node}} is stored.
 
|Returns the name of the database in which the specified [[#Database Nodes|database node]] {{Code|$node}} is stored.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0001|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
+
|{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
 
|}
 
|}
  
Line 547: Line 896:
  
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:path|$node as node()|xs:string}}
+
|<pre>db:path(
|-
+
  $node as node()
 +
) as xs:string</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
 
|Returns the path of the database document in which the specified [[#Database Nodes|database node]] {{Code|$node}} is stored.
 
|Returns the path of the database document in which the specified [[#Database Nodes|database node]] {{Code|$node}} is stored.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0001|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
+
|{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database.
 
|}
 
|}
  
 
==db:exists==
 
==db:exists==
 +
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:exists|$db as xs:string|xs:boolean}}<br/>{{Func|db:exists|$db as xs:string, $path as xs:string|xs:boolean}}
+
|<pre>db:exists(
|-
+
  $database  as xs:string,
 +
  $path     as xs:string := ()
 +
) as xs:boolean</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Checks if the database {{Code|$db}} or the resource specified by {{Code|$path}} exists. {{Code|false}} is returned if a database directory has been addressed.
+
|Checks if a {{Code|$database}} exists, or a resource located at {{Code|$path}} in this database.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
 
* {{Code|db:exists("DB")}} returns {{Code|true}} if the database {{Code|DB}} exists.
 
* {{Code|db:exists("DB")}} returns {{Code|true}} if the database {{Code|DB}} exists.
* {{Code|db:exists("DB", "resource")}} returns {{Code|true}} if {{Code|resource}} is an XML document or a raw file.
+
* {{Code|db:exists("DB", "resource")}} returns {{Code|true}} if {{Code|resource}} exists in this database.
 
|}
 
|}
  
==db:is-raw==
+
==db:type==
 +
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:is-raw|$db as xs:string, $path as xs:string|xs:boolean}}
+
|<pre>db:type(
|-
+
  $database  as xs:string,
 +
  $path     as xs:string
 +
) as xs:string</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Checks if the specified resource in the database {{Code|$db}} and the path {{Code|$path}} exists, and if it is a [[Binary Data|binary resource]].
+
|Returns the type ({{Code|xml}}, {{Code|binary}}, {{Code|value}}) of a resource in a {{Code|$database}} at the specified {{Code|$path}}.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
* {{Code|db:is-raw("DB", "music/01.mp3")}} returns {{Code|true}}.
+
* {{Code|db:type("DB", "factbook.xml")}} returns {{Code|true}} if the specified resource is an XML document.
 
|}
 
|}
  
==db:is-xml==
+
==db:content-type==
{| width='100%'
 
|-
 
| width='120' | '''Signatures'''
 
|{{Func|db:is-xml|$db as xs:string, $path as xs:string|xs:boolean}}
 
|-
 
| '''Errors'''
 
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.
 
|-
 
| '''Summary'''
 
|Checks if the specified resource in the database {{Code|$db}} and the path {{Code|$path}} exists, and if it is an XML document.
 
|-
 
| '''Examples'''
 
|
 
* {{Code|db:is-xml("DB", "dir/doc.xml")}} returns {{Code|true}}.
 
|}
 
  
==db:content-type==
 
 
{| width='100%'
 
{| width='100%'
|-
+
|- valign="top"
| width='120' | '''Signatures'''
+
| width='120' | '''Signature'''
|{{Func|db:content-type|$db as xs:string, $path as xs:string|xs:string}}
+
|<pre>db:content-type(
|-
+
  $database  as xs:string,
 +
  $path     as xs:string
 +
) as xs:string</pre>
 +
|- valign="top"
 
| '''Summary'''
 
| '''Summary'''
|Retrieves the content type of a resource in the database {{Code|$db}} and the path {{Code|$path}}.<br/>The file extension is used to recognize the content-type of a resource stored in the database. Content-type {{Code|application/xml}} will be returned for any XML document stored in the database, regardless of its file name extension.
+
|Retrieves the content-type of a resource in a {{Code|$database}} at the specified {{Code|$path}}.<br/>The file extension is used to recognize the content-type of a resource stored in the database. {{Code|application/xml}} will be returned for any XML document stored in the database, regardless of its file name extension.
|-
+
|- valign="top"
 
| '''Errors'''
 
| '''Errors'''
|{{Error|BXDB0002|XQuery Errors#BaseX Errors}} The addressed database does not exist or could not be opened.<br/>{{Error|FODC0002|XQuery Errors#Functions Errors}} the addressed resource is not found or cannot be retrieved.
+
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.
|-
+
|- valign="top"
 
| '''Examples'''
 
| '''Examples'''
 
|
 
|
Line 630: Line 976:
 
{| class="wikitable" width="100%"
 
{| class="wikitable" width="100%"
 
! width="110"|Code
 
! width="110"|Code
|Description
+
| Description
|-
+
|- valign="top"
|{{Code|BXDB0001}}
+
|{{Code|args}}
 +
|The number of specified inputs and paths differs.
 +
|- valign="top"
 +
|{{Code|conflict}}
 +
|Multiple update operations point to the same target.
 +
|- valign="top"
 +
|{{Code|lock}}
 +
|A database cannot be updated because it is opened by another process.
 +
|- valign="top"
 +
|{{Code|mainmem}}
 +
|The addressed database is not ''persistent'' (stored on disk).
 +
|- valign="top"
 +
|{{Code|name}}
 +
|The name of the specified database is invalid.
 +
|- valign="top"
 +
|{{Code|no-backup}}
 +
|No backup exists for a database.
 +
|- valign="top"
 +
|{{Code|node}}
 
|The referenced XML node is no [[#Database Nodes|database node]], i.e. it is neither stored in a database nor represented as database fragment.
 
|The referenced XML node is no [[#Database Nodes|database node]], i.e. it is neither stored in a database nor represented as database fragment.
|-
+
|- valign="top"
|{{Code|BXDB0002}}
+
|{{Code|no-index}}
 +
|The database lacks an index structure required by the called function.
 +
|- valign="top"
 +
|{{Code|open}}
 
|The addressed database does not exist or could not be opened.
 
|The addressed database does not exist or could not be opened.
|-
+
|- valign="top"
|{{Code|BXDB0003}}
+
|{{Code|option}}
|The addressed database is not ''persistent'' (stored on disk).
+
|The specified option is unknown.
|-
+
|- valign="top"
|{{Code|BXDB0004}}
+
|{{Code|path}}
|The database lacks an index structure required by the called function.
+
|The specified database path is invalid.
|-
+
|- valign="top"
|{{Code|BXDB0005}}
+
|{{Code|property}}
|A query is expected to exclusively return [[#Database Nodes|database nodes]] of a single database.
+
|The specified database property is unknown.
|-
+
|- valign="top"
|{{Code|BXDB0006}}
+
|{{Code|range}}
|A database path addressed with {{Code|doc()}} contains more than one document.
+
|The addressed database ID or PRE value is out of range.
|-
+
|- valign="top"
|{{Code|BXDB0007}}
+
|{{Code|target}}
|A database cannot be updated because it is opened by another process.
+
|Path points to an invalid target.
|-
 
|{{Code|BXDB0008}}
 
|Database paths cannot be renamed to empty strings.
 
|-
 
|{{Code|BXDB0009}}
 
|The addressed database id or pre value is out of range.
 
|-
 
|{{Code|BXDB0010}}
 
|The specified event is unknown.
 
|-
 
|{{Code|BXDB0011}}
 
|The name of the specified database is invalid.
 
|-
 
|{{Code|BXDB0012}}
 
|A database can only be created once.
 
|-
 
|{{Code|BXDB0013}}
 
|The number of specified inputs and paths differs.
 
|-
 
|{{Code|BXDB0014}}
 
|Path points to a directory.
 
 
|}
 
|}
  
 
=Changelog=
 
=Changelog=
 +
 +
;Version 10
 +
* Added: {{Function||db:get}}, {{Function||db:put}}, {{Function||db:type}}.
 +
* Added: [[#Backups|Backups]]: Support for general data ([[User Management|registered users]], [[Job Module#Services|scheduled services]] and [[Store Module|key-value stores]]).
 +
* Updated: {{Function||db:get}}, {{Function||db:get-id}}, {{Function||db:get-pre}} renamed (before: {{Code|db:open}}, {{Code|db:open-id}}, {{Code|db:open-pre}})
 +
* Updated: {{Function||db:put}} renamed (before: {{Code|db:replace}}); function signature aligned with {{Function||db:add}} (second and third argument swapped).
 +
* Updated: {{Function||db:put-binary}} renamed (before: {{Code|db:store}}); function signature aligned with {{Function||db:add}} (second and third argument swapped).
 +
* Updated: {{Function||db:get-binary}} renamed (before: {{Code|db:retrieve}}).
 +
* Updated: {{Function||db:backups}}, {{Function||db:create-backup}}: Options added.
 +
* Removed: {{Code|db:is-raw}}, {{Code|db:is-raw}} (new: {{Function||db:type}}).
 +
 +
;Version 9.3
 +
* Added: {{Function||db:alter-backup}}
 +
* Updated: {{Code|db:open-id}}, {{Code|db:open-pre}}: support for multiple integers
 +
 +
;Version 9.2
 +
* Added: {{Function||db:dir}}
 +
* Updated: {{Function||db:add}}: {{Code|$path}} allow empty path argument
 +
 +
;Version 9.0
 +
* Added: {{Function||db:option}}
 +
* Updated: db:output renamed to {{Function|Update|update:output}}, db:output-cache renamed to {{Function|Update|update:cache}}
 +
* Updated: error codes updated; errors now use the module namespace
 +
 +
;Version 8.6
 +
* Added: {{Function||db:property}}
 +
 +
;Version 8.4
 +
* Updated: {{Function||db:create}}, {{Function||db:add}}, {{Code|db:replace}}: support for {{Code|ADDCACHE}} option.
 +
* Added: {{Function||db:token}}
 +
 +
;Version 8.3
 +
* Updated: {{Function||db:list-details}}: attributes with name of database and date of backup added to results.
 +
* Updated: {{Function||db:backups}} now include attributes with name of database and date of backup.
 +
* Updated: {{Function|Database|Value Indexes}}: raise error if no index exists.
 +
 +
;Version 8.2
 +
* Added: {{Function||db:output-cache}}
 +
* Removed: db:event
 +
 +
;Version 7.9
 +
* Updated: parsing options added to {{Function||db:create}}, {{Function||db:add}} and {{Code|db:replace}}.
 +
* Updated: allow {{Option|UPDINDEX}} if {{Code|$all}} is {{Code|true}}.
 +
 +
;Version 7.8.2
 +
* Added: {{Function||db:alter}}, {{Function||db:copy}}, {{Function||db:create-backup}}, {{Function||db:drop-backup}}, {{Function||db:restore}}
  
 
;Version 7.8
 
;Version 7.8
* Removed: db:fulltext (use [[Full-Text Module#ft:search|ft:search]] instead)
+
* Removed: db:fulltext (use {{Function|Full-Text|ft:search}} instead)
  
 
;Version 7.7
 
;Version 7.7
 
+
* Added: {{Function||db:export}}, {{Function||db:name}}, {{Function||db:path}}
* Added: [[#db:export|db:export]], [[#db:name|db:name]], [[#db:path|db:path]]
+
* Updated: {{Code|$options}} argument added to {{Function||db:create}} and {{Function||db:optimize}}.
* Updated: {{Code|$options}} argument added to [[#db:create|db:create]] and [[#db:optimize|db:optimize]].
+
* Updated: the functions no longer accept [[#Database Nodes|database nodes]] as reference. Instead, the name of a database must now be specified.
* Updated: the functions no longer accept [[#Database Nodes|Database Nodes]] as reference. Instead, the name of a database must now be specified.
 
  
 
;Version 7.6
 
;Version 7.6
 
+
* Updated: {{Function||db:create}}: allow more than one input and path.
* Updated: [[#db:create|db:create]]: allow more than one input and path.
 
  
 
;Version 7.5
 
;Version 7.5
 
+
* Updated: {{Function||db:add}}: input nodes will be automatically converted to document nodes
* Updated: [[#db:add|db:add]]: input nodes will be automatically converted to document nodes
+
* Added: {{Function||db:backups}}
* Added: [[#db:backups|db:backups]]
+
* Added: {{Function||db:create}}
* Added: [[#db:create|db:create]]
+
* Added: {{Function||db:drop}}
* Added: [[#db:drop|db:drop]]
 
  
 
;Version 7.3
 
;Version 7.3
 
+
* Added: {{Function||db:flush}}
* Added: [[#db:flush|db:flush]]
 
  
 
;Version 7.2.1
 
;Version 7.2.1
 
+
* Added: {{Function||db:text-range}}, {{Function||db:attribute-range}}, {{Function||db:output}}
* Added: [[#db:text-range|db:text-range]], [[#db:attribute-range|db:attribute-range]], [[#db:output|db:output]]
 
  
 
;Version 7.1
 
;Version 7.1
 
+
* Added: {{Function||db:list-details}}, {{Function||db:content-type}}
* Added: [[#db:list-details|db:list-details]], [[#db:content-type|db:content-type]]
+
* Updated: {{Function||db:info}}, {{Function||db:system}}, {{Code|db:retrieve}}
* Updated: [[#db:info|db:info]], [[#db:system|db:system]], [[#db:retrieve|db:retrieve]]
 
  
 
;Version 7.0
 
;Version 7.0
 
+
* Added: {{Function||db:exists}}, {{Code|db:retrieve}}, {{Code|db:store}}, {{Code|db:is-raw}}, {{Code|db:is-xml}}
* Added: [[#db:retrieve|db:retrieve]], [[#db:store|db:store]], [[#db:exists|db:exists]], [[#db:is-raw|db:is-raw]], [[#db:is-xml|db:is-xml]]
+
* Updated: {{Function||db:list}}, {{Code|db:open}}, {{Function||db:add}}
* Updated: [[#db:list|db:list]], [[#db:open|db:open]], [[#db:add|db:add]]
 
 
 
[[Category:XQuery]]
 

Latest revision as of 23:07, 1 December 2023

This XQuery Module contains functions for processing databases from within XQuery. Existing databases can be opened and listed, its contents can be directly accessed, documents can be added to and removed, etc.

Conventions[edit]

All functions and errors in this module are assigned to the http://basex.org/modules/db namespace, which is statically bound to the db prefix.

Database Nodes[edit]

In BaseX, two internal representations exist for XML nodes:

1. Database nodes are:

  • stored in a persistent database on disk;
  • nodes of a document that has been generated temporarily with fn:doc, fn:parse-xml and other functions; or
  • the result of a main-memory update.

2. Fragments are similar to DOM structures. They are created when XQuery node constructors are used (<a/>, element a { }, etc.).

Fragments require less memory for small XML structures, but database nodes are more efficient for larger amounts of data. Fragments nodes can be converted to database nodes by applying a main-memory update with an empty body to a node:

<xml>hello world</xml> update { }

Updating Functions[edit]

Various functions in this module are updating. Updating functions will not be immediately executed, but queued on the Pending Update List, and processed after the remaining query has been evaluated. This means that the order in which the functions are specified in the query often does not reflect the order in which they will eventually be executed.

General Functions[edit]

db:system[edit]

Signature
db:system() as element(system)
Summary Returns general information on the database system the current values of all global and local Options. The INFO command returns similar output.

db:option[edit]

Signature
db:option(
  $name  as xs:string
) as xs:string
Summary Returns the current value (string, integer, boolean, map) of a global or local Option with the specified $name. The SHOW OPTIONS command returns similar output.
Errors option: the specified option is unknown.
Examples
  • db:option('dbpath') returns the database path string.
  • db:option('serializer') returns a map with the current serialization parameters.
  • declare option db:stripws 'true'; db:option('stripws') returns the locally assigned value.

db:info[edit]

Signature
db:info(
  $database  as xs:string
) as element(database)
Summary Returns meta information on the specified $database. The output is similar to the INFO DB command.
Errors open: the addressed database does not exist or could not be opened.

db:property[edit]

Signature
db:property(
  $database  as xs:string,
  $name      as xs:string
) as xs:anyAtomicType
Summary Returns the value (string, boolean, integer) of a property with the specified $name in the specified $database. The available properties are the ones returned by db:info.
Errors property: the specified property is unknown.
Examples
  • db:property('db', 'size') returns the number of bytes occupied by the database db.
  • db:property('xmark', 'textindex') indicates if the xmark database has a text index.
  • db:property('discogs', 'uptodate') indicates if the database statistics and index structures of the discogs database are up-to-date.

db:list[edit]

Signature
db:list(
  $database  as xs:string  := (),
  $path      as xs:string  := ()
) as xs:string*
Summary Without arguments, the names of all databases are returned that are accessible to the current user. If $database is specified, paths to all resources of this database are returned. The results can be restricted to resources starting with the specified $path.
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:list("docs") returns the names of all documents of a database named docs.

db:list-details[edit]

Signature
db:list-details(
  $database  as xs:string  := (),
  $path      as xs:string  := ()
) as element()*
Summary Without arguments, an element is returned for each database that is accessible to the current user:
  • An element has a value, which is the name of the database, and several attributes, which contain the number of stored resources, the modification date, the database size on disk (measured in bytes), and a path to the original database input.

If $database is specified, an element for each resource in this database is returned:

  • An element has a value, which is the name of the resource, and several attributes, which contain the content type, the modification date, the raw flag (which indicates if the resource is binary or XML), and the size of a resource.
  • The value of the size attribute depends on the resource type: for documents, it represents the number of nodes; for binary data, it represents the file size (measured in bytes).
  • The results can be restricted to resources starting with the specified $path.
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:list-details("shop") returns the names plus additional info on all resources of a database named shop.

db:dir[edit]

Signature
db:dir(
  $database  as xs:string,
  $path      as xs:string
) as element()*
Summary Returns metadata on all directories and resources of a $database in the specified $path. Two types of elements are returned:
  • resource represents a resource. The element value is the directory path; content type, modification date, raw flag (which indicates if the resource is binary or XML), and size of the resource are returned as attributes.
  • dir represents a directory. The element value is the directory path; the modification date is returned in an attribute.

The directories are not stored in the internal database layout. Instead, they result implicitly from the paths of stored resources.

Errors open: the addressed database does not exist or could not be opened.
path: the specified path is invalid.
Examples
  • db:dir('shop', 'books') returns all entries of the books directory of a shop database.

Read Operations[edit]

db:get[edit]

Signature
db:get(
  $database  as xs:string,
  $path      as xs:string  := ()
) as document-node()*
Summary Returns all documents from the specified $database, or only documents matching the specified $path.
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:get('docs') returns all documents from the database named docs.
  • db:get('db', 'one') returns all documents from the database named db located in the path one.
  • for $i in 1 to 3 return db:get('db' || $i)//item returns all item elements from the databases db1, db2 and db3.

db:get-pre[edit]

Signature
db:get-pre(
  $database  as xs:string,
  $values    as xs:integer*
) as node()*
Summary Returns all nodes from a $database with the specified PRE values in distinct document order.
The PRE value provides very fast access to an existing database node, but it will change whenever a node with a smaller pre values is added to or deleted from a database.
Errors open: the addressed database does not exist or could not be opened.
range: the specified PRE value does not exist in the database.
Examples
  • db:get-pre("docs", 0) returns the first database node from the database named docs.

db:get-id[edit]

Signature
db:get-id(
  $database  as xs:string,
  $values    as xs:integer*
) as node()*
Summary Returns all nodes from a $database with the specified ID $values in distinct document order.
Each database node has a persistent ID value. Access to the node ID can be sped up by turning on the UPDINDEX option.
Errors open: the addressed database does not exist or could not be opened.
range: the specified ID value does not exist in the database.

db:get-binary[edit]

Signature
db:get-binary(
  $database  as xs:string,
  $path      as xs:string
) as item()
Summary Returns a map with the paths and binary items of all resources in the specified $database. A single xs:base64Binary item is returned if a $path is specified. All items are lazy, i.e., the actual data will only be retrieved if it is processed.
Errors open: the addressed database does not exist or could not be opened.
mainmem: the database is not persistent (stored on disk).
Examples
  • db:get-binary('DB', 'music/01.mp3') returns the specified audio file as raw data.
  • stream:materialize(db:get-binary('DB', 'music/01.mp3')) materializes the streamable result in main-memory before returning it.
  • convert:binary-to-string(db:get-binary('DB', 'info.txt'), 'UTF-8') converts a binary database resource as UTF-8 text and returns a string.

db:get-value[edit]

Signature
db:get-value(
  $database  as xs:string,
  $path      as xs:string
) as item()*
Summary Returns a map with the paths and values of all resources in the specified $database. A single value is returned if a $path is specified.
Errors open: the addressed database does not exist or could not be opened.
mainmem: the database is not persistent (stored on disk).
Examples
  • db:get-value('DB', 'sequence') returns the specified sequence.

db:node-pre[edit]

Signature
db:node-pre(
  $nodes  as node()*
) as xs:integer*
Summary Returns the PRE values of the specified $nodes, which must all be database nodes.
The PRE value provides very fast access to an existing database node, but it will change whenever a node with a smaller pre values is added to or deleted from a database.
Errors node: $nodes contains a node which is not stored in a database.
Examples
  • db:node-pre(doc("input")) returns 0 if the database input contains a single document.

db:node-id[edit]

Signature
db:node-id(
  $nodes  as node()*
) as xs:integer*
Summary Returns the ID values of the specified $nodes, which must all be database nodes.
Each database node has a persistent ID value. Access to the node id can be sped up by turning on the UPDINDEX option.
Errors node: $nodes contains a node which is not stored in a database.

db:export[edit]

Signature
db:export(
  $database  as xs:string,
  $path      as xs:string,
  $options   as map(*)?    := map { }
) as empty-sequence()
Summary Exports the specified $database to the specified file $path. Existing files will be overwritten.
The $options argument contains serialization parameters (see fn:serialize).
Errors open: the addressed database does not exist or could not be opened.
Examples Export all files as text:
db:export("DB", "/home/john/xml/texts", map { 'method': 'text' })

The following code can be used to export parts of the database:

let $target := '/home/john/xml/target'
for $doc in db:get('DB', 'collection')
let $path := $target || db:path($doc)
return (
  file:create-dir(file:parent($path)),
  file:write($path, $doc)
)

Value Indexes[edit]

db:text[edit]

Signature
db:text(
  $database  as xs:string,
  $values    as xs:string*
) as text()*
Summary Returns all text nodes of a $database that match one of the specified $values and that are stored in the text index.
Errors open: the addressed database does not exist or could not be opened.
no-index: the index is not available.
Examples
  • db:text("DB", "QUERY")/.. returns the parents of all text nodes of the database DB that match the string QUERY.

db:text-range[edit]

Signature
db:text-range(
  $database  as xs:string,
  $min       as xs:string,
  $max       as xs:string
) as text()*
Summary Returns all text nodes of a $database whose values are larger than or equal to $min and smaller than or equal to $max and that are stored in the text index.
Errors open: the addressed database does not exist or could not be opened.
no-index: the index is not available.
Examples
  • db:text-range("DB", "2000", "2001") returns all text nodes of the database DB that are found in between 2000 and 2001.

db:attribute[edit]

Signature
db:attribute(
  $database  as xs:string,
  $values    as xs:string*,
  $name      as xs:string   := ()
) as attribute()*
Summary Returns all attribute nodes of a $database that match one of the specified $values and that are stored in the attribute index.
If $name is specified, the resulting attribute nodes are filtered by their attribute name.
Errors open: the addressed database does not exist or could not be opened.
no-index: the index is not available.
Examples
  • db:attribute("DB", "QUERY", "id")/.. returns the parents of all id attribute nodes of the database DB that have QUERY as string value.

db:attribute-range[edit]

Signature
db:attribute-range(
  $database  as xs:string,
  $min       as xs:string,
  $max       as xs:string,
  $name      as xs:string  := ()
) as attribute()*
Summary Returns all attributes of a $database whose values are larger than or equal to $min and smaller than or equal to $max and that are stored in the attribute index.
Errors open: the addressed database does not exist or could not be opened.
no-index: the index is not available.
Examples
  • db:attribute-range("DB", "id456", "id473", 'id') returns all @id attributes of the database DB that have a string value in between id456 and id473.

db:token[edit]

Signature
db:token(
  $database  as xs:string,
  $tokens    as xs:string*,
  $name      as xs:string   := ()
) as attribute()*
Summary Returns all attribute nodes of a $database the values of which contain one of the specified $tokens.
If $name is specified, the resulting attribute nodes are filtered by their attribute name.
Errors open: the addressed database does not exist or could not be opened.
no-index: the index is not available.
Examples
  • db:token("DB", "row", "class")/parent::div returns all div nodes of database DB with a class attribute that contains the token row.

Updates[edit]

All functions in this section are Updating Functions.

db:create[edit]

Signature
db:create(
  $database  as xs:string,
  $inputs    as item()*     := (),
  $paths     as xs:string*  := (),
  $options   as map(*)?     := map { }
) as empty-sequence()
Summary Creates a new $database and adds the supplied $inputs to the specified $paths:
  • The inputs may be strings or nodes:
    • nodes may be of any type except for attributes
    • strings can be a URI pointing to a file/directory or an XML string (which is detected by the leading < character)
    • a path must be specified if the input is not a file or directory reference
  • The parsing and indexing behavior can be controlled via $options:
  • An existing database will be overwritten.
  • Database creation takes place after most other update operations (see Pending Update List). As a consequence, a newly created database cannot be addressed in the same query.
Errors lock: a database is opened by another process.
name: the specified name is not a valid database name.
conflict: the same database was addressed more than once.
args: the number of specified inputs and paths differs.
Examples
  • db:create("DB") creates the empty database DB.
  • db:create("DB", "/home/dir/doc.xml") creates the database DB and adds the document /home/dir/doc.xml as initial content.
  • db:create("DB", <a/>, "doc.xml") creates the database DB and adds the document with content <a/> under the name doc.xml.
  • db:create("DB", "/home/dir/", "docs/dir") creates the database DB and adds the documents in /home/dir to the database under the path docs/dir.
  • db:create("DB", file:list('.'), (), map { 'ftindex': true() }) adds all files of the current working directory to a new database, preserving relative filesystem paths and creating a full-text index.

db:add[edit]

Signature
db:add(
  $database  as xs:string,
  $input     as item(),
  $path      as xs:string?  := (),
  $options   as map(*)?     := map { }
) as empty-sequence()
Summary Adds the specified $input to a $database with the specified $path:
  • A document with the same path may occur more than once in a database. If you want to enforce single instances, use db:put instead.
  • See db:create for more details on the input and path arguments.
  • The parsing behavior can be controlled via $options:
    • allowed options are ADDCACHE and the parsing and XML parsing options, all in lower case
    • parsing options will only impact string input (URIs, XML strings) because nodes have already been parsed
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:add("DB", "/home/dir/doc.xml") adds the file /home/dir/doc.xml to the database DB.
  • db:add("DB", <a/>, "doc.xml") adds a document node to the database DB under the name doc.xml.
  • db:add("DB", "/home/dir", "docs/dir", map { 'addcache': true() }) adds all documents in /home/dir to the database DB under the path docs/dir. To reduce memory consumption, the files will be cached before being added to the database.

db:put[edit]

Signature
db:put(
  $database  as xs:string,
  $input     as item(),
  $path      as xs:string,
  $options   as map(*)?    := map { }
) as empty-sequence()
Summary Replaces a resource, specified by $path, in a $database with the contents of $input, or adds it as a new resource:
  • The parsing behavior can be controlled via $options:
    • Allowed options are ADDCACHE and the parsing and XML parsing options, all in lower case.
    • Parsing options will only impact string input (URIs, XML strings), because nodes have already been parsed.
  • See db:create for more details on the input argument.
Errors open: the addressed database does not exist or could not be opened.
target: the path points to a directory.
Examples
  • db:put("DB", "/home/dir/doc.xml", "docs/dir/doc.xml") replaces the content of the document docs/dir/doc.xml in the database DB with the content of the file /home/dir/doc.xml.
  • db:put("DB", "<a/>", "docs/dir/doc.xml") replaces the content of the document docs/dir/doc.xml in the database DB with <a/>.
  • db:put("DB", document { <a/> }, "docs/dir/doc.xml") replaces the content of the document docs/dir/doc.xml in the database DB with the specified document node.

The following query can be used to import files from a directory to a database:

let $source := '/home/john/xml/source'
for $file in file:list($source, true())
let $path := $source || $file
where not(file:is-dir($path))
return db:put('db', doc($path), $file)

db:put-binary[edit]

Signature
db:put-binary(
  $database  as xs:string,
  $input     as item(),
  $path      as xs:string
) as empty-sequence()
Summary Stores a binary resource specified by $input in a $database at the specified $path. Existing resources are overwritten.
Errors open: the addressed database does not exist or could not be opened.
mainmem: the database is not persistent (stored on disk).
Examples
  • db:put-binary('DB', file:read-binary('video.mov'), 'video/sample.mov') stores the addressed video file at the specified location.
  • With the following query, you can copy the binary resources of one database into another:
let $db := 'db'
let $src-path := 'src/'
let $trg-path := 'trg/'
for $src in db:list($db, $src-path)
where db:type($db, $src) = 'binary'
let $trg := $trg-path || substring-after($src, $src-path)
return db:put-binary($db, db:get-binary($db, $src), $trg)

db:put-value[edit]

Signature
db:put-value(
  $database  as xs:string,
  $input     as item()*,
  $path      as xs:string
) as empty-sequence()
Summary Stores an $input value in a $database at the specified $path. Existing resources are overwritten. The value can be an arbitrary sequence of atomic items, nodes, maps, and arrays.
Errors open: the addressed database does not exist or could not be opened.
mainmem: the database is not persistent (stored on disk).
Examples
  • db:put-value('DB', 1 to 10000, 'sequence') stores a numeric range in the database.
  • With the following query, a map with countries and associated cities is stored in a database. The value resource can e.g. be used as index in future queries:
db:put-value(
  'factbook',
  map:merge(
    for $country in db:get('factbook')//country
    return map:entry($country/@name, $country//city/name ! string())
  ),
  'cities'
)

db:delete[edit]

Signature
db:delete(
  $database  as xs:string,
  $path      as xs:string
) as empty-sequence()
Summary Deletes resource(s), specified by $path, from the specified $database.
Errors open: the addressed database does not exist or could not be opened.
path: the specified path is invalid.
Examples
  • db:delete("DB", "docs/dir/doc.xml") deletes the resource docs/dir/doc.xml from DB.
  • db:delete("DB", "docs/dir") deletes all resources from DB in the specified path docs/dir.

db:copy[edit]

Signature
db:copy(
  $database  as xs:string,
  $new-name  as xs:string
) as empty-sequence()
Summary Creates a copy of $database, which will be called $new-name.
Errors open: the addressed database does not exist or could not be opened.
lock: a database is opened by another process.
name: invalid database name.
conflict: the same database was addressed more than once.

db:alter[edit]

Signature
db:alter(
  $database  as xs:string,
  $new-name  as xs:string
) as empty-sequence()
Summary Renames a $database to $new-name.
Errors open: the addressed database does not exist or could not be opened.
lock: a database is opened by another process.
name: invalid database name.
conflict: the same database was addressed more than once.

db:optimize[edit]

Signature
db:optimize(
  $database  as xs:string,
  $all       as xs:boolean?  := false(),
  $options   as map(*)?      := map { }
) as empty-sequence()
Summary Optimizes the metadata and indexes of a $database.
If $all is true, the complete database will be rebuilt.
The $options argument can be used to control indexing. The syntax is identical to the db:create function: Allowed options are all indexing and full-text options. UPDINDEX is only supported if $all is true.
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:optimize("DB") optimizes the database structures of the database DB.
  • db:optimize("DB", true(), map { 'ftindex': true() }) optimizes all database structures of the database DB and creates a full-text index.

db:rename[edit]

Signature
db:rename(
  $database  as xs:string,
  $source    as xs:string,
  $target    as xs:string
) as empty-sequence()
Summary Moves all resources(s) of a $database, which are found in the supplied $source path, to the supplied $target path. The paths may point to single resources or directories. No updates will take place if a non-existing source path is supplied.
Errors open: the addressed database does not exist or could not be opened.
path: the specified source or target path, or one of its descendants, is invalid.
Examples
  • db:rename("DB", "docs/dir/doc.xml", "docs/dir/newdoc.xml") renames the resource docs/dir/doc.xml to docs/dir/newdoc.xml in the database DB.
  • db:rename("DB", "docs/dir", "docs/newdir") moves all resources in the database DB from docs/dir to docs/newdir.

db:flush[edit]

Signature
db:flush(
  $database  as xs:string
) as empty-sequence()
Summary Explicitly flushes the buffers of a $database. This command is only useful if AUTOFLUSH has been set to false.
Errors open: the addressed database does not exist or could not be opened.

db:drop[edit]

Signature
db:drop(
  $database  as xs:string
) as empty-sequence()
Summary Drops a $database and all connected resources.
Errors open: the addressed database does not exist or could not be opened.
lock: a database is opened by another process.
conflict: the same database was addressed more than once.
Examples
  • db:drop("DB") drops the database DB.

Backups[edit]

All functions in this section except for db:backups are Updating Functions.

db:create-backup[edit]

Signature
db:create-backup(
  $database  as xs:string,
  $options   as map(*)?    := map { }
) as empty-sequence()
Summary Creates a backup of a $database. If no name is supplied, general data will be backed up. The following $options are available:
  • With comment, a comment string can be attached to the backup.
  • By setting compress to false, the backup will be created faster, but it will take more space on disk.
Errors open: the addressed database does not exist or could not be opened.
name: invalid database name.
conflict: the same database was addressed more than once.
Examples
  • db:create-backup('DB', map { 'compress': false() }) creates a backup of the database DB without compressing its entries.

db:drop-backup[edit]

Signature
db:drop-backup(
  $name  as xs:string
) as empty-sequence()
Summary Drops all backups of the database with the specified $name. If the name ends with a timestamp, only the specified backup file will be deleted. If no name is supplied, backups with general data are addressed.
Errors backup: No backup file found.
name: invalid database name.
conflict: the same database was addressed more than once.
Examples
  • db:drop-backup("DB") drops all backups of the database DB.
  • db:drop-backup("DB-2014-03-13-17-36-44") drops the specific backup file DB-2014-03-13-17-36-44.zip of the database DB.

db:alter-backup[edit]

Signature
db:alter-backup(
  $name      as xs:string,
  $new-name  as xs:string
) as empty-sequence()
Summary Renames all backups of the database with the specified $name to $new-name. If the name ends with a date, only the specified backup file will be renamed.
Errors backup: No backup file found.
name: invalid database name.
conflict: the same database was addressed more than once.
Examples
  • db:alter-backup("DB", "DB2) renames all backups of the database DB to DB2.

db:restore[edit]

Signature
db:restore(
  $name  as xs:string
) as empty-sequence()
Summary Restores the database with the specified $name. The $name may include the timestamp of the backup file. If no name is supplied, general data will be restored. If general data is restored, it will only be available after BaseX has been restarted.
Errors lock: a database is opened by another process.
name: invalid database name.
no-backup: No backup found.
conflict: the same database was addressed more than once.
Examples
  • db:restore("DB") restores the database DB.
  • db:restore("DB-2014-03-13-18-05-45") restores the database DB from the backup file with the given timestamp.

db:backups[edit]

Signature
db:backups(
  $database  as xs:string  := ()
) as element(backup)*
Summary Returns an element sequence containing all available database backups with timestamp, file size and comment.
If a $database is specified, the sequence will be restricted to the backups matching this database.
Examples
  • db:backups("factbook") returns all backups that have been made from the factbook database.

Helper Functions[edit]

db:name[edit]

Signature
db:name(
  $node  as node()
) as xs:string
Summary Returns the name of the database in which the specified database node $node is stored.
Errors node: $nodes contains a node which is not stored in a database.

db:path[edit]

Signature
db:path(
  $node  as node()
) as xs:string
Summary Returns the path of the database document in which the specified database node $node is stored.
Errors node: $nodes contains a node which is not stored in a database.

db:exists[edit]

Signature
db:exists(
  $database  as xs:string,
  $path      as xs:string  := ()
) as xs:boolean
Summary Checks if a $database exists, or a resource located at $path in this database.
Examples
  • db:exists("DB") returns true if the database DB exists.
  • db:exists("DB", "resource") returns true if resource exists in this database.

db:type[edit]

Signature
db:type(
  $database  as xs:string,
  $path      as xs:string
) as xs:string
Summary Returns the type (xml, binary, value) of a resource in a $database at the specified $path.
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:type("DB", "factbook.xml") returns true if the specified resource is an XML document.

db:content-type[edit]

Signature
db:content-type(
  $database  as xs:string,
  $path      as xs:string
) as xs:string
Summary Retrieves the content-type of a resource in a $database at the specified $path.
The file extension is used to recognize the content-type of a resource stored in the database. application/xml will be returned for any XML document stored in the database, regardless of its file name extension.
Errors open: the addressed database does not exist or could not be opened.
Examples
  • db:content-type("DB", "docs/doc01.pdf") returns application/pdf.
  • db:content-type("DB", "docs/doc01.xml") returns application/xml.
  • db:content-type("DB", "docs/doc01") returns application/xml, if db:is-xml("DB", "docs/doc01") returns true.

Errors[edit]

Code Description
args The number of specified inputs and paths differs.
conflict Multiple update operations point to the same target.
lock A database cannot be updated because it is opened by another process.
mainmem The addressed database is not persistent (stored on disk).
name The name of the specified database is invalid.
no-backup No backup exists for a database.
node The referenced XML node is no database node, i.e. it is neither stored in a database nor represented as database fragment.
no-index The database lacks an index structure required by the called function.
open The addressed database does not exist or could not be opened.
option The specified option is unknown.
path The specified database path is invalid.
property The specified database property is unknown.
range The addressed database ID or PRE value is out of range.
target Path points to an invalid target.

Changelog[edit]

Version 10
Version 9.3
  • Added: db:alter-backup
  • Updated: db:open-id, db:open-pre: support for multiple integers
Version 9.2
  • Added: db:dir
  • Updated: db:add: $path allow empty path argument
Version 9.0
Version 8.6
Version 8.4
Version 8.3
  • Updated: db:list-details: attributes with name of database and date of backup added to results.
  • Updated: db:backups now include attributes with name of database and date of backup.
  • Updated: Value Indexes: raise error if no index exists.
Version 8.2
Version 7.9
Version 7.8.2
Version 7.8
Version 7.7
Version 7.6
  • Updated: db:create: allow more than one input and path.
Version 7.5
Version 7.3
Version 7.2.1
Version 7.1
Version 7.0