|Version 4 (modified by 11 years ago) ( diff ),|
There are times when you have multiple records in the database which are duplicates.
For some simple 'leaf' resources it may be possible to simply delete one of them (e.g. Contacts).
However where other records point to this one, it is better 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 = s3db.resource("pr_person") # (Good, Bad) resource.merge(117, 90) # If succesful: db.commit()
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. There may of course be addiional records, such as Human Resource or Contacts.