public function testRawQuery()
{
$query = 'select * from cb_my_table where id = ? and name = ?';
$bindings = array(5, 'usman');
$queryArr = $this->builder->query($query, $bindings)->get();
$this->assertEquals(array($query, array(array(5, PDO::PARAM_INT), array('usman', PDO::PARAM_STR))), $queryArr);
}
public function setUp()
{
parent::setUp();
$connection = new Connection('sqlite', array('driver' => 'sqlite', 'database' => ':memory:'));
$this->qb = new QueryBuilderHandler($connection);
$this->qb->query("CREATE TABLE sample(\n t_key TEXT NOT NULL,\n t_value TEXT NOT NULL\n );");
for ($i = 1; $i <= 100; $i++) {
$record = array('t_key' => 'Key ' . $i, 't_value' => 'Value ' . $i);
$this->qb->table('sample')->insert($record);
}
}
