<?php

namespace App\Model\Facade;

use Nette\Database\Connection;

class DatabazeFacade
{
    public function __construct(
        private Connection $masterDb
    ) {
    }

    /**
     * Seznam databází z master tabulky LOGIN (jeden login = jedna databáze).
     *
     * @return \Nette\Database\Row[]
     */
    public function getAll(): array
    {
        return $this->masterDb->fetchAll(
            'SELECT ID, EMAIL, POSLEDNI_PRIHLASENI, AKTIVNI, [DATABASE], [SERVER], FIRMA_ID, IS_ADMIN
             FROM dbo.LOGIN
             ORDER BY [DATABASE], EMAIL'
        );
    }
}