Get raw mysqli from Cake's default config

mysqliFromCake.php

<?php

    // get the raw mysql object
    $dataSource = ConnectionManager::getDataSource('default');
    $mysqli = $dataSource->connection;

    // dump the config
    var_dump($dataSource->config);

    // query the database
    $query = 'select * from am_assets';
    $result = $mysqli->query($query);
    echo  $result->num_rows, 'rows found', PHP_EOL;

    // iterate through the results row by row
    $i = 0;
    while($row = $result->fetch_assoc()) {
        echo $i++, "\t", $row['id'], PHP_EOL;
    }
    $result->close();