/** show one collection **/
public function doIndex()
{
$this->db = xn("db");
$this->collection = xn("collection");
//selected format last time
$this->last_format = rock_cookie("rock_format", "json");
//write query to log
$params = xn();
if ($this->_logQuery && count($params) > 3) {
//not only "action", "db" and "collection"
$logDir = dirname(__ROOT__) . DS . "logs";
if (!empty($params["criteria"]) && strlen(trim($params["criteria"], "{} \t\n\r")) > 0) {
if (is_writable($logDir)) {
$logFile = $this->_logFile($this->db, $this->collection);
$fp = null;
if (!is_file($logFile)) {
$fp = fopen($logFile, "a+");
fwrite($fp, '<?php exit("Permission Denied"); ?>' . "\n");
} else {
$fp = fopen($logFile, "a+");
}
fwrite($fp, date("Y-m-d H:i:s") . "\n" . var_export($params, true) . "\n================\n");
fclose($fp);
}
}
}
//information
$db = $this->_mongo->selectDB($this->db);
$info = MCollection::info($db, $this->collection);
$this->canAddField = !$info["capped"];
//field and sort
$fields = xn("field");
//order fields
$orders = xn("order");
//order type:asc|desc
if (empty($fields)) {
if (!$this->_server->docsNatureOrder()) {
$fields = array($info["capped"] ? "\$natural" : "_id", "", "", "");
} else {
$fields = array();
}
$orders = array("desc", "asc", "asc", "asc");
x("field", $fields);
x("order", $orders);
}
//format
$format = x("format");
if (!$format) {
$format = $this->last_format;
x("format", $format);
}
//remember last format choice
$this->last_format = $format;
$this->_rememberFormat($format);
//read fields from collection
import("models.MCollection");
$this->nativeFields = MCollection::fields($db, $this->collection);
$this->queryFields = x("query_fields");
if (!is_array($this->queryFields)) {
$this->queryFields = array();
}
$this->indexFields = $db->selectCollection($this->collection)->getIndexInfo();
$this->recordsCount = $db->selectCollection($this->collection)->count();
foreach ($this->indexFields as $index => $indexField) {
$this->indexFields[$index]["keystring"] = $this->_encodeJson($indexField["key"]);
}
$this->queryHints = x("query_hints");
if (!is_array($this->queryHints)) {
$this->queryHints = array();
}
//new obj in modification
$newobj = trim(xn("newobj"));
if (!$newobj) {
if ($format == "array") {
x("newobj", 'array(
\'$set\' => array (
//your attributes
)
)');
} else {
x("newobj", '{
\'$set\': {
//your attributes
}
}');
}
}
//conditions
$native = xn("criteria");
$criteria = $native;
if (empty($criteria)) {
$criteria = array();
if ($format == "array") {
$native = "array(\n\t\n)";
} else {
if ($format == "json") {
$native = '{
}';
}
}
x("pagesize", 10);
} else {
$row = null;
$eval = new VarEval($criteria, $format, $db);
$row = $eval->execute();
if (is_object($row)) {
$row = get_object_vars($row);
}
if (!is_array($row)) {
$this->message = "Criteria must be a valid " . ($format == "json" ? "JSON object" : "array");
$this->jsonLink = "#";
$this->arrayLink = "#";
$this->display();
return;
}
$criteria = $row;
}
//remember criteria in cookie (may be replaced by query history some day)
//setcookie("criteria_" . $this->db . "__" . $this->collection . "__" . $format, $native, time() + );
x("criteria", $native);
import("lib.mongo.RQuery");
$query = new RQuery($this->_mongo, $this->db, $this->collection);
$query->cond($criteria);
//sort
$realOrderedFields = array();
$realOrderedOrders = array();
foreach ($fields as $index => $field) {
if (!empty($field)) {
$realOrderedFields[] = $field;
if ($orders[$index] == "asc") {
$realOrderedOrders[] = "asc";
$query->asc($field);
} else {
$realOrderedOrders[] = "desc";
$query->desc($field);
}
}
}
x("field", $realOrderedFields);
x("order", $realOrderedOrders);
//command
$command = x("command");
if (!$command) {
$command = "findAll";
x("command", $command);
}
$limit = xi("limit");
if ($limit > 0) {
$query->limit($limit);
}
$count = $limit > 0 && $command == "findAll" ? $query->count(true) : $query->count();
switch ($command) {
case "findAll":
if (!empty($this->queryFields)) {
$query->result($this->queryFields);
}
if (!empty($this->queryHints)) {
foreach ($this->indexFields as $index) {
if (in_array($index["name"], $this->queryHints)) {
$query->hint($index["key"]);
}
}
}
break;
case "remove":
$microtime = microtime(true);
$query->delete();
$this->cost = microtime(true) - $microtime;
break;
case "modify":
$microtime = microtime(true);
$row = null;
$newobj = xn("newobj");
$eval = new VarEval($newobj, $format, $db);
$row = $eval->execute();
if (is_array($row)) {
$query->upsert($row);
}
$this->cost = microtime(true) - $microtime;
break;
}
//construct links
if ($format == "json") {
$params = xn();
unset($params["newobj"]);
$exportor = new VarExportor($db, $criteria);
$params["format"] = "array";
$params["criteria"] = $exportor->export();
$this->arrayLink = $this->path($this->action(), $params);
$params = xn();
unset($params["newobj"]);
$params["format"] = "json";
$this->jsonLink = $this->path($this->action(), $params);
} else {
if ($format == "array") {
$params = xn();
unset($params["newobj"]);
$params["format"] = "array";
$this->arrayLink = $this->path($this->action(), $params);
$params = xn();
unset($params["newobj"]);
$params["format"] = "json";
if (empty($criteria)) {
$params["criteria"] = "{\n\t\n}";
} else {
$exportor = new VarExportor($db, $criteria);
$params["criteria"] = $exportor->export(MONGO_EXPORT_JSON);
}
$this->jsonLink = $this->path($this->action(), $params);
}
}
if ($command != "findAll") {
$this->count = $count;
$this->display();
return;
}
//pagination
$pagesize = xi("pagesize");
if ($pagesize < 1) {
$pagesize = 10;
}
import("lib.page.RPageStyle1");
$page = new RPageStyle1();
$page->setTotal($count);
$page->setSize($pagesize);
$page->setAutoQuery();
$this->page = $page;
$query->offset($page->offset());
if ($limit > 0) {
$query->limit(min($limit, $page->size()));
} else {
$query->limit($page->size());
}
$microtime = microtime(true);
$this->rows = $query->findAll(true);
$this->cost = microtime(true) - $microtime;
foreach ($this->rows as $index => $row) {
$native = $row;
$exportor = new VarExportor($query->db(), $native);
$row["text"] = $exportor->export($format);
$row["data"] = $this->_highlight($native, $format, true);
$row["can_delete"] = isset($row["_id"]) && !$info["capped"];
$row["can_modify"] = isset($row["_id"]);
$row["can_duplicate"] = isset($row["_id"]);
$row["can_add_field"] = isset($row["_id"]) && !$info["capped"];
$row["can_refresh"] = isset($row["_id"]);
$this->rows[$index] = $row;
}
$this->display();
}
/** db profiling **/
public function doProfile()
{
$this->db = xn("db");
import("lib.mongo.RQuery");
import("lib.page.RPageStyle1");
$query = new RQuery($this->_mongo, $this->db, "system.profile");
$page = new RPageStyle1();
$page->setTotal($query->count());
$page->setSize(10);
$page->setAutoQuery();
$this->page = $page;
$this->rows = $query->offset($page->offset())->limit($page->size())->desc("ts")->findAll();
foreach ($this->rows as $index => $row) {
$this->rows[$index]["text"] = $this->_highlight($row, "json");
}
$this->display();
}
var_dump("Insert Into test last id: " . $id);
$idB = $rQuery->insert("INSERT INTO test (`name`) VALUES (:name)", array('name' => 'B'));
var_dump("Insert Into test last id: " . $idB);
$id = $rQuery->insert("INSERT INTO test (`name`) VALUES (:name)", array('name' => 'C'));
var_dump("Insert Into test last id: " . $id);
$id = $rQuery->insert("INSERT INTO test (`name`) VALUES (:name)", array('name' => 'chickenskill'));
var_dump("Insert Into test last id: " . $id);
$rowsAffected = $rQuery->update("UPDATE test SET name = :name WHERE id = :id", array('id' => $idB, 'name' => 'google'));
var_dump("Row affected: " . $rowsAffected);
$rowsAffected = $rQuery->delete("DELETE FROM test WHERE name = :name1 OR name = :name2", array('name1' => 'A', 'name2' => 'C'));
var_dump("Row affected: " . $rowsAffected);
$cursor = $rQuery->select("SELECT * FROM test");
while ($row = $rQuery->read($cursor)) {
var_dump($row);
}
$pdo = $rQuery->getDriver();
var_dump($pdo);
$count = $rQuery->count("SELECT COUNT(*) FROM test");
var_dump($count);
$rows = $rQuery->selectAll("SELECT * FROM test");
var_dump($rows);
$row = $rQuery->selectRow("SELECT * FROM test WHERE id = :id", array('id' => $idB));
var_dump($row);
$row = $rQuery->selectCol("SELECT id FROM test");
var_dump($row);
$row = $rQuery->selectCol("SELECT id FROM test WHERE id = :id", array('id' => 99999));
var_dump($row);
$var = $rQuery->selectVar("SELECT name FROM test WHERE id = :id", array('id' => $idB));
var_dump($var);
$var = $rQuery->selectVar("SELECT name FROM test WHERE id = :id", array('id' => 99999));
var_dump($var);