openspecimen_demo
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
load_revision_entity_records
Parameters
Name
Type
Mode
entityName
text
IN
entityTable
text
IN
Definition
begin select concat( 'insert into os_rev_entity_recs_tmp', ' (rev, rev_type, entity_name, entity_id) ', 'select ', ' o.rev as rev, o.revtype as rev_type, re.entityname as entity_name, ', ' o.identifier as entity_id ', 'from ', ' os_revisions r ', ' inner join os_revision_entities re on re.rev = r.rev and re.entityname = '', entityName, ''', ' inner join ', entityTable, ' o on o.rev = re.rev ' ) into @dml; prepare stmt from @dml; execute stmt; deallocate prepare stmt; end