EXISTdB Database
Favorites
Notebook Data Access
Tags
Last edited time @December 8, 2024 10:06 PM
Archive
Created time @December 8, 2024 10:00 PM
INTRODUCTION
ExistDB allows the creation of collections. It only has one database that can hold
various collections. The Collections can hold xml documents. In Exist to find the
path to your database document the syntax goes by the following doc(’/db/path’)
doc('/db/economia/empresa.xml')
Update Statements In ExistDB
Insert - One or various nodes into one or more various
nodes
update insert (nodeAInserir | seqüènciaNodes)
(into | following | preceding) onInserir
EXISTdB Database 1
In case of sequence of nodes, each must go between parenthesis separated by
commas.
Insert - One or various attributes into one or more
nodes
update insert (attribute nomAtribut {'valor'},...)
(into | following | preceding) onInserir
The claus following and preceding are used to place attributes after and before a
specified attribute
Insert - One or more Nodes and Attributes into one or
moe nodes
update insert (seqüènciaAtributs, seqüènciaNodes)
(into | following | preceding) onInserir
The attributes must be inserted before the nodes. Sedna controls them but
❗
existdb doesn’t. So the order should be followed! The preceding and following
seems to not work so its better to use into
Rename - Rename a node or attribute
update rename nodeOAtributAReanomenar as 'nouNom'
o també
EXISTdB Database 2
for $n in nodeOAtributAReanomenar
return update rename $n as 'nouNom'
Replace Value - Substitute The Value Of
Nodes/Attributes
update value nodeOAtribut with 'nouValor'
o també
for $n in nodeOAtributAReanomenar
return update value $n with 'nouValor'
Replace - Nodes/Attributes
update replace nodeOAtribut with nouNodeONouAtribut
o també
for $n in nodeOAtributAReanomenar
return update replace $n with nouNodeONouAtribu
To indicate the new attribute, follow the rule indicated in the INSERT statement. In
eXist-db 2.0-5.2., replacing an attribute only replaces the content and not the
name of the attribute. Error maybe fixed in later versions
Delete - Delete nodes/attributes
update delete nodeOAtributAEliminar
EXISTdB Database 3