Page MenuHomeSoftware Heritage
Paste P795

deposits with no XML
ActivePublic
Actions

Authored by vlorentz on Oct 1 2020, 10:59 AM.
softwareheritage-deposit=> select distinct metadata->>'{http://www.w3.org/2005/Atom}title', metadata->>'{https://doi.org/10.5063/SCHEMA/CODEMETA-2.0}name', max(deposit_request.date) from deposit_request, deposit where deposit_request.deposit_id=deposit.id and raw_metadata is null and metadata is not null group by metadata->>'{http://www.w3.org/2005/Atom}title', metadata->>'{https://doi.org/10.5063/SCHEMA/CODEMETA-2.0}name';
?column? | ?column? | max
---------------------------------------+-------------------------------------------------------------------------------------------------------------+-------------------------------
| The assignment problem | 2018-06-27 06:55:08.607636+00
| Composing a Web of Audio Applications | 2018-06-27 06:55:13.838716+00
| AffectationRO- The assignment problem | 2018-02-26 16:56:12.295115+00
| Tableur | 2018-03-20 12:09:07.937099+00
| The assignment problem | 2018-01-10 13:14:50.555143+00
Awesome Compiler | | 2018-01-10 11:15:09.227063+00
| You need such a software! | 2018-01-18 12:33:58.601575+00
| Pareto Graph Contraction Algorithm | 2018-04-06 14:26:19.153304+00
| name | 2018-01-19 11:34:09.447519+00
| Formal study in Coq of pi computations using arithmetic-geometric means | 2018-04-16 09:06:17.83487+00
| My very awesome software | 2018-01-18 12:16:14.563138+00
| | 2018-07-17 15:17:57.583629+00
| Test BM | 2018-01-10 12:09:39.975391+00
Composing a Web of Audio Applications | | 2017-10-25 13:16:06.456262+00
Je suis GPL | | 2018-02-01 11:05:13.103607+00
| MyMakeFile | 2017-12-21 09:48:23.001955+00
| MailSender4Hal | 2018-01-05 12:50:40.977218+00
| Battleship exercise | 2018-03-20 10:38:26.563157+00
| Porridge, an OCaml library implementing POR techniques for checking trace equivalence of security protocols | 2018-07-02 08:37:50.948657+00
| moldableILP | 2018-03-13 14:25:10.846694+00
| BM ConvLatex pour Test Software Heritage: Sur plateforme de test | 2018-07-04 07:33:26.430386+00

Event Timeline

vlorentz created this paste.Oct 1 2020, 10:59 AM
moranegg added a subscriber: moranegg.Oct 1 2020, 11:06 AM

I think that all are also tests, but I need the external_id column to be sure

moranegg added a comment.Oct 1 2020, 11:10 AM

Oh je-suis-GPL isn't a real test, di we really loose the xml for that?

vlorentz added a comment.Oct 1 2020, 11:31 AM
softwareheritage-deposit=> select distinct external_id, client_id, collection_id from deposit_request, deposit  where deposit_request.deposit_id=deposit.id and raw_metadata is null and metadata is not null;
 external_id  | client_id | collection_id 
--------------+-----------+---------------
 hal-01831369 |         2 |             1
 hal-01715124 |         2 |             1
 hal-01243573 |         2 |             1
 hal-01718131 |         2 |             1
 hal-01836189 |         2 |             1
 hal-01588927 |         2 |             1
 hal-01767263 |         2 |             1
 hal-01717498 |         2 |             1
 hal-01243618 |         2 |             1
 hal-01592430 |         2 |             1
 hal-01588781 |         2 |             1
 hal-01588942 |         2 |             1
 hal-01243617 |         2 |             1
 hal-01836169 |         2 |             1
 hal-01836266 |         2 |             1
 external-id  |         3 |             2
 hal-01760120 |         2 |             1
 hal-01588935 |         2 |             1
 hal-01588928 |         2 |             1
 hal-01831364 |         2 |             1
 hal-01588780 |         2 |             1
 hal-01243065 |         2 |             1
 hal-01588782 |         2 |             1
 hal-01727745 |         2 |             1
 hal-01837101 |         2 |             1
 je-suis-gpl  |         3 |             2
 hal-01715545 |         2 |             1
 external-id  |         2 |             1
 hal-01821474 |         2 |             1
About · Developer information · Legal