Exemplo n.º 1
0
 /**
  * @covers PDOforRunalyze::insert
  * @covers PDOforRunalyze::update
  * @covers PDOforRunalyze::updateWhere
  * @covers PDOforRunalyze::exec
  */
 public function testUpdate()
 {
     $this->object->insert('training', array('id', 's', 'distance'), array(1, 600, 1));
     $this->object->insert('training', array('id', 's', 'distance'), array(2, 900, 1));
     $this->object->insert('training', array('id', 's', 'distance'), array(3, 300, 1));
     $this->object->update('training', 1, 'distance', 2);
     $this->assertEquals(array(600, 2), $this->object->query('SELECT `s`, `distance` FROM `runalyze_training` WHERE `id`=1 LIMIT 1')->fetch(PDO::FETCH_NUM));
     $this->object->update('training', 2, 'distance', 3);
     $this->assertEquals(array(900, 3), $this->object->query('SELECT `s`, `distance` FROM `runalyze_training` WHERE `id`=2 LIMIT 1')->fetch(PDO::FETCH_NUM));
     $this->object->update('training', 3, array('s', 'distance'), array(150, 0.5));
     $this->assertEquals(array(150, 0.5), $this->object->query('SELECT `s`, `distance` FROM `runalyze_training` WHERE `id`=3 LIMIT 1')->fetch(PDO::FETCH_NUM));
     $this->object->updateWhere('training', '`distance` > 1', 'comment', 'Super weit.');
     $this->assertEquals("1,2", $this->object->query('SELECT GROUP_CONCAT(`id`) FROM `runalyze_training` WHERE `comment`="Super weit." GROUP BY `accountid`')->fetchColumn());
     $this->assertEquals(3, $this->object->exec('DELETE FROM `runalyze_training`'));
     $this->assertEquals(0, $this->object->query('SELECT COUNT(*) FROM `runalyze_training`')->fetchColumn());
     $this->object->exec('TRUNCATE TABLE `runalyze_training`');
 }