/// <reference path="../pb_data/types.d.ts" />
migrate((app) => {
  const collection = app.findCollectionByNameOrId("pbc_2992844423")

  // update collection data
  unmarshal({
    "viewQuery": "select \n  (ROW_NUMBER() OVER()) as id,\n  upper(`Dvn1`.`patientName`) as dvn_patient\nfrom `Dvn1`\n  \n"
  }, collection)

  return app.save(collection)
}, (app) => {
  const collection = app.findCollectionByNameOrId("pbc_2992844423")

  // update collection data
  unmarshal({
    "viewQuery": "select \n  (ROW_NUMBER() OVER()) as id,\n  lower(`Dvn1`.`patientName`) as dvn_patient\nfrom `Dvn1`\n  \n"
  }, collection)

  return app.save(collection)
})