Differential D5522 Diff 19700 swh/dataset/relational.py

Changeset View

Standalone View

swh/dataset/relational.py

This file was added.

				# Copyright (C) 2021 The Software Heritage developers
				zackUnsubmitted Done Inline Actions a comment line before the formatting pragma stating what this module contains would be nice to have zack: a comment line before the formatting pragma stating what this module contains would be nice to…
				# See the AUTHORS file at the top-level directory of this distribution
				# License: GNU General Public License version 3, or any later version
				# See top-level LICENSE file for more information

				# fmt: off
				TABLES = {
				"origin": [
				("url", "string"),
				],
				"origin_visit": [
				("origin", "string"),
				("visit", "bigint"),
				("date", "timestamp"),
				("type", "string"),
				],
				"origin_visit_status": [
				("origin", "string"),
				("visit", "bigint"),
				("date", "timestamp"),
				("status", "string"),
				("snapshot", "string"),
				],
				"snapshot": [
				("id", "string"),
				],
				"snapshot_branch": [
				("snapshot_id", "string"),
				("name", "binary"),
				("target", "string"),
				("target_type", "string"),
				],
				"release": [
				("id", "string"),
				("name", "binary"),
				("message", "binary"),
				("target", "string"),
				("target_type", "string"),
				("author", "binary"),
				("date", "timestamp"),
				("date_offset", "smallint"),
				],
				"revision": [
				("id", "string"),
				("message", "binary"),
				("author", "binary"),
				("date", "timestamp"),
				("date_offset", "smallint"),
				("committer", "binary"),
				("committer_date", "timestamp"),
				("committer_offset", "smallint"),
				("directory", "string"),
				],
				"directory": [
				("id", "string"),
				],
				"directory_entry": [
				("directory_id", "string"),
				("name", "binary"),
				("type", "string"),
				("target", "string"),
				("perms", "int"),
				],
				"content": [
				("sha1", "string"),
				("sha1_git", "string"),
				("sha256", "string"),
				("blake2s256", "string"),
				("length", "bigint"),
				("status", "string"),
				],
				"skipped_content": [
				("sha1", "string"),
				("sha1_git", "string"),
				("sha256", "string"),
				("blake2s256", "string"),
				("length", "bigint"),
				("status", "string"),
				("reason", "string"),
				],
				}
				# fmt: on