method fullDbs documentation in bbn\Appui\Database
Returns the list of DBs available for the given connection with statistics.
function(string $host = '', string $engine = 'mysql')
{
$o =& $this->o;
if ($dbs = $this->dbs($host, $engine)) {
$res = array_map(
function ($a) use ($o, $engine) {
$r = [
'id' => $a['id'],
'text' => $a['text'],
'name' => $a['name'],
'num_tables' => 0,
'num_connections' => 0,
'num_procedures' => 0,
'num_functions' => 0
];
//die(var_dump( $o->fromCode('tables', $a['id'])));
if ($id_tables = $o->fromCode('tables', $a['id'])) {
$r['num_tables'] = $o->count($id_tables);
}
if ($id_connections = $o->fromCode($engine === 'sqlite' ? 'paths' : 'connections', $a['id'])) {
$r['num_connection'] = $o->count($id_connections);
}
if ($id_procedures = $o->fromCode('procedures', $a['id'])) {
$r['num_procedures'] = $o->count($id_procedures);
}
if ($id_functions = $o->fromCode('functions', $a['id'])) {
$r['num_functions'] = $o->count($id_functions);
}
return $r;
},
$dbs
);
return $res ?: [];
}
return [];
}
Returns the list of DBs available for the given connection with statistics. BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way
This website uses cookies to ensure you get the best experience on our website.
© 2011-2023
BBN Solutions
