Hello Irfan,

The nodes are actually deleted and the operation is commited. The update invalidates the meta data (e.g. the size), so to reflect the changes you can run the OPTIMIZE command. See https://docs.basex.org/wiki/Commands#OPTIMIZE for some more information.

Cheers, Dirk

On 06/02/14 13:35, Irfan Khan wrote:

Hello,

I am new to BaseX and am doing basic manipulations, but can't delete nodes/elements permanently from a Database.

So these are my databases:

...

list

name Resources Size Input Path

Example 1 34928 Experiment_Owner 3 4651 Store 3 14015 TestbyIrfan 0 4541 Users 299 86299 Workon 1 4753

6 database(s)

open Users

XQUERY /

<user> <fullname>null</fullname> <username>user590</username> <password>3b36431be670500f759191b1cc27adc3</password> <experiments/> <email>email</email> <role>ROLE_BEE</role> </user><user> <fullname>null</fullname> <username>user591</username> <password>18b944141c4104d3a577516e7aa429</password> <experiments/> <email>email</email> <role>ROLE_BEE</role> </user>

afterwards to delete the users I tried commands such as:

XQUERY delete node db:open("Users")//user or

XQUERY for $v in /user where $v[contains(username,"user")] return delete node $v/user

then the records disappear, the command XQUERY / doesn't show the records of users, however when I do a command list,

the size of the database and the number of resources don't change.

I tried to do an Export like: EXPORT /root/BEES_CENTRAL/BaseXData/data but no change....

So my question is how can I commit the changes made by Delete to disk permanently ?

Thanks a lot.

Regards,

Irfan

---

BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk