[ome-users] Deleting OMERO.web shares

[Woodbridge, Mark R]

Perfect! Thanks Josh.

Would be great to see this in OMERO.web at some point.

________________________________________
From: ome-users-bounces at lists.openmicroscopy.org.uk [ome-users-bounces at lists.openmicroscopy.org.uk] On Behalf Of Josh Moore [josh.moore at gmx.de]
Sent: 11 June 2010 11:35
To: ome-users at lists.openmicroscopy.org.uk
Subject: Re: [ome-users] Deleting OMERO.web shares

(oops. Looks like this didn't go to the list. Re-sending after seeing
Ola's email)

Hi Mark.

at the moment, both the user and the application interfaces only provide
for disabling shares, not deleting them as a non-admin user. If you'd
like to do it at the SQL level, the only real quirks are to know that
Shares subclass Sessions and contain ShareMembers, so first you would
either remove all the users via the API or SQL:

In [9]: sharePrx = session.getShareService()
In [10]: sharePrx.createShare("example", None,
In [12]: sharePrx.createShare("example", None, None, None, None, None)
Out[12]: 60L
In [13]: sharePrx.addUser(60, omero.model.ExperimenterI(0, False))
In [15]: lst = sharePrx.getAllMembers(60)
In [16]: [x.omeName.val for x in lst]
Out[16]: ['root']
In [20]: sharePrx.getAllMembers(60)
Out[20]: []


omero=# delete from sharemember where parent = 60;
DELETE 1

Then to remove the shares, delete first the share and then the session:

omero=# delete from share where session_id = 60;
DELETE 1
omero=# delete from session where id = 60;
DELETE 1
omero=#

Cheers,
~Josh

On 6/9/10 7:23 PM, Woodbridge, Mark R wrote:
> Hi,
>
> Is it possible to delete (rather than deactivate) OMERO.web shares? I can't see how to do it in the UI and it doesn't appear to available using the API (ShareI.java). I've looked at share table in the database with a view to do it using SQL but it's a bit confusing.
>
> Perhaps I'm missing something?
>
> Mark.
>
_______________________________________________
ome-users mailing list
ome-users at lists.openmicroscopy.org.uk
http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users