From f704cbefbebd2e6ba982935118d7d84fdcb3c3b7 Mon Sep 17 00:00:00 2001
From: Christian A. Weber
Date: Wed, 16 Mar 2016 13:42:55 +0100
Subject: add function dbi::tables() to get a list of all tables of a db

---
 it_dbi.class | 18 ++++++++++++++----
 1 file changed, 14 insertions(+), 4 deletions(-)

diff --git a/it_dbi.class b/it_dbi.class
index 1b749eb..d498090 100644
--- a/it_dbi.class
+++ b/it_dbi.class
@@ -115,10 +115,8 @@ function createclasses($p = array())
 
 	if (!$tables = $state['tables'])
 	{
-		for ($tables = array(), $res = $dbi->query('SHOW TABLES', $p); $row = mysqli_fetch_row($res);)
-			$tables[] = $row[0];
-
-		$state = it_dbi::_state_get($dbid);	# State could have been modified by query above
+		$tables = $dbi->tables($p);
+		$state = it_dbi::_state_get($dbid);	# State could have been modified by $db->ables() call
 		$state['tables'] = $tables;
 		it_dbi::_state_put($dbid, $state);
 	}
@@ -421,6 +419,18 @@ function _write_pre_process(&$tags, $command)	# NOPHPLINT
 }
 
 
+/**
+ * Return an array of all tables of this database
+ */
+function tables($p = array())
+{
+	for ($qr = $this->query('SHOW TABLES', $p); $row = mysqli_fetch_row($qr);)
+		$result[] = $row[0];
+
+	return (array)$result;
+}
+
+
 /**
  * Clear record
  */
-- 
cgit v1.2.3