Difference between revisions of "Database Module"
(27 intermediate revisions by 2 users not shown) | |||
Line 7: | Line 7: | ||
==Database Nodes== | ==Database Nodes== | ||
− | In BaseX, two internal representations exist for nodes | + | 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 {{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> |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | </ | ||
==Updating Functions== | ==Updating Functions== | ||
Line 41: | Line 30: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:system() as element(system)</pre> |
− | |- | + | |- valign="top" |
| '''Summary''' | | '''Summary''' | ||
|Returns general information on the database system the current values of all global and local [[Options]]. The {{Command|INFO}} command returns similar output. | |Returns general information on the database system the current values of all global and local [[Options]]. The {{Command|INFO}} command returns similar output. | ||
Line 52: | Line 41: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:option( |
− | |- | + | $name as xs:string |
+ | ) as xs:string</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''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. | |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''' | | '''Errors''' | ||
|{{Error|option|#Errors}} the specified option is unknown. | |{{Error|option|#Errors}} the specified option is unknown. | ||
− | |- | + | |- valign="top" |
| '''Examples''' | | '''Examples''' | ||
| | | | ||
Line 72: | Line 63: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:info( |
− | |- | + | $database as xs:string |
+ | ) as element(database)</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns meta information on the | + | |Returns meta information on the specified {{Code|$database}}. The output is similar to the {{Command|INFO DB}} command. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#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. | ||
Line 86: | Line 79: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:property( |
− | |- | + | $database as xs:string, |
+ | $name as xs:string | ||
+ | ) as xs:anyAtomicType</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns the value (string, boolean, integer) of a property with the specified {{Code|$name}} in the | + | |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}}. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{Error|property|#Errors}} the specified property is unknown. | |{{Error|property|#Errors}} the specified property is unknown. | ||
− | |- | + | |- valign="top" |
| '''Examples''' | | '''Examples''' | ||
| | | | ||
Line 106: | Line 102: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:list( |
− | |- | + | $database as xs:string := (), |
+ | $path as xs:string := () | ||
+ | ) as xs:string*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | | | + | |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}}. |
− | + | |- valign="top" | |
− | |||
− | |||
− | |- | ||
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#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''' | ||
| | | | ||
Line 127: | Line 123: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:list-details( |
− | |- | + | $database as xs:string := (), |
+ | $path as xs:string := () | ||
+ | ) as element()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
|Without arguments, an element is returned for each database that is accessible to the current user: | |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. | * 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 | + | 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. | * 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 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''' | | '''Errors''' | ||
|{{Error|open|#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''' | ||
| | | | ||
Line 150: | Line 149: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:dir( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string | ||
+ | ) as element()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns | + | |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|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 | + | * {{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|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified path is invalid. | |{{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''' | ||
| | | | ||
Line 171: | Line 173: | ||
==db:get== | ==db:get== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:get( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string := () | ||
+ | ) as document-node()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all documents from the | + | |Returns all documents from the specified {{Code|$database}}, or only documents matching the specified {{Code|$path}}. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#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''' | ||
| | | | ||
Line 193: | Line 196: | ||
==db:get-pre== | ==db:get-pre== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:get-pre( |
− | |- | + | $database as xs:string, |
+ | $values as xs:integer* | ||
+ | ) as node()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all nodes from | + | |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|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|range|#Errors}} the specified | + | |{{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''' | ||
| | | | ||
Line 213: | Line 217: | ||
==db:get-id== | ==db:get-id== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:get-id( |
− | |- | + | $database as xs:string, |
+ | $values as xs:integer* | ||
+ | ) as node()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all nodes from | + | |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|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. | |{{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. | ||
Line 229: | Line 234: | ||
==db:get-binary== | ==db:get-binary== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:get-binary( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string | ||
+ | ) as item()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns a | + | |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|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). | |{{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:get-binary( | + | * {{Code|db:get-binary('DB', 'music/01.mp3')}} returns the specified audio file as raw data. |
− | * <code><nowiki>stream:materialize(db:get-binary( | + | * <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( | + | * <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:get-value== | ==db:get-value== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:get-value( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string | ||
+ | ) as item()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns | + | |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|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). | |{{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''' | ||
| | | | ||
Line 273: | Line 280: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:node-pre( |
− | |- | + | $nodes as node()* |
+ | ) as xs:integer*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns the | + | |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|node|#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. | ||
− | |- | + | |- valign="top" |
| '''Examples''' | | '''Examples''' | ||
| | | | ||
Line 291: | Line 300: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:node-id( |
− | |- | + | $nodes as node()* |
+ | ) as xs:integer*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns the | + | |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''' | | '''Errors''' | ||
|{{Error|node|#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 305: | Line 316: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |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]). |
− | + | |- valign="top" | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#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''' | ||
| Export all files as text:<br/> | | Export all files as text:<br/> | ||
− | < | + | <pre lang='xquery'> |
db:export("DB", "/home/john/xml/texts", map { 'method': 'text' }) | db:export("DB", "/home/john/xml/texts", map { 'method': 'text' }) | ||
− | </ | + | </pre> |
The following code can be used to export parts of the database: | The following code can be used to export parts of the database: | ||
− | < | + | <pre lang='xquery'> |
let $target := '/home/john/xml/target' | let $target := '/home/john/xml/target' | ||
for $doc in db:get('DB', 'collection') | for $doc in db:get('DB', 'collection') | ||
Line 341: | Line 344: | ||
file:write($path, $doc) | file:write($path, $doc) | ||
) | ) | ||
− | </ | + | </pre> |
|} | |} | ||
Line 349: | Line 352: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:text( |
− | |- | + | $database as xs:string, |
+ | $values as xs:string* | ||
+ | ) as text()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all text nodes of | + | |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|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/> | |{{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 367: | Line 373: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |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|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/> | |{{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 385: | Line 395: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |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|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/> | |{{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 403: | Line 417: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |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|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|no-index|#Errors}} the index is not available.<br/> | |{{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 421: | Line 440: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:token( |
− | |- | + | $database as xs:string, |
+ | $tokens as xs:string*, | ||
+ | $name as xs:string := () | ||
+ | ) as attribute()*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all attribute nodes of | + | |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''' | | '''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/> | |{{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 443: | Line 466: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |Creates a new {{Code|$database}} and adds the supplied {{Code|$inputs}} to the specified {{Code|$paths}}: |
− | * | + | * The inputs may be strings or nodes: |
** nodes may be of any type except for attributes | ** 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 <code><</code> character) | ** strings can be a URI pointing to a file/directory or an XML string (which is detected by the leading <code><</code> character) | ||
Line 455: | Line 483: | ||
* The parsing and indexing behavior can be controlled via {{Code|$options}}: | * The parsing and indexing behavior can be controlled via {{Code|$options}}: | ||
** 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 | ** 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 | ||
− | ** parsing options will only impact string input (URIs, XML strings) | + | ** parsing options will only impact string input (URIs, XML strings) because nodes have already been parsed. |
* An existing database will be overwritten. | * An existing database will be overwritten. | ||
* 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. | * 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. | ||
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{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. | |{{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 474: | Line 502: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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''' | ||
− | |Adds | + | |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. | * 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. | * See {{Function||db:create}} for more details on the input and path arguments. | ||
* The parsing behavior can be controlled via {{Code|$options}}: | * 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 | ** 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) | + | ** parsing options will only impact string input (URIs, XML strings) because nodes have already been parsed |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#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:add("DB", "/home/dir/doc.xml")</code> adds the file {{Code|/home/dir/doc.xml}} to 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", <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}}. | + | * <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:put== | ==db:put== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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''' | ||
− | |Replaces a resource, specified by {{Code|$path}}, in | + | |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}}: | * 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. | ** 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. | ** 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. | * See {{Function||db:create}} for more details on the input argument. | ||
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|target|#Errors}} the path points to a directory. | |{{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''' | ||
| | | | ||
Line 521: | Line 557: | ||
* {{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. | * {{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: | The following query can be used to import files from a directory to a database: | ||
− | < | + | <pre lang='xquery'> |
let $source := '/home/john/xml/source' | let $source := '/home/john/xml/source' | ||
for $file in file:list($source, true()) | for $file in file:list($source, true()) | ||
Line 527: | Line 563: | ||
where not(file:is-dir($path)) | where not(file:is-dir($path)) | ||
return db:put('db', doc($path), $file) | return db:put('db', doc($path), $file) | ||
− | </ | + | </pre> |
|} | |} | ||
==db:put-binary== | ==db:put-binary== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:put-binary( |
− | |- | + | $database as xs:string, |
+ | $input as item(), | ||
+ | $path as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Stores a binary resource specified by {{Code|$input}} in | + | |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|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). | |{{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:put-binary('DB', file:read-binary('video.mov'), 'video/sample.mov')}} stores the addressed video file at the specified location. | * {{Code|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: | * With the following query, you can copy the binary resources of one database into another: | ||
− | < | + | <pre lang='xquery'> |
let $db := 'db' | let $db := 'db' | ||
let $src-path := 'src/' | let $src-path := 'src/' | ||
Line 557: | Line 595: | ||
let $trg := $trg-path || substring-after($src, $src-path) | let $trg := $trg-path || substring-after($src, $src-path) | ||
return db:put-binary($db, db:get-binary($db, $src), $trg) | return db:put-binary($db, db:get-binary($db, $src), $trg) | ||
− | </ | + | </pre> |
|} | |} | ||
==db:put-value== | ==db:put-value== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:put-value( |
− | |- | + | $database as xs:string, |
+ | $input as item()*, | ||
+ | $path as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Stores | + | |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|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). | |{{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:put-value('DB', 1 to 10000, 'sequence')}} stores a numeric range in the database. | * {{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: | * 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( | db:put-value( | ||
'factbook', | 'factbook', | ||
Line 587: | Line 627: | ||
), | ), | ||
'cities' | 'cities' | ||
− | )</ | + | )</pre> |
|} | |} | ||
Line 593: | Line 633: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:delete( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Deletes resource(s), specified by {{Code|$path}}, from the | + | |Deletes resource(s), specified by {{Code|$path}}, from the specified {{Code|$database}}. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''Errors''' | ||
|{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified path is invalid. | |{{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''' | ||
| | | | ||
Line 612: | Line 655: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:copy( |
− | |- | + | $database as xs:string, |
+ | $new-name as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Creates a copy of | + | |Creates a copy of {{Code|$database}}, which will be called {{Code|$new-name}}. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''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. | |{{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 626: | Line 672: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:alter( |
− | |- | + | $database as xs:string, |
+ | $new-name as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Renames | + | |Renames a {{Code|$database}} to {{Code|$new-name}}. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''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. | |{{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 640: | Line 689: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |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|open|#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''' | ||
| | | | ||
Line 659: | Line 712: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:rename( |
− | |- | + | $database as xs:string, |
+ | $source as xs:string, | ||
+ | $target as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Moves all resources(s) of | + | |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|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. | |{{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 resource {{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")}} moves all resources in the database {{Code|DB}} from {{Code|docs/dir}} to {Code|docs/newdir}}. | + | * {{Code|db:rename("DB", "docs/dir", "docs/newdir")}} moves all resources in the database {{Code|DB}} from {{Code|docs/dir}} to {{Code|docs/newdir}}. |
|} | |} | ||
Line 678: | Line 735: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:flush( |
− | |- | + | $database as xs:string |
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Explicitly flushes the buffers of | + | |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''' | | '''Errors''' | ||
|{{Error|open|#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. | ||
Line 692: | Line 751: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:drop( |
− | |- | + | $database as xs:string |
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Drops | + | |Drops a {{Code|$database}} and all connected resources. |
− | |- | + | |- valign="top" |
| '''Errors''' | | '''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|conflict|#Errors}} the same database was addressed more than once. | |{{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''' | ||
| | | | ||
Line 708: | Line 769: | ||
=Backups= | =Backups= | ||
− | |||
− | |||
All functions in this section except for {{Function||db:backups}} are {{Function|Database|Updating Functions}}. | All functions in this section except for {{Function||db:backups}} are {{Function|Database|Updating Functions}}. | ||
==db:create-backup== | ==db:create-backup== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:create-backup( |
− | |- | + | $database as xs:string, |
+ | $options as map(*)? := map { } | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Creates a backup of | + | |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. | * 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. | * 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|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. | |{{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''' | ||
| | | | ||
Line 738: | Line 798: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:drop-backup( |
− | |- | + | $name as xs:string |
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
|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. | |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''' | | '''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. | |{{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''' | ||
| | | | ||
Line 757: | Line 819: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:alter-backup( |
− | |- | + | $name as xs:string, |
+ | $new-name as xs:string | ||
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''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. | |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''' | | '''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. | |{{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''' | ||
| | | | ||
Line 775: | Line 840: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:restore( |
− | |- | + | $name as xs:string |
+ | ) as empty-sequence()</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
|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. | |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|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. | |{{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''' | | '''Examples''' | ||
| | | | ||
Line 794: | Line 861: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:backups( |
− | |- | + | $database as xs:string := () |
+ | ) as element(backup)*</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns an element sequence containing all available database backups with timestamp, file size and comment.<br/>If a | + | |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''' | | '''Examples''' | ||
| | | | ||
Line 811: | Line 880: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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|node|#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 825: | Line 896: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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|node|#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 839: | Line 912: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:exists( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string := () | ||
+ | ) as xs:boolean</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Checks if | + | |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}} | + | * {{Code|db:exists("DB", "resource")}} returns {{Code|true}} if {{Code|resource}} exists in this database. |
|} | |} | ||
==db:type== | ==db:type== | ||
− | |||
− | |||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<pre>db:type( |
− | |- | + | $database as xs:string, |
+ | $path as xs:string | ||
+ | ) as xs:string</pre> | ||
+ | |- valign="top" | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns the type | + | |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|open|#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''' | ||
| | | | ||
Line 875: | Line 952: | ||
{| width='100%' | {| width='100%' | ||
− | |- | + | |- valign="top" |
− | | width='120' | ''' | + | | width='120' | '''Signature''' |
− | | | + | |<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 | + | |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|open|#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''' | ||
| | | | ||
Line 896: | Line 976: | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
! width="110"|Code | ! width="110"|Code | ||
− | |Description | + | | Description |
− | |- | + | |- valign="top" |
|{{Code|args}} | |{{Code|args}} | ||
|The number of specified inputs and paths differs. | |The number of specified inputs and paths differs. | ||
− | |- | + | |- valign="top" |
|{{Code|conflict}} | |{{Code|conflict}} | ||
|Multiple update operations point to the same target. | |Multiple update operations point to the same target. | ||
− | |- | + | |- valign="top" |
|{{Code|lock}} | |{{Code|lock}} | ||
|A database cannot be updated because it is opened by another process. | |A database cannot be updated because it is opened by another process. | ||
− | |- | + | |- valign="top" |
|{{Code|mainmem}} | |{{Code|mainmem}} | ||
|The addressed database is not ''persistent'' (stored on disk). | |The addressed database is not ''persistent'' (stored on disk). | ||
− | |- | + | |- valign="top" |
|{{Code|name}} | |{{Code|name}} | ||
|The name of the specified database is invalid. | |The name of the specified database is invalid. | ||
− | |- | + | |- valign="top" |
|{{Code|no-backup}} | |{{Code|no-backup}} | ||
|No backup exists for a database. | |No backup exists for a database. | ||
− | |- | + | |- valign="top" |
|{{Code|node}} | |{{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|no-index}} | |{{Code|no-index}} | ||
|The database lacks an index structure required by the called function. | |The database lacks an index structure required by the called function. | ||
− | |- | + | |- valign="top" |
|{{Code|open}} | |{{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|option}} | |{{Code|option}} | ||
|The specified option is unknown. | |The specified option is unknown. | ||
− | |- | + | |- valign="top" |
|{{Code|path}} | |{{Code|path}} | ||
|The specified database path is invalid. | |The specified database path is invalid. | ||
− | |- | + | |- valign="top" |
|{{Code|property}} | |{{Code|property}} | ||
|The specified database property is unknown. | |The specified database property is unknown. | ||
− | |- | + | |- valign="top" |
|{{Code|range}} | |{{Code|range}} | ||
− | |The addressed database | + | |The addressed database ID or PRE value is out of range. |
− | |- | + | |- valign="top" |
|{{Code|target}} | |{{Code|target}} | ||
|Path points to an invalid target. | |Path points to an invalid target. | ||
Line 945: | Line 1,025: | ||
;Version 10 | ;Version 10 | ||
* Added: {{Function||db:get}}, {{Function||db:put}}, {{Function||db:type}}. | * Added: {{Function||db:get}}, {{Function||db:put}}, {{Function||db:type}}. | ||
− | * Added: [[#Backups|Backups]]: Support for general data ([[User Management|registered users]], [[ | + | * 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: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}} renamed (before: {{Code|db:replace}}); function signature aligned with {{Function||db:add}} (second and third argument swapped). |
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.
Contents
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: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: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-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:
If
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
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:
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 |
|
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-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-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-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: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-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-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: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-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: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 |
|
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 :
|
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: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 :
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
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:
|
Errors | open : the addressed database does not exist or could not be opened.target : the path points to a directory.
|
Examples |
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 |
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(
'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: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: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: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 |
|
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:
|
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: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: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: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: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 |
|
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: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: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 |
|
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
- Added:
db:get
,db:put
,db:type
. - Added: Backups: Support for general data (registered users, scheduled services and key-value stores).
- Updated:
db:get
,db:get-id
,db:get-pre
renamed (before:db:open
,db:open-id
,db:open-pre
) - Updated:
db:put
renamed (before:db:replace
); function signature aligned withdb:add
(second and third argument swapped). - Updated:
db:put-binary
renamed (before:db:store
); function signature aligned withdb:add
(second and third argument swapped). - Updated:
db:get-binary
renamed (before:db:retrieve
). - Updated:
db:backups
,db:create-backup
: Options added. - Removed:
db:is-raw
,db:is-raw
(new:db:type
).
- Version 9.3
- Added:
db:alter-backup
- Updated:
db:open-id
,db:open-pre
: support for multiple integers
- Version 9.2
- Version 9.0
- Added:
db:option
- Updated: db:output renamed to
update:output
, db:output-cache renamed toupdate:cache
- Updated: error codes updated; errors now use the module namespace
- Version 8.6
- Added:
db:property
- 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
- Added:
db:output-cache
- Removed: db:event
- Version 7.9
- Updated: parsing options added to
db:create
,db:add
anddb:replace
. - Updated: allow
UPDINDEX
if$all
istrue
.
- Version 7.8.2
- Added:
db:alter
,db:copy
,db:create-backup
,db:drop-backup
,db:restore
- Version 7.8
- Removed: db:fulltext (use
ft:search
instead)
- Version 7.7
- Added:
db:export
,db:name
,db:path
- Updated:
$options
argument added todb:create
anddb:optimize
. - Updated: the functions no longer accept database nodes as reference. Instead, the name of a database must now be specified.
- Version 7.6
- Updated:
db:create
: allow more than one input and path.
- Version 7.5
- Updated:
db:add
: input nodes will be automatically converted to document nodes - Added:
db:backups
- Added:
db:create
- Added:
db:drop
- Version 7.3
- Added:
db:flush
- Version 7.2.1
- Added:
db:text-range
,db:attribute-range
,db:output
- Version 7.1
- Added:
db:list-details
,db:content-type
- Updated:
db:info
,db:system
,db:retrieve
- Version 7.0