MonetDB importer

These schemas specify some artifacts used by the administration of the importer as well as a translation format for developer accounts.

Database schema update

https://gros.liacs.nl/schema/monetdb-import/update.json

update

update

type	object
properties
schema	Name of the database schema to work on.
	Update field name
table	Name of the table to perform an update action on.
	Update field name
action	Action to perform with regards to a table in the database. With create, a previously nonexistent table is to be created. With drop, a previously existent table is to be dropped. With alter, columns and keys are changed.
	type	string
	enum	create, drop, alter
	default	alter
columns	type	array
	items	type	object
		properties
		name	Name of the column to update.
			Update field name
		action	Action to perform with regards to a column. With add, a previously nonexistent column is to be created. With drop, a previously existent column is to be dropped. With alter, properties of the column are changed compared to a previous situation.
			type	string
			enum	add, drop, alter
		null	Whether the altered column will be allowed to store NULL values.
			type	boolean
		default	The default value that the column will store.
			type	string / boolean / number
keys	type	array
	items	type	object
		properties
		name	Name of the key to update.
			Update field name
		action	Action to perform with regards to a key. With create, a previously nonexistent key is to be created. With drop, a previously existent key is to be dropped. With alter, properties of the column are key compared to a previous situation.
			type	string
			enum	create, drop, alter
		objects	The columns to be used within the updated key.
			type	array
			items	Update field name
		type	The storage type to be used for the updated key.
			type	string
			enum	Primary Key, Unique Key, Foreign Key, Hash, Join, Order preserving hash, No-index, Imprint, Ordered

Update field name

type	string
pattern	^[a-z_]+$

Table validation

https://gros.liacs.nl/schema/monetdb-import/validation.json

validation

validation

type	object
properties
table	type	object
	patternProperties
	^[a-z_]+$	Validation table
special_type	type	object
	properties
	type	Validation field type
	limit	type	string
		pattern	^[0-9]+$
group	type	object
	patternProperties
	.+	type	array
		items	Validation field name

Validation table

type	object
properties
field	type	object
	patternProperties
	^[a-z_]+$	type	object
		properties
		type	Validation field type
		null	type	boolean
		primary_key	type	boolean
		reference	type	array
			items	oneOf	Validation field name
					type	null
			minItems	2
primary_key_combined	type	array
	items	oneOf	Validation field name
			type	null
	minItems	2

Validation field name

type	string
pattern	^[a-z_]+$

Validation field type

type	string
pattern	^[A-Z]+(\\([A-Za-z0-9, ]+\\))?$

Version control system developer to Jira developer mapping

https://gros.liacs.nl/schema/monetdb-import/vcsdev_to_dev.json

vcsdev_to_dev

vcsdev_to_dev

type	array
items	oneOf	link_jira
		link_id
		link_pattern

link_base

type	object
properties
display_name	Name of the developer within a version control system to link to the same developer in Jira (whose name, account name and email address may have been written differently between systems).
	type	string
email	Email address of the developer within a version control system to link to the same developer in Jira. The email address does not need to be formatted as an email (link may be made when name, account name or email address have been written differently between systems).
	type	string

link_jira

properties
jira_user_name	Account name of the developer in Jira to link to.
	type	string
allOf	link_base

link_id

properties
id	Identifier of the developer in Jira to link to. When this is -1, the developer within a version control system is explicitly marked as not having a link with a Jira developer, such as a system account.
	type	string
	format	^-?d+$
allOf	link_base

link_pattern

type	object
properties
prefix	Start of account names of developers within a version control name. May contain _ characters to indicate any other characters, exactly one, and % characters to indicate subsequences of any characters, zero or more. Only developers with matching account names are considered for linking.
	type	string
pattern	Pattern to match within account names of developers that start with prefix. By default, only the prefix is matched.
	type	string
	format	regex
replace	Pattern replacement to replace within account names of developers that start with prefix. May contain backreferences ($1, etc.) to groups within pattern. By default, only the prefix is removed from the replaced name.
	type	string
mutate	Operator to perform on the account names of developers that start with prefix, after pattern and replace are handled, to obtain a linkable name. This may be lower to turn the account name to lowercase.
	type	string
	enum	lower
projects	Projects to apply the link for. Can be used as a filter when providing the mapping to another system that pre-converts the username. This may be ignored during an import, when personal data from multiple projects or global encryption may be in use.
	type	array
	items	type	string
		pattern	^[A-Z]+$