029.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 28
	-- to_version: 29
	-- description: add metadata column to revision table

	insert into dbversion(version, release, description)
	values(29, now(), 'Work In Progress');

	ALTER TABLE revision
	ADD COLUMN metadata jsonb;

	CREATE OR REPLACE FUNCTION swh_revision_add() RETURNS void
	LANGUAGE plpgsql
	AS $$
	begin
	perform swh_person_add_from_revision();

	insert into revision (id, date, date_offset, committer_date, committer_date_offset, type, directory, message, author, committer, metadata, synthetic)
	select t.id, t.date, t.date_offset, t.committer_date, t.committer_date_offset, t.type, t.directory, t.message, a.id, c.id, t.metadata, t.synthetic
	from tmp_revision t
	left join person a on a.name = t.author_name and a.email = t.author_email
	left join person c on c.name = t.committer_name and c.email = t.committer_email;
	return;
	end
	$$;

	alter type revision_entry
	drop attribute parents,
	drop attribute synthetic,
	add attribute metadata jsonb,
	add attribute synthetic boolean,
	add attribute parents bytea[];

	alter type revision_log_entry
	drop attribute synthetic,
	add attribute metadata jsonb,
	add attribute synthetic boolean;

	CREATE OR REPLACE FUNCTION swh_revision_get() RETURNS SETOF revision_entry
	LANGUAGE plpgsql
	AS $$
	begin
	return query
	select t.id, r.date, r.date_offset,
	r.committer_date, r.committer_date_offset,
	r.type, r.directory, r.message,
	a.name, a.email, c.name, c.email, r.metadata, r.synthetic,
	array_agg(rh.parent_id::bytea order by rh.parent_rank)
	as parents
	from tmp_revision t
	left join revision r on t.id = r.id
	left join person a on a.id = r.author
	left join person c on c.id = r.committer
	left join revision_history rh on rh.id = r.id
	group by t.id, a.name, a.email, r.date, r.date_offset,
	c.name, c.email, r.committer_date, r.committer_date_offset,
	r.type, r.directory, r.message, r.metadata, r.synthetic;
	return;
	end
	$$;

	CREATE OR REPLACE FUNCTION swh_revision_log(root_revision sha1_git) RETURNS SETOF revision_log_entry
	LANGUAGE sql STABLE
	AS $$
	select revision.id, date, date_offset,
	committer_date, committer_date_offset,
	type, directory, message,
	author.name as author_name, author.email as author_email,
	committer.name as committer_name, committer.email as committer_email,
	revision.metadata, revision.synthetic
	from swh_revision_list(root_revision) as rev_list
	join revision on revision.id = rev_list
	join person as author on revision.author = author.id
	join person as committer on revision.committer = committer.id;
	$$;

File Metadata

Mime Type: text/plain
Expires: Thu, Apr 17, 9:11 AM (4 d, 21 h ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3283594

029.sql
No OneTemporary
Actions

029.sql
View Options

File Metadata

Event Timeline

029.sqlNo OneTemporaryActions

029.sqlView Options

File Metadata

Event Timeline

029.sql
No OneTemporary
Actions

029.sql
View Options