| private getTableColumnTypes ( string $tableName ) : array | ||
| $tableName | string | Name of table to export |
| return | array | type column types detailed |
private function getTableColumnTypes($tableName)
{
$columnTypes = array();
$columns = $this->dbHandler->query($this->typeAdapter->show_columns($tableName));
$columns->setFetchMode(PDO::FETCH_ASSOC);
foreach ($columns as $key => $col) {
$types = $this->typeAdapter->parseColumnType($col);
$columnTypes[$col['Field']] = array('is_numeric' => $types['is_numeric'], 'is_blob' => $types['is_blob'], 'type' => $types['type'], 'type_sql' => $col['Type']);
}
return $columnTypes;
}