Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.
 All Data Structures Functions Variables Pages
ZurmoMySqlQueryWriter.php
1 <?php
2  /*********************************************************************************
3  * Zurmo is a customer relationship management program developed by
4  * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
5  *
6  * Zurmo is free software; you can redistribute it and/or modify it under
7  * the terms of the GNU Affero General Public License version 3 as published by the
8  * Free Software Foundation with the addition of the following permission added
9  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
10  * IN WHICH THE COPYRIGHT IS OWNED BY ZURMO, ZURMO DISCLAIMS THE WARRANTY
11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12  *
13  * Zurmo is distributed in the hope that it will be useful, but WITHOUT
14  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
15  * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
16  * details.
17  *
18  * You should have received a copy of the GNU Affero General Public License along with
19  * this program; if not, see http://www.gnu.org/licenses or write to the Free
20  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
21  * 02110-1301 USA.
22  *
23  * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive
24  * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
25  *
26  * The interactive user interfaces in original and modified versions
27  * of this program must display Appropriate Legal Notices, as required under
28  * Section 5 of the GNU Affero General Public License version 3.
29  *
30  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
31  * these Appropriate Legal Notices must retain the display of the Zurmo
32  * logo and Zurmo copyright notice. If the display of the logo is not reasonably
33  * feasible for technical reasons, the Appropriate Legal Notices must display the words
34  * "Copyright Zurmo Inc. 2017. All rights reserved".
35  ********************************************************************************/
36 
37  class ZurmoMySqlQueryWriter extends RedBean_QueryWriter_MySQL
38  {
44  public function doesTableExist($tableName)
45  {
46  $tableName = strtolower($tableName);
47  $result = $this->adapter->get("SHOW TABLES LIKE '$tableName'");
48  return (count($result) > 0);
49  }
50 
57  public function doesColumnExist($tableName, $columnName)
58  {
59  $tableName = $this->safeTable($tableName);
60  $result = $this->adapter->get("SHOW COLUMNS FROM $tableName LIKE '$columnName'");
61  return (count($result) > 0);
62  }
63 
69  public function getColumnsWithDetails($tableName)
70  {
71  $columns = array();
72  $tableName = $this->safeTable($tableName);
73  $columnsRaw = $this->adapter->get("DESCRIBE $tableName");
74  foreach ($columnsRaw as $r)
75  {
76  $columns[$r['Field']] = $r;
77  }
78  return $columns;
79  }
80 
86  public function getIndexes($tableName)
87  {
88  $indexes = array();
89  $tableName = $this->safeTable($tableName);
90  $indexesRaw = $this->adapter->get("SHOW KEYS FROM $tableName");
91  foreach ($indexesRaw as $index)
92  {
93  $indexName = $index['Key_name'];
94  $column = $index['Column_name'];
95  $unique = (!(bool)$index['Non_unique']);
96  $indexes[$indexName]['unique'] = $unique;
97  if (isset($indexes[$indexName]['columns']))
98  {
99  $indexes[$indexName]['columns'][] = $column;
100  }
101  else
102  {
103  $indexes[$indexName]['columns'] = array($column);
104  }
105  }
106  return $indexes;
107  }
108 
115  public function getColumnCountByTableName($tableName, $excludeIdColumn = true)
116  {
117  $columns = $this->getColumns($tableName);
118  $count = count($columns);
119  if ($excludeIdColumn)
120  {
121  $count--;
122  }
123  return $count;
124  }
125 
130  public function getFirstRowByTableName($tableName)
131  {
132  $tableName = $this->safeTable($tableName);
133  $sql = 'select * from ' . $tableName . ' limit 1';
134  try
135  {
136  $data = $this->adapter->getRow($sql); // we don't really need getRow here as we have used 'limit 1', still...
137  }
138  catch (RedBean_Exception_SQL $e)
139  {
140  throw new NoRowsInTableException();
141  }
142  return $data;
143  }
144 
149  public function dropTableByTableName($tableName)
150  {
151  $tableName = $this->safeTable($tableName);
152  $this->adapter->exec("drop table if exists $tableName");
153  }
154 
160  public function safeTable($name, $noQuotes = false)
161  {
162  assert('is_string($name)');
163  return parent::safeTable(strtolower($name), $noQuotes);
164  }
165  }
166 ?>
safeTable($name, $noQuotes=false)
doesColumnExist($tableName, $columnName)
getColumnCountByTableName($tableName, $excludeIdColumn=true)
Generated on Sun Jul 5 2020 07:10:28
Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.