public function testQueryWithPlaceholders() { $sql = "SELECT *\n\t\t\t\t\tFROM children\n\t\t\t\t\tWHERE parent_id = 1"; $queryTable = $this->getConnection()->createQueryTable('parent_children', $sql); $result = $this->connection->query("\n\t\t\t\tSELECT *\n\t\t\t\tFROM children\n\t\t\t\tWHERE parent_id = ?\n\t\t\t", array(1)); $queryDataSet = new ArrayDataSet(array('parent_children' => $result->flatten())); $this->assertTablesEqual($queryDataSet->getTable('parent_children'), $queryTable); }
protected function createTableFromResult(Result $result) { $dataSet = new ArrayDataSet(array('result_table' => $result->flatten())); return $dataSet->getTable('result_table'); }