Support Mutiple schema with Postgresql about datatables HOT 4 CLOSED

class Codeigniter4Adapter extends DBAdapter
{
    protected $db;

    protected array $config;

    public function __construct($config = null)
    {
        if ($config != null) {
            $this->config = $config;
        }

        if (!isset($this->config['DBGroup']))
        {
            $this->config['DBGroup'] = 'default';
        }
    }

    public function connect()
    {
        
        $this->db = \Config\Database::connect($this->config['DBGroup']);

        return $this;
    }

public function datatables()
    {
        $dt = new Datatables(new Codeigniter4Adapter(['DBGroup' => $this->DBGroup]));

        $builder = $this->db->table($this->table . ' page');

        $builder->select('page.id, page.title, template.name, page.status');
        $builder->join('web_page_templates template', 'template.id=page.template_id','left');
        $builder->orderBy('page.id DESC');

        $dt->query($builder);
     
        return $dt->generate()->toJson();
    }