Example #1
0
 /**
  *
  */
 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");
 }