public function testSelectUserWithPassword() { $select = new Select(["table" => "users", "where" => ["#login" => "email", "#password" => ["PASSWORD" => "value"]]], ["prefix" => "prfx_"]); $this->assertEquals($select->getRawQuery(), "SELECT * FROM `prfx_users` WHERE `login` = `email` AND `password` = PASSWORD(:__p0)"); }
public function testSelectConstSumm() { $select = new Select(["columns" => ["+" => [1, 2, 3]]]); $this->assertEquals($select->getRawQuery(), "SELECT (1 + 2 + 3)"); }