protected function beforeHandle($action, $params)
{
if (isset($_SESSION['userId'])) {
$this->currentUser = $this->db->selectRow('SELECT * FROM user WHERE id=' . (int) $_SESSION['userId']);
}
return null;
}
public function testConditionBuilder()
{
$this->assertEquals('`a` IS NULL', $this->db->where('a', null));
$this->assertEquals("`a`='4'", $this->db->where('a', 4));
$this->assertEquals("`a` IN ('1','2','3')", $this->db->where('a', [1, 2, 3]));
$this->assertEquals('`a` IS NULL', $this->db->where(array('a' => null)));
$this->assertEquals("`a`='4'", $this->db->where(array('a' => 4)));
$this->assertEquals("`a` IN ('1','2','3')", $this->db->where(array('a' => [1, 2, 3])));
$this->assertEquals("`a`='4' AND `b`='as\\'d'", $this->db->where(array('a' => 4, 'b' => 'as\'d')));
}
public function selectOne($where)
{
return Utils::mapOne($this->db->selectRow("SELECT * FROM {$this->table} WHERE {$where}"), $this->class);
}
/**
* @expectedException \Vtk13\LibSql\SqlException
* @expectedExceptionMessage You have an error in your SQL syntax;
*/
public function testMisspelledDelete()
{
$this->db->delete('S E', 'q w');
}
