Data Display Issues Laravel 5.1

Question

I’m a beginner in Laravel and I’m trying to bring data from a BD with multiple Postgresql schemas with Laravel 5.1 and is bringing me an error

What configuration should be done for the model to correctly access the table of that schema?

Directly by postgres would write the query this way:

 SELECT * FROM cadastro.escolaridade  
 SELECT * FROM schema.tabela

Errorexception in Testecontroller.php line 13: Use of Undefined Registration form - assumed 'registration'

Database.php

'pgsql' => [
'driver'   => 'pgsql',
'host'     => env('DB_HOST', '127.0.0.1'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset'  => 'utf8',
'prefix'   => '',
'schema'   => 'public',
],

Model

<?php


namespace App\Models\Programas;

use Illuminate\Database\Eloquent\Model;

class Cadastro extends Model
{

}

Controller

<?php
 namespace App\Http\Controllers;
 use App\Models\Programas\Cadastro;


 class TesteController extends Controller
 {


public function getIndex()
{
    $escolaridade = cadastro.escolaridade::all();


    return view('programas.escrituras.index', compact('escolaridade'));


}

View

@forelse($escolaridade as $descricao)

<p><b>Grau de Escolaridade:</b>{{$descricao->descricao}}</p>

@empty
    <p>Nenhum Grau Cadastrado!</p>

    @endforelse

Answer 1

According to that answer, you must define the schema in the attribute $table of your model.

class Cadastro extends Model
{
    protected $table = 'cadastro.escolaridade';
}

Then you can call normally,

$escolaridade = Cadastro::all();

Answer 2

That bit of code is wrong

$escolaridade = cadastro.escolaridade::all();

By chance you come from another language and are trying to access members of classes or objects?

Your code indicates that you are trying to concatenate a constant cadastro with the result brought by escolaridade::all() (which in turn is converted to Json, since it is concatenating). Since the constant does not exist, the error is generated.

This is how PHP is understanding your code. So, if it’s not the desired result, you have to change it.

Multiples Schemas

In Laravel you could use more than one connection to solve this problem.

For example, you can set your configuration like this:

return [
    
    'default' => 'pgsql',

    'pgsql' => [
        'driver'   => 'pgsql',
        'host'     => env('DB_HOST', '127.0.0.1'),
        'database' => 'schema_1',
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'charset'  => 'utf8',
        'prefix'   => '',
        'schema'   => 'public',
    ],

    'pgsql_2' => [
        'driver'   => 'pgsql',
        'host'     => env('DB_HOST', '127.0.0.1'),
        'database' => 'schema_2',
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'charset'  => 'utf8',
        'prefix'   => '',
        'schema'   => 'public',
    ]
];

And in the model that wants to use another schema (different from what is in default), you can set it in model.

Example with default schema set in configuration:

namespace App\Model\Schema1;

class Pessoa {}

Exmeplo with standard schema defined in the model

namespace App\Model\Schema2;

class TabelaQualquer
{
       protected $connection = 'pgsql_2';
}

Thus, you are informing the model that you will be using another connection configuration with the database for it. In this case, you use the same connection data, changing only the database.