Ruckusing_Adapter_PgSQL_Base::multi_query PHP Method

multi_query() public method

Execute several queries
public multi_query ( string $queries ) : boolean
$queries string queries to run
return boolean
    public function multi_query($queries)
    {
        $res = pg_query($this->conn, $queries);
        if ($this->isError($res)) {
            throw new Ruckusing_Exception(sprintf("Error executing 'query' with:\n%s\n\nReason: %s\n\n", $queries, pg_last_error($this->conn)), Ruckusing_Exception::QUERY_ERROR);
        }
        return true;
    }

Usage Example

 /**
  * test multiple queries with error in second query
  *
  * @expectedException Ruckusing_Exception
  */
 public function test_multiple_queries_error_in_second_query()
 {
     $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 (name2)\n            VALUES ('John')\n        ");
 }
All Usage Examples Of Ruckusing_Adapter_PgSQL_Base::multi_query