/**
* Get the schema builder instance.
*
* @return \Illuminate\Database\Schema\Builder
*/
public function getSchemaBuilder()
{
if (is_null($this->schema)) {
$this->schema = DB::getSchemaBuilder();
}
return $this->schema;
}
/**
* "league/csv": "^8.0"
*
* use League\Csv\Reader;
* use League\Csv\Writer;
* use Illuminate\Database\Schema\Builder as Schema;
*
* @param null $tableName
*/
public function toCsv($tableName = null)
{
$data = DB::table($tableName)->get();
$csv = \League\Csv\Writer::createFromFileObject(new \SplTempFileObject());
$csv->insertOne(DB::getSchemaBuilder()->getColumnListing($tableName));
foreach ($data as $datum) {
$datum = json_encode($datum);
$csv->insertOne($datum);
}
$csv->output('out.csv');
}
public function getCustomFields()
{
// Get all fields of the custom table
$fields = DB::getSchemaBuilder()->getColumnListing('custom_' . $this->list_id);
// remove id and record_id fields
if (($key = array_search('id', $fields)) !== false) {
unset($fields[$key]);
}
if (($key = array_search('record_id', $fields)) !== false) {
unset($fields[$key]);
}
return $fields;
}
public function getTableColumns($table_name)
{
return DB::getSchemaBuilder()->getColumnListing($table_name);
}
/**
* @param \Illuminate\Database\Eloquent\Builder $builder
*/
public function setFilterableFields(\Illuminate\Database\Eloquent\Builder $builder)
{
$table = $builder->getModel()->getTable();
$columns = DB::getSchemaBuilder()->getColumnListing($table);
foreach ($columns as $col) {
$this->filterableFields[$col] = $col;
}
}
public function pegaColunasTabela($tabela)
{
$cons = DB::getSchemaBuilder()->getColumnListing($tabela);
return $cons;
}
