Changeset 7329a74

Timestamp:

08/25/10 21:44:42 (21 months ago)

Author:

Benoit Grégoire <benoitg@…>

Branches:

('master', '8434b8322dd6f8ff37c17bd45b94e7a826f86b53')('vitrine', 'afe109c61a407808bd54d88bcccb1cde726a010a')

Children:

ce9b376399bdac774ac9123625fc841f9afdfbb4

Parents:

c644bf60405467e51cba29d863ad84bf11a27add

git-author:

Benoit Grégoire <benoitg@coeus.ca>2010-08-25 21:44:42-04:00

git-committer:

Benoit Grégoire <benoitg@coeus.ca>2010-08-25 21:44:42-04:00

Message:

cron/cleanup.php: Found a new source of dangling relations to clean up

File:

• html/cron/cleanup.php (modified) (2 diffs)

html/cron/cleanup.php

@@ -2 +2 @@
 require_once '../include/common.php';
 require_once 'classes/Style.php';
-$sql=null;
-$sql .= "DELETE FROM lom_5_educational WHERE lom_5_educational_id IN (SELECT
+$sql = "DELETE FROM lom_identifiers WHERE lom_identifiers_id IN 
+(SELECT
+  lom_identifiers.lom_identifiers_id
+FROM 
+  public.lom_identifiers
+  LEFT JOIN public.lom_1_1_identifiers_has_lom ON (lom_1_1_identifiers_has_lom.lom_identifiers_id = lom_identifiers.lom_identifiers_id)
+  LEFT JOIN public.lom_7_relation_7_2_1_has_lom_identifiers ON (lom_7_relation_7_2_1_has_lom_identifiers.lom_identifiers_id = lom_identifiers.lom_identifiers_id)
+WHERE 
+lom_1_1_identifiers_has_lom.lom_identifiers_id IS NULL
+AND lom_7_relation_7_2_1_has_lom_identifiers.lom_identifiers_id IS NULL);\n";
+$db->execSqlUpdate("\n$sql\n\n", true);
+
+$sql = "DELETE FROM lom_5_educational WHERE lom_5_educational_id IN (SELECT
   lom_5_educational.lom_5_educational_id
 FROM 
@@ -11 +22 @@
 lom_5_has_educational.lom_5_educational_id IS NULL);\n";
 $db->execSqlUpdate("\n$sql\n\n", true);
-$sql .= "DELETE FROM lom_9_classification WHERE lom_9_classification_id IN (SELECT
+
+$sql = "DELETE FROM lom_9_classification WHERE lom_9_classification_id IN (SELECT
   lom_9_classification.lom_9_classification_id
 FROM