/** * 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); }
/** * Select all query * * @param string $sql the query to run * * @return array */ public function select_all($sql) { return $this->_adapter->select_all($sql); }