Page MenuHomeSoftware Heritage
Differential D3170 Diff 11264 swh/storage/sql/30-swh-schema.sql

Changeset View

Standalone View

View Options

swh/storage/sql/30-swh-schema.sql

Show All 11 Lines
comment on table dbversion is 'Details of current db version'; comment on table dbversion is 'Details of current db version';
comment on column dbversion.version is 'SQL schema version'; comment on column dbversion.version is 'SQL schema version';
comment on column dbversion.release is 'Version deployment timestamp'; comment on column dbversion.release is 'Version deployment timestamp';
comment on column dbversion.description is 'Release description'; comment on column dbversion.description is 'Release description';
-- latest schema version -- latest schema version
insert into dbversion(version, release, description) insert into dbversion(version, release, description)
values(149, now(), 'Work In Progress'); values(150, now(), 'Work In Progress');
-- a SHA1 checksum -- a SHA1 checksum
create domain sha1 as bytea check (length(value) = 20); create domain sha1 as bytea check (length(value) = 20);
-- a Git object ID, i.e., a Git-style salted SHA1 checksum -- a Git object ID, i.e., a Git-style salted SHA1 checksum
create domain sha1_git as bytea check (length(value) = 20); create domain sha1_git as bytea check (length(value) = 20);
-- a SHA256 checksum -- a SHA256 checksum
▲ Show 20 Lines • Show All 383 Lines • ▼ Show 20 Lines
comment on column metadata_fetcher.metadata is 'Extra information about the fetcher'; comment on column metadata_fetcher.metadata is 'Extra information about the fetcher';
create table metadata_authority create table metadata_authority
( (
id serial not null, id serial not null,
type text not null, type text not null,
url text not null, url text not null,
metadata jsonb metadata jsonb not null
vlorentzUnsubmitted
Not Done
Inline Actions

I don't think there should be a default. https://docs.softwareheritage.org/devel/swh-storage/extrinsic-metadata-specification.html#authorities-and-metadata-fetchers doesn't allow None.

vlorentz: I don't think there should be a default. https://docs.softwareheritage.org/devel/swh…
ardumontAuthorUnsubmitted
Done
Inline Actions

Ok, removing the default.

We have some which are None already though.
Is it fine to default it to {} as the migration current does?

softwareheritage=> select * from metadata_authority where metadata is null;
 id  |      type      |           url            | metadata
-----+----------------+--------------------------+----------
 206 | deposit_client | https://www.ipol.im/     |
 250 | deposit_client | https://doi.org/10.5201/ |
ardumont: Ok, removing the default. We have some which are None already though. Is it fine to default it…
); );
comment on table metadata_authority is 'Metadata authority information'; comment on table metadata_authority is 'Metadata authority information';
comment on column metadata_authority.id is 'Internal identifier of the authority'; comment on column metadata_authority.id is 'Internal identifier of the authority';
comment on column metadata_authority.type is 'Type of authority (deposit/forge/registry)'; comment on column metadata_authority.type is 'Type of authority (deposit/forge/registry)';
comment on column metadata_authority.url is 'Authority''s uri'; comment on column metadata_authority.url is 'Authority''s uri';
comment on column metadata_authority.metadata is 'Other metadata about authority'; comment on column metadata_authority.metadata is 'Other metadata about authority';
-- Discovery of metadata during a listing, loading, deposit or external_catalog of an origin -- Discovery of metadata during a listing, loading, deposit or external_catalog of an origin
-- also provides a translation to a defined json schema using a translation tool (tool_id) -- also provides a translation to a defined json schema using a translation tool (tool_id)
create table origin_metadata create table origin_metadata
( (
id bigserial not null, -- PK internal object identifier id bigserial not null, -- PK internal object identifier
origin_id bigint not null, -- references origin(id) origin_id bigint not null, -- references origin(id)
discovery_date timestamptz not null, -- when it was extracted discovery_date timestamptz not null, -- when it was extracted
authority_id bigint not null, authority_id bigint not null,
fetcher_id bigint not null, fetcher_id bigint not null,
format text default 'sword-v2-atom-codemeta-v2-in-json', format text not null default 'sword-v2-atom-codemeta-v2-in-json',
metadata bytea metadata bytea not null
); );
comment on table origin_metadata is 'keeps all metadata found concerning an origin'; comment on table origin_metadata is 'keeps all metadata found concerning an origin';
comment on column origin_metadata.id is 'the origin_metadata object''s id'; comment on column origin_metadata.id is 'the origin_metadata object''s id';
comment on column origin_metadata.origin_id is 'the origin id for which the metadata was found'; comment on column origin_metadata.origin_id is 'the origin id for which the metadata was found';
comment on column origin_metadata.discovery_date is 'the date of retrieval'; comment on column origin_metadata.discovery_date is 'the date of retrieval';
comment on column origin_metadata.authority_id is 'the metadata provider: github, openhub, deposit, etc.'; comment on column origin_metadata.authority_id is 'the metadata provider: github, openhub, deposit, etc.';
comment on column origin_metadata.fetcher_id is 'the tool used for extracting metadata: loaders, crawlers, etc.'; comment on column origin_metadata.fetcher_id is 'the tool used for extracting metadata: loaders, crawlers, etc.';
▲ Show 20 Lines • Show All 41 Lines • Show Last 20 Lines
About · Developer information · Legal