/**
* @param Instance $instance
*
* @return array
*/
protected function getStoredData(Instance $instance)
{
// Get our database connection...
$_db = $instance->instanceConnection($instance);
// Get a table list...
$_tables = $_db->getDoctrineConnection()->getSchemaManager()->listTables();
$_data = [];
foreach ($_tables as $_table) {
$_tableName = $_table->getName();
// Get the columns
$_columns = [];
foreach ($_table->getColumns() as $_column) {
$_array = $_column->toArray();
$_array['type'] = (string) $_array['type'];
$_columns[] = $_array;
}
$_data[$_tableName] = ['schema' => $_columns, 'data' => $_db->select('SELECT * FROM ' . $_tableName)];
}
return $_data;
}
