Changeset View
Changeset View
Standalone View
Standalone View
swh/journal/tests/test_backfill.py
| Show First 20 Lines • Show All 87 Lines • ▼ Show 20 Lines | |||||
| def test_compute_query_origin_visit(): | def test_compute_query_origin_visit(): | ||||
| query, where_args, column_aliases = compute_query( | query, where_args, column_aliases = compute_query( | ||||
| 'origin_visit', 1, 10) | 'origin_visit', 1, 10) | ||||
| assert where_args == [1, 10] | assert where_args == [1, 10] | ||||
| assert column_aliases == [ | assert column_aliases == [ | ||||
| 'visit', 'type', 'url', 'date', 'snapshot', 'status', 'metadata', | 'visit', 'origin.type', 'origin_visit.type', | ||||
| 'url', 'date', 'snapshot', 'status', 'metadata', | |||||
| ] | ] | ||||
| assert query == ''' | assert query == ''' | ||||
| select visit,type,url,date,snapshot,status,metadata | select visit,origin.type,origin_visit.type,url,date,snapshot,status,metadata | ||||
| from origin_visit | from origin_visit | ||||
| left join origin on origin_visit.origin=origin.id | left join origin on origin_visit.origin=origin.id | ||||
| where (origin_visit.origin) >= %s and (origin_visit.origin) < %s | where (origin_visit.origin) >= %s and (origin_visit.origin) < %s | ||||
| ''' | ''' | ||||
| def test_compute_query_release(): | def test_compute_query_release(): | ||||
| query, where_args, column_aliases = compute_query( | query, where_args, column_aliases = compute_query( | ||||
| Show All 15 Lines | |||||