Difference between revisions of "Database Module"
(48 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
=Conventions= | =Conventions= | ||
− | All functions 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 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/> |
− | |||
==Database Nodes== | ==Database Nodes== | ||
− | Database nodes are XML nodes which are either stored in a persistent database or | + | Database nodes are XML nodes which are either stored in a persistent database, or which are a node of a main-memory database representation. XML fragments can be converted to a main-memory database by e. g. applying the [[XQuery_Update#update|update]] or [[XQuery_Update#transform|transform]] expression on a node: |
<pre class="brush:xquery"> | <pre class="brush:xquery"> | ||
− | + | db:node-id(element hello { 'world' } update {}) | |
</pre> | </pre> | ||
Line 24: | Line 23: | ||
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns information on the database system | + | |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%' | ||
+ | |- | ||
+ | | width='120' | '''Signatures''' | ||
+ | |{{Func|db:option|$name as xs:string|xs:string}} | ||
+ | |- | ||
+ | | '''Summary''' | ||
+ | |Returns the current value (string, integer, boolean, map) of a global or local [[Options|Option]] with the specified {{Code|$name}}. The {{Command|GET}} command works similar. | ||
+ | |- | ||
+ | | '''Errors''' | ||
+ | |{{Error|option|#Errors}} the specified option is unknown. | ||
+ | |- | ||
+ | | '''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:chop 'true'; db:option('chop')</code> returns {{Code|true}} (irrespective of the global value). | ||
|} | |} | ||
Line 35: | Line 54: | ||
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns meta information on the database {{Code|$db}}. The output is similar to the | + | |Returns meta information on the database {{Code|$db}}. The output is similar to the {{Command|INFO DB}} command. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
+ | |} | ||
+ | |||
+ | ==db:property== | ||
+ | |||
+ | {| width='100%' | ||
+ | |- | ||
+ | | width='120' | '''Signatures''' | ||
+ | |{{Func|db:property|$db as xs:string, $name as xs:string|xs:anyAtomicType}} | ||
+ | |- | ||
+ | | '''Summary''' | ||
+ | |Returns the value (string, boolean, integer) of a property with the specified {{Code|$name}} in the database {{Code|$db}}. The available properties are the ones returned by [[#db:info|db:info]]. | ||
+ | |- | ||
+ | | '''Errors''' | ||
+ | |{{Error|property|#Errors}} the specified property is unknown. | ||
+ | |- | ||
+ | | '''Examples''' | ||
+ | | | ||
+ | * <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. | ||
|} | |} | ||
Line 50: | Line 89: | ||
| '''Summary''' | | '''Summary''' | ||
|The result of this function is dependent on the number of arguments: | |The result of this function is dependent on the number of arguments: | ||
− | * Without arguments, the names of all databases are returned. | + | * Without arguments, the names of all databases are returned that are accessible to the current user. |
* If a database {{Code|$db}} is specified, all documents and raw files of the specified database are returned. | * If a database {{Code|$db}} is specified, all documents and raw files of the specified database are returned. | ||
* The list of returned resources can be restricted by the {{Code|$path}} argument. | * The list of returned resources can be restricted by the {{Code|$path}} argument. | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 70: | Line 109: | ||
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Without arguments, an element is returned for each 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 and the database | + | * 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 a database {{Code|$db}} is specified, | + | If a database {{Code|$db}} is specified, an element for each documents and raw file of the specified 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). | ||
* Returned databases resources can be further restricted by the {{Code|$path}} argument. | * Returned databases resources can be further restricted by the {{Code|$path}} argument. | ||
− | |||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
| | | | ||
* {{Code|db:list-details("shop")}} returns the names plus additional info on all resources of a database named {{Code|shop}}. | * {{Code|db:list-details("shop")}} returns the names plus additional info on all resources of a database named {{Code|shop}}. | ||
+ | |} | ||
+ | |||
+ | ==db:dir== | ||
+ | |||
+ | {{Mark|Introduced with Version 9.2:}} | ||
+ | |||
+ | {| width='100%' | ||
+ | |- | ||
+ | | width='120' | '''Signatures''' | ||
+ | |{{Func|db:dir|$db as xs:string, $path as xs:string|element()*}} | ||
+ | |- | ||
+ | | '''Summary''' | ||
+ | |Returns meta data on all directories and resources of the database {{Code|$db}} in the specified directory {{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 as attribute. | ||
+ | Please note that directories are not stored in BaseX. Instead, they result implicitly from the paths of stored resources. | ||
+ | |- | ||
+ | | '''Errors''' | ||
+ | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified path is invalid. | ||
+ | |- | ||
+ | | '''Examples''' | ||
+ | | | ||
+ | * {{Code|db:dir('shop', 'books')}} returns all entries of the {{Code|books}} directory of a {{Code|shop}} database. | ||
|} | |} | ||
Line 113: | Line 175: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 133: | Line 195: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 151: | Line 213: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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 165: | Line 227: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 183: | Line 245: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database. |
|} | |} | ||
Line 197: | Line 259: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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). |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 203: | Line 265: | ||
* {{Code|db:retrieve("DB", "music/01.mp3")}} returns the specified audio file as raw data. | * {{Code|db:retrieve("DB", "music/01.mp3")}} returns the specified audio file as raw data. | ||
* <code><nowiki>stream:materialize(db:retrieve("DB", "music/01.mp3"))</nowiki></code> materializes the streamable result in main-memory before returning it. | * <code><nowiki>stream:materialize(db:retrieve("DB", "music/01.mp3"))</nowiki></code> materializes the streamable result in main-memory before returning it. | ||
+ | * <code><nowiki>convert:binary-to-string(db:retrieve("DB", "info.txt"), 'UTF-8')</nowiki></code> converts a binary database resource as UTF-8 text and returns a string. | ||
|} | |} | ||
Line 228: | Line 291: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 254: | Line 317: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{Func|db:text|$db as xs:string, $string | + | |{{Func|db:text|$db as xs:string, $strings as xs:string*|text()*}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all text nodes of the database {{Code|$db}} that have {{Code|$ | + | |Returns all text nodes of the database {{Code|$db}} that have one of the specified {{Code|$strings}} as values and that are stored in the text index. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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/> |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 278: | Line 341: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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/> |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 290: | Line 353: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{Func|db:attribute|$db as xs:string, $string | + | |{{Func|db:attribute|$db as xs:string, $strings as xs:string*|attribute()*}}<br/>{{Func|db:attribute|$db as xs:string, $strings as xs:string*, $name as xs:string|attribute()*}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all attribute nodes of the database {{Code|$db}} that have {{Code|$ | + | |Returns all attribute nodes of the database {{Code|$db}} that have one of the specified {{Code|$strings}} as 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. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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/> |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 314: | Line 377: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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/> |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 326: | Line 389: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{Func|db:token|$db as xs:string, $ | + | |{{Func|db:token|$db as xs:string, $tokens as xs:string*|attribute()*}}<br/>{{Func|db:token|$db as xs:string, $tokens as xs:string*, $name as xs:string|attribute()*}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Returns all attribute nodes of the database {{Code|$db}} | + | |Returns all attribute nodes of the database {{Code|$db}} 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. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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/> |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 348: | Line 411: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{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 map(*)|empty-sequence()}} | + | |{{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 map(*)?|empty-sequence()}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
Line 356: | Line 419: | ||
** 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) | ||
** a path must be specified if the input is not a file or directory reference | ** a path must be specified if the input is not a file or directory reference | ||
− | * The {{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 |
− | ** | + | ** 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. | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 384: | Line 448: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 396: | Line 460: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{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()}}<br/>{{Func|db:add|$db as xs:string, $input as item(), $path as xs:string, $options as map(*)|empty-sequence()|empty-sequence()}} | + | |{{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()}}<br/>{{Func|db:add|$db as xs:string, $input as item(), $path as xs:string, $options as map(*)?|empty-sequence()|empty-sequence()}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
|Adds documents specified by {{Code|$input}} to the database {{Code|$db}} with the specified {{Code|$path}}: | |Adds documents specified by {{Code|$input}} to the database {{Code|$db}} 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 [[#db:replace|db:replace]] instead. | * A document with the same path may occur more than once in a database. If you want to enforce single instances, use [[#db:replace|db:replace]] instead. | ||
− | * | + | * See [[#db:create|db:create]] for more details on the input argument. |
+ | * 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 | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''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", <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}}. In order to reduce memory consumption, the files will be cached before being added to the database. |
|} | |} | ||
Line 424: | Line 491: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|path|#Errors}} the specified path is invalid. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 437: | Line 504: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{Func|db:copy|$db as xs:string, $ | + | |{{Func|db:copy|$db as xs:string, $name as xs:string|empty-sequence()}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Creates a copy of the database | + | |Creates a copy of the database {{Code|$db}}, which will be called {{Code|$name}}. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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 451: | Line 518: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{Func|db:alter|$db as xs:string, $ | + | |{{Func|db:alter|$db as xs:string, $name as xs:string|empty-sequence()}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | |Renames the database | + | |Renames the database {{Code|$db}} to {{Code|$name}}. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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 471: | Line 538: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 489: | Line 556: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 508: | Line 575: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 521: | Line 588: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{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 map(*)|empty-sequence()}} | + | |{{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 map(*)?|empty-sequence()}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
Line 527: | Line 594: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 546: | Line 613: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 559: | Line 626: | ||
|- | |- | ||
| width='120' | '''Signatures''' | | width='120' | '''Signatures''' | ||
− | |{{Func|db:replace|$db as xs:string, $path as xs:string, $input as item()|empty-sequence()}}<br/>{{Func|db:replace|$db as xs:string, $path as xs:string, $input as item(), $options as map(*)|empty-sequence()|empty-sequence()}} | + | |{{Func|db:replace|$db as xs:string, $path as xs:string, $input as item()|empty-sequence()}}<br/>{{Func|db:replace|$db as xs:string, $path as xs:string, $input as item(), $options as map(*)?|empty-sequence()|empty-sequence()}} |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
|Replaces a resource, specified by {{Code|$path}}, in the database {{Code|$db}} with the contents of {{Code|$input}}, or adds it as a new resource: | |Replaces a resource, specified by {{Code|$path}}, in the database {{Code|$db}} with the contents of {{Code|$input}}, or adds it as a new resource: | ||
− | * See [[#db: | + | * See [[#db:create|db:create]] for more details on the input argument. |
+ | * 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 | ||
+ | * For historical reasons, the order of the 2nd and 3rd argument is different to [[#db:add|db:add]] and [[#db:create|db:create]] | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened.<br/>{{Error|target|#Errors}} the path points to a directory. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 591: | Line 662: | ||
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
− | | | + | |Replaces a binary resource specified by {{Code|$input}} in the database {{Code|$db}} and the location specified by {{Code|$path}}, or adds it as new resource. |
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{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). |
|- | |- | ||
| '''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:store("DB", "video/sample.mov", file:read-binary('video.mov'))}} stores the addressed video file at the specified location. | ||
− | + | * With the following query, you can copy full directories: | |
− | + | <pre class="brush:xquery"> | |
− | + | let $db := 'db' | |
− | + | let $src-path := 'src/' | |
− | + | let $trg-path := 'trg/' | |
− | + | for $src in db:list($db, $src-path) | |
− | + | where db:is-raw($db, $src) | |
− | + | let $trg := $trg-path || substring-after($src, $src-path) | |
− | + | return db:store($db, $trg, db:retrieve($db, $src)) | |
− | + | </pre> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | | | ||
− | |||
− | |||
− | |||
|} | |} | ||
Line 638: | Line 693: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|} | |} | ||
Line 654: | Line 709: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database. |
|} | |} | ||
Line 668: | Line 723: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|node|#Errors}} {{Code|$nodes}} contains a node which is not stored in a database. |
|} | |} | ||
Line 698: | Line 753: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 713: | Line 768: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Summary''' | | '''Summary''' | ||
Line 734: | Line 789: | ||
|- | |- | ||
| '''Errors''' | | '''Errors''' | ||
− | |{{Error| | + | |{{Error|open|#Errors}} the addressed database does not exist or could not be opened. |
|- | |- | ||
| '''Examples''' | | '''Examples''' | ||
Line 749: | Line 804: | ||
|Description | |Description | ||
|- | |- | ||
− | |{{Code| | + | |{{Code|args}} |
− | |The | + | |The number of specified inputs and paths differs. |
+ | |- | ||
+ | |{{Code|conflict}} | ||
+ | |Multiple update operations point to the same target. | ||
|- | |- | ||
− | |{{Code| | + | |{{Code|lock}} |
− | | | + | |A database cannot be updated because it is opened by another process. |
|- | |- | ||
− | |{{Code| | + | |{{Code|mainmem}} |
|The addressed database is not ''persistent'' (stored on disk). | |The addressed database is not ''persistent'' (stored on disk). | ||
|- | |- | ||
− | |{{Code| | + | |{{Code|name}} |
− | |The database | + | |The name of the specified database is invalid. |
|- | |- | ||
− | |{{Code| | + | |{{Code|no-backup}} |
− | | | + | |No backup exists for a database. |
|- | |- | ||
− | |{{Code| | + | |{{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. |
|- | |- | ||
− | |{{Code| | + | |{{Code|no-index}} |
− | | | + | |The database lacks an index structure required by the called function. |
|- | |- | ||
− | |{{Code| | + | |{{Code|open}} |
− | |The | + | |The addressed database does not exist or could not be opened. |
|- | |- | ||
− | |{{Code| | + | |{{Code|option}} |
− | |The | + | |The specified option is unknown. |
|- | |- | ||
− | |{{Code| | + | |{{Code|path}} |
− | |The | + | |The specified database path is invalid. |
|- | |- | ||
− | |{{Code| | + | |{{Code|property}} |
− | | | + | |The specified database property is unknown. |
|- | |- | ||
− | |{{Code| | + | |{{Code|range}} |
− | |The | + | |The addressed database id or pre value is out of range. |
|- | |- | ||
− | |{{Code| | + | |{{Code|target}} |
− | |Path points to | + | |Path points to an invalid target. |
|} | |} | ||
=Changelog= | =Changelog= | ||
+ | |||
+ | ;Version 9.2 | ||
+ | |||
+ | * Added: [[#db:dir|db:dir]] | ||
+ | |||
+ | ;Version 9.0 | ||
+ | |||
+ | * Added: [[#db:option|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: [[#db:property|db:property]] | ||
;Version 8.4 | ;Version 8.4 | ||
+ | |||
* Updated: [[#db:create|db:create]], [[#db:add|db:add]], [[#db:replace|db:replace]]: support for {{Code|ADDCACHE}} option. | * Updated: [[#db:create|db:create]], [[#db:add|db:add]], [[#db:replace|db:replace]]: support for {{Code|ADDCACHE}} option. | ||
* Added: [[#db:token|db:token]] | * Added: [[#db:token|db:token]] | ||
;Version 8.3 | ;Version 8.3 | ||
+ | |||
* Updated: [[#db:list-details|db:list-details]]: attributes with name of database and date of backup added to results. | * Updated: [[#db:list-details|db:list-details]]: attributes with name of database and date of backup added to results. | ||
* Updated: [[#db:backups|db:backups]] now include attributes with name of database and date of backup. | * Updated: [[#db:backups|db:backups]] now include attributes with name of database and date of backup. | ||
Line 801: | Line 875: | ||
;Version 8.2 | ;Version 8.2 | ||
+ | |||
* Added: [[#db:output-cache|db:output-cache]] | * Added: [[#db:output-cache|db:output-cache]] | ||
* Removed: db:event | * Removed: db:event | ||
;Version 7.9 | ;Version 7.9 | ||
+ | |||
* Updated: parsing options added to [[#db:create|db:create]], [[#db:add|db:add]] and [[#db:replace|db:replace]]. | * Updated: parsing options added to [[#db:create|db:create]], [[#db:add|db:add]] and [[#db:replace|db:replace]]. | ||
* Updated: allow {{Option|UPDINDEX}} if {{Code|$all}} is {{Code|true}}. | * Updated: allow {{Option|UPDINDEX}} if {{Code|$all}} is {{Code|true}}. | ||
;Version 7.8.2 | ;Version 7.8.2 | ||
+ | |||
* Added: [[#db:alter|db:alter]], [[#db:copy|db:copy]], [[#db:create-backup|db:create-backup]], [[#db:drop-backup|db:drop-backup]], [[#db:restore|db:restore]] | * Added: [[#db:alter|db:alter]], [[#db:copy|db:copy]], [[#db:create-backup|db:create-backup]], [[#db:drop-backup|db:drop-backup]], [[#db:restore|db:restore]] | ||
;Version 7.8 | ;Version 7.8 | ||
+ | |||
* Removed: db:fulltext (use [[Full-Text Module#ft:search|ft:search]] instead) | * Removed: db:fulltext (use [[Full-Text Module#ft:search|ft:search]] instead) | ||
Revision as of 11:06, 20 May 2019
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
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
Database nodes are XML nodes which are either stored in a persistent database, or which are a node of a main-memory database representation. XML fragments can be converted to a main-memory database by e. g. applying the update or transform expression on a node:
db:node-id(element hello { 'world' } update {})
General Functions
db:system
Signatures | 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
Signatures | 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 GET command works similar.
|
Errors | option : the specified option is unknown.
|
Examples |
|
db:info
Signatures | db:info($db as xs:string) as element(database)
|
Summary | Returns meta information on the database $db . The output is similar to the INFO DB command.
|
Errors | open : the addressed database does not exist or could not be opened.
|
db:property
Signatures | db:property($db 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 database $db . The available properties are the ones returned by db:info.
|
Errors | property : the specified property is unknown.
|
Examples |
|
db:list
Signatures | db:list() as xs:string* db:list($db as xs:string) as xs:string* db:list($db as xs:string, $path as xs:string) as xs:string*
|
Summary | The result of this function is dependent on the number of arguments:
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
db:list-details
Signatures | db:list-details() as element(database)* db:list-details($db as xs:string) as element(resource)* db:list-details($db as xs:string, $path as xs:string) as element(resource)*
|
Summary | Without arguments, an element is returned for each database that is accessible to the current user:
If a database
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
db:dir
Signatures | db:dir($db as xs:string, $path as xs:string) as element()*
|
Summary | Returns meta data on all directories and resources of the database $db in the specified directory $path . Two types of elements are returned:
Please note that directories are not stored in BaseX. 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:backups
Signatures | db:backups() as element(backup)* db:backups($db as xs:string) as element(backup)*
|
Summary | Returns an element sequence containing all available database backups. If a database $db is specified, the sequence will be restricted to the backups matching this database.
|
Examples |
|
Read Operations
db:open
Signatures | db:open($db as xs:string) as document-node()* db:open($db as xs:string, $path as xs:string) as document-node()*
|
Summary | Opens the database $db and returns all document nodes.The document nodes to be returned can be filtered with the $path argument.
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
db:open-pre
Signatures | db:open-pre($db as xs:string, $pre as xs:integer) as node()
|
Summary | Opens the database $db and returns the node with the specified $pre value.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:open-id
Signatures | db:open-id($db as xs:string, $id as xs:integer) as node()
|
Summary | Opens the database $db and returns the node with the specified $id value.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:node-pre
Signatures | db:node-pre($nodes as node()*) as xs:integer*
|
Summary | Returns the pre values of the nodes supplied by $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
Signatures | db:node-id($nodes as node()*) as xs:integer*
|
Summary | Returns the id values of the nodes supplied by $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:retrieve
Signatures | db:retrieve($db as xs:string, $path as xs:string) as xs:base64Binary
|
Summary | Returns a binary resource addressed by the database $db and $path as streamable xs:base64Binary .
|
Errors | open : the addressed database does not exist or could not be opened.mainmem : the database is not persistent (stored on disk).
|
Examples |
|
db:export
Signatures | db:export($db as xs:string, $path as xs:string) as empty-sequence() db:export($db as xs:string, $path as xs:string, $params as item()) as empty-sequence() |
Summary | Exports the specified database $db to the specified file $path . Existing files will be overwritten. The $params argument contains serialization parameters (see Serialization for more details), which can either be specified
<output:serialization-parameters> <output:method value='xml'/> <output:cdata-section-elements value="div"/> ... </output:serialization-parameters>
map { "method": "xml", "cdata-section-elements": "div", ... } |
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 query can be used to export parts of the database: let $target := '/home/john/xml/target' for $doc in db:open('DB', 'collection') let $path := $target || db:path($doc) return ( file:create-dir(file:parent($path)), file:write($path, $doc) ) |
Value Indexes
db:text
Signatures | db:text($db as xs:string, $strings as xs:string*) as text()*
|
Summary | Returns all text nodes of the database $db that have one of the specified $strings as 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
Signatures | db:text-range($db as xs:string, $min as xs:string, $max as xs:string) as text()*
|
Summary | Returns all text nodes of the database $db that are located in between the $min and $max strings 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
Signatures | db:attribute($db as xs:string, $strings as xs:string*) as attribute()* db:attribute($db as xs:string, $strings as xs:string*, $name as xs:string) as attribute()*
|
Summary | Returns all attribute nodes of the database $db that have one of the specified $strings as 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
Signatures | db:attribute-range($db as xs:string, $min as xs:string, $max as xs:string) as attribute()* db:attribute-range($db as xs:string, $min as xs:string, $max as xs:string, $name as xs:string) as attribute()*
|
Summary | Returns all attributes of the database $db , the string values of which 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
Signatures | db:token($db as xs:string, $tokens as xs:string*) as attribute()* db:token($db as xs:string, $tokens as xs:string*, $name as xs:string) as attribute()*
|
Summary | Returns all attribute nodes of the database $db 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
Important note: All functions in this section are updating functions: they will not be immediately executed, but queued on the 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.
db:create
Signatures | db:create($db as xs:string) as empty-sequence() db:create($db as xs:string, $inputs as item()*) as empty-sequence() db:create($db as xs:string, $inputs as item()*, $paths as xs:string*) as empty-sequence() db:create($db as xs:string, $inputs as item()*, $paths as xs:string*, $options as map(*)?) as empty-sequence()
|
Summary | Creates a new database with name $db and adds initial documents specified via $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:drop
Signatures | db:drop($db as xs:string) as empty-sequence()
|
Summary | Drops the database $db 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:add
Signatures | db:add($db as xs:string, $input as item()) as empty-sequence() db:add($db as xs:string, $input as item(), $path as xs:string) as empty-sequence() db:add($db as xs:string, $input as item(), $path as xs:string, $options as map(*)?) as empty-sequence()
|
Summary | Adds documents specified by $input to the database $db with the specified $path :
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
db:delete
Signatures | db:delete($db as xs:string, $path as xs:string) as empty-sequence()
|
Summary | Deletes resource(s), specified by $path , from the database $db .
|
Errors | open : the addressed database does not exist or could not be opened.path : the specified path is invalid.
|
Examples |
|
db:copy
Signatures | db:copy($db as xs:string, $name as xs:string) as empty-sequence()
|
Summary | Creates a copy of the database $db , which will be called $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
Signatures | db:alter($db as xs:string, $name as xs:string) as empty-sequence()
|
Summary | Renames the database $db to $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:create-backup
Signatures | db:create-backup($db as xs:string) as empty-sequence()
|
Summary | Creates a backup of the database $db .
|
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
Signatures | db:drop-backup($name as xs:string) as empty-sequence()
|
Summary | Drops all backups of the database with the specified $name . If the given $name points to a specific backup file, only this specific backup file is deleted.
|
Errors | backup : No backup file found.name : invalid database name.conflict : the same database was addressed more than once.
|
Examples |
|
db:restore
Signatures | 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.
|
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:optimize
Signatures | db:optimize($db as xs:string) as empty-sequence() db:optimize($db as xs:string, $all as xs:boolean) as empty-sequence() db:optimize($db as xs:string, $all as xs:boolean, $options as map(*)?) as empty-sequence()
|
Summary | Optimizes the meta data and indexes of the database $db .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
Signatures | db:rename($db as xs:string, $source as xs:string, $target as xs:string) as empty-sequence()
|
Summary | Moves all resources(s) of database $db , 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:replace
Signatures | db:replace($db as xs:string, $path as xs:string, $input as item()) as empty-sequence() db:replace($db as xs:string, $path as xs:string, $input as item(), $options as map(*)?) as empty-sequence()
|
Summary | Replaces a resource, specified by $path , in the database $db 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:replace('db', $file, doc($path)) |
db:store
Signatures | db:store($db as xs:string, $path as xs:string, $input as item()) as empty-sequence()
|
Summary | Replaces a binary resource specified by $input in the database $db and the location specified by $path , or adds it as new resource.
|
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:is-raw($db, $src) let $trg := $trg-path || substring-after($src, $src-path) return db:store($db, $trg, db:retrieve($db, $src)) |
db:flush
Signatures | db:flush($db as xs:string) as empty-sequence()
|
Summary | Explicitly flushes the buffers of the database $db . 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.
|
Helper Functions
db:name
Signatures | 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
Signatures | 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
Signatures | db:exists($db as xs:string) as xs:boolean db:exists($db as xs:string, $path as xs:string) as xs:boolean
|
Summary | Checks if the database $db or the resource specified by $path exists. false is returned if a database directory has been addressed.
|
Examples |
|
db:is-raw
Signatures | db:is-raw($db as xs:string, $path as xs:string) as xs:boolean
|
Summary | Checks if the specified resource in the database $db and the path $path exists, and if it is a binary resource.
|
Errors | open : the addressed database does not exist or could not be opened.
|
Examples |
|
db:is-xml
Signatures | db:is-xml($db as xs:string, $path as xs:string) as xs:boolean
|
Errors | open : the addressed database does not exist or could not be opened.
|
Summary | Checks if the specified resource in the database $db and the path $path exists, and if it is an XML document.
|
Examples |
|
db:content-type
Signatures | db:content-type($db as xs:string, $path as xs:string) as xs:string
|
Summary | Retrieves the content type of a resource in the database $db and the path $path .The file extension is used to recognize the content-type of a resource stored in the database. Content-type 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
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
- Version 9.2
- Added: db:dir
- 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
- Updated: db:create, db:add, db:replace: support for
ADDCACHE
option. - Added: db:token
- 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 and db: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 to db:create and db: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