Changeset 637 for trunk/lib

Timestamp:

Sep 29, 2018 6:50:33 PM (6 years ago)

Author:

anonymous

Message:

Add version remove methods

File:

• trunk/lib/Version.inc.php (modified) (1 diff)

trunk/lib/Version.inc.php

@@ -416 +416 @@
 
     /**
+     * Delete all versioned history of a DB record.
+     *
+     * @param string $record_table  The table containing the record.
+     * @param string $record_key    The key column for the record.
+     * @param string $record_val    The value of the key column for the record.
+     *
+     * @return void
+     */
+    public function deleteAll($record_table, $record_key, $record_val)
+    {
+        $app =& App::getInstance();
+        $db =& DB::getInstance();
+
+        $this->initDB();
+
+        // Delete all versions for this record.
+        $qid = $db->query("
+            DELETE FROM " . $db->escapeString($this->getParam('db_table')) . "
+            WHERE record_table = '" . $db->escapeString($record_table) . "'
+            AND record_key = '" . $db->escapeString($record_key) . "'
+            AND record_val = '" . $db->escapeString($record_val) . "'
+        ");
+        $app->logMsg(sprintf('Deleted all %s rows for %s.%s=%s', mysql_affected_rows($db->getDBH()), $record_table, $record_key, $record_val), LOG_INFO, __FILE__, __LINE__);
+    }
+
+    /**
+     * Delete one version of a DB record.
+     *
+     * @param string $version_id    The ID of the version to delete.
+     *
+     * @return void
+     */
+    public function delete($version_id)
+    {
+        $app =& App::getInstance();
+        $db =& DB::getInstance();
+
+        $this->initDB();
+
+        // Delete one version.
+        $qid = $db->query("
+            DELETE FROM " . $db->escapeString($this->getParam('db_table')) . "
+            WHERE version_id = '" . $db->escapeString($version_id) . "'
+        ");
+        $app->logMsg(sprintf('Deleted version_id=%s', $version_id), LOG_INFO, __FILE__, __LINE__);
+    }
+
+    /**
      * Get a list of versions of specified record.
      *