search

ecolabdata / ecospheres-dashboard-backend

0 stars 0 forks source link

Fix harvest.* typing #12

Open streino opened 1 day ago

streino commented 1 day ago

Fix https://github.com/ecolabdata/ecospheres/issues/410

demo=# \d catalog
                                                 Table "public.catalog"
            Column            |            Type             | Collation | Nullable |               Default               
------------------------------+-----------------------------+-----------+----------+-------------------------------------
 ...
 harvest__backend             | text                        |           |          | 
 harvest__source_id           | text                        |           |          | 
 harvest__remote_id           | text                        |           |          | 
 harvest__domain              | text                        |           |          | 
 harvest__last_update         | timestamp without time zone |           |          | 
 harvest__remote_url          | text                        |           |          | 
 harvest__uri                 | text                        |           |          | 
 harvest__dct_identifier      | text                        |           |          | 
 harvest__created_at          | timestamp without time zone |           |          | 
 harvest__modified_at         | timestamp without time zone |           |          | 
demo=# select dataset_id, harvest__source_id, harvest__created_at, harvest__modified_at, harvest__last_update from catalog limit 2;
        dataset_id        |    harvest__source_id    | harvest__created_at | harvest__modified_at |  harvest__last_update   
--------------------------+--------------------------+---------------------+----------------------+-------------------------
 6707388aeabdb61dd47ed652 | 6703b4870724a55efd609b84 | 2023-03-01 00:00:00 | 2023-01-24 00:00:00  | 2024-10-18 00:18:55.147
 6707388aeabdb61dd47ed651 | 6703b4870724a55efd609b84 | 2022-05-25 00:00:00 | 2023-01-24 00:00:00  | 2024-10-18 00:18:55.095