Page MenuHomeSoftware Heritage
Paste P1531

(An Untitled Masterwork)
ActivePublic

Authored by vlorentz on Nov 24 2022, 1:36 PM.
softwareheritage=> select *, encode(name, 'escape') from snapshot_branch where target_type='revision' and target='\x7076613b79f425dc8bc3600a3253e9c0c9a3397e';
object_id | name | target | target_type | encode
-----------+----------------------------------------------+--------------------------------------------+-------------+-----------------------
133325445 | \x6275737465722f6d61696e2f322e372e302d32 | \x7076613b79f425dc8bc3600a3253e9c0c9a3397e | revision | buster/main/2.7.0-2
133383513 | \x756e737461626c652f6d61696e2f322e372e302d32 | \x7076613b79f425dc8bc3600a3253e9c0c9a3397e | revision | unstable/main/2.7.0-2
(2 lignes)
softwareheritage=> select * from snapshot_branches where branch_id in (133325445, 133383513);
snapshot_id | branch_id
-------------+-----------
26273242 | 133325445
51645287 | 133325445
26273242 | 133383513
(3 lignes)
softwareheritage=> select * from snapshot where object_id in (26273242, 51645287, 26273242);
object_id | id
-----------+--------------------------------------------
26273242 | \xa12431fe9c2051e8444364fdfdfffa5dad8697ed
51645287 | \xff1917af4f9cb653b9c4baca1ee5c6499f3a661f
(2 lignes)