[ome-users] Partial Replication of OMERO data for TEST system: how to obtain user specific Pixels data as well?

[Rainer Poehlmann]

Hi Josh,

thanks a lot for your answer and the clarification!

Cheers,
-Rainer


On 07/15/2016 04:34 PM, Josh Moore wrote:
> On Wed, Jul 13, 2016 at 12:02 PM, Rainer Poehlmann
> <rainer.poehlmann at unibas.ch> wrote:
>> Hi Josh,
>
> Hi Rainer,
>
>
>> thanks a lot for your reply, it is making things much clearer.
>>
>>> The pyramid files can be found with `find /OMERO/Pixels -name "*_pyramid"`
>>
>>
>> May I then ask what all the other files within "Pixels" not named
>> "*_pyramid" are?
>
> These are either pre-OMERO5 (i.e. non-FS) images which were uploaded
> or generated images which have no associated original files.
>
>
>> Example:
>> (...)
>> -rw-rw-r-- 1 omeronas omeronas   14209619 Oct 18  2013 39851_pyramid
>> -rw-rw-r-- 1 omeronas omeronas   14343669 Oct 18  2013 39858_pyramid
>> -rw-rw-r-- 1 omeronas omeronas   14205337 Oct 18  2013 39870_pyramid
>> -rwxrwx--- 1 omeronas omeronas    2160000 Oct 18  2013 39922
>> -rwxrwx--- 1 omeronas omeronas    2160000 Oct 18  2013 39923
>> -rwxrwx--- 1 omeronas omeronas    2160000 Oct 18  2013 39924
>> (...)
>>
>>> In order to limit by user, you'd have to cross-check the pixel IDs in
>>> the DB. Happy to help with this if you'd like.
>>
>>
>> If possible, I would appreciate getting kind of an SQL example I could use
>> to identify the required pyramid files for a specific user.
>
> Paul's suggestion of using HQL (
> https://www.openmicroscopy.org/community/viewtopic.php?f=6&t=55&start=10#p15318
> )
> would also work, but if you'd prefer to do the same with SQL the equivalent to:
>
>   bin/omero login root at localhost
>   bin/omero hql -q --all --style plain --limit -1 --ids-only 'from
> Pixels where details.owner = 2'
>
> is:
>
>   psql omero -c "select id from pixels where owner_id = 2"
>
> Cheers,
> ~Josh.
>
>
>> Thanks & cheers,
>> -Rainer
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>