Change or remove the delete action

[clawes]

I have developed a contact management application with a mysql backend. The records in this database are later used to create contact accounts in our Windows Active Directory domain. I have a Windows Powershell script that queries the database periodically for all records that are flagged (create_this=1) for processing then create the AD contact accounts accordingly.

At the moment, deleting a contact record in the database has no impact on the related account in AD. What I would like is for all Xataface delete actions to simply "flag" the record for deletion instead of removing it entirely. Is there a way to customize the delete action so that the affected records are flagged, i.e. set the delete_this field to 1 then hidden the record from the list view? The Powershell script will be updated to find these records then remove the corresponding AD accounts.

[shannah]

I think the easiest thing to do would be to:

1. Disallow the delete permission on the table (so users cannot delete records)
2. Create your own "delete" action that is essentially a special update.

-Steve

[clawes]

Thanks for the responding.


1. Pardon my ignorance, but how do you set the "disable delete" at the table level?
2. I would like to keep the Delete (with selected) option on the list view so that one can easily select multiple records for deletion "flagging" instead of creating a delete action checkbox at the form level.

Any pointers?

[shannah]

If you disallow the delete permission it will prevent users from deleting records from any access point. It is possible that the delete selected action will need to be disabled separately.... though if you use delete selected on a record that doesn't grant the "delete" permission, the operation will fail.

You can set permissions on a table by table basis by defining the getPermissions() method in the appropriate table's delegate class.

Steve

[clawes]

Upon further pondering, I decide to approach this another way:

I will allow deletion as normal. I will create a beforeDelete trigger that will copy the deleted records to another table called delete_these, for example.
My backend Powershell script will query the delete_these table and process any record it finds there.

In this approach, I don't have to make any changes to the form or fiddle with permissions. My contacts table stays current with only active contacts.

I would appreciate if you could provide a simple code snippet (or direction to one) that demonstrates how to copy a dataface record array to another table.

TIA.

[shannah]

Just use SQL queries.

Code: Select all

$res = mysql_query("insert into copy_of_table select * from original_table where id='".addslashes($record->val('id'))."'", df_db());


[clawes]

That worked. Thanks again!