Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/tests/test_backfill.py
| Show First 20 Lines • Show All 112 Lines • ▼ Show 20 Lines | def test_compute_query_origin_visit(): | ||||
| assert where_args == [1, 10] | assert where_args == [1, 10] | ||||
| assert column_aliases == [ | assert column_aliases == [ | ||||
| "visit", | "visit", | ||||
| "type", | "type", | ||||
| "origin", | "origin", | ||||
| "date", | "date", | ||||
| "snapshot", | |||||
| "status", | |||||
| "metadata", | |||||
| ] | ] | ||||
| assert ( | assert ( | ||||
| query | query | ||||
| == """ | == """ | ||||
| select visit,type,origin.url as origin,date,snapshot,status,metadata | select visit,type,origin.url as origin,date | ||||
| 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(): | ||||
| ▲ Show 20 Lines • Show All 107 Lines • Show Last 20 Lines | |||||