add function dbi::tables() to get a list of all tables of a db

1 files 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);
 	}
@@ -422,6 +420,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
  */
 function clear($pp = true)