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);
}
}
}
