feat(pdo): add removeEntry method to clear expired metadata

tamil-rss · thijskh · commit e1400c2151a1 · 2023-07-06T16:56:14.000+02:00
diff --git a/src/SimpleSAML/Metadata/MetaDataStorageHandlerPdo.php b/src/SimpleSAML/Metadata/MetaDataStorageHandlerPdo.php
@@ -255,6 +255,31 @@ public function addEntry(string $index, string $set, array $entityData): bool
     }
 
 
+    /**
+     * Remove metadata from the configured database
+     *
+     * @param string $entityId The entityId we are removing.
+     * @param string $set The set to remove the metadata from.
+     *
+     * @return bool True/False if entry was successfully deleted
+     */
+    public function removeEntry(string $entityId, string $set): bool
+    {
+        if (!in_array($set, $this->supportedSets, true)) {
+            return false;
+        }
+
+        $tableName = $this->getTableName($set);
+
+        $rows = $this->db->write(
+            "DELETE FROM $tableName WHERE entity_id = :entity_id",
+            ['entity_id' => $entityId]
+        );
+
+        return $rows === 1;
+    }
+
+
     /**
      * Replace the -'s to an _ in table names for Metadata sets
      * since SQL does not allow a - in a table name.
