Page MenuHomeSoftware Heritage
Paste P644

psql service=staging-swh ; nixguix origin visits
ActivePublic
Actions

Authored by ardumont on Apr 9 2020, 10:10 AM.
psql service=staging-swh
psql (11.7, server 11.6 (Debian 11.6-1.pgdg100+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.
swh=> select * from origin o inner join origin_visit ov on o.id=ov.origin where o.url='https://nix-community.github.io/nixpkgs-swh/sources-unstable.json';
id | url | origin | visit | date | type | status | metadata | snapshot
-------+-------------------------------------------------------------------+--------+-------+-------------------------------+---------+---------+----------+--------------------------------------------
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 1 | 2020-04-02 15:29:27.811603+00 | nixguix | partial | |
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 2 | 2020-04-02 18:06:32.201307+00 | nixguix | partial | |
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 3 | 2020-04-03 14:02:31.593289+00 | nixguix | partial | |
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 4 | 2020-04-03 14:44:48.514733+00 | nixguix | partial | |
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 5 | 2020-04-04 09:55:51.907641+00 | nixguix | partial | |
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 6 | 2020-04-06 08:29:27.431316+00 | nixguix | partial | |
37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json | 37576 | 7 | 2020-04-07 16:08:56.976561+00 | nixguix | partial | | \x3a810cbc026b7bc147b535392babbda85942f906

Event Timeline

ardumont created this paste.Apr 9 2020, 10:10 AM
ardumont added a comment.Apr 9 2020, 10:24 AM

equivalent api call (browser): https://webapp.internal.staging.swh.network/api/1/origin/https://nix-community.github.io/nixpkgs-swh/sources-unstable.json/visits/

ardumont added a comment.EditedApr 20 2020, 3:33 PM
swh=> select * from origin o inner join origin_visit ov on o.id=ov.origin where o.url='https://nix-community.github.io/nixpkgs-swh/sources-unstable.json';
  id   |                                url                                | origin | visit |             date              |  type   | status  | metadata |                  snapshot
-------+-------------------------------------------------------------------+--------+-------+-------------------------------+---------+---------+----------+--------------------------------------------
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     1 | 2020-04-02 15:29:27.811603+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     2 | 2020-04-02 18:06:32.201307+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     3 | 2020-04-03 14:02:31.593289+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     4 | 2020-04-03 14:44:48.514733+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     5 | 2020-04-04 09:55:51.907641+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     6 | 2020-04-06 08:29:27.431316+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     7 | 2020-04-07 16:08:56.976561+00 | nixguix | partial |          | \x3a810cbc026b7bc147b535392babbda85942f906
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     8 | 2020-04-09 11:58:50.251787+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     9 | 2020-04-14 15:38:26.163045+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    10 | 2020-04-14 15:52:47.793209+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    11 | 2020-04-14 15:57:17.398971+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    12 | 2020-04-14 16:00:44.784147+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    13 | 2020-04-14 16:02:59.928223+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    14 | 2020-04-15 12:21:59.469303+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    15 | 2020-04-15 12:39:58.417827+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    16 | 2020-04-15 12:42:52.93652+00  | nixguix | partial |          | \xd820451681c74eec63693b6ea4e4b8417c76bb7a
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    17 | 2020-04-17 17:25:13.738789+00 | nixguix | partial |          | \xd20627c1ae2b5e553e8adcf625f37e37cc5190dd
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    18 | 2020-04-19 19:02:42.906079+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    19 | 2020-04-20 12:43:41.120422+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    20 | 2020-04-20 12:46:40.255418+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    21 | 2020-04-20 12:49:05.543821+00 | nixguix | ongoing |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |    22 | 2020-04-20 12:55:18.700015+00 | nixguix | ongoing |          |
(22 rows)
About · Developer information · Legal