Page MenuHomeSoftware Heritage
Paste P1232

drop date field in debian lister extra arguments
ActivePublic

Authored by ardumont on Dec 3 2021, 2:09 PM.
14:09:12 swh-scheduler@db1:5432=> begin;
BEGIN
Time: 5.818 ms
14:09:14 *swh-scheduler@db1:5432=> update listed_origins set extra_loader_arguments = extra_loader_arguments - 'date' where visit_type='deb';
UPDATE 35105
Time: 3388.502 ms (00:03.389)
14:09:22 *swh-scheduler@db1:5432=> select url, extra_loader_arguments from listed_origins where visit_type='deb' and url = 'deb://Debian/packages/assword' limit 1;
+-------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| url | extra_loader_arguments |
+-------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| deb://Debian/packages/assword | {"packages": {"stretch/main/0.10-2": {"name": "assword", "files": {"assword_0.10-2.dsc": {"name": "assword_0.10-2.dsc", "size": 2006, "md5sum": "0bff6613a433ca69fc270948e36ac3bc", "sha256": "c632a47e0bdbf3add0561d10acc3a765457f97654f419ea21a7e922f14ae94e9"}, "assword_0.10.orig.tar.gz": {"name": "assword_0.10.orig.tar.gz", "size": 24647, "md5sum": "2d1f5ea092c9515c0774b75943074770", "sha256": "2a47ec871899284b9ddc88fc83c54e79e629df527f7f3571be2ff86a3c38c150"}, "assword_0.10-2.debian.tar.xz": {"name": "assword_0.10-2.debian.tar.xz", "size": 2704, "md5sum": "8972972f9b708ff14eff04f97ea5da6e", "sha256": "df7707494e5c9212d0c6cb29d38decd7ccec59662da136dccfa7e35c60e2d0ed"}}, "version": "0.10-2"}}} |
+-------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
(1 row)
Time: 5.171 ms