Laravel Columns Info

Laravel Columns Info

private function getColumnsInfo($tableName)
    {
        try {
            $columns = DB::table('information_schema.columns')
                ->select('column_name')
                    ->where('table_name', $tableName)
                    ->where('column_name', '!=', 'geom')
                    ->get()->toArray();
            foreach ($columns as $column) {
                $column->data_type = DB::connection()
                    ->getDoctrineColumn($tableName, $column->column_name)
                    ->getType()
                    ->getName();
            }
        } catch (QueryException $e) {
            $columns = [];
        }
        return $columns;
    }