/**
* test multiple queries
*/
public function test_multiple_queries()
{
$this->adapter->execute_ddl("CREATE TABLE users ( name varchar(20) );");
$this->adapter->multi_query("\n INSERT INTO users (name)\n VALUES ('Bill');\n INSERT INTO users (name)\n VALUES ('John')\n ");
$users = $this->adapter->select_all('SELECT * FROM users');
$expected = array(array('name' => 'Bill'), array('name' => 'John'));
$this->assertEquals($expected, $users);
}