database_transformation

relational-database-bridge grammar version 78

'none' group
(
	'operation' component 'tag: operation type'
	'stack'     component 'tag: variable stack'
)
'context' group
(
	'singular' component 'tag: context type'
	'plural'   component 'tag: context type'
)
'root' ['root'] group
(
	'root' ['='] component 'node mapping'
)
/* data context information */
'tag: context type'
'tag: context'
'context creation'
	'tag' component 'tag: context'
/* execution context information */
'tag: operation type'
'unguaranteed operation'
	'is' ['<!', '!>'] stategroup
	(
		'unguarded'
			'annotation' text
		'guarded'
	)
'null guard'
	'require guard' stategroup (
		'yes' ['nullable']
			'unguaranteed operation' component 'unguaranteed operation'
		'no'
	)
/* static data descriptors */
'static: number list'
	'type' stategroup
	(
		'single'
			'value' number
		'range'
			'begin' number
			'end' ['-'] number
	)
	'has more' stategroup
	(
		'yes'
			'tail' [','] component 'static: number list'
		'no'
	)
'static: text list'
	'value' text
	'has more' stategroup
	(
		'yes'
			'tail' [','] component 'static: text list'
		'no'
	)
/* variable stack */
'tag: variable stack'
'tag: variable'
	'tag' component 'tag: variable stack'
'variable selector'
	'is' stategroup ('stack frame')
	'select' stategroup
	(
		'this' ['$']
		'parent' ['$^']
			'tail' component 'variable selector'
		'partition'
			'select' stategroup
			(
				'key' ['$key']
				'set' ['$set']
			)
		'branch' ['$']
			'branch' reference
	)
'variable assignment: context'
	'variable' component 'tag: variable'
'variable assignment: number'
	'variable' component 'tag: variable'
'variable assignment: text'
	'variable' component 'tag: variable'
'variable assignment: regexp'
	'variable' component 'tag: variable'
'variable assignment: array'
	'variable' component 'tag: variable'
'variable assignment: partition'
	'variable' component 'tag: variable'
'variable assignment: block'
	'branches' ['(',')'] collection indent
	( ['$']
		'type' stategroup
		(
			'context' ['=']
				'expression' component 'context selector'
				'context' component 'context creation'
				'assignment' component 'variable assignment: context'
			'array' [':''array''=']
				'selection' component 'context selector'
				'is' stategroup ('plural context')
				'transformation' stategroup
				(
					'none' ['on']
						'unguaranteed operation' component 'unguaranteed operation'
					'partition' ['partition']
						'bucket context' component 'context creation'
				)
				'index' ['[',']'] group
				(
					'context' component 'context creation'
					'variable' component 'variable assignment: context'
					'expression' component 'number expression'
				)
				'assignment' component 'variable assignment: array'
			'regexp' [':''regexp']
				'regexp' ['='] reference
				'unguaranteed operation' component 'unguaranteed operation'
				'value' ['on'] component 'text expression'
				'assignment' component 'variable assignment: regexp'
			'number' [':''number']
				'expression' ['='] component 'number expression'
				'assignment' component 'variable assignment: number'
			'text' [':''text']
				'expression' ['='] component 'text expression'
				'assignment' component 'variable assignment: text'
		)
	)
	'variable' component 'tag: variable'
/* type specific context selection */
'implicit constraint'
	'key type' stategroup
	(
		'primary key'
			'fields' ['(',')'] collection
			(
				'data type' ['=='] stategroup
				(
					// 'enum' ['enum']
					'integer' ['integer']
						'value' component 'number expression'
					'text' ['text']
						'value' component 'text expression'
				)
			)
		'unique index'
			'index' [':'] reference
			'fields' ['(',')'] collection
			(
				'data type' ['=='] stategroup
				(
					// 'enum' ['enum']
					'integer' ['integer']
						'value' component 'number expression'
					'text' ['text']
						'value' component 'text expression'
				)
			)
	)
	'unguaranteed operation' component 'unguaranteed operation'
'context selector recursive'
	'step' stategroup
	(
		'yes'
			'type' stategroup
			(
				'explicit foreign key'
					'is' stategroup
					(
						'singular context'
							'link' ['>>'] reference
						'plural context'
							'link' ['>>','*'] reference
					)
				'implicit foreign key'
					'is' stategroup
					(
						'singular context'
							'table' ['>>'] reference
							'temp var' component 'variable assignment: context'
							'expression' component 'implicit constraint'
						'plural context'
							'table' ['>>','*'] reference
							'temp ctx' component 'context creation'
							'temp var' component 'variable assignment: context'
							'expression' component 'implicit constraint'
					)
				'child collection' ['inverse']
					'is' stategroup
					(
						'singular context'
							'source'      ['table'] reference
							'links to me' ['>']     reference
						'plural context'
							'source'      ['table'] reference
							'links to me' ['>','*'] reference
					)
			)
			'temp' component 'context creation'
			'optional assignment' stategroup
			(
				'assign' ['as' '$']
					'variable' component 'variable assignment: context'
				'skip'
			)
			'tail' component 'context selector recursive'
		'no'
	)
'context selector'
	'source' stategroup
	(
		'root'
			'table' ['table'] reference
			'temp' component 'context creation'
		'stack'
			'selection' component 'variable selector'
			'is' stategroup ('context variable')
		'array'
			'operation' stategroup
			(
				'predecessor' ['predecessor']
				'successor' ['successor']
			)
			'key expression' ['of'] component 'number expression'
			'selection' ['in'] component 'variable selector'
			'unguaranteed operation' component 'unguaranteed operation'
			'is' stategroup ('array variable')
	)
	'steps' component 'context selector recursive'
	'require' stategroup ('valid context')
/* generic sub expressions */
'regexp selector'
	'source' stategroup
	(
		'stack'
			'selection' component 'variable selector'
			'is' stategroup ('regexp')
		'inline' ['inline']
			'regexp' reference
			'unguaranteed operation' component 'unguaranteed operation'
			'value' ['on'] component 'text expression'
	)
'number expression transformation'
	'base'     ['*'] number
	'exponent' ['^'] number
	'rounding' stategroup (
		'ordinary' ['round']
		'ceil'     ['ceil']
		'floor'    ['floor']
	)
'number expression list'
	'expression' component 'number expression'
	'has more' stategroup (
		'no'
		'yes' [',']
			'tail' component 'number expression list'
	)
'number expression'
	'type' stategroup
	(
		'convert text'
			'value constraint' stategroup
			(
				'integer' ['to-integer']
				'natural' ['to-natural']
			)
			'unguaranteed operation' component 'unguaranteed operation'
			'value' component 'text expression'
		'cast to natural' ['(natural)']
			'unguaranteed operation' component 'unguaranteed operation'
			'value' component 'number expression'
		'convert date' ['to-date']
			'unguaranteed operation' component 'unguaranteed operation'
			'selection' component 'regexp selector'
			'year' ['where' 'year' '='] reference
			'offset' stategroup
			(
				'month based'
					'month'        ['month' '='] reference
					'day of month' ['day' '='] reference
				'week based'
					'week' ['week' '='] reference
					'day of week' ['day' '='] stategroup
					(
						'monday'    ['Monday']
						'tuesday'	['Tuesday']
						'wednesday'	['Wednesday']
						'thursday'	['Thursday']
						'friday'	['Friday']
						'saturday'	['Saturday']
						'sunday'    ['Sunday']
					)
			)
		'convert date and time' ['to-datetime']
			'unguaranteed operation' component 'unguaranteed operation'
			'selection' component 'regexp selector'
			'year'         ['where' 'year' '='] reference
			'month'        ['month' '='] reference
			'day of month' ['day' '='] reference
			'hour'         ['hour' '='] reference
			'minute'       ['minute' '='] reference
			'second'       ['second' '='] reference
		'from context'
			'is' stategroup
			(
				'singular context'
				'plural context'
					'operation' stategroup
					(
						'shared value' ['shared']
							'unguaranteed operation' component 'unguaranteed operation'
						'sum' ['sum']
						'max' ['max']
							'unguaranteed operation' component 'unguaranteed operation'
						'min' ['min']
							'unguaranteed operation' component 'unguaranteed operation'
					)
			)
			'selection' ['#'] component 'context selector' // NOTE: temporary keyword
			'field' ['.'] reference
			'conversion' stategroup
			(
				'real to integer'
					'transformation' component 'number expression transformation'
					'equivalent set type' component 'numerical set constraint'
				'none'
					'inequivalent set type' component 'numerical set constraint'
			)
			'null guard' component 'null guard'
			'field is' stategroup ('number')
		'from variable'
			'selection' component 'variable selector'
			'is' stategroup ('number variable')
		'unary operation'
			'operation' stategroup (
				'additive inverse' ['-']
			)
			'expression' component 'number expression'
		'list operation'
			'operation' stategroup (
				'sum' ['sum']
				'product' ['product']
			)
			'list' ['(',')'] component 'number expression list'
		'division' ['division']
			'left' ['('] component 'number expression'
			'right' [',',')'] component 'number expression'
		'static value'
			'value constraint' stategroup
			(
				'integer' ['integer']
					'value' number
				'natural' ['natural']
					'value' number
			)
	)
'numerical set constraint'
'text expression: concatenate'
	'expression' component 'text expression'
	'has more' stategroup
	(
		'yes' [',']
			'tail' component 'text expression: concatenate'
		'no'
	)
'text expression'
	'type' stategroup
	(
		'convert number' ['to-text']
			'value' component 'number expression'
		'from context'
			'is' stategroup
			(
				'singular context'
				'plural context'
					'operation' stategroup
					(
						'shared value' ['shared']
							'unguaranteed operation' component 'unguaranteed operation'
						'join' ['join']
							'separator' text
					)
			)
			'selection' component 'context selector'
			'field' ['.'] reference
			'null guard' component 'null guard'
			'field is' stategroup ('text')
		'from regexp' ['regexp']
			'selection' component 'regexp selector'
			'capture' ['@'] reference
		'from variable'
			'selection' component 'variable selector'
			'is' stategroup ('text')
		'concatenation' ['concat']
			'expressions' ['(', ')'] component 'text expression: concatenate'
		'static value'
			'value' text
	)
'boolean expression: candidates'
	'expression' component 'boolean expression'
	'has more' stategroup
	(
		'yes' [',']
			'tail' component 'boolean expression: candidates'
		'no'
	)
'boolean expression'
	'type' stategroup
	(
		'logic operation'
			'operation' stategroup
			(
				'and' ['and']
				'or'  ['or']
			)
			'expressions' ['(', ')'] component 'boolean expression: candidates'
		'compare number'
			'sub type' stategroup
			(
				'binary operation'
					'left' component 'number expression'
					'operation' stategroup
					(
						'equal' ['==']
						'greater' ['>']
						'greater equal' ['>=']
						'smaller' ['<']
						'smaller equal' ['<=']
					)
					'right' component 'number expression'
				'set operation'
					'find' ['is','in'] component 'number expression'
					'in' ['(', ')'] component 'static: number list'
			)
		'compare text'
			'sub type' stategroup
			(
				'binary operation'
					'left' component 'text expression'
					'operation' stategroup
					(
						'equals' ['equals']
						'starts with' ['starts-with']
						'ends with' ['ends-with']
					)
					'right' component 'text expression'
				'set operation'
					'find' ['is','in'] component 'text expression'
					'in' ['(', ')'] component 'static: text list'
			)
		'compare boolean' ['bool']
			'selection' component 'context selector'
			'is' stategroup
			(
				'singular context'
				'plural context'
					'operation' stategroup
					(
						'shared value' ['shared']
							'unguaranteed operation' component 'unguaranteed operation'
					)
			)
			'field' ['.'] reference
			'null guard' component 'null guard'
			'field is' stategroup ('boolean')
	)
'collection expression'
	'variable type' ['(', ')'] stategroup
	(
		'context'
			'selection' component 'context selector'
			'context'  component 'context creation'
		'array' ['array']
			'selection' component 'variable selector'
			'is' stategroup ('array context')
			'require' stategroup ('valid context')
	)
'collection mapping'['=']
	'source' stategroup
	(
		'empty' ['empty']
		'static entry'
			'key' ['key' '='] component 'text expression'
			'mapping' component 'node mapping'
		'from variable'
			'transformation' stategroup
			(
				'none'
					'is' stategroup
					(
						'singular context'
						'plural context'
							'unguaranteed operation' component 'unguaranteed operation'
					)
					'expression' component 'collection expression'
					'optional assignment' stategroup
					(
						'assign' ['as' '$']
							'variable' component 'variable assignment: context'
						'skip'
					)
					'key' ['key' '='] component 'text expression'
					'mapping' component 'node mapping'
				'partition' ['partition']
					'set is' stategroup
					(
						'plural context'
							'unguaranteed operation' component 'unguaranteed operation'
					)
					'row is' stategroup ('singular context')
					'expression' component 'collection expression'
					'index' group
					( ['[', ']']
						'variable' component 'variable assignment: context'
						'expression' component 'text expression'
					)
					'set context' component 'context creation'
					'optional assignment' stategroup
					(
						'assign' ['as' '(' '$key' ',' '$set' ')']
							'key variable' component 'variable assignment: text'
							'set variable' component 'variable assignment: context'
							'variable' component 'variable assignment: partition'
						'skip'
					)
					'key' ['key' '='] component 'text expression'
					'mapping' component 'node mapping'
			)
	)
'state mapping' ['=']
	'type' stategroup
	(
		'panic' ['panic']
			'comment' text
		'conditional' ['match']
			'condition' ['(', ')'] component 'boolean expression'
			'on true'  ['|' 'true'] component 'state mapping'
			'on false' ['|' 'false'] component 'state mapping'
		'enrich' ['try']
			'try assign' component 'variable assignment: block'
			'guarded operation' component 'tag: operation type'
			'on success' ['|' 'success'] component 'state mapping'
			'on failure' ['|' 'failure'] component 'state mapping'
		'context switch'
			'selection' component 'context selector'
			'is' stategroup ('plural context')
			'on singular' ['|''singular'] group
			(
				'context' component 'context creation'
				'variable' component 'variable assignment: context'
				'mapping' component 'state mapping'
			)
			'on plural' ['|''plural'] group
			(
				'context' component 'context creation'
				'variable' component 'variable assignment: context'
				'mapping' component 'state mapping'
			)
		'from context'
			'is' stategroup
			(
				'singular context' ['switch']
				'plural context' ['switch-shared']
					'unguaranteed operation' component 'unguaranteed operation'
			)
			'selection' ['('] component 'context selector'
			'field' ['?'] reference
			'null guard' component 'null guard'
			'field is' [')'] stategroup ('enum')
			'mappings' ['(',')'] collection indent
			( ['|']
				'optional variable assignment' stategroup
				(
					'assign' ['as' '$']
						'context'  component 'context creation'
						'variable' component 'variable assignment: context'
					'skip'
				)
				'mapping' component 'state mapping'
			)
		'from array'
			'operation' stategroup
			(
				'first' ['first']
				'last' ['last']
			)
			'selection' ['in'] component 'variable selector'
			'is' stategroup ('array variable')
			'optional variable assignment' stategroup
			(
				'assign'
					'variable' ['as' '$'] component 'variable assignment: context'
				'skip'
			)
			'on success' ['|' 'success' ] component 'state mapping'
			'on failure' ['|' 'failure' ] component 'state mapping'
		'set state'
			'state' reference
			'mapping' component 'node mapping'
	)
'node mapping' ['(',')']
	'define block' stategroup
	(
		'yes'
			'block' component 'variable assignment: block'
		'no'
	)
	'properties' collection indent
	(
		'type' [':'] stategroup
		(
			'group' ['group']
				'optional binding' ['='] stategroup
				(
					'bind'
						'selection' component 'context selector'
						'context' ['as'] component 'context creation'
						'variable' ['$'] component 'variable assignment: context'
					'skip'
				)
				'mapping' component 'node mapping'
			'collection' ['collection']
				'mapping' component 'collection mapping'
			'stategroup' ['stategroup']
				'mapping' component 'state mapping'
			'number'
				'set type' stategroup
				(
					'integer' ['integer']
					'natural' ['natural']
						'equivalent set type' component 'numerical set constraint'
				)
				'value source' ['='] stategroup
				(
					'clock' ['now']
					'source'
						'expression' component 'number expression'
				)
			'text' ['text']
				'expression' ['='] component 'text expression'
			'reference' ['text' '(->)']
				'expression' ['='] component 'text expression'
		)
	)
// 'enum expression'
// 	'type' stategroup (
// 		'field'
// 			'link' component 'link path'
// 			'context type' stategroup (
// 				'record'
// 					'field' [ '.' ] reference
// 					'null guard' component 'null guard'
// 					'data type constraint' stategroup ( 'enum' )
// 				'record set'
// 					'field' [ '.' ] reference
// 					'null guard' component 'null guard'
// 					'data type constraint' stategroup ( 'enum' )
// 					'merge' stategroup (
// 						'shared value' [ 'shared' ]
// 							'unguaranteed operation' component 'unguaranteed operation'
// 					)
// 			)
// 	)