Record Merging

There are times when you have multiple records in the database which are duplicates. Rather than simply delete one of them, which may mean that other records don't point correctly at this one, it is possible to merge the 2 records together.

Identify the 2 record IDs, decide which one you wish to keep & which one should be deprecated & then merge them as follows:

auth.override=True
resource = s3mgr.define_resource("pr", "person")
# (Good, Bad)
resource.merge(117, 90)
db.commit()
# or db.rollback()

It is also possible to specify that some fields should be retained from the one which is being deprecated.

There may of course be addiional records, such as Human Resource or Contacts.