/** * */ public function testInsertTable() { $this->create_table_summing_url_views(); $state = $this->insert_data_table_summing_url_views(); $this->assertFalse($state->isError()); $st = $this->db->select('SELECT sum(views) as sum_x, min(v_00) as min_x FROM summing_url_views'); $this->assertEquals(122, $st->fetchOne('sum_x')); $this->assertEquals(9, $st->fetchOne('min_x')); $this->db->enableExtremes(true); $st = $this->db->select('SELECT * FROM summing_url_views ORDER BY url_hash'); $this->db->enableExtremes(false); $this->assertEquals(4, $st->count()); $this->assertEquals(0, $st->countAll()); $this->assertEquals(0, sizeof($st->totals())); $this->assertEquals('HASH1', $st->fetchOne()['url_hash']); $this->assertEquals(2345, $st->extremesMin()['site_id']); $st = $this->db->select(' SELECT url_hash, sum(views) as vv, avg(views) as avgv FROM summing_url_views WHERE site_id < 3333 GROUP BY url_hash WITH TOTALS '); $this->assertEquals(2, $st->count()); $this->assertEquals(0, $st->countAll()); $this->assertEquals(34, $st->totals()['vv']); $this->assertEquals(17, $st->totals()['avgv']); $this->assertEquals(22, $st->rowsAsTree('url_hash')['HASH1']['vv']); // drop $this->db->write("DROP TABLE IF EXISTS summing_url_views"); }