[OGo-Bugs][Bug 1976] deleting contatcts, enterprises or tasks, does not delete records from the obj_link table

[bugs@opengroupware.org]

Please do not reply directly to this email. All additional
comments should be made in the comments box of this bug
report.

http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1976


awilliam@whitemice.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         AssignedTo|qa@opengroupware.org        |awilliam@whitemice.org




------- Additional Comments From awilliam@whitemice.org  2008-05-22 20:37 -------

Deletion of a task removes properties and links:
---------------
 SELECT t1.assignment_kind, t1.child_job_id, t1.db_status, t1.job_assignment_id,
t1.parent_job_id, t1.position_x FROM  job_assignment t1 WHERE
t1.parent_job_id=149530
 SELECT t1.value_key, t1.namespace_prefix, t1.preferred_type, t1.value_string,
t1.value_int, t1.value_float, t1.value_date, t1.value_oid, t1.value_blob,
t1.blob_size, t1.access_key, t1.obj_id, t1.obj_property_id FROM  obj_property t1
WHERE t1.obj_id = 149530
[ERROR] <0x0x8922d5c[SkyAccessManager]> did not find class 'OGoJobAccessHandler'
for key 'Job'
  in bundle: <NGBundle 0x80eeee4 fullPath:
/usr/local/lib/opengroupware.org-1.1/commands/LSTasks.cmd infoDictionary:
0x82bae9c loaded=yes>
  handlers: {
    Job = OGoJobAccessHandler;
}
 DELETE FROM obj_link WHERE target_id = 149530
 DELETE FROM obj_link WHERE source_id = 149530
 DELETE FROM job WHERE job_id=149530
 COMMIT TRANSACTION


Deletion of a company removes properties and links:
--------
....
 DELETE FROM address WHERE address_id=10398269
 SELECT t1.value_key, t1.namespace_prefix, t1.preferred_type, t1.value_string,
t1.value_int, t1.value_float, t1.value_date, t1.value_oid, t1.value_blob,
t1.blob_size, t1.access_key, t1.obj_id, t1.obj_property_id FROM  obj_property t1
WHERE t1.obj_id = 10398262
 SELECT t1.owner_id, t1.is_private, t1.is_readonly, t1.company_id FROM 
enterprise t1 WHERE t1.company_id = 10398262
 SELECT t1.object_id, t1.auth_id, t1.permissions FROM  object_acl t1 WHERE
t1.object_id IN ('10398262')
 DELETE FROM obj_link WHERE target_id = 10398262
 DELETE FROM obj_link WHERE source_id = 10398262
 DELETE FROM log WHERE object_id=10398262
 DELETE FROM enterprise WHERE company_id=10398262
 COMMIT TRANSACTION

Project deletion probably works - will need to test via zOGI as project deletion
seems not supported via the WebUI.

Still need to support clean appointment deletion and possibly clean document
deletion - delete operations on these two types of entities is more complicated.
 For appointments due to cyclics and documents due to... well, document handling
is wierd.

------- Additional Comments From awilliam@whitemice.org  2008-05-22 20:37 -------
assigning bug to myself

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.