Page MenuHomeSoftware Heritage
Paste P460

bitbucket lister last entries (indexed by repo's creation date)
ActivePublic

Authored by ardumont on Jul 6 2019, 9:31 AM.
```
swh-lister=> select * from bitbucket_repo order by indexable desc limit 10;
name | full_name | html_url | origin_url | origin_type | last_seen | task_id | uid | indexable
------------------------------+----------------------------------------------+--------------------------------------------------------------------+------------------------------------------------------------------------+-------------+----------------------------+-----------+----------------------------------------+-------------------------------
issues_crud_hg | bb-synthetic_2-bot/issues_crud_hg | https://bitbucket.org/bb-synthetic_2-bot/issues_crud_hg | https://bitbucket.org/bb-synthetic_2-bot/issues_crud_hg | hg | 2019-07-06 07:23:56.735599 | 169799503 | {bf9c4d33-712b-4da3-b420-a959f53db27f} | 2019-07-06 07:23:52.331212+00
push-ssh_hg | bb-synthetic_11-bot/push-ssh_hg | https://bitbucket.org/bb-synthetic_11-bot/push-ssh_hg | https://bitbucket.org/bb-synthetic_11-bot/push-ssh_hg | hg | 2019-07-06 07:23:56.72974 | 169800059 | {469bda29-f883-4fac-b679-a7a5435edf47} | 2019-07-06 07:23:42.277378+00
issues_crud_git | bb-synthetic_14-bot/issues_crud_git | https://bitbucket.org/bb-synthetic_14-bot/issues_crud_git | https://bitbucket.org/bb-synthetic_14-bot/issues_crud_git.git | git | 2019-07-06 07:23:56.726666 | 169799507 | {4c95e100-a7c2-4b87-93f2-8b90a7523a00} | 2019-07-06 07:23:37.296924+00
push-newbranch-https_git | bb-synthetic_27-bot/push-newbranch-https_git | https://bitbucket.org/bb-synthetic_27-bot/push-newbranch-https_git | https://bitbucket.org/bb-synthetic_27-bot/push-newbranch-https_git.git | git | 2019-07-06 07:23:56.724102 | 169800057 | {2506b14f-45e6-433a-87c1-1102db94d34f} | 2019-07-06 07:23:35.877469+00
pull-ssh_hg | bb-synthetic_23-bot/pull-ssh_hg | https://bitbucket.org/bb-synthetic_23-bot/pull-ssh_hg | https://bitbucket.org/bb-synthetic_23-bot/pull-ssh_hg | hg | 2019-07-06 07:23:56.719526 | 169799519 | {08caf302-9c08-4a5c-9937-b89f5b3b7af6} | 2019-07-06 07:23:35.774458+00
ella | ELRAJEANEDEDAL/ella | https://bitbucket.org/ELRAJEANEDEDAL/ella | https://bitbucket.org/ELRAJEANEDEDAL/ella.git | git | 2019-07-06 07:23:56.715998 | 169800061 | {4a694561-452f-435a-9dcb-648264454790} | 2019-07-06 07:19:54.553818+00
HemperialCBD | hemperialcbd/hemperialcbd | https://bitbucket.org/hemperialcbd/hemperialcbd | https://bitbucket.org/hemperialcbd/hemperialcbd.git | git | 2019-07-06 07:23:56.712841 | 169800060 | {188c3524-fa42-4ca3-917e-797968830941} | 2019-07-06 07:18:08.916815+00
AccountService | timsawtell/accountservice | https://bitbucket.org/timsawtell/accountservice | https://bitbucket.org/timsawtell/accountservice.git | git | 2019-07-06 07:23:56.709601 | 169800062 | {025896de-9121-48ab-b93b-2a48fa1b57a6} | 2019-07-06 07:12:03.663197+00
teknikkompilasi | fataelislami/teknikkompilasi | https://bitbucket.org/fataelislami/teknikkompilasi | https://bitbucket.org/fataelislami/teknikkompilasi.git | git | 2019-07-06 07:23:56.706109 | 169800058 | {4a0cda85-06c2-498c-86e6-763eee3c7e47} | 2019-07-06 07:11:09.120796+00
rebrain-devops-task-checkout | rtzra/rebrain-devops-task-checkout | https://bitbucket.org/rtzra/rebrain-devops-task-checkout | https://bitbucket.org/rtzra/rebrain-devops-task-checkout.git | git | 2019-07-06 07:23:56.09893 | 169800026 | {648418d4-b6f0-4647-bcd7-bc62f660d811} | 2019-07-06 07:11:07.288939+00
(10 rows)
```