ParagonIE\EasyDB\Tests\UpdateTest::testUpdate PHP Method

testUpdate() public method

public testUpdate ( callable $cb )
$cb callable
    public function testUpdate(callable $cb)
    {
        $db = $this->EasyDBExpectedFromCallable($cb);
        $db->insertMany('irrelevant_but_valid_tablename', [['foo' => '1'], ['foo' => '2']]);
        $this->assertEquals($db->single('SELECT COUNT(*) FROM irrelevant_but_valid_tablename'), 2);
        $this->assertEquals($db->single('SELECT COUNT(*) FROM irrelevant_but_valid_tablename WHERE foo = ?', [1]), 1);
        $this->assertEquals($db->single('SELECT COUNT(*) FROM irrelevant_but_valid_tablename WHERE foo = ?', [2]), 1);
        $this->assertEquals($db->single('SELECT COUNT(*) FROM irrelevant_but_valid_tablename WHERE foo = ?', [3]), 0);
        $db->update('irrelevant_but_valid_tablename', ['foo' => 3], ['foo' => 2]);
        $this->assertEquals($db->single('SELECT COUNT(*) FROM irrelevant_but_valid_tablename WHERE foo = ?', [2]), 0);
        $this->assertEquals($db->single('SELECT COUNT(*) FROM irrelevant_but_valid_tablename WHERE foo = ?', [3]), 1);
    }