Migrate PhenoTips data from a virtual instance to another one

{{comment}}
When migrating PhenoTips data from a virtual instance to another through XAR export and import,
certain inter-document references will still contain the virtual instance identifier in them,
for example "rdconnect:Studies.Ataxia", which means that links between patient records,
users, groups, and studies, will be broken. In order to fix these links, we need to manually
fix this prefix.

0. Move the data from the old instance to the new instance
1. Log in with an administrative account on the new instance
2. Put this script in a new document, for example: /bin/edit/Sandbox/FixWikiId
3. Replace the values for $sourceInstanceId and $targetInstanceId with the right ones, if needed
4. Click Preview (this will actually change the data)
{{/comment}}

{{velocity}}
#set ($sourceInstanceId = 'rdconnect:')
#set ($targetInstanceId = 'xwiki:')
#set ($ctx = $xcontext.context)
#set ($store = $xwiki.xWiki.store.store)
$store.beginTransaction($ctx)
#set ($session = $store.getSession($ctx))
#foreach ($p in $store.search("from StringProperty p where p.value like '${sourceInstanceId}%'", 0, 0, $ctx))
  $p.setValue($p.getValue().replace($sourceInstanceId, $targetInstanceId))
  $session.update($p)
#end
#foreach ($p in $store.search("from LargeStringProperty p where p.value like '%${sourceInstanceId}%'", 0, 0, $ctx))
  $p.setValue($p.getValue().replace($sourceInstanceId, $targetInstanceId))
  $session.update($p)
#end
$store.endTransaction($ctx, true)
{{/velocity}}