mig-import missed a clause for deleting from the itemtypes table
authorRogan Hamby <rhamby@equinoxinitiative.org>
Wed, 3 Jun 2020 15:39:14 +0000 (11:39 -0400)
committerRogan Hamby <rhamby@equinoxinitiative.org>
Wed, 3 Jun 2020 15:39:14 +0000 (11:39 -0400)
kmig.d/bin/mig-import

index 4483c23..e94e5d0 100755 (executable)
@@ -446,7 +446,6 @@ sub restore_itemtypes {
     my $sth = $dbh->prepare($query);
     $sth->execute();
 
-
     $query = "DELETE FROM authorised_values WHERE category = 'ITEMTYPECAT'";
     $sth = $dbh->prepare($query);
     $sth->execute();
@@ -455,6 +454,10 @@ sub restore_itemtypes {
     $sth = $dbh->prepare($query);
     $sth->execute();
 
+    $query = "DELETE FROM itemtypes WHERE 1 = 1";
+    $sth = $dbh->prepare($query);
+    $sth->execute();
+
     foreach my $node ($dom->findnodes('/document/authorised_values/value')) {
         my $category = sql_str($node->findvalue('./category'));
         my $authvalue = sql_str($node->findvalue('./authvalue'));