From 66f5e240b0c48fe26411b9c911a4ad9af480bbbc Mon Sep 17 00:00:00 2001
From: Tim Otten <totten@civicrm.org>
Date: Tue, 29 Oct 2019 17:20:18 -0700
Subject: [PATCH] CRM_Core_DAO - Add helper checkTableHasData()

---
 CRM/Core/DAO.php | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/CRM/Core/DAO.php b/CRM/Core/DAO.php
index 0a09592556..b508b64e6c 100644
--- a/CRM/Core/DAO.php
+++ b/CRM/Core/DAO.php
@@ -1063,6 +1063,18 @@ LIKE %1
     return $result;
   }
 
+  /**
+   * Check if a given table has data.
+   *
+   * @param string $tableName
+   * @return bool
+   *   TRUE if $tableName has at least one record.
+   */
+  public static function checkTableHasData($tableName) {
+    $c = CRM_Core_DAO::singleValueQuery(sprintf('SELECT count(*) c FROM `%s`', $tableName));
+    return $c > 0;
+  }
+
   /**
    * @param $version
    *
-- 
2.25.1