public static function reorderPages()
{
$pages = \Meta\Builder::read('pages');
// reordena pelo caminho (path)
ksort($pages);
\Meta\Builder::write('pages', $pages);
}
$pages = \Meta\Builder::read('pages');
$page = new \Meta\Builder\Page($path, $pages[$path]);
$object = $page->objects[$oid];
echo json_encode($object);
});
route_add('builder/analizesql/*/*', function ($pname, $oid) {
$errors = array();
$cols = array();
$sql = \Meta\Builder::replaceSQL(\Meta\Core\Db::sqlNormalize($_REQUEST['query']));
$statement = \Meta\Core\Db::getPDO()->prepare($sql);
if ($statement->execute()) {
for ($i = 0; $i < $statement->columnCount(); $i++) {
$meta = $statement->getColumnMeta($i);
// $cols[$meta['name']] = $meta['native_type'];
$cols[$meta['name']] = $meta['name'];
}
} else {
$errors = $statement->errorInfo();
}
// ataualiza colunas do SQL na base (array)
$pages = \Meta\Builder::read('pages');
$pages[$pname]['objects'][$oid]['sqlCols'] = $cols;
\Meta\Builder::write('pages', $pages);
echo json_encode(array('errors' => $errors, 'sql_cols' => $cols));
});
route_add('builder/print-metadata/*', function ($pname) {
$pages = \Meta\Builder::read('pages');
print_header();
highlight_string("<?php\n" . var_export($pages[$pname], true));
print_footer();
});
