diff --git a/swh/journal/backfill.py b/swh/journal/backfill.py --- a/swh/journal/backfill.py +++ b/swh/journal/backfill.py @@ -87,7 +87,8 @@ ], 'snapshot': ['id', 'object_id'], 'origin': ['type', 'url'], - 'origin_visit': ['visit', 'type', 'url', 'date', 'snapshot', 'status'], + 'origin_visit': ['visit', 'type', 'url', 'date', + 'snapshot', 'status', 'metadata'], } diff --git a/swh/journal/tests/test_backfill.py b/swh/journal/tests/test_backfill.py --- a/swh/journal/tests/test_backfill.py +++ b/swh/journal/tests/test_backfill.py @@ -93,11 +93,11 @@ assert where_args == [1, 10] assert column_aliases == [ - 'visit', 'type', 'url', 'date', 'snapshot', 'status' + 'visit', 'type', 'url', 'date', 'snapshot', 'status', 'metadata', ] assert query == ''' -select visit,type,url,date,snapshot,status +select visit,type,url,date,snapshot,status,metadata from origin_visit left join origin on origin_visit.origin=origin.id where (origin_visit.origin) >= %s and (origin_visit.origin) < %s