topic Is it possible to delete a store in Alfresco Archive

Is it possible to delete a store

pmarreddy — Tue, 16 May 2006 05:52:38 GMT

I want to delete the content of a full store,Is there any mechanism to do this. If it is possible, what are its implicit and explicit conditionsIf it is not possible how to delete the store

Re: Is it possible to delete a store

derek — Fri, 30 Jun 2006 18:08:47 GMT

Hi,

No, there isn't a way to do it. It would have to be hooked into the system at a low level (NodeService) and the Lucene code would have to listen for it and remove the store's index files.

The content will take care of itself, then.

Regards

Re: Is it possible to delete a store

rdanner — Mon, 03 Jul 2006 04:39:13 GMT

Hi,

No, there isn't a way to do it. It would have to be hooked into the system at a low level (NodeService) and the Lucene code would have to listen for it and remove the store's index files.

The content will take care of itself, then.

Regards

Derek,

You are stating what would have to happen should this be possible? Is there a reason apart from time, technical or design issue why it is not yet possible to delete a store?

Re: Is it possible to delete a store

derek — Mon, 03 Jul 2006 09:47:31 GMT

Hi,

There is no technical reason why it has not been done. It's the first I've heard of it being required, but that doesn't mean that others wouldn't use the feature if it were there.

Regards

Re: Is it possible to delete a store

cludt — Wed, 23 Aug 2006 07:27:38 GMT

So, why did you guys implement the web service tests (contained in the SDK) in that way, that each time, a new store is created if you are not able to delete the stores again? I think, there is no way to do it manually, is there?

Maybe, you should think about changing the web service test, then. Wouldn't it be better to create new spaces in e.g. the workspace store for the WS tests? (Except from a test case where you want to create a new store, of course.)

Re: Is it possible to delete a store

sergio — Tue, 17 Oct 2006 11:51:35 GMT

Hi all!

I agree with all of you who have a need for a method that allows to delete stores. It could be useful to provide such a method in order to clean all the test stores created by the SDK examples.

However, what are the steps needed to be executed manually to delete each reference to a store for which protocol and id are well known?

All the best,

Sergio

Re: Is it possible to delete a store

cludt — Tue, 17 Oct 2006 12:06:44 GMT

Use the WebServiceAPI: For each reference, run a delete command:

RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();        
        
CMLDelete delete = new CMLDelete(new Predicate(new Reference[] {reference}, reference.getStore(), null));
CML cml = new CML();
cml.setDelete(new CMLDelete[] {delete});
        
// Execute the update
try {
   repositoryService.update(cml);
} catch (RepositoryFault e) {
   […]
} catch (RemoteException e) {
   […]
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Or create one delete for all references.

Re: Is it possible to delete a store

sergio — Tue, 17 Oct 2006 12:13:24 GMT

Many thanks, very useful.

But is the deleting a store procedure available only via WS?

All the best,

Sergio

Re: Is it possible to delete a store

cludt — Tue, 17 Oct 2006 12:20:04 GMT

At least not via the web interface. Maybe via the Java Content Repository API. But I have never worked with this, so I cannot tell.

Re: Is it possible to delete a store

cludt — Tue, 17 Oct 2006 12:34:37 GMT

Sorry sergio, there is no way to delete a store! Just to delete the content / spaces in a store that is usually not accessible via the web interface (e.g. stores created during the web service api test). The procedure I posted is only for deleting content / spaces!

Re: Is it possible to delete a store

sergio — Tue, 17 Oct 2006 13:29:35 GMT

Thanks Christian!

For the moment it is sufficient. However, after deleting the content of a store it could be convenient to delete the store itself in order to avoid an increasing of garbage inside tha alf_data folder.

I took a look at the structure of the alfresco schema inside my MySql database instance, I found some tables containing references to existing stores, for example the alf_store and alf_node tables. In your opinion could it be enough to delete store reference records from these two tables?

Cheers,

Sergio

Re: Is it possible to delete a store

cludt — Tue, 17 Oct 2006 13:53:06 GMT

Hi Sergio,

I am not sure if this works. The database and the file system are sort of synchronized. You would also have to delete the lucene index. I don't recommend to delete anything manually in the database. And, btw, the files in the alf_data won't be removed.

If you delete something via SOAP, the deleted items are placed in the "recycle bin", too. So, there might be a solution to delete the items finally.

I don't know anything about deleting a store, maybe one of the developers could help us here.

Regards
Christian