Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/backfill.py
| Show First 20 Lines • Show All 73 Lines • ▼ Show 20 Lines | "skipped_content": [ | ||||
| "sha1_git", | "sha1_git", | ||||
| "sha256", | "sha256", | ||||
| "blake2s256", | "blake2s256", | ||||
| "length", | "length", | ||||
| "ctime", | "ctime", | ||||
| "status", | "status", | ||||
| "reason", | "reason", | ||||
| ], | ], | ||||
| "directory": ["id", "dir_entries", "file_entries", "rev_entries"], | "directory": ["id", "dir_entries", "file_entries", "rev_entries", "raw_manifest"], | ||||
| "extid": ["extid_type", "extid", "extid_version", "target_type", "target"], | "extid": ["extid_type", "extid", "extid_version", "target_type", "target"], | ||||
| "metadata_authority": ["type", "url"], | "metadata_authority": ["type", "url"], | ||||
| "metadata_fetcher": ["name", "version"], | "metadata_fetcher": ["name", "version"], | ||||
| "origin": ["url"], | "origin": ["url"], | ||||
| "origin_visit": ["visit", "type", ("origin.url", "origin"), "date",], | "origin_visit": ["visit", "type", ("origin.url", "origin"), "date",], | ||||
| "origin_visit_status": [ | "origin_visit_status": [ | ||||
| ("origin_visit_status.visit", "visit"), | ("origin_visit_status.visit", "visit"), | ||||
| ("origin.url", "origin"), | ("origin.url", "origin"), | ||||
| Show All 21 Lines | "raw_extrinsic_metadata": [ | ||||
| "path", | "path", | ||||
| "directory", | "directory", | ||||
| ], | ], | ||||
| "revision": [ | "revision": [ | ||||
| ("revision.id", "id"), | ("revision.id", "id"), | ||||
| "date", | "date", | ||||
| "date_offset", | "date_offset", | ||||
| "date_neg_utc_offset", | "date_neg_utc_offset", | ||||
| "date_offset_bytes", | |||||
| "committer_date", | "committer_date", | ||||
| "committer_date_offset", | "committer_date_offset", | ||||
| "committer_date_neg_utc_offset", | "committer_date_neg_utc_offset", | ||||
| "committer_date_offset_bytes", | |||||
| "type", | "type", | ||||
| "directory", | "directory", | ||||
| "message", | "message", | ||||
| "synthetic", | "synthetic", | ||||
| "metadata", | "metadata", | ||||
| "extra_headers", | "extra_headers", | ||||
| ( | ( | ||||
| "array(select parent_id::bytea from revision_history rh " | "array(select parent_id::bytea from revision_history rh " | ||||
| "where rh.id = revision.id order by rh.parent_rank asc)", | "where rh.id = revision.id order by rh.parent_rank asc)", | ||||
| "parents", | "parents", | ||||
| ), | ), | ||||
| "raw_manifest", | |||||
| ("a.id", "author_id"), | ("a.id", "author_id"), | ||||
| ("a.name", "author_name"), | ("a.name", "author_name"), | ||||
| ("a.email", "author_email"), | ("a.email", "author_email"), | ||||
| ("a.fullname", "author_fullname"), | ("a.fullname", "author_fullname"), | ||||
| ("c.id", "committer_id"), | ("c.id", "committer_id"), | ||||
| ("c.name", "committer_name"), | ("c.name", "committer_name"), | ||||
| ("c.email", "committer_email"), | ("c.email", "committer_email"), | ||||
| ("c.fullname", "committer_fullname"), | ("c.fullname", "committer_fullname"), | ||||
| ], | ], | ||||
| "release": [ | "release": [ | ||||
| ("release.id", "id"), | ("release.id", "id"), | ||||
| "date", | "date", | ||||
| "date_offset", | "date_offset", | ||||
| "date_neg_utc_offset", | "date_neg_utc_offset", | ||||
| "date_offset_bytes", | |||||
| "comment", | "comment", | ||||
| ("release.name", "name"), | ("release.name", "name"), | ||||
| "synthetic", | "synthetic", | ||||
| "target", | "target", | ||||
| "target_type", | "target_type", | ||||
| ("a.id", "author_id"), | ("a.id", "author_id"), | ||||
| ("a.name", "author_name"), | ("a.name", "author_name"), | ||||
| ("a.email", "author_email"), | ("a.email", "author_email"), | ||||
| ("a.fullname", "author_fullname"), | ("a.fullname", "author_fullname"), | ||||
| "raw_manifest", | |||||
| ], | ], | ||||
| "snapshot": ["id", "object_id"], | "snapshot": ["id", "object_id"], | ||||
| } | } | ||||
| JOINS = { | JOINS = { | ||||
| "release": ["person a on release.author=a.id"], | "release": ["person a on release.author=a.id"], | ||||
| "revision": [ | "revision": [ | ||||
| ▲ Show 20 Lines • Show All 494 Lines • Show Last 20 Lines | |||||