Easy way to delete all submissions

[Andreas Rain]

Hello,

my project has almost come to an end. Within the next days I'm going to
deploy the system on a live-server
(I was able to do all changes we wanted to dryad, so thanks for making
that possible).

Now there's one thing: The installation script you created doesn't
create the whole database and doesn't make
necessary insertions into the tables, so that the system could work. The
thing is that I have a running database.
The only thing I'd have to do now, is clearing all submissions and then
create a dump. I'd replace the database your
script creates with this one.

So my question now is: Is there an easy way to delete all the
submissions in the database? Do you have a script,
that does this?

Best regards,
Andreas

[Ryan Scherle]

Andreas,

Dryad wasn't designed for large-scale deletion, so we don't have a script to do this. But I can certainly see the need for such a script!

You can try deleting all of the content from the database tables that handle items and item content, including:
bi_2_dis
bi_2_dmap
bi_item
bi_withdrawn
bitstream
bundle
bundle2bitstream
collection2item
collection_item_count
dcvalue
epersongroup2workspaceitem
item
item2bundle
metadatavalue
tasklistitem
workflowitem
workspaceitem

After removing items from the database, you will need to rebuild the search index:
bin/dspace update-discovery-index

--- Ryan

> --
> You received this message because you are subscribed to the Google Groups "dryad-dev" group.
> To post to this group, send email to drya...@googlegroups.com.
> To unsubscribe from this group, send email to dryad-dev+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/dryad-dev?hl=en.
>

[Andreas Rain]

Hi there!

Thanks a lot Ryan. This is very helpful. I'm going to write a wiping
command and share it with you.
Now that I know which tables have to be wiped it's no problem.

Best regards,
Andreas

[Mark Diggory]

You may also want to reset the sequences associated with the row ids as well if your going to drop database contents directly in this manner. 

Also add the dryad custom versioning tables into this and the doi database contents as they will no longer apply to items that exist anymore.

Mark