public function lalala_testQuery() { $client = new Client(); $db = $client->createDatabase("test_xxx"); //$db->createUser("root", "root"); $db->insert("foobar", array('fields' => array('type' => '/foobar', 'karma' => 10))); $db->insert("foobar", array('fields' => array('type' => '/foobar', 'karma' => 20))); $db->insert("foobar", array('fields' => array('type' => '/barfoo', 'karma' => 30))); usleep(100000); // ugly, wait 0.1 seconds to be sure that values are written into database $this->assertEquals($db->first("SELECT max(karma) FROM foobar")->max, 30); $this->assertEquals($db->first("SELECT min(karma) FROM foobar")->min, 10); $this->assertEquals($db->first("SELECT mean(karma) FROM foobar")->mean, 20); foreach ($db->query("SELECT mean(karma), type FROM foobar GROUP BY type") as $row) { var_dump($row); $dtParsed = date_parse($row->time); var_dump($dtParsed); $this->assertEquals($dtParsed['error_count'], 0); if ($row->type == "/foobar") { $this->assertEquals(15, $row->mean); } else { $this->assertEquals(20, $row->mean); } } }