laravelDatabasenotconfigured.

Database [postgres] not configured.

namespace App\Models;



use Illuminate\Database\Eloquent\Model;

use Illuminate\Support\Facades\DB;





class StaKeyModel extends Model

{



    protected $guarded = [];

    protected $cOnnection= 'postgres';

    protected $table = 'sta_key';



    /**

     * @date 2017-07-17 16:05:39

     *

     * @param $startDate

     * @param $endDate

     * @return mixed

     */

    public static function getList($startDate, $endDate) {

        $object = static::select(DB::raw('date,key,count(distinct(value)) v'));

        $object->where('date', '>=', $startDate);

        $object->where('date', '<=', $endDate);



        $object->groupBy('date');

        $object->groupBy('key');



        $object->orderBy('v', 'desc');



        $data = $object->get()->toArray();

        return $data;

    }



}

'default' => env('DB_CONNECTION', 'mysql');

'connections' => [

    //支付数据库

    'mysql' => [

        'driver'    => 'mysql',

        'host'      => env('DB_HOST', 'localhost'),

        'database'  => env('DB_DATABASE', 'mysqldb'),

        'username'  => env('DB_USERNAME', 'user'),

        'password'  => env('DB_PASSWORD', 'password'),

        'charset'   => 'utf8',

        'collation' => 'utf8_unicode_ci',

        'prefix'    => '',

        'strict'    => false,

    ],

    'postgres' => [

        'driver'   => 'postgres',

        'host'     => env('DB_HOST_PGSQL', 'localhost'),

        'port'     => env('DB_PORT_PGSQL', 5439),

        'database' => env('DB_DATABASE_PGSQL', 'postgredb'),

        'username' => env('DB_USERNAME_PGSQL', 'user'),

        'password' => env('DB_PASSWORD_PGSQL', 'password'),

        'charset'  => 'utf8',

        'prefix'   => '',

        'schema'   => 'public',

    ],

];