From 06f945f27840b53e57795dadbc38e76f7e11ab1c Mon Sep 17 00:00:00 2001 From: Horus3 Date: Mon, 24 Feb 2014 16:42:14 +0100 Subject: init --- zend/tests/Zend/Gdata/SpreadsheetsOnlineTest.php | 295 +++++++++++++++++++++++ 1 file changed, 295 insertions(+) create mode 100644 zend/tests/Zend/Gdata/SpreadsheetsOnlineTest.php (limited to 'zend/tests/Zend/Gdata/SpreadsheetsOnlineTest.php') diff --git a/zend/tests/Zend/Gdata/SpreadsheetsOnlineTest.php b/zend/tests/Zend/Gdata/SpreadsheetsOnlineTest.php new file mode 100644 index 0000000..57a6c52 --- /dev/null +++ b/zend/tests/Zend/Gdata/SpreadsheetsOnlineTest.php @@ -0,0 +1,295 @@ +sprKey = constant('TESTS_ZEND_GDATA_SPREADSHEETS_SPREADSHEETKEY'); + $this->wksId = constant('TESTS_ZEND_GDATA_SPREADSHEETS_WORKSHEETID'); + $service = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME; + $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service); + $this->gdata = new Zend_Gdata_Spreadsheets($client); + } + + public function testGetSpreadsheetsAndWorksheetsAndData() + { + $spreadsheetCount = 0; + + $spreadsheets = $this->gdata->getSpreadsheets(); + $testedContents = false; + foreach($spreadsheets as $spreadsheet) { + $spreadsheetCount++; + $worksheetCount = 0; + $this->assertTrue($spreadsheet instanceof Zend_Gdata_Spreadsheets_SpreadsheetEntry, 'not instance of SpreadsheetEntry'); + foreach($spreadsheet->getWorksheets() as $worksheet) { + $this->assertTrue($worksheet instanceof Zend_Gdata_Spreadsheets_WorksheetEntry, 'not instance of WorksheetEntry'); + $worksheetCount++; + if ($spreadsheet->getTitle()->getText() == 'PHP Unit Test Sheet') { + $testedContents = true; + $contentAsCells = $worksheet->getContentsAsCells(); + $this->assertEquals('a1', $contentAsCells['A1']['value']); + $this->assertEquals('new', $contentAsCells['A2']['value']); + $this->assertEquals('row', $contentAsCells['B2']['value']); + $contentAsRows = $worksheet->getContentsAsRows(); + $this->assertEquals('new', $contentAsRows[0]['a1']); + $this->assertEquals('data', $contentAsRows[0]['c1']); + $this->assertEquals('here', $contentAsRows[0]['d1']); + } + } + $this->assertTrue($worksheetCount >= 1, 'didn\'t get >= 1 worksheet'); + } + $this->assertTrue($spreadsheetCount > 1, 'didn\'t get >1 spreadsheet'); + $this->assertTrue($testedContents, 'didn\'t test the contents of the worksheet'); + } + + public function testGetSpreadsheetFeed() + { + $feed = $this->gdata->getSpreadsheetFeed(); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_SpreadsheetFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_SpreadsheetEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + + $query = new Zend_Gdata_Spreadsheets_DocumentQuery(); + $feed = $this->gdata->getSpreadsheetFeed($query); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_SpreadsheetFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_SpreadsheetEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + + $uri = $query->getQueryUrl(); + $feed = $this->gdata->getSpreadsheetFeed($uri); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_SpreadsheetFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_SpreadsheetEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + } + + public function testGetWorksheetFeed() + { + $query = new Zend_Gdata_Spreadsheets_DocumentQuery(); + $query->setSpreadsheetKey($this->sprKey); + $feed = $this->gdata->getWorksheetFeed($query); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_WorksheetFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_WorksheetEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + + $uri = $query->getQueryUrl(); + $feed = $this->gdata->getWorksheetFeed($uri); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_WorksheetFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_WorksheetEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + } + + public function testGetCellFeed() + { + $query = new Zend_Gdata_Spreadsheets_CellQuery(); + $query->setSpreadsheetKey($this->sprKey); + $query->setWorksheetId($this->wksId); + $feed = $this->gdata->getCellFeed($query); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_CellFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_CellEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + + $feed = $this->gdata->getCellFeed($query->getQueryUrl()); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_CellFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_CellEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + } + + public function testGetListFeed() + { + $query = new Zend_Gdata_Spreadsheets_ListQuery(); + $query->setSpreadsheetKey($this->sprKey); + $query->setWorksheetId($this->wksId); + $feed = $this->gdata->getListFeed($query); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_ListFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_ListEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + + $feed = $this->gdata->getListFeed($query->getQueryUrl()); + $this->assertTrue($feed instanceof Zend_Gdata_Spreadsheets_ListFeed); + foreach ($feed->entries as $entry) { + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_ListEntry); + $this->assertTrue($entry->getHttpClient() == $feed->getHttpClient()); + } + } + + public function testGetSpreadsheetEntry() + { + $query = new Zend_Gdata_Spreadsheets_DocumentQuery(); + $query->setSpreadsheetKey($this->sprKey); + $entry = $this->gdata->getSpreadsheetEntry($query); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_SpreadsheetEntry); + + $entry = $this->gdata->getSpreadsheetEntry($query->getQueryUrl()); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_SpreadsheetEntry); + } + + public function testGetWorksheetEntry() + { + $query = new Zend_Gdata_Spreadsheets_DocumentQuery(); + $query->setSpreadsheetKey($this->sprKey); + $query->setWorksheetId($this->wksId); + $entry = $this->gdata->getWorksheetEntry($query); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_WorksheetEntry); + + $entry = $this->gdata->getWorksheetEntry($query->getQueryUrl()); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_WorksheetEntry); + } + + public function testGetCellEntry() + { + $query = new Zend_Gdata_Spreadsheets_CellQuery(); + $query->setSpreadsheetKey($this->sprKey); + $query->setCellId('R1C1'); + $entry = $this->gdata->getCellEntry($query); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_CellEntry); + + $entry = $this->gdata->getCellEntry($query->getQueryUrl()); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_CellEntry); + } + + public function testGetListEntry() + { + $query = new Zend_Gdata_Spreadsheets_ListQuery(); + $query->setSpreadsheetKey($this->sprKey); + $query->setStartIndex('1'); + $query->setMaxResults('1'); + $entry = $this->gdata->getListEntry($query); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_ListEntry); + + $entry = $this->gdata->getListEntry($query->getQueryUrl()); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_ListEntry); + } + + public function testUpdateCell() + { + $this->gdata->updateCell(5, 1, 'updated data', $this->sprKey, $this->wksId); + + $query = new Zend_Gdata_Spreadsheets_CellQuery(); + $query->setSpreadsheetKey($this->sprKey); + $query->setCellId('R5C1'); + $entry = $this->gdata->getCellEntry($query); + $this->assertTrue($entry instanceof Zend_Gdata_Spreadsheets_CellEntry); + $this->assertTrue($entry->cell->getText() == 'updated data'); + + $this->gdata->updateCell(5, 1, '', $this->sprKey, $this->wksId); + } + + public function testInsertUpdateDeleteRow() + { + $rowData = array(); + $rowData['a1'] = 'new'; + $rowData['b1'] = 'row'; + $rowData['c1'] = 'data'; + $rowData['d1'] = 'here'; + $entry = $this->gdata->insertRow($rowData, $this->sprKey); + $rowData['a1'] = 'newer'; + $entry = $this->gdata->updateRow($entry, $rowData); + $this->gdata->deleteRow($entry); + } + + public function testInsertUpdateDeleteRow2() + { + $rowData = array(); + $rowData['a1'] = 'new'; + $rowData['b1'] = 'row'; + $rowData['c1'] = 'data'; + $rowData['d1'] = 'here'; + $entry = $this->gdata->insertRow($rowData, $this->sprKey); + $rowData['a1'] = 'newer'; + $entry = $this->gdata->updateRow($entry, $rowData); + $ssTest = new Zend_Gdata_Spreadsheets($entry->getHttpClient()); + $ssTest->delete($entry->getEditLink()->href); + } + + public function testInsertUpdateDeleteRow3() + { + $rowData = array(); + $rowData['a1'] = 'new'; + $rowData['b1'] = 'row'; + $rowData['c1'] = 'data'; + $rowData['d1'] = 'here'; + $entry = $this->gdata->insertRow($rowData, $this->sprKey); + $rowData['a1'] = 'newer'; + $entry = $this->gdata->updateRow($entry, $rowData); + $ssTest = new Zend_Gdata_Spreadsheets($entry->getHttpClient()); + $ssTest->delete($entry); + } + + public function testCustomElementsCollected() { + $rowData = array(); + $rowData['a1'] = 'new'; + $rowData['b1'] = 'row'; + $rowData['c1'] = 'data'; + $rowData['d1'] = 'here'; + $entry = $this->gdata->insertRow($rowData, $this->sprKey); + + $this->assertEquals(4, count($entry->custom)); + $this->assertEquals(4, count($entry->customByName)); + + $this->assertEquals('new', $entry->custom[0]->getText()); + $this->assertEquals('row', $entry->custom[1]->getText()); + $this->assertEquals('data', $entry->custom[2]->getText()); + $this->assertEquals('here', $entry->custom[3]->getText()); + + $this->assertEquals('new', $entry->customByName['a1']->getText()); + $this->assertEquals('row', $entry->customByName['b1']->getText()); + $this->assertEquals('data', $entry->customByName['c1']->getText()); + $this->assertEquals('here', $entry->customByName['d1']->getText()); + + $ssTest = new Zend_Gdata_Spreadsheets($entry->getHttpClient()); + $ssTest->delete($entry); + } + +} -- cgit v1.2.3