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

[Josh Moore]

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