joshmoore
commented
1 year ago - [ ] add rows to eventlog
- [ ] better handling of "third" item in the list as .zattrs
- [ ] fill in more originalfile fields (see first comment)
Open joshmoore opened 1 year ago
joshmoore
commented
1 year ago joshmoore
commented
1 year ago idr=# select * from originalfile order by id desc limit 30;
id | atime | ctime | permissions | hash | mimetype | mtime | name | path | size | version | creation_id | external_id | group_id | owner_id | update_id | hasher | repo
----------+-------+-------------------------+-------------+------------------------------------------+----------------------------+-------------------------+------------------------+------------------------------------------------------------------------------------------+-------+---------+-------------+-------------+----------+----------+-----------+--------+--------------------------------------
50485811 | | | -56 | | application/octet-stream | | .zattrs | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/1/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485810 | | | -56 | | application/octet-stream | | .zgroup | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/1/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485809 | | | -56 | | application/octet-stream | | .zarray | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/1/1/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485808 | | | -56 | | Directory | | 1 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/1/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485807 | | | -56 | | application/octet-stream | | .zarray | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/1/0/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485806 | | | -56 | | Directory | | 0 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/1/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485805 | | | -56 | | Directory | | 1 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485804 | | | -56 | | application/octet-stream | | .zattrs | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/0/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485803 | | | -56 | | application/octet-stream | | .zgroup | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/0/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485802 | | | -56 | | application/octet-stream | | .zarray | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/0/1/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485801 | | | -56 | | Directory | | 1 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/0/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485800 | | | -56 | | application/octet-stream | | .zarray | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/0/0/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485799 | | | -56 | | Directory | | 0 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/0/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485798 | | | -56 | | Directory | | 0 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485797 | | | -56 | | application/octet-stream | | .zattrs | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485796 | | | -56 | | application/octet-stream | | .zgroup | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485795 | | | -56 | | application/octet-stream | | .zattrs | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/OME/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485794 | | | -56 | | application/octet-stream | | .zgroup | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/OME/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485793 | | | -56 | | application/octet-stream | | METADATA.ome.xml | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/OME/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485792 | | | -56 | | Directory | | OME | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/a.ome.zarr/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485791 | | | -56 | | Directory | | a.ome.zarr | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975_converted/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485790 | | | -56 | | Directory | | 12-46-39.975_converted | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/ | | | 326138781 | | 3 | 2 | 326138781 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485738 | | 2023-06-22 12:46:41.018 | -56 | f3e97f1f09d4241956301a1f3060302caa7a9e49 | | 2023-06-22 12:46:41.692 | a.fake.ini | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975/ | 9 | 0 | 326138714 | | 3 | 2 | 326138717 | 6 | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485737 | | 2023-06-22 12:46:41.018 | -56 | da39a3ee5e6b4b0d3255bfef95601890afd80709 | | 2023-06-22 12:46:41.397 | a.fake | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/12-46-39.975/ | 0 | 0 | 326138714 | | 3 | 2 | 326138715 | 6 | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485736 | | | -56 | | application/omero-log-file | | 12-46-39.975.log | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/ | 45691 | 0 | 326138713 | | 3 | 2 | 326138736 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485735 | | 2023-06-22 12:46:40.399 | -56 | | Directory | | 12-46-39.975 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/22/ | | 0 | 326138711 | | 1 | 2 | 326138711 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485734 | | 2023-06-22 12:46:40.285 | -56 | | Directory | | 22 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/2023-06/ | | 0 | 326138710 | | 1 | 2 | 326138710 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485733 | | 2023-06-22 12:46:40.023 | -56 | | Directory | | 2023-06 | demo_2/Blitz-0-Ice.ThreadPool.Server-2/ | | 0 | 326138709 | | 1 | 2 | 326138709 | | cdf35825-def1-4580-8d0b-9c349b8f78d6
50485732 | | 2023-06-16 11:58:35.873 | -56 | 4301000000000000 | | 2023-04-29 12:53:41 | .zarray | demo_2/Blitz-0-Ice.ThreadPool.Server-4/2023-06/16/11-56-13.628/Week1_22123.zarr/G/5/1/2/ | 323 | 0 | 326091771 | | 3 | 2 | 326096158 | 7 | cdf35825-def1-4580-8d0b-9c349b8f78d6